See net sales, quantity sold, refunds, and orders for every product and variant, plus cost-based profit and margin for variants, in a live spreadsheet fed by your Shopify store. Slice by collection, vendor, tag, or date range, and build on the numbers with regular formulas.
Mixtable's analytical worksheets turn your Shopify sales data into spreadsheet rows and columns. Start from templates, pick your metrics and filters, and keep working the numbers with formulas.
Net sales, gross sales, quantity sold, orders, and refunds per product or variant, plus cost of goods sold, profit, and margin per variant.
Start from Product Sales by Month, Product Sales by Year, Product Sales Metrics, Product Variant Sales Metrics, Collection Sales, or Product Returns.
Compare performance by collection, vendor, product type, category, or tag, and see which parts of the catalog carry the quarter.
Build analytical worksheets as pivot tables or time series, then add your own formulas on top, like any other spreadsheet.
Add supported analytics fields directly to product worksheets, so sales numbers sit next to the fields you manage every day.
Use fixed or dynamic date ranges, and filter by countries, customer segments, discounts, fulfillment status, or order type.
Dashboards show you numbers. A spreadsheet lets you keep going: sort by any metric, filter to one vendor, add a formula column, and answer the follow-up question without exporting anything.
Revenue tells you what sold, quantity tells you what moves, and returns tell you what comes back. Variant-level metrics show which sizes and colors actually drive a product's numbers, and the Product Returns template keeps refund problems visible.
Bestsellers are not always best earners. With cost of goods sold, profit, and gross margin as variant-level columns, you can see which sizes and options earn their shelf space, and which ones only look good in a revenue chart.
One quarter is a number, twelve months is a story. Time series worksheets lay out sales by month or year per product, and dynamic date ranges keep recurring views like last 30 days fresh without rebuilding anything.
Analytical worksheets cover supported metric and filter combinations. These are the core metrics for product sales analysis.
Shopify's reports answer the standard questions. Here is how the options compare when your questions do not fit a canned report.
| Analysis task | Mixtable | Shopify reports | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Product and variant level sales metrics | Yes, in a live sheet | Yes, fixed reports | Stale the moment you export | Yes, after setup |
| Add your own formulas to the numbers | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Profit and margin per variant | Yes, from your cost data | Limited | Manual math | Yes, after modeling |
| Numbers beside your editable catalog | Yes, same spreadsheet | No | No | No |
| Stays current without re-exporting | Yes, dynamic ranges | Yes | No | Yes, via pipelines |
| Company-wide BI across many data sources | No, by design | No | No | Yes, their core job |
| Setup time | Minutes, from templates | None | Every single time | Days to weeks |
Comparison reflects typical product sales analysis workflows. Mixtable analytics covers supported metric and filter combinations.
No exports, no pipelines. Pick a template and start asking questions.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and open a spreadsheet.
Start from Product Sales Metrics, sales by month or year, Collection Sales, or Product Returns.
Choose a fixed period for a report, or a dynamic range like last 30 days for a living view.
Compare by collection, vendor, type, or tag, and filter by segment, country, or order type.
Sort, add formula columns, and export to Excel or CSV when someone needs the file.
Install the Mixtable Analytics Spreadsheet from the Shopify App Store and create an analytical worksheet from a template like Product Sales Metrics. Your products load as rows with sales metrics as columns, live from your store, and you work with them like any spreadsheet.
Yes. Net and gross quantity sold are available per product and per variant, so you can see which sizes and colors actually move, not just which product page earns revenue.
Yes. Cost of goods sold, net profit, gross profit, and gross margin load as variant-level metric columns, using the cost data in your Shopify store. These columns are analysis views, not Shopify fields you sync back.
Yes. Analytical worksheets can group and compare performance by collection, vendor, product type, category, or tag, and the Collection Sales template gives you a ready-made starting point.
Yes. Use a dynamic date range like last 30 days or last month and the worksheet keeps itself current as time moves. Fixed ranges are there when you need a report for a specific period.
Yes. Supported analytics fields can be added directly to a products worksheet, so quantity sold or net sales sits beside the titles, tags, and prices you already manage there.
Open Mixtable for your store and see which products actually carry your business.
