> ## Documentation Index
> Fetch the complete documentation index at: https://docs.jelou.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Import products

> Bulk-load your catalog with the Excel template: steps, sheets, fields and formats.

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.

> [!NOTE]
>
> 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](https://apps.jelou.ai/shop-v2/products), click **Import**.

![Import button on the Products screen](https://mintcdn.com/jelouai/iC8zdv4B6xOY2cqw/assets/images/integraciones/e-commerce/shop-import/importar.png?fit=max\&auto=format\&n=iC8zdv4B6xOY2cqw\&q=85\&s=05b316306edf6cccf218cdbde67bbf51)

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](https://mintcdn.com/jelouai/iC8zdv4B6xOY2cqw/assets/images/integraciones/e-commerce/shop-import/sku-automatico.png?fit=max\&auto=format\&n=iC8zdv4B6xOY2cqw\&q=85\&s=1fc453ce12580253473018c1717f16a5)

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](https://mintcdn.com/jelouai/iC8zdv4B6xOY2cqw/assets/images/integraciones/e-commerce/shop-import/hojas-opcionales.png?fit=max\&auto=format\&n=iC8zdv4B6xOY2cqw\&q=85\&s=305f7b98da0e5bfb37a36bb2e5fbe89d)

Complete upload: optional sheets enabled.

> [!NOTE]
>
> 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](#the-excel-template) 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.

| 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). |

> [!NOTE]
>
> 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.

| 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 by `product_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. |

## 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.

> [!TIP]
>
> To manage the catalog from the interface, see [Shop Admin](https://docs.jelou.ai/en/guides/integrations/e-commerce/shop-admin.md).


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.