The sections below describe the required formats for CSV uploads across different entities in Masava.
To successfully import data, your CSV files must follow these specifications:
If the headers or value formats do not match the required specifications, the upload may fail or produce unexpected results.
If you need assistance creating or validating your CSV files, please reach out to our team and we’ll be happy to help.
| CSV Column Header | Required | Value Type | Example Value | Shared Across Order |
|---|---|---|---|---|
| Order ID | ✓ Required | Text | ORD-00001 | ✓ Yes |
| Order Date | ✓ Required | Text (Date) | 2024-01-15 | ✓ Yes |
| Delivery Date | ✓ Required | Text (Date) | 2024-01-18 | ✓ Yes |
| Account ID | ✓ Required | Text | ACC-00001 | ✓ Yes |
| Representatives ID | ✓ Required | Text | USR-00001 | ✓ Yes |
| Driver ID | ✓ Required | Text | USR-00001 | ✓ Yes |
| Warehouse ID | ✓ Required | Text | WH-00001 | ✓ Yes |
| Sku | ✓ Required | Text | SKU-CH-MAR-2018-750 | |
| Unit Quantity | ✓ Required | Text (Number) | 24 | |
| Unit Price | ✓ Required | Text (Number) | 809.99 | |
| Total | ✓ Required | Text (Number) | 1619.98 | ✓ Yes |
| Amount Paid | ❌ Optional | Number | 1619.98 | ✓ Yes |
How Order CSV Imports Work
The Order CSV import works slightly differently from other CSV imports.
In this format, each row represents a single line item within an order, rather than a full order by itself. Multiple rows are grouped into the same order using the Order ID field.
Because of this structure, some information must be repeated across all rows that belong to the same order. These fields are marked in the table above under “Shared Across Order.”
If values in these shared fields are inconsistent across rows with the same Order ID, the system cannot guarantee which value will be used when creating the order.
The CSV example below is valid and will create one order containing two line items.
| Order ID | Order Date | Delivery Date | Account ID | Representatives ID | Driver ID | Warehouse ID | Sku | Unit Quantity | Unit Price | Total | Amount Paid |
|---|---|---|---|---|---|---|---|---|---|---|---|
| ORD-001 | 2024-01-15 | 2024-01-18 | ACC-001 | USR-001 | DRV-001 | WH001 | CH-MAR-2018-750 | 24 | 12.99 | 5303.64 | 5303.64 |
| ORD-001 | 2024-01-15 | 2024-01-18 | ACC-001 | USR-001 | DRV-001 | WH001 | AR-JAN-20120-750 | 12 | 15.99 | 5303.64 | 5303.64 |