Import & Export
Import & Export
Menura supports bulk importing menu items from CSV and Excel files, with intelligent provider auto-detection, column mapping, preview, and rollback. You can also export your menu to PDF, CSV, or JSON.
Import
Supported Formats
- CSV (.csv)
- Excel (.xlsx, .xls)
Maximum import rows: 1,000 (MAX_IMPORT_ROWS)
Supported Source Providers
Menura automatically detects the source provider by analyzing column headers. Supported providers:
| Provider | Description | Key Column Markers |
|---|---|---|
| Square | Square POS export | item name, variation name, reporting category, sku |
| Toast | Toast POS export | menu group, menu item, modifier group, guid |
| Clover | Clover POS export | modifier groups, categories, hidden, price type |
| Lightspeed | Lightspeed export | default price, archived, tax class, sell online |
| Generic | Any standard CSV | Falls back to keyword matching on headers |
Provider detection requires at least 2 matching markers to auto-select. You can override the provider manually during import.
Importable Fields
| Field | Required | Description |
|---|---|---|
title | Yes | Item name |
price | Yes | Item price |
category | Yes | Category name (created if it doesn't exist) |
description | No | Item description |
available | No | Availability (yes/no, true/false, 1/0) |
is_featured | No | Featured flag |
is_coming_soon | No | Coming soon flag |
image | No | Image URL |
tags | No | Comma/semicolon/pipe-separated tags |
allergens | No | Comma/semicolon/pipe-separated allergens |
dietary_tags | No | Comma/semicolon/pipe-separated dietary tags |
variants | No | Variant/option data (JSON string or key:value pairs) |
nutritional_info | No | Nutritional data |
Column Mapping
Menura uses a sophisticated mapping engine:
- Field aliases: Common column name variations are recognized (e.g.
name,item name,product nameall map totitle). - Provider-specific aliases: Each provider has custom mappings for its export format.
- Fuzzy matching: Headers containing keywords (e.g. "desc" → description, "cost" → price) are automatically matched.
- Manual override: You can adjust the auto-detected mapping before importing.
Import Workflow
Step 1: Upload
- Open the menu editor and go to the Import tab.
- Select or drag your CSV/Excel file into the upload area.
Step 2: Review Column Mapping
- Menura auto-detects the source provider.
- The system maps columns to Menura fields.
- You can change the provider if detection is incorrect.
- Adjust any column mappings manually.
Step 3: Preview
- Click Preview to see how your data will be imported.
- Review the parsed items, categories, and any validation errors.
- Categories are auto-created based on your data.
- Duplicate detection flags items with the same title and category.
Step 4: Commit or Adjust
- If everything looks correct, click Commit Import.
- If there are issues, go back and adjust mappings or fix your file.
Step 5: Rollback (If Needed)
- After committing, each import job is tracked.
- Go to the Import History section.
- Click Rollback to undo a previously committed import.
- Rollback removes all items and categories that were created during that import.
Import History
The Import tab maintains a history of all import jobs:
| Column | Description |
|---|---|
| Date | When the import was committed |
| File | Original file name |
| Provider | Detected or manually selected provider |
| Rows | Number of items imported |
| Status | Previewed, Applied, Failed, or Rolled Back |
Export
Export to PDF
Export your menu as a styled PDF document using jspdf and html2canvas:
- Open the menu editor and click the Export button (top bar).
- Select PDF format.
- Configure options:
- Include header (business name, tagline)
- Include footer
- Include QR code (links to the digital menu)
- Page format: A4, Letter, or A3
- Orientation: Portrait or Landscape
- Click Export to generate and download the PDF.
Export to CSV
Export item data as a structured CSV file for use in spreadsheets or other systems.
Export to JSON
Export the complete menu structure (items, categories, pricing) as JSON for programmatic use or backup.
Related Documentation
Was this page helpful?