Works with BigCommerce · ready

Live spreadsheets on your BigCommerce store data

Orders, refunds, products, customers and coupons become live tables inside your BigCommerce control panel. Sales reports and dashboards stay current without exporting a CSV.

Contact us See the reports
  • Opens inside your control panel
  • AI assistants via MCP
  • Reads your store; changes nothing
What it is

Drop Top Sheets

Live spreadsheets, dashboards and scheduled reports on BigCommerce data.

Drop Top Sheets for BigCommerce, a single-click app.

Drop Top Sheets for BigCommerce turns your store into live spreadsheets, pivot tables, charts and dashboards. Orders, order lines, refunds, products, variants, categories, brands, customers, customer groups, buyers and coupons become tables that spreadsheet formulas read directly, so your numbers stay up to date without exporting a CSV. It opens inside your BigCommerce control panel, under Apps → Drop Top Sheets, in the control panel's own look.

  • Net sales after refunds, orders, average order, items sold, refunds, shipping, buyers and orders to fulfil, per month, status, product and country, in a ready-made "BigCommerce overview" spreadsheet.
  • Formulas such as =data.orders.sum(net_total, counts_as_sale, TRUE) and =data.order_lines.sum(quantity, product, "Ceramic mug") work next to any spreadsheet function.
  • Several stores: link the stores you run and report on them together, with an "Orders, all stores" table that has a Store column.
  • Pivot tables, charts and dashboards with filters and click-to-filter; exports to .xlsx and PDF; share links.
  • Scheduled e-mail reports and alerts sent from your own mailbox.
  • Work with AI: connect Claude, ChatGPT or another assistant that supports MCP to your store's spreadsheets.

Drop Top Sheets reads your store with read-only access. It never changes orders, products or customers.

The data

11 tables from your BigCommerce store

Add any of them to a spreadsheet as a data source. Each table's page lists its columns and the formulas that use them.

Sales

Orders 35 columns · data.orders Order lines 29 columns · data.order_lines Refunds 14 columns · data.refunds

Catalog

Products 22 columns · data.products Product variants 14 columns · data.product_variants Categories 5 columns · data.categories Brands 2 columns · data.brands

Customers

Customers 9 columns · data.customers Buyers (from orders) 11 columns · data.buyers_from_orders Customer groups 3 columns · data.customer_groups

Marketing

Coupons 11 columns · data.coupons
Reports

Reports people build first

One formula each. Put it in a cell, fill it down a column, or turn the table into a pivot and a chart.

=data.orders.sum(net_total, counts_as_sale, TRUE)
Net sales. Order totals after refunds, for every order that counts as a sale (paid, being fulfilled, shipped, completed or refunded).
=data.orders.sum(net_total, month, A2, counts_as_sale, TRUE)
Net sales per month. List the months with =list.orders(month) in column A and the net sales beside each one.
=data.orders.avg(total, counts_as_sale, TRUE)
Average order. Average order total over the orders that count as sales.
=data.order_lines.sum(quantity, product, A2, counts_as_sale, TRUE)
Units sold per product. Quantity per product from the order lines. List the products with =list.order_lines(product).
=data.orders.sum(net_total, country, A2, counts_as_sale, TRUE)
Sales by country. Net sales per billing country in column A.
=data.orders.count(id, status, A2)
Orders per status. How many orders are awaiting payment, awaiting fulfillment, shipped, completed and so on. Put a status in A2.

All 10 reports

How it works

From connection to a live report

  1. ConnectInstall Drop Top Sheets from Apps in your control panel and open it from Apps → Drop Top Sheets. It gets read-only access; it never changes your store.
  2. Add dataAdd the tables a sheet needs as data sources, each under a short name.
  3. Write formulasUse =data.<name>.sum(…) next to any spreadsheet function, or build pivots and charts.
  4. Share and scheduleShare the sheet with colleagues, export to .xlsx or PDF, or e-mail it on a schedule.
FAQ

Questions

Does Sheets change my store?

No. Sheets asks BigCommerce for read-only permissions only, and reads orders, products, customers and coupons with them.

Which store data can a sheet use?

11 tables: orders, order lines, refunds, products, product variants, categories, brands, customers, buyers (from orders), customer groups, and coupons.

How are net sales counted?

Orders awaiting fulfillment, shipment or pickup, shipped, completed and (partially) refunded count as sales, and Net total takes refunds off each order.

Can I report on several stores together?

Yes. Install the app in each store and link them in Sheets: "Orders, all stores" gives one table with a Store column. People only see a store they use Sheets in.

Can an AI assistant build my reports?

Yes. Connect Claude or another MCP client to your store's Sheets: it can read your sheets and store data, write formulas and build dashboards. It can never change your store.

Live spreadsheets on your BigCommerce store data

Orders, refunds, products, customers and coupons become live tables inside your BigCommerce control panel. Sales reports and dashboards stay current without exporting a CSV.

Contact us

BigCommerce is a trademark of BigCommerce Pty. Ltd. Drop Top Sheets is not made or endorsed by BigCommerce.