Bulk Inventory Export and Import - Revision history

Admin at 23:04, 10 December 2024

2024-12-10T23:04:30Z

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

2024-12-10T22:39:54Z

The inventory.csv file explained

Admin: /* Product Import Page */

2024-12-10T22:39:40Z

Product Import Page

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

2024-12-10T02:32:52Z

The inventory.csv file explained

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

2024-12-10T02:32:28Z

The inventory.csv file explained

Admin: /* Product Import Page */

2024-12-10T02:31:07Z

Product Import Page

Admin at 01:04, 10 October 2024

2024-10-10T01:04:18Z

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

2024-10-10T01:03:02Z

The products.csv file explained

Show changes

Admin: /* Product Import Page */

2024-10-10T00:43:56Z

Product Import Page

Admin: /* Product Import Page */

2024-10-10T00:41:21Z

Product Import Page

← Older revision		Revision as of 23:04, 10 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 ==

@@ Line 136: / Line 136: @@
 | '''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.
 |}

@@ Line 68: / Line 68: @@
 Available
 On hand
 </pre>

@@ Line 137: / Line 137: @@
 | '''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.
 | '''Price'''
 | The price of the variation.
 |}

@@ Line 137: / Line 137: @@
 | '''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.
 |}

← Older revision		Revision as of 01: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.

@@ Line 53: / Line 53: @@
 <pre>Handle
 Title
 Option1 Name
 Option1 Value
@@ Line 68: / Line 59: @@
 Option3 Name
 Option3 Value
-Variant SKU
+SKU
-Variant Location Code
+HS Code
-Variant Barcode
+COO
-Variant Grams
+Location
-Variant Inventory Tracker
+Incoming
-Variant Inventory Qty
+Unavailable
-Variant Inventory Policy
+Committed
-Variant Fulfillment Service
+Available
-Variant Price
+On hand
 </pre>
 The fields are explained below.

@@ Line 38: / Line 38: @@
 The '''Product Import''' page contains some instructions on how to use the product import process. In the side-bar are the answers to a number of commonly asked questions about importing products.
-If you want a template CSV file to use to start building your product update CSV file, then click on the '''Download Template CSV''' button.
+If you want a template CSV file to use to start building your product update CSV file, then click on the '''Download Template CSV''' button. This is only used for full Product imports, and if you want to use an Inventory import CSV file, you should do an export of the Inventory first.
 <gallery widths="200px" heights="200px" class="right">