Works with WooCommerce · ready

Live spreadsheets on your WooCommerce store data

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

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

Drop Top Sheets

Live spreadsheets, dashboards and scheduled reports on WooCommerce data.

Drop Top Sheets for WooCommerce, a WordPress plugin.

Drop Top Sheets for WooCommerce turns your store into live spreadsheets, pivot tables, charts and dashboards. Orders, order lines, refunds, products, variations, customers, buyers, coupons and categories become tables that spreadsheet formulas read directly, so your numbers stay up to date without exporting a CSV. It opens full page inside your WordPress admin, under WooCommerce → Sheets, in the admin's own look.

  • Net sales after refunds, orders, average order, items sold and orders waiting, per month, status, product and country, in a ready-made "WooCommerce overview" spreadsheet.
  • Formulas such as =data.orders.sum(net_total, counts_as_sale, TRUE) and =data.order_lines.sum(quantity, product, "Classic mug") work next to any spreadsheet function.
  • 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, approved in your WordPress admin.

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

The data

9 tables from your WooCommerce 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 31 columns · data.orders Order lines 22 columns · data.order_lines Refunds 13 columns · data.refunds

Catalog

Products 20 columns · data.products Product variations 14 columns · data.product_variations Product categories 5 columns · data.product_categories

Customers

Customers 10 columns · data.customers Buyers (from orders) 11 columns · data.buyers_from_orders

Marketing

Coupons 9 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 (processing, on hold, completed, 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 pending payment, processing, on hold, completed and so on. Put a status in A2.

All 10 reports

How it works

From connection to a live report

  1. ConnectInstall the plugin, open WooCommerce → Sheets and click Connect your store. Sheets gets a read-only key; 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. The plugin creates a read-only WooCommerce REST API key, and Sheets only reads orders, products, customers and coupons with it.

Which store data can a sheet use?

9 tables: orders, order lines, refunds, products, product variations, customers, buyers (from orders), coupons, and product categories.

How are net sales counted?

Processing, on hold, completed and refunded orders count as sales, as WooCommerce Analytics counts them by default, and Net total takes refunds off each order.

Can an AI assistant build my reports?

Yes. Connect Claude or another MCP client to your store's Sheets, approved in your WordPress admin: it can read your sheets and store data, write formulas and build dashboards.

What happens when I disconnect?

Disconnecting, or deactivating or deleting the plugin, deletes the read-only key and Sheets stops reading the store. Spreadsheets are kept until you ask us to delete them.

Live spreadsheets on your WooCommerce store data

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

Contact us

WooCommerce is a registered trademark of Automattic Inc. WordPress is a trademark of the WordPress Foundation. Drop Top Sheets is not made or endorsed by either.