Hi. How can we help?

Search

Importing products in bulk

To quickly import products and format product data, you can use a spreadsheet CSV file to import products in bulk to your eCom (C-Series) back office.

Downloading the spreadsheet template

  1. Navigate to Tools > Imports > New Import.

  2. Click Download Template to download the product import template spreadsheet. This is a pre-formatted template that includes all the relevant columns needed to import products into eCom (C-Series).

    Create New Import page.

  3. Open the product import template spreadsheet in Excel or Google Sheets.
  4. Enter your product data for each column.
  5. Save your spreadsheet, then download as a CSV file.

Importing your spreadsheet file

  1. Navigate to Tools > Imports > New Import.
  2. Drag and drop your file or click Browse Computer to locate the file on your computer.

  3. Click the Set category dropdown and select Products.

    Imports page with column mapping details.

  4. Click the Behavior dropdown and select Only creates new products to import new products, or Only update existing products to make changes to products you've previously imported. 
  5. Click the Group by dropdown and select the field you want to use to group variants.
  6. In the Set Field Types section, review the list of columns and the mapped eCom product fields. Check the Skip box to ignore the column on import.
  7. Click Continue.

Once complete, the import will display as Finished and will be listed on the Imports page with the file details and import date.

To verify your products were successfully imported, copy a product's Internal_ID from your spreadsheet file, navigate to Products > paste the ID into the search bar > press enter or the search icon. The product should appear in the search results list. 

Commonly required columns for worksheets

  Column name System name Importance
01 Product ID Internal_ID Allows you to add variants.
02 Title XX_Title_Short Required when importing new products.
03 Full title XX_Title_Long  
04 Description XX_Short_Description Used in most themes as a short summary of the product.
05 Content XX_Long_Description Most themes display the content on the product page. If left blank, the product page may look incomplete.
06 Variant title XX_Variant_Title When adding variants, allows you to set the title of the variant.
07 Category 1
Category 2
Category 3		 XX_Category_1
XX_Category_2
XX_Category_3 		Used for your website's navigation and product organization. You can't update existing categories through an import.
08 Brand Brand Used by most themes for shop navigation, usually a summary page which displays all brands.
09 Price Price Required when selling products online.
10 Visibility Visible Controls whether your products are immediately visible on your eCom store.
11 Inventory level Stock_Level Setting the inventory level can prevent customers from purchasing more products than you have available in stock.
12 Weight unit Weight_Value
Weight_Unit 		Setting the weight value and unit is important for shipping methods, as shipping is based on weight.

If you use your own column titles, you'll need to manually map your columns to the correct fields in the Set Field Types section during the import process.

Was this article helpful?

0 out of 0 found this helpful