What Is the Inventory Cost Report?
The Inventory Cost Report is a product-level Shopify report that shows how much capital is tied up in your current stock at cost. For every variant it multiplies the cost per item by the quantity in stock, then sits that figure next to the selling price, so you can read both the cost and the retail value of what you are holding in one place.
The number that matters here is cost, not units. Shopify's built-in inventory views tell you how many pieces you have; this report tells you how much money those pieces represent and where that money is parked. Two fields are easy to mix up: Inventory Cost is your stock valued at what you paid (cost per item × quantity), while Inventory Value is the same stock valued at its selling price (product price × quantity). The gap between them is the profit still locked in your shelves.
Merchants reach for this report when the question is financial rather than operational: how much cash is sitting in inventory right now, which products hold most of it, and is that stock set up to earn its keep.
Which Fields Are Included in the Inventory Cost Report?
These fields let you value your stock, trace each figure back to a real product, and see where your capital sits.
You can add, remove, or reorder columns — for example adding Vendor, Product Type, or Inventory Quantity — so the report matches how you review stock.
Important Insights You Can Find in This Report
Where is the gap between cost and selling price thinnest?
Read Inventory Cost and Inventory Value side by side for each variant. When the two numbers sit close together, that product has little room between what you paid and what you charge, so a supplier price rise or a modest markdown can erase the margin. Sort to surface the smallest gaps first, then decide whether to reprice, renegotiate supply, or stop reordering the items whose profit is most fragile.
Is your inventory cost concentrated in a few products, one collection, or one location?
Group by Collections or Location and total the Inventory Cost column. If a large share of your capital sits in a single category, supplier, or warehouse, you are carrying concentration risk: one slow season or one supplier problem can tie up a big chunk of cash at once. This is the check worth running before you commit the next large purchase order.
Are any rows showing a blank or zero Inventory Cost?
A blank Inventory Cost means the cost per item was never set on that product in Shopify, so it silently drops out of your valuation. Filter for empty cost values to find the gaps. Fixing that source data is the difference between a total you can put on a balance sheet and one that quietly understates what you actually own.
THE ANALYST'S READ: The Signal Most Merchants Miss
The tempting move is to subtract Inventory Cost from Inventory Value, call the difference profit, and feel good about a big number. That gap is potential gross profit, not money in the bank. It only becomes real if the stock sells, and this report does not show how fast anything is moving. A wide spread sitting in slow stock is not good news at all: it is cash locked in a product that may need a markdown before it clears, which shrinks the very margin the gap seemed to promise.
Read the cost-versus-value gap next to how fast each product is selling, never on its own. Where a high Inventory Cost lines up with weak movement, treat the "potential profit" as a clearance risk to investigate rather than a win to bank. And keep in mind that any row with missing cost data is quietly deflating the whole picture, so your true position may be worse than the report first suggests. Cost is only one of several inventory signals worth reading together; stock levels, movement, and location tell the rest of the story.
How Can You Automate the Inventory Cost Report?
Once the columns and filters are set the way you want, you do not have to rebuild anything by hand. Save the report, then schedule it to email automatically on a daily, weekly, or monthly cycle, which turns month-end valuation into a hands-off task. The same schedule can send to your team, your VA, or your accountant.
Export it as Excel, CSV, or PDF — PDF for a clean valuation to share, Excel to dig into the numbers — or push it to Google Sheets or Google Drive so the data lands where you already work.
Frequently Asked Questions
What is the Inventory Cost Report in Shopify?
It is a product-level report showing how much capital is tied up in your current stock at cost. For each variant it multiplies the cost per item by the quantity in stock, and it places that figure next to the selling price so you can see both the cost and the retail value of what you hold.
How is Inventory Cost different from Inventory Value in this report?
Inventory Cost is your stock valued at cost (cost per item × quantity). Inventory Value is the same stock valued at its selling price (product price × quantity). The distance between the two is the potential gross profit sitting in your inventory.
How is the Inventory Cost Report different from the Inventory Sale Value Report?
Both use the same fields but lead with a different number. This report is built around the cost side, so it answers how much capital you have locked in stock and where. The Inventory Sale Value Report leads with the retail value of that stock. Use the Cost Report for valuation, cash planning, and margin protection; use Sale Value when you care most about the selling-price worth of your holdings. If you run more than one store, keeping inventory value accurate across all of them needs extra care.
Do I need to set product cost in Shopify for this report to work?
Yes. The report reads the Cost per item field on each product or variant in Shopify. If that field is blank, the Inventory Cost column for that row will be blank too, and the product will be missing from your total valuation.
Does the report use my discounted or bulk cost per unit?
It uses whatever cost per item you have entered on the product in Shopify. If you negotiated a bulk discount and updated the cost to reflect your true per-unit price, the report uses that lower figure. Keeping the cost field current after each supplier change is what keeps the valuation accurate.
Can I see inventory cost by location, vendor, or collection?
Yes. Filter or group by Location or Collections directly, and add Vendor as a column to break cost down supplier by supplier. This is how buyers check what they already hold from one supplier before committing the next purchase order.
Can I schedule the report for month-end?
Yes. Set it to run monthly and email itself on the first of the month, giving finance a consistent stock valuation and a repeatable audit trail without anyone rebuilding it.