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 name all map to title).
• 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

1. Open the menu editor and go to the Import tab.
2. Select or drag your CSV/Excel file into the upload area.

Step 2: Review Column Mapping

1. Menura auto-detects the source provider.
2. The system maps columns to Menura fields.
3. You can change the provider if detection is incorrect.
4. Adjust any column mappings manually.

Step 3: Preview

1. Click Preview to see how your data will be imported.
2. Review the parsed items, categories, and any validation errors.
3. Categories are auto-created based on your data.
4. Duplicate detection flags items with the same title and category.

Step 4: Commit or Adjust

1. If everything looks correct, click Commit Import.
2. If there are issues, go back and adjust mappings or fix your file.

Step 5: Rollback (If Needed)

1. After committing, each import job is tracked.
2. Go to the Import History section.
3. Click Rollback to undo a previously committed import.
4. 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:

1. Open the menu editor and click the Export button (top bar).
2. Select PDF format.
3. 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

1. 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

• Menu Items
• Categories
• Menu Management Overview