Use case for Mixtable Analytics Spreadsheet
Stock levels, inventory value, stockouts, sell-through, and dead stock for every variant, product, and collection, calculated from your store's day-by-day inventory history. See what you had, what it was worth, and what isn't selling.
Inventory by Vendor - Acme Apparel From Shopify Trusted by thousands of Shopify stores
What you can do
Mixtable downloads your store's daily stock history from Shopify and calculates 18 inventory metrics from it. Add them beside your products, or total them in a report.
Stock levels, inventory value at cost and retail, stockouts, in-stock rate, sell-through, turnover, days of stock left, and dead stock.
Mixtable keeps your store's stock for every day and adds each finished day every morning, so last month's numbers are there when you need them.
Add inventory metrics as columns on variant, product, and collection worksheets, next to SKU, vendor, price, and cost.
Pivot Table and Time Series worksheets total inventory by vendor, product type, category, tag, stock location, or the whole store.
Count every stock location, or only the ones you pick, such as one warehouse without the returns shelf.
Sort, filter, and add your own reorder points or targets, like any spreadsheet.
Inventory metrics cover variants that track inventory in Shopify. Which ones a row can show depends on what the row holds.
In the spreadsheet
Month-End Inventory - September From Shopify Pick a day, such as the end of last month, and see how many units you had and what they were worth at cost and at retail. A month-end stock valuation by vendor, product type, or stock location takes one Pivot Table worksheet, with no snapshot to export every month.
Guide: Stock levels and inventory value Variants - Last 60 days From Shopify Sales reports can't show the orders you missed. Mixtable counts the days each variant ended out of stock and estimates the Net Sales those days likely cost, based on what it sold on the days it was in stock.
Guide: Stockouts and in-stock rate Variants - Reorder list From Shopify Days of Stock Left divides what's on hand by the pace each variant sold on its in-stock days, so a recent stockout doesn't make a bestseller look slow. Sort by it, and the variants that run out first rise to the top.
Guide: Sell-through, turnover, and dead stock Dead Stock - Last 6 months From Shopify Dead Stock Units and Dead Stock Value at Cost total the stock on variants that sold nothing during the period, by vendor, product type, or stock location. See how much money is sitting on the shelf before you place the next order.
Guide: Dead stock by vendor or locationCompare
Shopify shows your stock right now. Here is how the options compare when the question is about stock over time.
| Inventory task | Mixtable | Shopify reports | Exporting to Excel | BI platforms |
|---|---|---|---|---|
| Stock and its value on a past day | Yes, day by day | Some reports, by plan | Only days you exported | Yes, after modeling |
| Stockout days and estimated lost sales per variant | Yes, per variant | Limited | Daily exports needed | Yes, after modeling |
| Dead stock valued at cost | Yes, any period | Limited | Manual joins | Yes, after modeling |
| Inventory metrics beside product fields | Yes, same worksheet | Separate reports | Manual lookups | Separate tool |
| Totals by vendor, type, or location | Yes, Pivot Table worksheets | Some reports | Manual pivot work | Yes, after modeling |
| Add your own reorder formulas | Yes, it is a spreadsheet | No | Yes, manually | Query languages |
| Setup time | Minutes, once history loads | None | Every single time | Days to weeks |
Comparison reflects typical inventory analysis workflows. Mixtable inventory metrics cover variants that track inventory in Shopify.
Getting started
Mixtable downloads your stock history in the background. Once it's in, every report fills in on its own.
Install Mixtable Analytics Spreadsheet from the Shopify App Store and approve its permissions, including reading your Shopify reports.
Mixtable downloads your daily stock history a month at a time, then adds each finished day every morning.
Add analytics columns to a Products (with variants) worksheet, or build a Pivot Table or Time Series worksheet from the Inventory group.
Choose a day or a period, and count every stock location or only the ones you pick.
Sort by Days of Stock Left to reorder, or by Dead Stock Value at Cost to plan markdowns.
Questions
Mixtable downloads your store's daily stock history from Shopify in the background, then adds each finished day every morning. The metrics that compare stock with sales use the Net Sales and Net Quantity Sold that Mixtable calculates from your Shopify orders over the same days.
Eighteen: Opening Stock, Closing Stock, Stock Change, Average Daily Stock, Closing Value at Cost, Closing Value at Retail, Units Without Cost, Days In Stock, Days Out of Stock, In-Stock Rate, Out-of-Stock Variants, Last In-Stock Date, Days of Stock Left, Estimated Lost Sales, Sell-Through Rate, Inventory Turnover, Dead Stock Units, and Dead Stock Value at Cost.
Sell-Through Rate is units sold divided by units sold plus the stock left at the end of the period. Units sold is Net Quantity Sold from your Shopify orders, so returns count against it. A variant that sold 60 units and ended with 40 has a Sell-Through Rate of 60%.
Closing Value at Cost multiplies the units in stock at the end of the day by each variant's cost per item, and Closing Value at Retail uses its price. Mixtable uses the cost and price as they stood on that day, from its own record of them. Units without a cost are left out, and the Units Without Cost metric shows how many there are.
Yes. Pivot Table and Time Series worksheets have a Location breakdown with one row per stock location, and most inventory metrics let you count only the locations you pick. Metrics that compare stock with sales, such as Sell-Through Rate, always count every location, because Shopify orders aren't split by stock location.
No. Inventory metrics describe days that have finished, so yesterday's Closing Stock won't match your Shopify admin right now. For current quantities by location, which you can also edit and sync with Mixtable Spreadsheet Editor, add an Inventory column to a Products (with variants) worksheet.
Mixtable Analytics Spreadsheet installed with permission to read your Shopify reports, inventory tracking turned on for the variants you want to measure, and cost per item filled in for the inventory value metrics.
With Mixtable Spreadsheet Editor, yes. Mark slow sellers down or add them to a sale collection in a Shopify data worksheet, then preview your changes and sync them to Shopify when you're ready.
Keep going
Adjacent workflows and the help articles behind this page.
Open Mixtable for your store and let your stock history answer the questions sales numbers can't.
