Orders
Create and update BigCommerce orders using Shift.
Quick start
There are a few ways to get started. Depending what you're looking to achieve, here are some templates to get you started:
Import & export columns
This is a list of all order fields that can be exported.
If you are looking to import orders, e.g. update status or even to import historical orders, not all fields are going to be required. See our template files above for some examples.
Basic columns
Column | Description |
Order ID | The unique identifier of the order. This field is required to update existing orders. 🔒 This field is read-only. |
Status | The status of the order. See all order statuses. 🔒 This field is read-only. To update the order status, update the |
Date Created | The date the order was placed. 🔒 This field is read-only after creation. Example value: |
Subtotal Ex Tax | The order subtotal without tax. 🔒 This field is read-only. |
Subtotal Inc Tax | The order subtotal with tax applied. 🔒 This field is read-only. |
Date Modified | The date the order was last updated. 🔒 This field is read-only. Example value: |
Date Shipped | The date the order was shipped. 🔒 This field is read-only. |
Cart ID | This is the unique identifier of the cart that was used to create the order. 🔒 This field is read-only. |
Subtotal Tax | The order subtotal tax amount 🔒 This field is read-only. |
Shipping Cost Tax | The tax amount that was applied to the shipping fee. 🔒 This field is read-only. |
Shipping Cost Tax Class ID | The tax class applied to the shipping fee. 🔒 This field is read-only. |
Handling Cost Tax | The tax amount that was applied to the handling fee 🔒 This field is read-only. |
Handling Cost Tax Class ID | The tax class applied to the handling fee. 🔒 This field is read-only. |
Wrapping Cost Tax | The tax amount that was applied to the wrapping fee. 🔒 This field is read-only. |
Wrapping Cost Tax Class ID | The tax class applied to the wrapping fee. 🔒 This field is read-only. |
Payment Status | The status of the order payment. 🔒 This field is read-only. Allowed values:
|
Store Credit Amount | The store credit that the customer has redeemed against this order. 🔒 This field is read-only. |
Gift Certificate Amount | The gift certificate amount that the customer has redeemed against this order. |
Currency ID | The ID of the currency that the customer was shopping in. This is not necessarily the transaction currency. 🔒 This field is read-only. Example value: |
Currency Code | The code of the currency that the customer was shopping in. This is not necessarily the transaction currency. 🔒 This field is read-only. Example value: |
Currency Exchange Rate | The exchange rate between the store's default currency and the currency that the customer was shopping in. 🔒 This field is read-only. Example value: |
Default Currency ID | The ID of the transactional currency that the customer paid in. 🔒 This field is read-only. Example value: |
Store Default Currency Code | The currency code of the store's default currency. 🔒 This field is read-only. Example value: |
Store Default To Transaction Exchange Rate | The exchange rate between the store's default currency and the transactional currency used for the order. 🔒 This field is read-only. |
Coupon Discount | The discount amount through using a coupon. 🔒 This field is read-only. |
Shipping Address Count | The number of shipping addresses on the order. 🔒 This field is read-only. |
Is Email Opt In | Indicates whether the customer has opted in to marketing emails. 🔒 This field is read-only. |
Order Source | Where the order was placed. Allowed values: |
Status ID | The ID of the order status. See all order statuses. |
Base Handling Cost | The handling fee before tax is considered |
Base Shipping Cost | The shipping fee before tax is considered |
Base Wrapping Cost | The wrapped fee before tax is considered |
Channel ID | The ID of the channel from which the order originated. |
Customer ID | The ID of the customer who placed the order. |
Customer Message | The message that the customer provided in the Order Comments box during checkout. |
Discount Amount | The amount of discount applied to this order. |
Ebay Order ID | If the order was placed through eBay, this will be the eBay order number. |
External ID | If the order was placed through a third-party system, this is the third-party system's order reference. For example, on Amazon orders, this will hold the Amazon ID. 🔒 This field is read-only. |
External Merchant ID | The merchant ID represents an upstream order from an external system. 🔒 This field is read-only once an order is created. |
External Source | If the order was placed through an external system and then imported into BigCommerce, this field will define the source. When migrating historical orders placed on another ecommerce platform use the value |
Geoip Country | The country that the order was placed in, according to an IP address to country lookup. |
Geoip Country ISO2 | The country code for the country that the order was placed in, according to an IP address to country lookup. |
Handling Cost Ex Tax | The handling fee without tax applied. 🔒 This field is read-only. |
Handling Cost Inc Tax | The handling fee with tax applied. 🔒 This field is read-only. |
IP Address | The IPv4 address of the customer, if known. Setting this field will reset the IP Address V6 field. |
IP Address V6 | The IPv6 address of the customer, if known. Setting this field will reset the IP address field. |
Items Shipped | The number of items that have been shipped 🔒 This field is read-only. |
Items Total | The total number. of items on the order. 🔒 This field is read-only. |
Order Is Digital | Whether this is an order for digital products. |
Payment Method | The payment method for this order. Example values: |
Payment Provider ID | The payment or transaction ID used by the external payment provider (if one was used). |
Refunded Amount | The order amount that has been refunded |
Shipping Cost Ex Tax | The shipping fee without tax applied. |
Shipping Cost Inc Tax | The shipping fee with tax applied. |
Staff Notes | Any additional notes for staff |
Tax Provider ID | The ID of the tax provider. No value when the order was created via API. 🔒 This field is read-only. Allowed values: |
Customer Locale | The customers's locale |
External Order ID | If the order was placed through a third-party system, this is the third-party system's order reference. For example, on Amazon orders, this will hold the Amazon ID. 🔒 This field is read-only. |
Total Ex Tax | The total amount of the order, without tax. |
Wrapping Cost Ex Tax | The wrapping fee without tax applied. |
Wrapping Cost Inc Tax | The wrapping free with tax applied. |
Billing columns
Fields | Description |
Billing First Name | The billing address first name. |
Billing Last Name | The billing address last name |
Billing Email | The billing address email |
Billing Company | The billing address company |
Billing Street 1 | The first line of the billing address |
Billing Street 2 | The second line of the billing address |
Billing City | The billing address city |
Billing State | The billing address state |
Billing Zip | The billing address zip or postal code. |
Billing Country | The billing address country |
Billing Country ISO2 | The billing address country (2-letter ISO2 code) |
Billing Phone | The billing address phone number. |
Shipping addresses columns
There can be multiple shipping addresses on an order. When there are multiple, the field for each will have a numeric suffix, e.g. 1, 2, 3, etc.
Fields | Description |
Shipping Address ID 1 | The ID of the shipping address 🔒 This field is read-only. |
Shipping Items Total 1 | The total number items 🔒 This field is read-only. |
Shipping Base Cost 1 | The shipping fee amount. 🔒 This field is read-only. |
Shipping Cost Ex Tax 1 | The shipping fee amount without tax applied. 🔒 This field is read-only. |
Shipping Cost Inc Tax 1 | The shipping fee amount with tax applied. 🔒 This field is read-only. |
Shipping Cost Tax 1 | The shipping fee tax amount 🔒 This field is read-only. |
Shipping Cost Tax Class ID 1 | The ID of the tax class that was applied to the shipping fee. 🔒 This field is read-only. |
Shipping Base Handling Cost 1 | The handling fee amount. 🔒 This field is read-only. |
Shipping Handling Cost Ex Tax 1 | The handling fee without tax applied. 🔒 This field is read-only. |
Shipping Handling Cost Inc Tax 1 | The handling fee with tax applied. |
Shipping Zone ID 1 | The ID of the shipping zone. |
Shipping First Name 1 | The first name of the shipping address |
Shipping Last Name 1 | The last name of the shipping address |
Shipping Company 1 | The shipping address company |
Shipping Street 1 1 | The first line of the shipping address |
Shipping Street 2 1 | The second line of the shipping address |
Shipping City 1 | The shipping address city. |
Shipping State 1 | The shipping address state. |
Shipping Zip 1 | The shipping address zip or postal code. |
Shipping Country 1 | The shipping address country. Example value: |
Shipping Country ISO2 1 | The shipping address country code (2-letter ISO2 code). Example value: |
Shipping Phone 1 | The recipient's phone number |
Shipping Email 1 | The recipient's email |
Shipping Method 1 | The code that identifies the shipping method selected by the customer. |
Product columns
Fields | Description |
Product Entity ID 1 | The ID of this order product. Not the product ID, but a reference to this line item of the order. |
Product Order ID 1 | The ID of the associated order |
Product ID 1 | The product ID |
Product Order Pickup Method ID 1 | The ID of the pickup fulfillment method for this item. |
Product Order Address ID 1 | The ID of the associated order address |
Product Name 1 | The name of the product |
Product SKU 1 | The SKU of the product |
Product Type 1 | The type of the product Allowed values: |
Product Base Price 1 | The product price |
Product Price Ex Tax 1 | The product's without tax applied. |
Product Price Inc Tax 1 | The product's price with tax applied |
Product Price Tax 1 | The tax amount applied to the product |
Product Base Total 1 | The total for this line item |
Product Total Ex Tax 1 | The line item total without tax applied. |
Product Total Inc Tax 1 | The line item total with tax applied. |
Product Total Tax 1 | The tax amount for the line item. |
Product Quantity 1 | The quantity of product ordered. |
Product Base Cost Price 1 | The cost price of the product |
Product Cost Price Ex Tax 1 | The cost price of the product without tax applied. |
Product Cost Price Inc Tax 1 | The cost price of the product with tax applied |
Product Weight 1 | The weight of the product. |
Product Height 1 | The height of the product |
Product Depth 1 | The depth of the product. |
Product Width 1 | The width of the product |
Product Cost Price Tax 1 | The cost price of the product without tax applied. |
Product Is Refunded 1 | Whether the product has been refunded. |
Product Quantity Refunded 1 | The quantity that has been refunded. |
Product Refund Amount 1 | The amount that has been refunded. This field is deprecated. |
Product Return ID 1 | The ID of the refund |
Product Wrapping ID 1 | The ID of the gift-wrapping option |
Product Wrapping Name 1 | The name gift wrapping option. |
Product Base Wrapping Cost 1 | The fee for gift wrapping |
Product Wrapping Cost Ex Tax 1 | The fee for gift wrapping without tax applied. |
Product Wrapping Cost Inc Tax 1 | The fee for gift wrapping with tax applied. |
Product Wrapping Cost Tax 1 | The tax amount for the gift wrapping fee. |
Product Wrapping Message 1 | The gift wrapping message. |
Product Quantity Shipped 1 | The number of items that have been shipped. |
Product Event Name 1 | The name of the promotional event or delivery date |
Product Event Date 1 | The date of the promotional event or scheduled delivery. |
Product Fixed Shipping Cost 1 | The fixed shipping cost for this line item. |
Product Ebay Item ID 1 | The eBay item ID |
Product Ebay Transaction ID 1 | The eBay transaction ID for this item. |
Product Option Set ID 1 | The ID of the option set applied to this product. |
Product Parent Order Product ID 1 | The ID of the parent product |
Product Is Bundled Product 1 | Whether this product is bundled with other products |
Product Bin Picking Number 1 | The bin picking number for the physical product. |
Product External ID 1 | The ID of the order in an external system if the order was placed elsewhere. |
Product Brand 1 | The product's brand. |
Product Applied Discounts ID 1 | The name of the coupon applied to the order. |
Product Applied Discounts Amount 1 | The amount of the discount. |
Product Applied Discounts Name 1 | The name of the coupon |
Product Applied Discounts Code 1 | The coupon code |
Product Applied Discounts Target 1 | Determines if the discount is applied at the product or order level. 🔒 This field is read-only. Allowed values: |
Product Options ID 1 | The ID of the product options. This increments sequentially from 1 for each product. |
Product Options Option ID 1 | The ID of the option |
Product Options Order Product ID 1 | The ID of the product |
Product Options Product Option ID 1 | The ID of the option applied to the product from the list of options |
Product Options Display Name 1 | The product option name |
Product Options Display Value 1 | The product option selection name |
Product Options Value 1 | The product option selection value. |
Product Options Type 1 | The option type. Allowed values: |
Product Options Name 1 | The internal name for the option |
Product Options Display Style 1 | How the option is shown on the storefront. Example values: |
Product Options Display Name Customer 1 | The product option name that is shown to the customer |
Product Options Display Value Customer 1 | The product option selection value that is shown to the customer. |
Product Options Display Value Merchant 1 | The product option selection value that is shown in the admin |
Product Name Customer 1 | The product name that is shown to the customer. |
Product Name Merchant 1 | The product name that is shown in the admin. |
Product Gift Certificate ID 1 | The ID of any associated gift certificate. |
Product Discounted Total Inc Tax 1 | The line item total after discounts have been applied. This includes any order level discounts. |
Consignment columns
Fields | Description |
Consignment Pickups ID | The ID of the pickup consignment |
Consignment Pickups Pickup Method ID | The ID of the pickup method. |
Consignment Pickups Pickup Method Display Name | The pickup method name that is shown to customers. |
Consignment Pickups Collection Instructions | The message shown to customers to guide them on how to collect their order. |
Consignment Pickups Collection Time Description | The message shown to customers to indicate when their order will be available for collection. |
Consignment Pickups Location | The location details for where the order can be collected. |
Consignment Shipping ID 1 | The ID of the shipping consignment |
Consignment Shipping First Name 1 | The first name on the shipping consignment |
Consignment Shipping Last Name 1 | The last name on the shipping consignment. |
Consignment Shipping Company 1 | The company name on the shipping consignment |
Consignment Shipping Street 1 1 | The first line of the address on the shipping consignment. |
Consignment Shipping Street 2 1 | The second line of the address on the shipping consignment. |
Consignment Shipping City 1 | The city on the shipping consignment |
Consignment Shipping Zip 1 | The zip or postal code on the shipping consignment |
Consignment Shipping Country 1 | The country name on the shipping consignment. |
Consignment Shipping Country ISO2 1 | The ISO code of the country on the shipping consignment |
Consignment Shipping State 1 | The state on the shipping consignment |
Consignment Shipping Phone 1 | The phone number on the shipping consignment |
Consignment Shipping Email 1 | The email address on the shipping consignment |
Consignment Shipping Items Total 1 | The total number of items on the shipping consignment |
Consignment Shipping Items Shipped 1 | The total number of items that have been shipped from the shipping consignment. |
Consignment Shipping Shipping Method 1 | The shipping method used for the shipping consignment |
Consignment Shipping Base Cost 1 | The shipping fee for the shipping consignment |
Consignment Shipping Cost Ex Tax 1 | The shipping fee without tax applied. |
Consignment Shipping Cost Inc Tax 1 | The shipping fee with tax applied. |
Consignment Shipping Cost Tax 1 | The tax amount applied to the shipping fee. |
Consignment Shipping Cost Tax Class ID 1 | The ID of the tax class used for the shipping fee. |
Consignment Shipping Base Handling Cost 1 | The handling fee for the shipping consignment |
Consignment Shipping Handling Cost Ex Tax 1 | The handling fee without tax applied. |
Consignment Shipping Handling Cost Inc Tax 1 | The handling fee with tax applied. |
Consignment Shipping Handling Cost Tax 1 | The tax amount applied to the shipping fee. |
Consignment Shipping Shipping Zone ID 1 | The ID of the shipping zone for the consignment |
Consignment Shipping Shipping Zone Name 1 | The name of the shipping zone for the consignment |
Consignment Download Recipient Email | The recipient's email address for a digital product delivery. |
Consignment Email Gift Certificates Recipient Email | The recipient's email address for a digital gift certificate delivery. |
Metafield columns
Fields | Description |
{namespace}.{key} | You can create and update order metafields by adding a column named after the metafield namespace and metafield key separated by a The metafield namespace and key each must be fewer than 65 characters Metafield values can be up to 65,535 characters long. An empty string or a string with only whitespace is not a valid metafield value. All metafields will be created with write and storefront access permissions so they can be queried via the storefront GraphQL API. |
As we don't know the names of metafields in advance, you can only select all metafields when exporting.
Export filters
You can filter order exports only to include orders from specific customers.
[insert image]
As you reduce the number of items in your export, or change what data should be included, the estimate of the number of records and duration of the export will be updated
[insert image]