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.

Orders

Sample CSV

Orders.csv

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.

Example

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

Accounts