Importing Products

INTRODUCTION

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.

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.

AVAILABLE FIELDS

SKU                               | required in Product and Sub-Product lines
ProdName
ProdDescription
Brand
Manufacturer
IsRetail                          | “TRUE”,”FALSE”  Note: IsRetail defaults to TRUE if RetailPrice is set
RetailPrice*                      | Products can have multiple price categories.  * represents the value linking the
RetailPriceCat*                   | price, price category and special price and should be incremental numbers.
IsWholesale                       | “TRUE”,”FALSE” Note: IsWholesale defaults to TRUE if WholesalePrice is set
WholesalePrice
WholesaleQty
ProdStatus                        | “In Stock”,”Out of Stock”,”Backordered”,”Discontinued”
ProdInventory
OutOfStockPoint
ProdOnOrder
AltID
VendorID                          | the ID of the drop-shipper for the product
DescriptionHeader
ProductURLName                    | must be unique
SpecialPrice*                     | * represents the value linking price, price category and special price
IsSpecialOngoing                  | “TRUE”,”FALSE”
SpecialStart                      | format: mm-dd-yyyy hh:mm
SpecialEnd                        | format: mm-dd-yyyy hh:mm
SpecialText
BackorderedDate                   | format: mm-dd-yyyy
IgnoreBackorder                   | “TRUE”,”FALSE”
MinimumQuantity                   | Coming Soon
MaximumQuantity                   | Coming Soon
QuantityInSet                     | Coming Soon
NumIterationsDisplayed            | Coming Soon
DisplayWeight
ActualWeight
Unit                              | “none”,”each”,”tsps”,”tbs”,”cps”,”oz”,”pts”,”qts”,”ml”,”l”,”lbs”,”dz”,”pr”,”gal”,”sheet”
ImageSetThumb*                    | Products can have multiple image sets.  * represents the value linking the thumbnail, large,
ImageSetLarge*                    | and popup, type, and title for each image set. NOTE: This does NOT upload images.  These are
ImageSetPopup*                    | links only. The images must already exist on an external server or in your store.
ImageSetType*                     | “product” or “color_swatch”
ImageSetTitle*                    |
ImageSetEditType                  | “overwrite”,”append”  choose to overwrite current image sets or append to the end of the list.  The default is “overwrite”.
IsInactive                        | “TRUE”,”FALSE”
IsOutOfSeason                     | “TRUE”,”FALSE”
IsTaxExempt                       | “TRUE”,”FALSE”
HasTextField                      | “TRUE”,”FALSE”
IsHidden                          | “TRUE”,”FALSE”
IsFeatured                        | “TRUE”,”FALSE”
IsNew                             | “TRUE”,”FALSE”
IsGoogleCheckoutExempt            | “TRUE”,”FALSE”
IsContentOnly                     | “TRUE”,”FALSE”
IsInventoryExempt                 | “TRUE”,”FALSE”
IsSubscription                    | “TRUE”,”FALSE”
SubscriptionPrice
HasElectronicDelivery             | “TRUE”,”FALSE”
ElectronicDeliveryLink*           | products can have multiple electronic delivery documents
ElectronicDeliveryDaysAvailable*  | * represents the value linking the Link, DaysAvailable and Description
ElectronicDeliveryDescription*    |
ElectronicDeliveryEditType    COMING SOON    | “append”,”overwrite”  choose to overwrite current electronic delivery links or append new ones.  The default is “append”.
IsKit                             | “TRUE”,”FALSE”
KitProductSKUs                    | comma separated list of SKUs
ShipPreference                    | “tables”,”fixed”,”both
FixedShipping
ShipsInOwnBox                     | “TRUE”,”FALSE”
PackageLength
PackageWidth
PackageHeight
FreightClass
IsGiftCertificate                 | “TRUE”,”FALSE
GiftCertificateDaysAvailable
GiftCertificateValue
Rating
Keywords
MetaKeywords
MetaTitle
MetaDescription
CategoryIDs                       | comma separated list of category IDs
Custom1
Custom2
Custom3
Custom4
Custom5
Custom6
Custom7
Custom8
Custom9
Custom10
Custom11
Custom12
Template
DependencySKUs                    | comma separated list of SKUs
DependencyType                    | “AND”,”OR”
AdditionalProdSKUs                | comma separated list of SKUs
RelatedProdSKUs                   | comma separated list of SKUs
GiftWrap                          | “TRUE”,”FALSE”
GiftWrapName                      |
GiftWrapSKU                       |
GiftWrapAmount                    |
CategoryFilter*                   | products can have multiple category filters and values
CategoryFilterValue*              | * represents the value linking the filter with the value
ParentSKU                         | required for sub-product and attribute lines
SubProductAttributes              | comma separated list of attributes
IsAttribute                       | “TRUE”,”FALSE”  – required for attribute lines
AttributeTitle1                   | attribute titles are set in the parent product line
AttributeTitle2
AttributeTitle3
AttributeTitle4
AttributeSKU
Attribute1                        |
Attribute2                        | Required to update attribute
Attribute3                        | information
Attribute4                        |
Attribute1Code                    |
Attribute2Code                    |
Attribute3Code                    |
Attribute4Code                    |
AttributePrice*                   | Attributes can have multiple price categories.  * represents the value linking the
AttributePriceCat*                | price, price category and special price and should be incremental numbers.
AttributeSpecialPrice*            | * represents the value linking price, price category and special price
IsAttributeSpecialOngoing         | “TRUE”,”FALSE”
AttributeSpecialStart             | format: mm-dd-yyyy hh:mm
AttributeSpecialEnd               | format: mm-dd-yyyy hh:mm
AttributeBackorderedDate          | Format: mm-dd-yyyy
AttributeIgnoreBackorder          | “TRUE”,”FALSE”
AttributeInventory
AttributeOutOfStockPoint
AttributeOnOrder
IsAttributeInactive               | “TRUE”,”FALSE”        Note:this field will be ignored if AttributeStatus exists
AttributeStatus                   | “active”, “inactive”, “deleted”, “discontinued”
IsAttributeGiftCertificate        | “TRUE”,”FALSE”
AttributeGiftCertificateDaysAvailable
AttributeGiftCertificateValue
IsAttributeSubscription           | “TRUE”,”FALSE”
AttributeSubscriptionPrice

EXAMPLE IMPORT

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

EXAMPLE INVENTORY ONLY IMPORT

This is an example import file that only updates inventory counts for the products in above example.

Download Inventory Only Example Import