Bulk Inventory Export and Import - Revision history

Admin: Clarify exported-only Incoming, Unavailable and Committed columns

2026-10-19T04:01:41Z

Clarify exported-only Incoming, Unavailable and Committed columns

← Older revision		Revision as of 15:01, 19 October 2026
Line 92:		Line 92:
	Shipping Code		Shipping Code
	</pre>		</pre>

			'''Note:''' The '''Incoming''', '''Unavailable''' and '''Committed''' columns are exported for reference. They are not imported — an import updates '''Available''' only and leaves the existing unavailable and committed quantities unchanged.

	The fields are explained below.		The fields are explained below.
Line 149:		Line 151:
	\|-		\|-
	\| '''Unavailable'''		\| '''Unavailable'''
	\| ~~Unavailable inventory refers to inventory~~ that ~~isn~~'t ~~available for sale~~ or ~~committed to an order~~. It's ~~not available to be sold~~.		\| Inventory that is on hand but can't be sold, such as damaged, quality-control or safety-stock units. The exported total is for reference; the individual reasons are managed from the variation's Locations section.
	\|-		\|-
	\| '''Committed'''		\| '''Committed'''

Admin: Update HS Code and Country of Origin documentation for the Inventory CSV

2026-08-12T04:41:34Z

Update HS Code and Country of Origin documentation for the Inventory CSV

← Older revision		Revision as of 15:41, 12 August 2026
Line 137:		Line 137:
	\|-		\|-
	\| '''HS Code'''		\| '''HS Code'''
	\| The HS Code (Harmonized System Code) column is used to estimate duties and taxes for international customers. This column is optional~~. If you include it, then the values~~ can be left blank.		\| The HS Code (Harmonized System Code) column is used to estimate duties and taxes for international customers. This column is optional and can be left blank. The code must be exactly 6 digits, and ideally one of the official HS codes. Leading zeros are significant, so when editing the code in a spreadsheet, format the column as Text to stop them being removed.
	\|-		\|-
	\| '''COO'''		\| '''COO'''
	\| The COO (Country~~/Region~~ of Origin) column is used to estimate duties and taxes for international customers. ~~Accepted values are~~ ISO 3166-1 alpha-2 ~~country codes~~. ~~This column~~ is ~~optional. If you include it, then the values can be left blank~~.		\| The COO (Country of Origin) column is used to estimate duties and taxes for international customers. This column is optional and can be left blank. The exported file contains the country name, and on import either the full country name or the two letter ISO-3166-1 alpha-2 code (e.g. AU) is accepted.
	\|-		\|-
	\| '''Location'''		\| '''Location'''

Admin: Document expanded Inventory CSV fields (weight, dimensions, shipping and pricing)

2026-08-07T22:43:11Z

Document expanded Inventory CSV fields (weight, dimensions, shipping and pricing)

@@ Line 2: / Line 2: @@
 This feature is similar to the more generic [[Bulk Product Export and Import]] feature, but is specifically designed to make it much easier to update just the inventory levels for your products. Just download the inventory for your current products as a CSV, and use that file as a template in order to update the inventory levels for your products. Once updated, the CSV file can be imported, as described below.
 You cannot use the Inventory CSV file to import new products. You must use the full product CSV as defined in the [[Bulk Product Export and Import]] section.
@@ Line 70: / Line 72: @@
 Available
 On hand
 </pre>
@@ Line 138: / Line 159: @@
 | '''On hand'''
 | The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.
 |}

Admin at 23:04, 10 December 2024

2024-12-10T23:04:30Z

← Older revision		Revision as of 10:04, 11 December 2024
Line 6:		Line 6:

	You can also import a CSV file of your inventory downloaded from Shopify. If you're having problems importing inventory levels from Shopify, please send us your CSV file at [mailto:support@spiffystores.com.au support@spiffystores.com.au].		You can also import a CSV file of your inventory downloaded from Shopify. If you're having problems importing inventory levels from Shopify, please send us your CSV file at [mailto:support@spiffystores.com.au support@spiffystores.com.au].

			You can also export and import your store prices. Please refer to the details in [[Bulk Prices Export and Import]].

	== Exporting Inventory ==		== Exporting Inventory ==

Admin: /* The inventory.csv file explained */

2024-12-10T22:39:54Z

The inventory.csv file explained

← Older revision		Revision as of 09:39, 11 December 2024
Line 136:		Line 136:
	\| '''On hand'''		\| '''On hand'''
	\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.		\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.
	\|-
	~~\| '''Price'''~~
	~~\| The price of the variation.~~
	\|}		\|}

Admin: /* Product Import Page */

2024-12-10T22:39:40Z

Product Import Page

← Older revision		Revision as of 09:39, 11 December 2024
Line 68:		Line 68:
	Available		Available
	On hand		On hand
	~~Price~~
	</pre>		</pre>

Admin: /* The inventory.csv file explained */

2024-12-10T02:32:52Z

The inventory.csv file explained

← Older revision		Revision as of 13:32, 10 December 2024
Line 137:		Line 137:
	\| '''On hand'''		\| '''On hand'''
	\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.		\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.
			\|-
	\| '''Price'''		\| '''Price'''
	\| The price of the variation.		\| The price of the variation.
	\|}		\|}

Admin: /* The inventory.csv file explained */

2024-12-10T02:32:28Z

The inventory.csv file explained

← Older revision		Revision as of 13:32, 10 December 2024
Line 137:		Line 137:
	\| '''On hand'''		\| '''On hand'''
	\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.		\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.
			\| '''Price'''
			\| The price of the variation.
	\|}		\|}

Admin: /* Product Import Page */

2024-12-10T02:31:07Z

Product Import Page

← Older revision		Revision as of 13:31, 10 December 2024
Line 68:		Line 68:
	Available		Available
	On hand		On hand
			Price
	</pre>		</pre>

Admin at 01:04, 10 October 2024

2024-10-10T01:04:18Z

← Older revision		Revision as of 12:04, 10 October 2024
Line 137:		Line 137:
	\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.		\| The number of units that you have at a location. On hand inventory is made up of the total of your Committed, Unavailable and Available inventory. The inventory values that you input can be positive, negative or 0. The number cannot include a decimal, such as 1.5. You can also enter '''not stocked''' to indicate that the product is never stocked at the location.
	\|}		\|}

	~~== CSV File Usage Notes ==~~

	~~The first record for a given handle must contain the product data section (Title, Body, Vendor, Type and Tags). Title, Vendor and Type must be specified.~~

	~~Optionally this record and subsequent records with the same handle can contain Variant, Image and Custom Option records.~~

	~~As many secondary handle records are included as necessary to list all possible variant, image or option records.~~

	If the product is new, the first record must contain at least the product data, a variant record and optionally an image or option record. This and subsequent records will define the product and all its variants, images and options.

	If the product is being updated, then the product data in the first record will replace the existing product data. The variant, image and option data are optional on the first record. If a variant, image or option is specified on the first record, then '''ALL''' existing variants, images or options are deleted and replaced by the data from the CSV file.

	If there is no variant, image or option on the first record, but data appears on subsequent records, then these records are used to update or add new records. Thus, if there is no variant on the first record, but one appears on the second record, then this data replaces any existing variant with the same title or adds a new variant if it doesn't already exist.

	~~The same rules apply to options, and also to images. However, for images all images are treated as new images and an attempt is made to upload them to the product.~~

	~~If a product exists and the overwrite option is not specified, then the product is skipped entirely.~~

	~~NOTE: If the first record does not contain product data, it will be skipped.~~

	~~NOTE: Only the product data on the first record for a handle will be used. It will be ignored on all other records.~~

	~~Policy for updates -~~

	*If a product is new, then obviously all the data in the CSV will be added to the product.

	*If a product already exists and the overwrite flag is not set, then the product will be skipped and no changes will be made to the product, its variants, options or images.

	*If a product exists and overwrite is specified, then the main product attributes will be replaced. Also, all variants, options and images will be deleted and replaced by the ones specified in the CSV. This is equivalent to the product being deleted and replaced with a new version.

	~~With the addition of the Option1, Option2 and Option3 fields, the variant title is replaced by up to three of these 0ption names (and values).~~

	The Option Names are the titles of each of the options and are specified by "Option1 Name", "Option2 Name" and "Option3 Name". Only the values on the first record will be used when creating a product. All the names on subsequent lines are ignored, and are assumed to be the same as the first record. An error will be issued if the names change. When a product is being updated, then an error will be issued if the names do not exactly match the existing option names.

	If you are using your CSV file to update variant data such as prices and inventory levels, then we'd recommend deleting the '''Image Src''', '''Custom Option Name''', '''Custom Option Value''' and '''Custom Option Price''' fields as these won't be changing your product images or custom options and it's not necessary to update them every time you make minor changes to the product and variation settings.

	~~=== CSV File Examples ===~~

	~~==== Identification Section ====~~

	~~<gallery widths="200px" heights="200px" class="right">~~
	~~File:Product import 3.png\|Handle Section in CSV File~~
	~~</gallery>~~

	~~The CSV file is divided into five main sections.~~

	~~The first section consists of the first two columns, the '''Handle''' and the '''Title''' fields.~~

	~~These two fields identify each product, and either a Handle or Title '''MUST''' be specified for each product. The values are repeated for every line of the product definition.~~

	~~==== Product Section ====~~

	~~<gallery widths="200px" heights="200px" class="right">~~
	~~File:Product import 4.png\|Product Section in CSV File~~
	~~</gallery>~~

	~~The next section of the file contains the product description.~~

	~~The four fields in this section include the '''Body''', '''Vendor''', '''Type''' and '''Tags''' fields.~~

	~~This data is only required only on the '''FIRST''' record in a product definition. If any of these fields are specified on subsequent records for the product, they will be ignored.~~

	~~==== Variations Section ====~~

	~~<gallery widths="200px" heights="200px" class="right">~~
	~~File:Product import 5.png\|Variations Section in CSV File~~
	~~</gallery>~~

	~~The next 16 fields define each variation.~~

	Each product variation requires one record in the CSV file, so include as many entries as necessary. Remember to include the '''Handle''' and/or '''Title''' fields for the product at the start of each record.

	~~==== Custom Options Section ====~~

	~~<gallery widths="200px" heights="200px" class="right">~~
	~~File:Product import 6.png\|Custom Options Section in CSV File~~
	~~</gallery>~~

	~~The following 3 fields define all the custom options and their values.~~

	An entry is required for each custom option name and each of the values and prices for that name. Each combination requires one product record, and you need to include as many records as necessary to define all custom option combinations.

	It doesn't matter if you have more or less Custom Options than Variations. In the example on the right, there are 3 variations, but 4 custom options, so we need a total of 4 product records for the first product.

	~~==== Images Section ====~~

	~~<gallery widths="200px" heights="200px" class="right">~~
	~~File:Product import 7.png\|Images Section in CSV File~~
	~~</gallery>~~

	~~The final field defines the images for the product.~~

	~~Each entry is the URL of the image on a web server. Each product image is listed on a single record. You need to include as many records as you have product images to define.~~

	It doesn't matter if you have more or less Images than Custom Options or Variations. In the example on the right, there are 3 variations, 4 custom options, but only 1 image, so we need a total of 4 product records for the first product.