BigCommerce Data Reference

Orders

One row per order. Date range: filtered by order date_created. Includes totals, payment fields, and flattened billing address columns.

Column	Description
Order ID	Record ID from BigCommerce.
Customer ID	BigCommerce customer ID (blank for guest orders when applicable).
Date Created	When the record was created.
Date Modified	When the record was last modified.
Date Shipped	When the order was shipped (if shipped).
Status ID	Numeric order status ID.
Status	Order or record status as reported by the platform.
Custom Status	Custom status label when configured.
Subtotal Ex Tax	Order subtotal excluding tax.
Subtotal Inc Tax	Order subtotal including tax.
Subtotal Tax	Tax portion of the subtotal.
Base Shipping Cost	Base Shipping Cost in the row currency unless noted otherwise.
Shipping Cost Ex Tax	Shipping Cost Ex Tax: amount excluding tax.
Shipping Cost Inc Tax	Shipping Cost Inc Tax: amount including tax.
Shipping Cost Tax	Shipping Cost Tax.
Base Handling Cost	Base Handling Cost in the row currency unless noted otherwise.
Handling Cost Ex Tax	Handling Cost Ex Tax: amount excluding tax.
Handling Cost Inc Tax	Handling Cost Inc Tax: amount including tax.
Handling Cost Tax	Handling Cost Tax.
Base Wrapping Cost	Base Wrapping Cost in the row currency unless noted otherwise.
Wrapping Cost Ex Tax	Wrapping Cost Ex Tax: amount excluding tax.
Wrapping Cost Inc Tax	Wrapping Cost Inc Tax: amount including tax.
Wrapping Cost Tax	Wrapping Cost Tax.
Total Ex Tax	Order or line total excluding tax.
Total Inc Tax	Order or line total including tax.
Total Tax	Total tax amount.
Items Total	Total number of items on the order or address.
Items Shipped	Number of items shipped.
Payment Method	How the order was paid.
Payment Provider ID	Payment provider identifier.
Payment Status	Payment status for the order.
Refunded Amount	Cumulative amount refunded on the order.
Order Is Digital	Whether the order is digital-only.
Store Credit Amount	Store credit applied to the order.
Gift Certificate Amount	Gift certificate amount applied.
IP Address	Buyer IP address captured at checkout.
GeoIP Country	Country inferred from IP.
GeoIP Country ISO2	ISO2 country code inferred from IP.
Currency ID	BigCommerce currency ID for the order.
Currency Code	ISO 4217 currency code (e.g. `USD`).
Currency Exchange Rate	Exchange rate used for the order currency.
Default Currency ID	Default Currency ID (ISO 4217 when applicable).
Default Currency Code	Store default currency code.
Store Default Currency Code	Store Default Currency Code (ISO 4217 when applicable).
Store Default Exchange Rate	Store Default Exchange Rate in the row currency unless noted otherwise.
Staff Notes	Internal staff notes on the order.
Customer Message	Message from the customer on the order.
Discount Amount	Discount amount on the order.
Coupon Discount	Coupon discount amount on the order.
Shipping Address Count	Shipping address count.
Is Deleted	Whether the order is soft-deleted in BigCommerce.
eBay Order ID	eBay Order ID from the source platform.
Cart ID	Cart ID from the source platform.
Channel ID	Sales channel ID for the order or assignment.
External Source	External Source.
External ID	External ID from the source platform.
External Merchant ID	External Merchant ID from the source platform.
Tax Provider ID	Tax Provider ID from the source platform.
Customer Locale	Customer Locale.
Order Source	Source of the order (e.g. www, manual).
Consignments	Consignment payload when returned by the API.
Coupons	JSON or serialized coupon data attached to the order.
Products Resource URI	Resource URI for order products (use Order Line Items tab for row data).
Shipping Addresses Resource URI	Resource URI for shipping addresses (use Order Shipping Addresses tab for row data).
Billing Address First Name	Billing address first name.
Billing Address Last Name	Billing address last name.
Billing Address Company	Billing address company.
Billing Address Street 1	Billing address street 1.
Billing Address Street 2	Billing address street 2.
Billing Address City	Billing address city.
Billing Address State	Billing address state.
Billing Address Zip	Billing address zip.
Billing Address Country	Billing address country.
Billing Address Country Iso2	Billing address country iso2.
Billing Address Phone	Billing address phone.
Billing Address Email	Billing address email.
Billing Address Form Fields	Billing address form fields.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Order Line Items

One row per order line item. Date range: parent orders filtered by date_created.

Column	Description
Order ID	Parent order ID.
Line Item ID	Record ID from BigCommerce.
Product ID	Catalog product ID.
Variant ID	Catalog variant ID.
Order Address ID	Order Address ID from the source platform.
Name	Buyer or entity display name.
Customer Name	Customer Name.
Merchant Name	Merchant Name.
SKU	SKU for the product, variant, or line.
UPC	UPC barcode.
Type	Product or coupon type.
Base Price	Base unit price before adjustments.
Price Ex Tax	Unit price excluding tax.
Price Inc Tax	Unit price including tax.
Price Tax	Tax on the unit price.
Base Total	Base line total before adjustments.
Total Ex Tax	Order or line total excluding tax.
Total Inc Tax	Order or line total including tax.
Total Tax	Total tax amount.
Weight	Weight.
Width	Width.
Height	Height.
Depth	Depth.
Quantity	Available or ordered quantity.
Base Cost Price	Base Cost Price in the row currency unless noted otherwise.
Cost Price Inc Tax	Cost Price Inc Tax: amount including tax.
Cost Price Ex Tax	Cost Price Ex Tax: amount excluding tax.
Cost Price Tax	Cost Price Tax.
Is Refunded	Whether the line item has been refunded.
Quantity Refunded	Units refunded on the line.
Refund Amount	Refund amount for the line.
Return ID	Return ID from the source platform.
Wrapping ID	Wrapping ID from the source platform.
Wrapping Name	Wrapping Name.
Base Wrapping Cost	Base Wrapping Cost in the row currency unless noted otherwise.
Wrapping Cost Ex Tax	Wrapping Cost Ex Tax: amount excluding tax.
Wrapping Cost Inc Tax	Wrapping Cost Inc Tax: amount including tax.
Wrapping Cost Tax	Wrapping Cost Tax.
Wrapping Message	Wrapping Message.
Quantity Shipped	Quantity Shipped.
Event Name	Event Name.
Event Date	Event Date.
Fixed Shipping Cost	Fixed Shipping Cost in the row currency unless noted otherwise.
eBay Item ID	eBay Item ID from the source platform.
eBay Transaction ID	eBay Transaction ID from the source platform.
Option Set ID	Option Set ID from the source platform.
Parent Order Product ID	Parent Order Product ID from the source platform.
Is Bundled Product	Boolean: Is Bundled Product.
Bin Picking Number	Bin Picking Number.
External ID	External ID from the source platform.
Fulfillment Source	Fulfillment Source.
Brand	Brand.
Applied Discounts	JSON of discounts applied to the line.
Product Options	JSON of selected product options.
Configurable Fields	Configurable Fields.
Gift Certificate ID	Gift Certificate ID from the source platform.
Order Date Created	Created date of the parent order (for joining / filtering).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Order Shipping Addresses

One row per shipping address on orders in the selected date range.

Column	Description
Order ID	Parent order ID.
Shipping Address ID	Record ID from BigCommerce.
Items Total	Total number of items on the order or address.
Items Shipped	Number of items shipped.
Shipping Method	Shipping method name.
Base Cost	Base Cost in the row currency unless noted otherwise.
Cost Ex Tax	Cost Ex Tax: amount excluding tax.
Cost Inc Tax	Cost Inc Tax: amount including tax.
Cost Tax	Cost Tax.
Base Handling Cost	Base Handling Cost in the row currency unless noted otherwise.
Handling Cost Ex Tax	Handling Cost Ex Tax: amount excluding tax.
Handling Cost Inc Tax	Handling Cost Inc Tax: amount including tax.
Handling Cost Tax	Handling Cost Tax.
Shipping Zone ID	Shipping Zone ID from the source platform.
Shipping Zone Name	Shipping Zone Name.
Cost Tax Class ID	Cost Tax Class ID from the source platform.
Handling Cost Tax Class ID	Handling Cost Tax Class ID from the source platform.
Shipping Quotes	Shipping Quotes.
First Name	First name.
Last Name	Last name.
Company	Company name.
Street 1	Street 1.
Street 2	Street 2.
City	Ship-to city.
State	Ship-to state or region.
Zip	Ship-to postal code.
Country	Country.
Country Iso2	Country Iso2.
Phone	Phone number.
Email	Customer email address.
Form Fields	Form Fields.
Order Date Created	Created date of the parent order (for joining / filtering).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Order Shipments

One row per shipment (with tracking) for orders in the selected date range.

Column	Description
Order ID	Parent order ID.
Shipment ID	Record ID from BigCommerce.
Customer ID	BigCommerce customer ID (blank for guest orders when applicable).
Order Address ID	Order Address ID from the source platform.
Date Created	When the record was created.
Tracking Number	Shipment tracking number.
Merchant Shipping Cost	Merchant Shipping Cost in the row currency unless noted otherwise.
Shipping Method	Shipping method name.
Shipping Provider	Shipping provider code or name.
Shipping Provider Display Name	Shipping Provider Display Name.
Tracking Carrier	Carrier used for tracking.
Tracking Link	Tracking URL when provided.
Generated Tracking Link	Generated Tracking Link in the row currency unless noted otherwise.
Comments	Comments.
Items	Items.
Order Date Created	Created date of the parent order (for joining / filtering).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).
Shipping Address First Name	Shipping address first name.
Billing Address First Name	Billing address first name.
Shipping Address Last Name	Shipping address last name.
Billing Address Last Name	Billing address last name.
Shipping Address Company	Shipping address company.
Billing Address Company	Billing address company.
Shipping Address Street 1	Shipping address street 1.
Billing Address Street 1	Billing address street 1.
Shipping Address Street 2	Shipping address street 2.
Billing Address Street 2	Billing address street 2.
Shipping Address City	Shipping address city.
Billing Address City	Billing address city.
Shipping Address State	Shipping address state.
Billing Address State	Billing address state.
Shipping Address Zip	Shipping address zip.
Billing Address Zip	Billing address zip.
Shipping Address Country	Shipping address country.
Billing Address Country	Billing address country.
Shipping Address Country Iso2	Shipping address country iso2.
Billing Address Country Iso2	Billing address country iso2.
Shipping Address Phone	Shipping address phone.
Billing Address Phone	Billing address phone.
Shipping Address Email	Shipping address email.
Billing Address Email	Billing address email.
Shipping Address Form Fields	Shipping address form fields.
Billing Address Form Fields	Billing address form fields.

Order Transactions

One row per payment transaction or refund for orders in the selected date range.

Column	Description
Order ID	Parent order ID.
Transaction ID	Record ID from BigCommerce.
Event	Payment transaction event type (purchase, refund, etc.).
Method	Payment method on the transaction.
Amount	Coupon amount or gift certificate face value / monetary amount.
Currency	Currency code for monetary fields on the row.
Gateway	Payment gateway.
Gateway Transaction ID	Gateway's transaction ID.
Date Created	When the record was created.
Test	Test.
Status	Order or record status as reported by the platform.
Fraud Review	Fraud Review.
Reference Transaction ID	Reference Transaction ID from the source platform.
Payment Method ID	Payment Method ID from the source platform.
AVS Result	AVS Result.
CVV Result	CVV Result.
Credit Card	Credit Card.
Gift Certificate	Gift Certificate.
Store Credit	Store Credit.
Custom	Custom.
Payment Instrument Token	Payment Instrument Token.
Offline	Offline.
Order Date Created	Created date of the parent order (for joining / filtering).
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Customers

One row per customer. Full export each run: current customer records; the date range does not apply.

Column	Description
Customer ID	Record ID from BigCommerce.
Company	Company name.
Customer Group ID	Customer group ID.
Email	Customer email address.
First Name	First name.
Last Name	Last name.
Notes	Notes.
Phone	Phone number.
Registration IP Address	Registration IP Address.
Tax Exempt Category	Tax Exempt Category.
Date Created	When the record was created.
Date Modified	When the record was last modified.
Accepts Review/Abandoned Cart Emails	Accepts Review/Abandoned Cart Emails.
Origin Channel ID	Origin Channel ID from the source platform.
Channel IDs	Channel IDs.
Store Credit Amounts	Store Credit Amounts in the row currency unless noted otherwise.
Authentication	Authentication.
Addresses	Addresses.
Attributes	Attributes.
Form Fields	Form Fields.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Products

One row per catalog product. Full export each run: current catalog; the date range does not apply.

Column	Description
Product ID	Record ID from BigCommerce.
Name	Buyer or entity display name.
Type	Product or coupon type.
SKU	SKU for the product, variant, or line.
Description	Full description text.
Weight	Weight.
Width	Width.
Depth	Depth.
Height	Height.
Price	Unit or listing price in the row currency.
Cost Price	Cost of goods.
Retail Price	Retail / MSRP price.
Sale Price	Sale price when set.
MAP Price	Minimum advertised price.
Tax Class ID	Tax Class ID from the source platform.
Product Tax Code	Product Tax Code.
Calculated Price	Calculated selling price after rules.
Brand ID	Brand ID from the source platform.
Option Set ID	Option Set ID from the source platform.
Option Set Display	Option Set Display.
Inventory Level	Current inventory quantity.
Inventory Warning Level	Inventory Warning Level.
Inventory Tracking	How inventory is tracked (none, product, variant).
Reviews Rating Sum	Reviews Rating Sum.
Reviews Count	Reviews Count.
Total Sold	Total Sold in the row currency unless noted otherwise.
Fixed Cost Shipping Price	Fixed Cost Shipping Price in the row currency unless noted otherwise.
Is Free Shipping	Boolean: Is Free Shipping.
Is Visible	Whether the product or category is visible on the storefront.
Is Featured	Whether the product is featured.
Warranty	Warranty.
Bin Picking Number	Bin Picking Number.
Layout File	Layout File.
UPC	UPC barcode.
MPN	MPN.
GTIN	GTIN.
Search Keywords	Search Keywords.
Availability	Availability.
Availability Description	Availability Description.
Sort Order	Sort Order.
Condition	Item condition (e.g. New).
Is Condition Shown	Boolean: Is Condition Shown.
Order Quantity Minimum	Order Quantity Minimum.
Order Quantity Maximum	Order Quantity Maximum.
Page Title	Page Title.
Meta Keywords	Meta Keywords.
Meta Description	Meta Description.
Date Created	When the record was created.
Date Modified	When the record was last modified.
View Count	View Count.
Preorder Release Date	Preorder Release Date.
Preorder Message	Preorder Message.
Is Preorder Only	Boolean: Is Preorder Only.
Is Price Hidden	Boolean: Is Price Hidden.
Price Hidden Label	Price Hidden Label in the row currency unless noted otherwise.
Base Variant ID	Base Variant ID from the source platform.
Categories	Category IDs or payload for the product.
Related Products	Related Products.
Custom URL	Custom URL path for the catalog entity.
Variants	Variant payload when included on the product.
Images	Image payload when included on the product.
Custom Fields	Custom fields payload.
Bulk Pricing Rules	Bulk Pricing Rules.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Product Variants

One row per product variant. Full export each run: current variants; the date range does not apply.

Column	Description
Variant ID	Record ID from BigCommerce.
Product ID	Catalog product ID.
SKU	SKU for the product, variant, or line.
SKU ID	SKU ID from the source platform.
Price	Unit or listing price in the row currency.
Calculated Price	Calculated selling price after rules.
Sale Price	Sale price when set.
Retail Price	Retail / MSRP price.
MAP Price	Minimum advertised price.
Cost Price	Cost of goods.
Weight	Weight.
Width	Width.
Height	Height.
Depth	Depth.
Is Free Shipping	Boolean: Is Free Shipping.
Fixed Cost Shipping Price	Fixed Cost Shipping Price in the row currency unless noted otherwise.
Calculated Weight	Calculated Weight.
Purchasing Disabled	Whether purchasing is disabled for the variant.
Purchasing Disabled Message	Purchasing Disabled Message.
Image URL	Image URL.
UPC	UPC barcode.
MPN	MPN.
GTIN	GTIN.
Inventory Level	Current inventory quantity.
Inventory Warning Level	Inventory Warning Level.
Bin Picking Number	Bin Picking Number.
Option Values	JSON of variant option values.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Column	Description
Category ID	Record ID from BigCommerce.
Parent ID	Parent category ID (0 for top-level).
Name	Buyer or entity display name.
Description	Full description text.
Sort Order	Sort Order.
Page Title	Page Title.
Meta Keywords	Meta Keywords.
Meta Description	Meta Description.
Layout File	Layout File.
Image URL	Image URL.
Is Visible	Whether the product or category is visible on the storefront.
Search Keywords	Search Keywords.
Default Product Sort	Default Product Sort.
Custom URL	Custom URL path for the catalog entity.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Brands

One row per brand. Full export each run: current brands; the date range does not apply.

Column	Description
Brand ID	Record ID from BigCommerce.
Name	Buyer or entity display name.
Page Title	Page Title.
Meta Keywords	Meta Keywords.
Meta Description	Meta Description.
Search Keywords	Search Keywords.
Image URL	Image URL.
Custom URL	Custom URL path for the catalog entity.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Coupons

One row per marketing coupon. Full export each run: current coupons; the date range does not apply.

Column	Description
Coupon ID	Record ID from BigCommerce.
Name	Buyer or entity display name.
Type	Product or coupon type.
Amount	Coupon amount or gift certificate face value / monetary amount.
Min Purchase	Minimum purchase required for the coupon.
Expires	Coupon expiry datetime.
Enabled	Whether the coupon or location is enabled.
Code	Coupon or location code.
Applies To	What the coupon applies to.
Number Of Uses	Times the coupon has been used.
Max Uses	Maximum total uses.
Max Uses Per Customer	Maximum uses per customer.
Restricted To	Restricted To.
Shipping Methods	Shipping Methods.
Date Created	When the record was created.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Gift Certificates

One row per gift certificate. Full export each run: current gift certificates; the date range does not apply.

Column	Description
Gift Certificate ID	Record ID from BigCommerce.
Customer ID	BigCommerce customer ID (blank for guest orders when applicable).
Order ID	Parent order ID.
Code	Coupon or location code.
To Name	Gift certificate recipient name.
To Email	Gift certificate recipient email.
From Name	Gift certificate purchaser name.
From Email	Gift certificate purchaser email.
Amount	Coupon amount or gift certificate face value / monetary amount.
Balance	Remaining gift certificate balance.
Status	Order or record status as reported by the platform.
Currency Code	ISO 4217 currency code (e.g. `USD`).
Purchase Date	When the gift certificate was purchased.
Expiry Date	Gift certificate expiry date.
Template	Template.
Message	Message.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Inventory Locations

One row per inventory location. Full export each run: current locations; the date range does not apply.

Column	Description
Location ID	Record ID from BigCommerce.
Code	Coupon or location code.
Label	Label.
Description	Full description text.
Type ID	Type ID from the source platform.
Enabled	Whether the coupon or location is enabled.
Managed By External Source	Managed By External Source.
Time Zone	Time Zone.
Address	Address.
Storefront Visibility	Storefront Visibility.
Special Hours	Special Hours.
Operating Hours	Operating Hours.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Inventory Levels

One row per product/variant inventory level at a location. Full export each run: current levels; the date range does not apply.

Column	Description
Product ID	Catalog product ID.
Variant ID	Catalog variant ID.
SKU	SKU for the product, variant, or line.
Location ID	Inventory location ID.
Location Code	Inventory location code.
Available To Sell	Units available to sell at the location.
Total Inventory On Hand	Total on-hand inventory at the location.
Warning Level	Warning Level.
Safety Stock	Safety Stock.
Is In Stock	Boolean: Is In Stock.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Channels

One row per sales channel. Full export each run: current channels; the date range does not apply.

Column	Description
Channel ID	Record ID from BigCommerce.
Name	Buyer or entity display name.
Platform	Channel platform (e.g. bigcommerce, amazon).
Type	Product or coupon type.
Date Created	When the record was created.
Date Modified	When the record was last modified.
External ID	External ID from the source platform.
Icon URL	Icon URL.
Is Listable From UI	Boolean: Is Listable From UI.
Is Visible	Whether the product or category is visible on the storefront.
Status	Order or record status as reported by the platform.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).

Product Channel Assignments

One row per product-to-channel assignment for multi-storefront catalogs. Full export each run: current assignments; the date range does not apply.

Column	Description
Product ID	Catalog product ID.
Channel ID	Sales channel ID for the order or assignment.
Date Exported	Timestamp this row was written by SyncRange (your account timezone).