The CommerceV3 Product Import allows users to, in its most basic usage, import an entire inventory at store creation time and, in its most advanced usage, maintain inventory via a single spreadsheet that can be used to create and update products in the online store.

3. USING THE CV3 PRODUCT IMPORT

3.I OVERVIEW

Uploaded import files are pipe- or tab-delimited files that contain product, sub-product and attribute data. The file can include any of the possible fields in any order you would like. The only limitations are that the SKU must be present for product lines, the SKU and ParentSKU must be present for sub-product lines and ParentSKU, IsAttribute and Attribute1 - Attribute* (* = the number of attributes you have for that product) must be present in attribute lines. These fields are used as the keys when updating and linking your products. Other than that you can include as many of the fields as you would like to update.

The first line of the import file is the header line. In the header line you will define which fields you will be using. Remember, they can be in any order you would like. The remaining lines will contain product data with the information corresponding to the fields you defined in the header line. The only limitation here is that sub-products and attributes need to fall below its parent product. See below for examples.

Note: The product import can not be used to delete existing products. When updating existing products, you can include only those SKUs you wish to update in your file. Any SKUs not included in the file will be left untouched.

This is an example import file that includes all available fields as well as all product types. Download Example Import
Here is a breakdown:

Line 1: Header Line
Line 2: Regular Product (no sub-products or attributes)
Line 3: Product Containing Sub-Products
Line 4: Sub-Product 1 for Product in Line 3
Line 5: Sub-Product 2 for Product in Line 3
Line 6: Sub-Product 3 for Product in Line 3
Line 7: Products Containing Attributes
Line 8: Attribute 1 for Product in Line 7
Line 9: Attribute 2 for Product in Line 7
Line 10: Attribute 3 for Product in Line 7
Line 11: Product with Electronic Delivery