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.


    • Related Articles

    • Getting Started with your ENGAGE eCommerce Store

      1. eCommerce Store User Guide Accessing your eCommerce Store Admin Managing Orders Refunding Payments Editing and adding products Customizing your Storefront, Checkout & Notification Emails 2. Managing Digital Gift Card Sales and Redemption 3. ...

    • Creating a New eCommerce Store Promotion

      Step 1. Select “Promotions” under the Promotions Tab in the navigation. Step 2. Select “+ New Promotion” Step 3. Complete the following fields: Name The name you assign to the promotion. Code You can either create a custom code that will be used at ...

    • eCommerce Store Payment Gateway Integrations

      What Payment Gateway Options are supported? The eCommerce Store supports Jupico, Paypal, Heartland, Authorize.net payment gateways. What info is needed to setup Jupiter for Payment processing? You can apply for a Jupico Payment Gateway for our ...

    • eCommerce Store Implementation Guide

      This article covers the main requirements for initial setup of your eCommerce Store. See our eCommerce Store User Guide for guidance on operating your Store after initial setup. Store Items Gift Cards We can add Digital or Physical Gift Cards to your ...

    • eCommerce Store Fedex and UPS Integration

      Currently the eCommerce store integrates with UPS and FedEx for shipping calculations. To setup the integration we will need a set of credentials and the process to obtain those will be outlined below. UPS: For UPS you will need your login username ...