Browse by Topic

Importing and Exporting Orders

Exporting orders can be a quick way to back up your order history or transfer it to a third-party accounting software. Orders are an excellent example of when you might want to customize an export. You can change various settings during the export process and customize the export template so that you can exclude any information you don't find useful.

 
 

Importing Orders

Importing orders can only be done via the API. For more information, see our Developer documentation or ask a partner in the BigCommerce Community.

 
 

Choosing an Export Template

An export template determines what order information you are exporting. All export templates will include details like the order ID and customer name, but you can get more granular about other details. For a full list of exportable information, see this table of exportable fields.

BigCommerce comes with a few order export templates built in:

  • Default (recommended) — the default template includes basic order information such as order total, customer information, and shipping information. See the exportable fields for a full list of what's included in the default template.

You can also create custom export templates and select which of the exportable fields you want it to include.

 
 

Creating a Custom Export Template

Customizing your template is the best way to ensure your order export has exactly what you want. You can build an export template from scratch or customize a copy of one to suit your needs.

We recommend using a copy of the Default template and modifying it for your needs. This will let you bypass the settings and field mapping when you go to re-import it later.

To start, go to Advanced SettingsExport Templates. Use the Action menu to Create a Copy of the Default template.

View Export Templates

Type a name for your template in the Template Details section and since this template will be for orders, ensure Enable Orders Exporting? is the only option selected under Export Options. Notice that the tabs listed along the top update with your selections.

Order export option

Customize the rest of the template settings to fit your needs. When you're ready, click the Orders tab at the top to view the available export fields.

Order export fields

Go through and check or uncheck each field as needed. Click Save & Exit when you have made your changes. You can now export your data using your new template.

Exporting orders using a custom template

 
 

Exporting Orders

1. Go to OrdersExport Orders.

2. Fill out your order export settings.

Export Orders screen showing Export Templates and File Format

  • Template — Select your export template. For orders, we recommend the Default template or a custom export template.
  • File Format — You can choose between exporting to the CSV format or an XML format.
  • Save export to the server for later download? — Selecting this option will save the file to your exports folder in WebDAV. (Recommended if you are exporting more than 1000 orders.)

3. Click Continue. In the pop-up that appears, click Export my orders to a CSV file.

Export orders link

4. When the file is ready for download, click Download my Orders file.

Download orders link

Exporting Orders by Date Range

To export orders from within a certain date range, you will search your orders for that date range then export the results.

1. Go to OrdersSearch.

2. Scroll down to the Search by Date section.

3. If your date range is available in the drop-down, select it. Otherwise, choose Custom Period and set your date range.

Custom date range

The drop-down includes these options:

  • Today
  • Yesterday
  • Last 24 Hours
  • Last 7 Days
  • Last 30 Days
  • This Month
  • This Year

4. Date type should be set to Order Date. If there are any other search criteria, select them now.

5. Click Search. Your results will be shown on the following page.

6. Click Export All. All of the orders in the search result will be exported, not just the first page.

The control panel will report how many orders matched your criteria

7. Under Template, select Default (unless you have a preferred custom export template).

8. Click Continue, then Export my orders to a CSV file. When your CSV file is ready, select Download my Orders file.

Download my orders file link after exporting your orders

 
 

Exportable Fields

The following fields are the data that can be exported in an order export. The majority of these fields are included when using the Default export template.

FieldDescription
Order IDThe unique order ID in BigCommerce
Customer IDThe unique customer ID in BigCommerce (if purchased by existing customer)
Customer NameThe customer's name
Customer EmailThe customer's email address
Customer PhoneThe customer's phone number
Order DateThe date of the order (formattable)
Order StatusThe order's status at time of export
Subtotal (inc tax)Order subtotal including tax
Subtotal (ex tax)Order subtotal excluding tax
Tax TotalThe total tax for the order
Shipping Cost (inc tax)The amount charged for shipping, including tax
Shipping Cost (ex tax)The amount charged for shipping, excluding tax
Ship MethodThe shipping method selected
Handling Cost (inc tax)The amount charged for handling, including tax
Handling Cost (ex tax)The amount charged for handling, excluding tax
Store Credit RedeemedThe amount of store credit used towards the order
Gift Certificate Amount RedeemedThe amount of a gift certificate used towards the order
Gift Certificate CodeThe gift certificate code
Gift Certificate Expiration DateThe date the gift certificate used on the order expires
Coupon DetailsThe coupon data attached to the order
Coupon CodeThe coupon code associated with the order
Coupon NameThe name of the coupon associated with the order
Coupon ValueThe amount that the coupon took off of the order total
Order Total (inc tax)The order total, including tax
Order Total (ex tax)The order total, excluding tax
Payment MethodThe payment method or gateway used
Total QuantityThe total quantity of items ordered
Total ShippedThe total quantity of items shipped
Date ShippedThe date of shipment (determined by Shipment action)
Order Currency CodeThe code of the currency the order was placed in
Exchange RateThe exchange rate at the time the order was placed
Order NotesThe order notes
Customer MessageMessage left by the customer at the time of checkout
Billing First NameThe first name entered at checkout under Billing Details
Billing Last NameThe last named entered at checkout under Billing Details
Billing CompanyThe company entered at checkout under Billing Details
Billing Street 1The street entered at checkout under Billing Details
Billing Street 2The street entered at checkout under Billing Details
Billing SuburbThe city or suburb entered at checkout under Billing Details
Billing State AbbreviationThe state abbreviation entered at checkout under Billing Details
Billing ZipThe zip or postal code entered at checkout under Billing Details
Billing CountryThe country entered at checkout under Billing Details
Billing PhoneThe phone number entered at checkout under Billing Details
Billing EmailThe customer's email address
Billing Form FieldsResponses for custom form fields
Shipping First NameThe first name entered at checkout under Shipping Details
Shipping Last NameThe last named entered at checkout under Shipping Details
Shipping CompanyThe company entered at checkout under Shipping Details
Shipping Street 1The street entered at checkout under Shipping Details
Shipping Street 2The street entered at checkout under Shipping Details
Shipping SuburbThe city or suburb entered at checkout under Shipping Details
Shipping State AbbreviationThe state abbreviation entered at checkout under Shipping Details
Shipping ZipThe zip or postal code entered at checkout under Shipping Details
Shipping CountryThe country entered at checkout under Shipping Details
Shipping PhoneThe phone number entered at checkout under Shipping Details
Shipping EmailThe customer's email address
Shipping Form FieldsResponses for custom form fields
Product DetailsThe product's details, including the ID, quantity, SKU, name, weight, variant, and price (formattable)
Product IDThe product's unique ID in BigCommerce
Product QtyThe number of units of the product ordered
Product SKUThe product's SKU
Product NameThe product's name
Product WeightThe product's weight
Product Variation DetailsThe particular variation of the product that was ordered
Product Unit PriceThe price of a single unit of the product
Product Total PriceThe product's unit price times the number of units in the order
Refund AmountThe amount refunded on the order

Custom Export Template Fields

These fields are not automatically enabled in the Default export template but can be by manually adding them to a custom export template.

FieldDescription
Billing NameThe customer's first and last name entered at checkout under Billing Details
Billing StateThe state entered at checkout under Billing Details
Billing Suburb + State + ZipThe city, state, and zip/post code entered at checkout under Billing Details
Shipping NameThe customer's first and last name entered at checkout under Shipping Details
Shipping StateThe state entered at checkout under Shipping Details
Shipping Suburb + State + ZipThe city, state, and zip/post code entered at checkout under Shipping Details
Product IndexThe product's place within the order sequence
Product Unit CostThe cost of a single unit of the product
Product Total CostThe product's unit cost times the number of units in the order
# Unique Products in OrderThe number of products in the order
Todays DateThe date of the export
Order TimeThe time of day in which the order was placed
Merchant-defined Order StatusIf you've renamed the default order statuses , it will be listed here
Customer Group NameThe customer group your customer belongs to
Combined Product WeightThe total weight of the order
Order SourceThe origin of the order (e.g. eBay, Instagram, Pinterest, Facebook, Amazon, Buy Buttons, Mobile, Storefront or Manual)
Transaction IDThe unique transaction ID generated by your payment gateway

Was this article helpful?