Enter PIN to continue
QZ Boutique
Premium Order Management
Import / Export Orders Excel
Export Orders to Excel
V99 verified import: XLSX and CSV import are now validated with automatic header detection. The importer can find the correct sheet/header row and shows an import report after upload.
Download all order data as a real Excel XLSX sheet. Every field is in its own column and every order is in its own row. Amounts and numbers are exported as numbers only, for example 500 not AED 500.
Import Orders from Excel Sheet / CSV
Important: Upload the exported XLSX or CSV. The system will detect the correct sheet and header row, update existing orders by id, and add new rows as new orders.
How it works: if the row has an existing id, the system updates that order. If it is a new row (no id), the system adds it as a new order. Old export files containing order_number or delivery_number columns will still be accepted for backward compatibility.
Keep the same column names. Required columns: customer_name, total_amount, paid_amount. Numbers stay in English format.
Last Import Report
Included Order Fields
id | customer_name | phone | order_date | delivery_date | abaya_qty | cost_amount | item_details | size_details | total_amount | paid_amount | balance_amount | payment_status | payment_method | order_status | notes | image_url | created_at | updated_at |