Bulk Import
File Format
Bulk import accepts .xlsx and .csv files. The first row must be a header row. Rows with missing required fields are rejected with a row-level error; all other rows in the file are still imported.
Column Mapping
| Field | Type | Description |
|---|---|---|
Customer* key: customer | string | Customer name. Must exactly match an existing customer in the system. |
Order Type* key: order_type | REEL|SHEET|THERMAL | Order type (case-insensitive). |
Width (mm)* key: width_mm | number | Order width in millimetres. |
Length (mm) key: length_mm | number | Required for SHEET orders only. Leave blank for REEL/THERMAL. |
Quantity* key: quantity | integer | Number of rolls or sheets. |
Paper Type* key: paper_type | string | Must match an existing paper type name. |
GSM* key: gsm | number | GSM value. |
Core Diameter (mm) key: core_mm | number | Core diameter (THERMAL orders only). |
Outer Diameter (mm) key: od_mm | number | Outer diameter (THERMAL orders only). |
Delivery Date key: delivery_date | YYYY-MM-DD | Optional target delivery date. |
Validation & Errors
After upload, the system shows a validation report listing each rejected row with the reason. You can download a corrected template, fix the issues, and re-upload. Successfully imported rows are not duplicated if you re-upload the same file. Duplicate detection is based on customer + width + GSM + delivery date.
Was this page helpful?
Something unclear or missing? Reach out and we'll update this page.