BigCommerce orders export (Control Panel > Orders > Export)
The order CSV produced by a BigCommerce export TEMPLATE. The trap begins before the data: the template is user-configurable, so "the BigCommerce order export" has no fixed set of columns.
The shape, how the file is really laid out
Export runs against a selectable template (a built-in default or a custom one),
so column names and presence differ store to store, never assume a schema.
A typical line-item layout repeats order-level fields (Order ID, Order Date,
Order Status, Subtotal, Shipping Cost, Handling Cost, Tax, Total, Payment
Method, Currency Code) and blanks them on continuation rows while per-product
columns (Product Name, SKU, Qty, Product Price) vary. BigCommerce uses a large
status set: Incomplete, Pending, Awaiting Payment, Awaiting Fulfillment,
Awaiting Shipment, Awaiting Pickup, Partially Shipped, Completed, Shipped,
Cancelled, Declined, Refunded, Partially Refunded, Disputed, Manual
Verification Required. Order dates are in the store's configured timezone.
The traps
Incomplete-order trap: status "Incomplete" is an abandoned checkout that never completed payment; it can be included in an export and summing it invents revenue.
- Every trap in this export, worked through
- The reconciliation anchor, the total the file asserts about itself
- The refusal cases, when to stop and ask instead of guess
Reference: BigCommerce Help Center, exporting orders · export templates · order statuses · and Multi-Currency (documentation)