Skip to main content

Import SKU/items into variants

Add SKUs or items to one or more existing variants by preparing a spreadsheet of item codes and option values and uploading it through the import center.

  1. Prepare the spreadsheet. Note that the base variant(s) must exist before importing. Provide the item code and the item description:

    Spreadsheet with ItemCode, BaseCode, Option1Name, Option1Value and Description columns for three blue, green and red table variants
  2. Add the name of each option and the value of that option for the specific item.

  3. Click on the Cog -> Import Center -> Variants -> Variant & Items:

Import Center with Variants and Variant & Items tabs selected, showing Download Template button and file upload with Upload button

4. Select the file and click on 'Upload'

5. Check the success message for the number imported, and if the import has worked, the variants are ready to use.

Import dialog showing a green Import Complete tick and the message "3 created, 0 updated" for Import Variants.xlsx

6. The example import gives this:

Edit Base Variant Items tab with three imported shell items, TABLE-2-B, TABLE-2-G and TABLE-2-R, highlighted in the list
Did this answer your question?