Skip to main content

Bulk Import Menu Items

Overview: Bulk Import Menu Items​

The Bulk Upload feature allows administrators to upload hundreds of menu items at once using a CSV file. This saves time compared with adding items one-by-one.

Key Capabilities​

  • Create New Items: If the product name doesn't exist, the system creates it.
  • Update Existing Items: If the product name exists, the system updates its details (for example, prices).
  • Auto-Create Categories: If a category name in the file doesn't exist, the system creates it automatically.
  • Variations Support: Items with multiple sizes (Small/Large) can be uploaded in the same file.

Limitations​

  • Combo Products: Cannot be uploaded via bulk. Add combos manually.
  • Images: Must be direct URLs (public links). File uploads are not supported.
  • Maximum File Size: 5 MB.

Workflow Guide​

Step 1: Access the Bulk Upload Tool​

  1. Navigate to Back Office > Menu & Recipes > Menu Items.
  2. Click the blue Bulk Upload (or "Bulk Product") button in the top-right.
  3. A popup labelled Bulk Upload Products opens.

Step 2: Download the CSV Template​

  1. Inside the popup click Download Sample CSV Template.
  2. This downloads sample_products_bulk_upload.csv. Open it in Excel, Google Sheets, or another editor.

Step 3: Fill Data in the CSV File​

Use the provided template without changing column headers. Required columns and examples are below.

Essential columns

Column HeaderDescriptionExample
nameThe name of the dish.Chicken Burger
categoryThe menu category.Burgers
food_menu_typeMust be Regular (Combo unsupported).Regular
is_vegTRUE or FALSE.FALSE
dine_in / delivery / take_awayBase prices per service type.250
descriptionShort description of the item.Grilled chicken with cheese
item_photoDirect URL to image (.jpg or .png).https://.../burger.jpg
recipeUse Recipe ID, not name.68a6422e...
modifiersUse Modifier ID(s), comma-separated.b12da63b...,f33a9e10...

For variations (sizes)

Column HeaderDescriptionExample
is_variationTRUE if the row is a variation row.TRUE
variation_nameSize/variation name (e.g., Large).Large
variation_dine_inPrice for this variation for dine-in.300

Notes:

  • Leave variation columns blank or set is_variation to FALSE for non-variant items.

Step 4: Upload the File​

  1. Save your CSV (max 5 MB).
  2. In the Bulk Upload Products popup click Choose File and select the CSV.
  3. Click UPLOAD.
  4. The system processes the file; refresh the Menu Items list when complete.

Troubleshooting Common Errors​

  1. "Recipe/Modifier Not Found" — Ensure you supplied the ID (long string) not the name; IDs are visible in the item's/edit URL or the relevant list.
  2. "Combo Product Error" — Remove rows where food_menu_type is Combo; add combos manually instead.
  3. "Image Not Showing" — Confirm item_photo is a public direct link ending in .jpg or .png; avoid Google Drive share links.
  4. File Too Large — Compress or split the file to keep uploads under 5MB.

Best Practices​

  • Prepare and validate data in Excel or Google Sheets before upload.
  • Use the sample template; do not rename headers.
  • Upload non-critical batches first to validate the mapping.