Help Center / Menu Management

How to Bulk Upload Restaurant Menu via CSV or Excel

Overview

OnePe’s CSV / Excel Upload option lets you import large restaurant menus in bulk using spreadsheets. This method is ideal when migrating from another system, updating large catalogs, or managing structured menu data efficiently.

CSV & Excel Column Structure

To ensure a smooth import, format your spreadsheet with the appropriate column headers listed below:

Required Columns

  1. item_name: The display name of the menu item.
  2. category_name: Category the item belongs to (e.g., Burger, South Indian). Missing categories are auto-created upon upload.
  3. menu_name: Menu group for the item (e.g., Breakfast, Main Menu). Missing menus are auto-created upon upload.
  4. price: Item price in numbers.

Optional Columns

  1. description: Detailed item description.
  2. type: Dietary type (e.g., Veg, Non Veg, Contains Egg).
  3. show_on_customer_site: Visibility status (Yes or No).
💡 Tip for Existing Categories & Menus:
Use exact category and menu names already created in your system to avoid duplicate entries. Unrecognized categories or menus will be created automatically.

Step-by-Step Guide

Step 1: Download the Sample File

  1. Go to Menu Management > Bulk Upload Menu Items in your OnePe Dashboard.
  2. Click the CSV / Excel Upload tab.
  3. Click Download Sample File in the top-right corner to get a correctly formatted spreadsheet template.

Step 2: Prepare Your Spreadsheet

  1. Open the sample file in Microsoft Excel, Google Sheets, or any spreadsheet editor.
  2. Fill in your menu items following the column guidelines shown above.
  3. Reference the Available in Your System section on your screen to check existing categories and menus.
  4. Save your completed file as .csv or .xlsx.

Step 3: Upload and Select Kitchen

  1. Drag and drop your file into the Upload File drop zone, or click Choose file.
  2. Verify the auto-selected destination kitchen under Kitchen Selected (e.g., Default Kitchen).

Step 4: Import Your Menu

  1. Review the checklist under Start Import.
  2. Ensure both File Uploaded and Kitchen Selected display green checkmarks.
  3. Click Next to run the import process.

Need to Restart or Download Template Again?

  1. Download Template: Click Download Sample File at the top right.
  2. Reset Upload: Click Start New Upload at any time to clear current inputs and start over.