Importing Products to the eCommerce Store

Importing Products to the eCommerce Store

The product file should be a CSV (comma-separated values) file.  Each row may represent a product or a variant of a product, depending on if the column variant_of  is set.

A header row is optional. 

The process is case-insensitive (capitalization does not matter) when matching names/SKUs.  Values will be imported as they are.

The following columns can be used:

• update_fields: If the fields of the product or variant should be updated if the product or variant already exists. True or False. Defaults to the value of the "Update Fields" checkbox.
• name: The product name. Required if the row represents a product (variant_of is not set).
• description: The product description.
• sku: The SKU of the product or variant.
• price: The price of the product or variant. Required if the row represents a product (variant_of is not set).
• weight: The weight of the product or variant package. For shipping calculations.
• height: The height of the product or variant package. For shipping calculations.
• width: The width of the product or variant package. For shipping calculations.
• depth: The depth of the product or variant package. For shipping calculations.
• image_url: An URL pointing to an image of the product or variant.
• available_on: A date for when the product or variant should first become available. Set it to a past date if it should be available immediately. Format: YYYY-MM-DD (ISO 8601).
• track_inventory: If the store should keep track of the product or variant. True or False. False by default.
• backorderable: If the product or variant is backorderable. True or False. False by default.
• count_on_hand: Number of product or variant units in stock.
• categories: The names of the categories to which the product should be associated, separated by "|" (e.g.: "Merchandise|T-Shirts"). They will be created if non-existent.
• options: The names and values of the Option Types associated to the product or variant. Required if variant_of is set or create_variants is True. Format: "Color:Red|Color:Blue|Color:Green|Size:Small|Size:Medium|Size:Large". They will be created if non-existent.
• create_variants: If variants should be created based on each options combination. Defaults to True. Only applicable if the row represents a product (variant_of is not set).
• variant_of: If set, the row represents a variant of a product. The value should be the SKU or name of the product.
  

If a field contains double quotes, they must be escaped with a backslash. E.g.: "This is a product \"description\"".
If a field contains a line-break, the whole field must be surrounded by double quotes. E.g.: "This field has a \n Line break". It is recommended, but not required, that all fields be double-quoted.