This document will walk you through how to prepare and upload a CSV file to import orders into the system. To ensure a smooth and successful import, follow the format and instructions below carefully.


File Requirements

  • File must be in .csv format.

  • The column headers must exactly match those provided in the sample file.

  • Each row represents one order item. If an order contains multiple line items, each line item must be a separate row, with all order-level fields repeated.

  • All required fields must be filled in to avoid upload errors.


CSV Column Descriptions and Examples

Column NameDescriptionExample
Customer first nameFirst name of the customer.Jane
Customer last nameLast name of the customer.Smith
Customer emailCustomer’s email address.jane.smith@example.com
Customer phoneCustomer’s phone number (include country code if available).+14155552671
CurrencyCurrency used for the order (ISO code).USD
Sub totalTotal cost of the order before tax, discount, and shipping.120.00
DiscountAny discount applied to the order.10.00
Total Tax AmountTotal tax amount charged.8.40
AmountFinal amount paid for the order (Sub total - Discount + Tax).118.40
QuantityTotal quantity of items in the order (sum of line item quantities).3
Order dateDate the order was placed (YYYY-MM-DD).Jan 25, 2025
Order timeTime the order was placed (24-hour format HH:MM).12:45 PM
Payment MethodMethod used to pay (e.g., Credit Card, PayPal, Cash, ACH).Credit Card
Line item NameName of the individual item in the order.Blue T-Shirt
Line item QuantityQuantity of the individual line item.2
Line item PricePrice of the item (per unit, before tax/discount).25.00
Address Line 1Street address for shipping or billing.123 Main St
CityCity for the address.San Francisco
StateState or region for the address.CA
CountryCountry (ISO 2-letter or full name recommended).US
Postal CodeZIP or postal code.94105

⚠️ Common Upload Errors to Avoid

  • Incorrect or missing date/time formats.

  • Currency not in ISO 3-letter format (e.g., use USD, not $).

  • Email or phone numbers in invalid formats.

  • Orders with multiple line items not grouped correctly.

  • Amount mismatch: Ensure Amount = Sub total - Discount + Total Tax Amount.