Importing order history

Past orders, so the shop does not open with an empty customer history and last year missing from the figures. One row per item, rows sharing an order number becoming one order.

The columns

Your file can name its columns any of the ways shown: the importer matches them whatever their case or spacing. Columns it does not know are left out.

Column	Also read from	Notes
Order number (required) `orderNumber`	`name` `order id` `order` `order number` `reference` `invoice number`	The number in the old system. Rows sharing one become a single order, and it is kept alongside the new internal number.
Date placed (required) `placedAt`	`created at` `date` `order date` `processed at` `paid at`	What the reporting figures are grouped by. An order with no date cannot be put on a chart.
Email (required) `email`	`customer email` `contact email` `billing email` `e-mail`	Links the order to a customer already here. Where nobody matches, it stays a guest order rather than inventing an account.
Phone `phone`	`customer phone` `billing phone` `telephone`
Currency `currency`	`currency code`	Left out, the shop’s own currency is assumed.
Payment status `paymentStatus`	`financial status` `payment state` `paid` `status`	Paid, pending, refunded. Only paid orders count towards sales figures, so this is worth getting right.
Delivery status `fulfilmentStatus`	`fulfillment status` `fulfilment status` `shipping status` `shipment status`
Cancelled on `cancelledAt`	`cancelled at` `canceled at` `date cancelled`	Anything with a date here is treated as cancelled, whatever the payment column says.
Payment method `paymentMethod`	`gateway` `payment gateway` `payment type` `method`	Kept as written. Cash on delivery is recognised; everything else is recorded as taken outside this system, because it was.
Discount code `discountCode`	`discount code` `coupon` `voucher`
Subtotal `subtotal`	`sub total` `items subtotal` `net total`
Discount total `discountTotal`	`discount amount` `total discount`
Delivery charged `shippingTotal`	`shipping` `shipping total`
Tax `taxTotal`	`taxes` `tax total` `vat` `total tax`
Order total `total`	`total` `grand total` `order total` `amount`	What was actually charged. Left out, it is added up from the lines — so map it if the file has it.
Refunded `refundedTotal`	`refunded amount` `total refunded`
Customer note `customerNote`	`note` `notes` `order note`
Delivery name `shippingName`	`shipping name` `ship to name` `recipient` `delivery name`	One column with the whole name. Where the export splits it, map the two below instead.
Delivery first name `shippingFirstName`	`shipping first name`
Delivery last name `shippingLastName`	`shipping last name`
Delivery company `shippingCompany`	`shipping company`
Delivery address 1 `shippingLine1`	`shipping street` `shipping address 1` `shipping address1` `shipping address`
Delivery address 2 `shippingLine2`	`shipping address 2` `shipping address2`
Delivery city `shippingCity`	`shipping city` `shipping town`
Delivery region `shippingRegion`	`shipping province` `shipping state` `shipping county`
Delivery postcode `shippingPostcode`	`shipping zip` `shipping postal code` `shipping postcode`
Delivery country `shippingCountry`	`shipping country` `shipping country code`
Delivery phone `shippingPhone`	`shipping phone`
Delivery method `shippingMethod`	`shipping method` `shipping line` `delivery method` `carrier`
Billing name `billingName`	`billing name` `bill to name` `invoice name`
Billing address 1 `billingLine1`	`billing street` `billing address 1` `billing address1` `billing address`
Billing address 2 `billingLine2`	`billing address 2` `billing address2`
Billing city `billingCity`	`billing city` `billing town`
Billing region `billingRegion`	`billing province` `billing state` `billing county`
Billing postcode `billingPostcode`	`billing zip` `billing postal code` `billing postcode`
Billing country `billingCountry`	`billing country` `billing country code`
Item SKU `lineSku`	`lineitem sku` `line item sku` `item sku` `sku` `product sku`	Links the line to a product still in the catalogue. Not needed — the title and price are kept on the order either way, which is what an invoice is reprinted from.
Item name (required) `lineTitle`	`lineitem name` `line item name` `item name` `product name` `product title`
Item size or colour `lineVariantTitle`	`lineitem variant title` `variant title` `variant` `item variation`
Item quantity (required) `lineQuantity`	`lineitem quantity` `line item quantity` `item quantity` `qty` `quantity`
Item price each (required) `lineUnitPrice`	`lineitem price` `line item price` `item price` `unit price` `price`
Item discount `lineDiscount`	`lineitem discount` `line item discount` `item discount`
Item tax `lineTax`	`lineitem tax` `line item tax` `item tax`

A template to start from

The template has every column and a few example rows. The examples show the things most often got wrong on a first go.

Order number,Date placed,Email,Payment status,Delivery status,Order total,Delivery charged,Tax,Delivery name,Delivery address 1,Delivery city,Delivery postcode,Delivery country,Item SKU,Item name,Item size or colour,Item quantity,Item price each
1041,2025-11-04,ada@example.com,paid,fulfilled,84.00,4.00,13.44,Ada Lovelace,12 Analytical Way,Nicosia,1010,CY,NAVY-COAT-M,Navy Wool Coat,Navy / M,1,80.00
1042,2025-11-06,grace@example.com,paid,fulfilled,55.00,5.00,8.00,Grace Hopper,3 Compiler Street,Limassol,3010,CY,RED-SCARF-OS,Red Wool Scarf,One size,2,25.00
1042,2025-11-06,grace@example.com,paid,fulfilled,55.00,5.00,8.00,Grace Hopper,3 Compiler Street,Limassol,3010,CY,,Gift box,,1,0.00

Download the template (order-import-template.csv)