How to bulk upload product and categories

5 min. readlast update: 05.04.2026

How to Fill in the Menu Upload File

Use this article to create your categories, subcategories, and products in bulk.

This file is a template that you need to fill in and upload to your dashboard.

Important:

  • The file must be saved as a CSV or XLXS
  • You can edit it using:
    • Excel
    • Google Sheet

Once completed, you need to upload to the dashboard after Creating your Menu. 
Once your menu is uploaded and active will be shown inmediatly on your app and widget.

* How to create a MENU on your  dashboad?


Columns Meaning

Column What to enter Example Notes
Type The type of row CATEGORY, SUBCATEGORY, PRODUCT Required. This tells the system what you are creating.
ID Existing item ID Leave empty for new items Only use this when editing exported items.
Position Display order 1, 2, 3 Lower number appears first.
Name Name shown in the app Burgers, Classic Burger Required.
Description Description shown in the app Fresh burger options Optional.
Price Product price 9.99 Only for products.
CategoryID Existing category ID 651 Optional. If empty, it follows the structure above.

Example: Category → Subcategory → Products

Type ID Position Name Description Price CategoryID
CATEGORY   1 Burgers Fresh burger options    
SUBCATEGORY   1 Beef Burgers All beef burgers    
PRODUCT     Classic Burger Beef burger with cheese 9.99  
SUBCATEGORY   2 Chicken Burgers Chicken options    
PRODUCT     Chicken Burger Grilled chicken burger 8.99  
CATEGORY   2 Drinks Cold drinks    
PRODUCT     Coke Can of Coke 2.50  
PRODUCT     Water Still water bottle 1.50  

How This Works

The system reads the file from top to bottom.

Think of it like building your menu step by step:

  1. You create a Category
  2. Then a Subcategory (optional)
  3. Then the Products that belong to it

Each product is assigned to the closest category or subcategory above it


Example Explained

  • You create:
    • Burgers → Beef Burgers

So:

  • Classic Burger belongs to Beef Burgers

  • Then you create:
    • Chicken Burgers

So:

  • Chicken Burger belongs to Chicken Burgers

  • Then you create:
    • Drinks

So:

  • Coke and Water belong to Drinks

Simple way to think about it:

  • The file works like a menu structure
  • Each new category/subcategory becomes the “active section”
  • Products always belong to the last active section above them

Option Groups and Nested Option Groups

⚠️ Important:

This uses a separate CSV or XLXS file and needs to be upload under the Option Group Section

(not the same file used for categories and products)

You will have:

  • One file → Menu (categories + products)
  • One file → Options (customizations)

* How to create a OPTION AND NESTED OPTIONS manually on your dashboad?


How Customization Works in the App

Customizations always follow this flow:

The product decides which options appear


Example (Real Flow)

Customer selects a product:

Burger Meal

At the product level, the customer chooses:

  • Coke
  • Water

This is not an option group — this is part of the product setup.


Step 1 — Option Group

After selecting the product (or a product variation like Coke), the customer sees:

Choose Your Drink

  • Coke
  • Coke Zero
  • Coke Diet

This is the Option Group
It groups similar choices together


Step 2 — Nested Option Group

After choosing one option (for example, Coke), a second question appears:

Choose Size

  • Small
  • Medium
  • Large

This is the Nested Option Group


Simple Way to Understand It

  • Product → decides main selection (e.g. Coke, Water)
  • Option Group → variations (e.g. Coke, Coke Zero, Coke Diet)
  • Nested Option Group → extra step (e.g. size)

Option Group + Nested Option Group Example

Type ID LinkId Name IdentifierName Price MinChoice MaxChoice NestedOptionGroupIds Active Archive
OPTION_GROUP   OG_DRINK Choose Your Drink choose_drink   1 1   1 0
OPTION   OPT_COKE Coke coke 0       1 0
OPTION   OPT_ZERO Coke Zero coke_zero 0       1 0
OPTION   OPT_DIET Coke Diet coke_diet 0       1 0
NESTED_OPTION_GROUP   NOG_SIZE Choose Size choose_size   1     1 0
NESTED_OPTION   NSO_SMALL Small small 0       1 0
NESTED_OPTION   NSO_MEDIUM Medium medium 0.50       1 0
NESTED_OPTION   NSO_LARGE Large large 1       1 0

How to Read This Example

  • OPTION_GROUP creates:

    Choose Your Drink

  • OPTION rows define the choices:

    Coke, Coke Zero, Coke Diet


  • NESTED_OPTION_GROUP creates:

    Choose Size

  • NESTED_OPTION rows define:

    Small, Medium, Large


Final Customer Flow

Product selected
→ Choose Your Drink (Option Group)
→ Coke / Coke Zero / Coke Diet
→ Choose Size (Nested Option Group)
→ Small / Medium / Large


Important Notes

  • MinChoice = 1 → customer must choose
  • MaxChoice = 1 → only one allowed in this example
  • Price → adds extra cost
  • Active = 1 → visible
  • Archive = 1 → removed

How to Make Changes Later

Option 1: Edit in Dashboard (Easiest)

Use this for:

  • Price changes
  • Name edits
  • Disabling items
  • Deleting items

Option 2: Changes on file - Export, Edit, and Import Again

Best for bulk updates:

Steps:

  1. Export your menu
  2. Open it in Excel
  3. Make your changes
  4. Save as CSV or XLXS
  5. Upload again to the dashboard

Important: Understanding IDs When Editing

When you export your menu, every column will already have:

  • ID (for products, categories, etc.)
  • CategoryID (for categories)

These IDs are automatically generated by the dashboard once is upladed first time.


What You Can Change in the File

You can safely update the following:


Change Price

Just edit the value in the Price column.

Example:

Name Price
Classic Burger 9.9910.99

Edit Name or Description

Update directly in:

  • Name
  • Description

Disable a Product or Category (Temporarily Hide, not deleted)

Use the Active column:

  • 1 = visible
  • 0 = hidden/disabled

Example:

Name Active
Coke 10

The item will not appear in the app, but is not deleted


Delete / Archive an Item

Use the Archive column:

  • 0 = keep item
  • 1 = archive (remove it)

Example:

Name Archive
Old Product 01

This will remove the item from your menu

Was this article helpful?