Bulk Upload API Documentation

1. Overview

The Bulk Upload API allows you to create multiple products and categories in a single request using either XLSX or CSV file formats.

• Categories and products are processed in order.

• Products automatically inherit the category from the most recent category row above them.

2. Template

• CSV File
• XLXS File

3. File Format

3.1 Supported Formats

• XLSX — Excel 2007 and later

• CSV — Comma-separated values

3.2 Row Types

Each row must include a Type column that specifies one of the following:

4. Column Definitions

4.1 Category Rows

Auto-generated fields:

• categoryUrl — Generated from name-menuId (e.g., "chicken-dishes-44")

• categoryId — Auto-incremented primary key

• parentCategoryId — Always null for CATEGORY type

4.2 Subcategory Rows

Parent Assignment Logic

• If ParentId is provided → Uses that specific parent category (must exist).

• If ParentId is empty → Inherits from the most recent CATEGORY row above.

• If neither exists → Validation error.

Auto-generated fields:

• categoryUrl — Generated from name-menuId

• categoryId — Auto-incremented primary key

4.3 Product Rows

Category Assignment Logic

• If CategoryId is provided → Uses that specific category/subcategory (must exist).

• If CategoryId is empty → Inherits from the most recent CATEGORY or SUBCATEGORY row above.

• If neither exists → Validation error.

5. Character Validation

Both Name and Description fields accept:

✅ Allowed:

• Letters (including accented characters: é, ñ, ü, etc.)

• Numbers (0–9)

• Spaces

• Common punctuation: , . - ' & ( ) [ ] /

• Line breaks and tabs

❌ Not allowed:

• Special symbols like @ # $ % ^ * = + { } | \ ; : " < >

6. Example Files

6.1 XLSX Format

Example 1 — Category Inheritance

Products inherit the category from the row above.

Example 2 — Explicit Category ID

Example 3 — Subcategories (Parent Inheritance)

Example 4 — Explicit ParentId for Subcategories

6.2 CSV Format

Example 1 — Category Inheritance

Example 2 — Explicit Category ID

Example 3 — With Subcategories

CSV Notes:

• Empty cells must still have commas (e.g., PRODUCT,,Name,Description,Price,)

• If a field contains commas, wrap it in quotes — e.g. "Chicken, Grilled"

• Position, Price, and CategoryId may be left empty