The BigCommerce tables in Sheets
Sheets reads your BigCommerce store as 11 tables. Add one to a spreadsheet as a data source and its columns become names your formulas use.
Sales
OrdersDate, Month, Order number, Status, Counts as sale…Order linesDate, Month, Order number, Status, Counts as sale…RefundsDate, Month, Amount, Tax, Reason…
Catalog
ProductsName, Type, SKU, Visible, Availability…Product variantsProduct, Variant, SKU, Product: Brand, Product: Categories…CategoriesName, Parent, Visible, Sort order, ID…BrandsName, ID…
Customers
CustomersName, E-mail, Company, Group, Country…Buyers (from orders)E-mail, Name, Country, Registered, Customer ID…Customer groupsName, Default, ID…