← Back to Main App

Import Manager

Upload, map, and import data from external sources

Import from Purchase Table

Import ingredients from MithaasLive$Purch_ Inv_ Line table. Only items with codes starting with "MI" will be imported.
Purchase Records
—
Unique MI Codes
—
Already Imported
—
To Be Imported
—

Current Mapping

Purchase Column → Ingredient Column
No_ → item_code Must start with "MI"
Description → name
Unit Cost (LCY) → cost_per_unit
Posting Date → last_purchase_date

Preview Data

No_ (Item Code) Description Unit Cost (LCY) Posting Date Status
Click "Refresh Status" to load preview

Upload & Import Data

Upload Excel (.xlsx, .xls) or CSV files to import ingredients or dishes
📁

Drop file here or click to browse

Supported: Excel (.xlsx, .xls), CSV (.csv)

Column Mapping Configuration

Configure how columns from your source data map to the ingredients table

Field Mappings

Source Column
Target Field
→
→
→
→
→

Import Filters

Import History

View past imports and their results
Date & Time Source Type Records Processed Inserted Updated Errors Status
Import history coming soon...