.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
Open Import
In Products, click Import.
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.
Optional sheets link to each product by its SKU, so they require the SKU column. Enabling them turns off automatic generation.
Download the template
Press Download template (available in Spanish or English). The file is generated based on the options you chose.
Fill in the Excel
Complete the data using the Instructions sheet and the comments on each column. See the template structure below.
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.| Header color | Meaning |
|---|---|
| 🔴 Red | Required — must have a value. |
| ⚪ Gray | Optional — can be left empty. |
| 🟡 Amber | Conditional — required only in some cases (depends on another field). |
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.99or24,99). - Booleans (yes/no):
TRUEorFALSE. - Lists (categories, images): separate multiple values with semicolons (
;). E.g.Apparel;Shirts. - Stock type:
limitedorunlimited. Discount type:valueorpercentage.
Sheet: Products
Base data for each product. This is the only required sheet.| Column | Requirement | Description |
|---|---|---|
sku | Required* | Unique product code. *Only appears if you turned off automatic SKU generation. |
name | Required | Product name. |
price | Required | Unit price. |
description | Optional | Product description. |
has_tax | Optional | Does it have tax? TRUE/FALSE. |
tax | Conditional | Tax percentage (e.g. 12). Applies when has_tax is TRUE. |
status | Optional | Is the product active? TRUE/FALSE. Active by default. |
stock_type | Optional | limited or unlimited. |
stock | Conditional | Available quantity. Required when stock_type is limited. |
discount_type | Optional | value or percentage. |
discount | Conditional | Discount amount or percentage. Requires discount_type. |
branch_code | Optional | Code of an existing branch. |
branch_name | Conditional | Branch name. Required when the branch code is new. |
categories | Optional | One or more categories separated by ;. |
images | Optional | Image URLs separated by ;. |
product_url | Optional | Public product URL. |
note_enabled | Optional | Allow a customer note? TRUE/FALSE. |
note_label | Conditional | Note label text. Applies when note_enabled is TRUE. |
replace_variations | Optional | TRUE replaces the product’s existing variations. |
Sheet: Variations
Variations of a product (size, color, etc.). Each row links to the product byproduct_sku.
| Column | Requirement | Description |
|---|---|---|
product_sku | Required | Parent product SKU (must exist on the Products sheet). |
variation_sku | Required | Unique variation SKU. |
price | Required | Variation price. |
stock_type | Optional | limited or unlimited. |
stock | Conditional | Available quantity. Required when stock_type is limited. |
attribute_1_name | Optional | Attribute 1 name (e.g. Size). |
attribute_1_value | Conditional | Attribute 1 value. Required when attribute 1 name is set. |
attribute_2_name | Optional | Attribute 2 name (e.g. Color). |
attribute_2_value | Conditional | Attribute 2 value. Required when attribute 2 name is set. |
attribute_3_name | Optional | Attribute 3 name. |
attribute_3_value | Conditional | Attribute 3 value. Required when attribute 3 name is set. |
images | Optional | Image URLs separated by ;. |
Sheet: Features
Informational product attributes, in label/value format.| Column | Requirement | Description |
|---|---|---|
product_sku | Required | Product SKU (must exist on the Products sheet). |
label | Required | Feature label (e.g. Brand). |
value | Required | Feature value (e.g. Apple). |
Sheet: ModifierGroups
Groups of modifiers for a product (e.g. Toppings, Size).| Column | Requirement | Description |
|---|---|---|
product_sku | Required | Product SKU (must exist on the Products sheet). |
group_code | Required | Unique group code within the product; referenced from ModifierOptions. |
name | Required | Group display name. |
min_quantity | Optional | Minimum options to choose. Defaults to 0. |
max_quantity | Optional | Maximum options to choose. Defaults to 1. |
max_per_option | Optional | Maximum quantity per option. |
is_required | Optional | Is the group required? TRUE/FALSE. |
position | Optional | Display order. |
Sheet: ModifierOptions
Options inside each modifier group.| Column | Requirement | Description |
|---|---|---|
product_sku | Required | Product SKU (must exist on the Products sheet). |
group_code | Required | Code of the group it belongs to (must match group_code on ModifierGroups). |
code | Required | Unique option code. |
name | Required | Option display name (e.g. Pepperoni). |
price | Optional | Additional price for the option (0 if left empty). |
image_url | Optional | Option image URL. |
position | Optional | Display order. |
status | Optional | Is the option active? TRUE/FALSE. Active by default. |
linked_product_sku | Optional | SKU of a product linked to this option. |