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.

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
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 First Name 1	The recipient's first name
Shipping Last Name 1	The recipient's last name
Shipping Street 1 1	The first line of the recipient's address
Shipping Street 2 1	The second line of the recipient's address
Shipping City 1	The city of the recipient's address
Shipping State 1	The state of the recipient's address
Shipping Country 1	The country of the recipient's address
Shipping Country ISO2 1	The 2-letter country code for the country of the recipient's address. Example values: `GB` `US`
Shipping Zip 1	The zip or postal code of the recipient's address
Product Name 1	The name of the ordered product
Product Quantity 1	The quantity of this line item
Product Price Ex Tax 1	The tax exclusive price of this product
Product Price Inc Tax 1	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.

All shipping fields have a "1" suffix as there can be multiple shipping addresses, e.g. when there are multiple consignments.

For orders with more than one item, repeat the product columns and increment the suffix, e.g. Product Name 2, Product Quantity 2, etc.

For all available columns when importing orders, view Orders.