Import Design Master
Upload Excel (.xlsx) to bulk import designs into design_master
Upload Excel File

Drag & drop your Excel file here

Supports .xlsx / .xls — Max 10MB

Make sure your Excel has the exact column headers shown in the guide →
Excel Column Mapping Guide
Excel Column DB Field Notes Type
No. — Ignored Skip
Item Category category_id Lookup → auto-create if not found Auto-create
Item Sub Category — Ignored Skip
Item item_id Lookup → auto-create if not found Auto-create
Size size.size_name Lookup → auto-create if not found. NULL in design_master Auto-create
Design No design_no Upsert key — update if exists Upsert Key
Design Status design_status ACTIVE / INACTIVE stored as-is Map
Metal Type category_group_id Lookup → auto-create if not found Auto-create
Image image Filename string Map
Status status yes → 1 / no → 0 Map
Featured featured yes → 1 / no → 0 Map
New Arrival new_arrival yes → 1 / no → 0 Map
Is Show In-app is_show_inapp yes → 1 / no → 0 Map
Is Show In Guest Login is_show_in_guest_login yes → 1 / no → 0 Map
Supplier Name supplier_id Lookup → auto-create if not found Auto-create
Supplier Design No supplier_design_no String stored as-is Map
Created At created_at Parsed datetime Map
N.W. nw Double — net weight New Field
Collection collection_id Lookup → auto-create if not found Auto-create
Upsert Logic
If Design No already exists → row is updated. If new → inserted.
Auto-create
Category, Item, Metal Type, Supplier, Size & Collection are auto-created if not found in the database.
Size Behaviour
Size values are checked / created in the size table. The size column in design_master is always stored as NULL.
Importing data...
Please do not close or refresh this page