INTRODUCTIONThe 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.
OVERVIEWUploaded 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.
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 IMPORTThis 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 IMPORTThis is an example import file that only updates inventory counts for the products in above example.
Download Inventory Only Example Import