Migrating historical orders

Importing historical orders from another ecommerce platform is a common task as part of migrating to BigCommerce.

Getting started

Once you've exported your orders from your old ecommerce platform, you will need to reformat so that it is ready for BigCommerce.

We provide a template spreadsheet for importing historical orders.

tip

The column names don't have to exactly match as you can map the columns before importing.

Order Columns

For this import, as we're only considering historical orders, we're not going to worry about matching order products up with products in BigCommerce. Instead, each order will define a custom order product.

Field	Description
Status ID	Set the order status. See all order status IDs Example values: 2 - Shipped, 4 - Refunded, 5 - Cancelled, 10 - Completed
Status	Alternatively, you may import the status using the text version of the Status, e.g. "Completed" using this column. When doing so, this column takes priority over the Status ID column.
Customer ID	If you have already imported customers, you can assign an order to them by specifying the BigCommerce customer ID.
Billing First Name	The customer's first name on the billing address
Billing Last Name	The customer's last name on the billing address
Billing Street 1	The first line of the customer's billing address
Billing Street 2	The second line of the customer's billing address
Billing City	The city on the billing address
Billing State	The state on the billing address
Billing Country	The name of the country on the billing address
Billing Country ISO2	The 2-letter country code for the country on the billing address. Example values: GB US
Billing Zip	The zip or postal code on the customer's billing address
Billing email	The customer's email address
Shipping 1 First Name	The recipient's first name
Shipping 1 Last Name	The recipient's last name
Shipping 1 Street 1	The first line of the recipient's address
Shipping 1 Street 2	The second line of the recipient's address
Shipping 1 City	The city of the recipient's address
Shipping 1 State	The state of the recipient's address
Shipping 1 Country	The country of the recipient's address
Shipping 1 Country ISO2	The 2-letter country code for the country of the recipient's address. Example values: GB US
Shipping 1 Zip	The zip or postal code of the recipient's address
Product 1 Name	The name of the ordered product
Product 1 Quantity	The quantity of this line item
Product 1 Price Ex Tax	The tax exclusive price of this product
Product 1 Price Inc Tax	The tax inclusive price of this product
Default Currency Code	The currency that this order was transacted in. Example values: USD GBP
Date Created	The date & time that the order was placed. Example format: Mon, 23 Sep 2024 14:21:24 +0000
External Order ID	The Order ID from your previous ecommerce platform
External Source	M-MIG This value should be used to indicate to BigCommerce that these orders should not affect the GMV for your store which is used to calculate your BigCommerce license renewal costs.
Items Total	The total number of items on the order
Total Ex Tax	The total amount of the order, exclusive of tax
Total Inc Tax	The total amount of the order, inclusive of tax
Shipping Cost Ex Tax	The shipping fee, exclusive of tax
Shipping Cost Inc Tax	The shipping fee, inclusive of tax
Staff Notes	Any internal notes regarding the order.

note

All shipping and product fields have a number, e.g. Shipping 1, Product 1, as there can be multiple shipping addresses and products are on an order.

tip

For all available columns when importing orders, view the Orders template.