Skip to main content
Import many products at once by uploading an Excel file (.xlsx) that follows the structure of a downloadable template. The import runs in the background and you can track its progress in the same panel.
The import creates or updates products by their SKU: if the SKU already exists in your store it is updated; otherwise it is created.

​
How to import

1

Open Import

In Products, click Import.
Import button on the Products screen

Import button on the products list.

2

Choose the type of upload

Simple upload. Keep Generate SKU automatically on. The template won’t include the SKU column and the system assigns a unique SKU to each product. Ideal for uploading products quickly, with no extra configuration.
Generate SKU automatically option turned on

Simple upload: the SKU is generated automatically.

Complete upload. Turn Generate SKU automatically off so the SKU column and the optional sheets (Variations, Features, Modifiers) appear. Enable the ones you need for a more detailed upload.
Optional sheets (Variations, Features, Modifiers) enabled

Complete upload: optional sheets enabled.

Optional sheets link to each product by its SKU, so they require the SKU column. Enabling them turns off automatic generation.
3

Download the template

Press Download template (available in Spanish or English). The file is generated based on the options you chose.
4

Fill in the Excel

Complete the data using the Instructions sheet and the comments on each column. See the template structure below.
5

Upload the file and track progress

Drag or select your .xlsx and confirm. The import runs in the background and you’ll see created/updated products and, if any, per-row errors.

​
The Excel template

The first sheet, Instructions, summarizes what each sheet is for and includes a color reference. On the other sheets, each header is colored by whether it’s required and has a comment (hover over it) explaining what to enter.
The Products sheet is always required. Optional sheets only appear if you enabled them when downloading the template, and they reference products by the SKU on the Products sheet.

​
Important formats

  • Numbers and prices: a dot or a comma decimal is accepted (24.99 or 24,99).
  • Booleans (yes/no): TRUE or FALSE.
  • Lists (categories, images): separate multiple values with semicolons (;). E.g. Apparel;Shirts.
  • Stock type: limited or unlimited. Discount type: value or percentage.

​
Sheet: Products

Base data for each product. This is the only required sheet.

​
Sheet: Variations

Variations of a product (size, color, etc.). Each row links to the product by product_sku.

​
Sheet: Features

Informational product attributes, in label/value format.

​
Sheet: ModifierGroups

Groups of modifiers for a product (e.g. Toppings, Size).

​
Sheet: ModifierOptions

Options inside each modifier group.

​
Tracking and errors

After you upload the file, the import runs in the background. The panel shows progress and, when finished, a summary of created, updated and skipped products. If any row had problems, you’ll see a table with the sheet, row, SKU and reason, so you can fix and re-upload only what’s needed.
To manage the catalog from the interface, see Shop Admin.