BigCommerce brands in a live spreadsheet
Add the Brands table to a sheet as a data source named brands and its 2 columns become names your formulas, pivot tables and charts use. Sheets reads it from your BigCommerce store each time the sheet opens or refreshes.
Formulas on this table
=list.brands(name) Every name, once. Spills the distinct name values down the column: the row labels for the formula above.
=data.brands.count(name, name, "<>") Rows with a name. Counts the rows whose Name is not empty.
Columns
| Column | In formulas | Type |
|---|---|---|
| Name | name | Text |
| ID | id | Text |
Other catalog tables
Your brands, live
Orders, refunds, products, customers and coupons become live tables inside your BigCommerce control panel. Sales reports and dashboards stay current without exporting a CSV.