Bulk Product Export and Import - Revision history

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

2022-11-10T23:24:24Z

The products.csv file explained

2022-11-10T23:23:40Z

The products.csv file explained

2022-11-10T23:19:01Z

Product Import Page

2022-07-21T02:36:47Z

2022-05-13T00:48:47Z

CSV File Usage Notes

2020-08-26T23:50:48Z

The products.csv file explained

2020-08-26T23:47:15Z

Product Import Page

2020-05-19T22:31:31Z

The products.csv file explained

2020-05-19T22:25:27Z

The products.csv file explained

2020-05-19T22:24:39Z

The products.csv file explained

@@ Line 125: / Line 125: @@
 |-
 | '''Product Category'''
-| A label that describes the type of product and is used to help categorize products in search engines and other sales platforms. This label must be taken from the predefined standardized list of product categories.
+| A label that describes the type of product and is used to help categorize products in search engines and other sales platforms. This label must be taken from the predefined standardized list of product categories.<br><br>You can input the standardized product category in either as the full path from the Standardized Product Taxonomy, or use the numerical ID for the category.
 |-
 | '''Type''' (Required)

@@ Line 123: / Line 123: @@
 | '''Vendor''' (Required)
 | The name of the product's vendor.
 |-
 | '''Type''' (Required)

@@ Line 49: / Line 49: @@
 Body (HTML)
 Vendor
 Type
 Tags

@@ Line 3: / Line 3: @@
 This feature gives you the ability to perform a bulk import of new products into your store, or to update product attributes such as prices and inventory levels. The update capability is useful if you need to keep your store prices synchronized with an inventory management system, or if you have a large number of products and need an easier method for maintaining them.
-You can also import a CSV file of your products downloaded from Shopify, which is in a different format, but the import feature adapts to accept it.
+You can also import a CSV file of your products downloaded from Shopify, which is in a different format, but the import feature adapts to accept it.  If you're having problems importing products from Shopify, please send us your CSV file at [mailto:support@spiffystores.com.au support@spiffystores.com.au]
 == Exporting Products ==

@@ Line 272: / Line 272: @@
 *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 pption names (and values).
+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.

@@ Line 115: / Line 115: @@
 |-
 | '''Body'''
-| The product's description. This field may contain Textile markup codes. It may also include UTF-8 characters.
+| The product's description. This field may contain Textile markup codes. It may also include UTF-8 characters. If you use this column to populate the product decription, make sure you leave the column "Body (HTML)" blank.
 |-
 | '''Vendor''' (Required)

@@ Line 47: / Line 47: @@
 Title
 Body
 Vendor
 Type

@@ Line 156: / Line 156: @@
 |-
 | '''Variant Location Code'''
-| This is an optional value that you can use to specify a physical location for the variation. For example, you could use a shelf location, box number or some other identifier to indicate where you would find the item in your inventory. If the location code is available, then the packing list and order view will be sorted in location code order so that you will have a pick list sorted to make order fulfillment easier.
+| This is an optional value that you can use to specify a physical location for the variation. For example, you could use a shelf location, box number or some other identifier to indicate where you would find the item in your inventory. If the location code is available, then the packing list and order view will be sorted in location code order so that you will have a pick list sorted to make order fulfilment easier.
 |-
 | '''Variant Barcode'''

@@ Line 154: / Line 154: @@
 | '''Variant SKU'''
 | This is the SKU (Stock Keeping Unit) identifier used to identify the variation.
 |-
 | '''Variant Barcode'''