BigCommerce-tabellerna i Sheets
Sheets läser din BigCommerce-butik som 11 tabeller. Lägg till en i ett kalkylark som datakälla så blir dess kolumner namn som dina formler använder.
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…