What Is the Shopify Inventory by Location Report?
The Shopify Inventory by Location report organizes your stock by the location that holds it. Every product variant appears as its own row for each place you keep inventory, whether that is a warehouse, a retail store, a fulfillment center, or a 3PL. Each row shows the location name, the product and variant, the SKU, how many units sit there, what that stock is worth, and what it cost.
This is different from a store-wide inventory total. A single number tells you a product has 500 units, but it hides the fact that 460 sit in one warehouse and 40 sit in the one that actually ships most of your orders. Inventory by Location breaks that total apart so you can see exactly where each unit lives.
Merchants reach for this report when they run more than one location and need to rebalance stock, reorder per site, or fulfill from the closest stock instead of guessing. If you only need the combined quantity and value per product, the Inventory on Hand report is the simpler read. Use this one when the question is where your stock actually sits.
Which Fields Are Included in the Shopify Inventory by Location Report?
These fields let you read stock at the variant level for each location, so you can line up quantity, value, and cost across every place you hold inventory.
You can customize the pre-made report by adding, removing, or rearranging fields, or by filtering to a single location, product, or SKU, so the view matches how you manage stock.
Important Insights You Can Find in This Report
Is the same product overstocked in one location and running dry in another?
Compare Inventory Quantity for one variant across its location rows. A product can look healthy on a store-wide total while one location is nearly empty and another holds months of cover. When the split is that lopsided, a stock transfer usually fixes it faster and cheaper than a new purchase order. Sort by variant, then read the quantities location by location.
Where is your capital actually tied up?
Inventory Value and Inventory Cost show which locations hold the most money in stock, not just the most units. A location can carry a small number of units but a large share of your inventory value if those units are expensive. If a high-value location is also slow to sell, that is capital you could redeploy elsewhere. Read value alongside how quickly each site moves stock.
Are you fulfilling orders from the location that holds the stock?
Because every location sits on its own row, you can check whether the site that ships most of your orders is the one that actually holds the inventory. When demand concentrates in one region but stock concentrates in another, orders travel further, shipping costs rise, and delivery slows. Seeing the two side by side surfaces the mismatch before it starts costing sales.
THE ANALYST'S READ: The Signal Most Merchants Miss
The least useful number in multi-location inventory is the store-wide total, because it treats every unit as equally reachable. A unit sitting in a location that rarely serves a given region is close to invisible to that region's demand. Look for stranded stock: variants where one location holds most of the quantity while a different location generates most of the fulfillment. That gap inflates on-paper availability while your fastest-selling site still stocks out. Check this after any period where demand shifted between regions, since inventory tends to stay where it was received rather than where it now needs to be. The fix is usually rebalancing between locations rather than reordering something you already own.
How Can You Automate the Shopify Inventory by Location Report?
Open Report Pundit, load the pre-made Inventory by Location report, and save it. The columns are already set, so you can apply any filters you want and reuse it whenever you need it.
From there you can schedule it to send automatically on a daily, weekly, or monthly cycle, and route it to the people who act on it, such as a warehouse manager or your accountant. It exports to Excel, CSV, and PDF, and can be delivered to email, Google Sheets, or Google Drive so the numbers arrive already built.
Frequently Asked Questions
What does the Shopify Inventory by Location report show?
It shows your stock split by the location holding it, at the variant level. Each variant gets a row for every location, with the location name, product, variant, SKU, inventory quantity, inventory value, and inventory cost.
How is Inventory by Location different from Inventory on Hand?
Inventory by Location puts the location first and repeats each variant per site, so you can see where stock physically sits. Inventory on Hand gives the combined quantity and value per variant across the store. Choose this report when the question is where; choose Inventory on Hand when the question is how much in total.
Why does the same product appear in more than one row?
Because stock is broken out by location. If a variant is held in three locations, it appears three times, once per location, each with that location's quantity, value, and cost. That is what lets you compare sites directly.
Can I filter the report to a single location?
Yes. You can filter to one location to review a single warehouse or store on its own, and you can also filter by product or SKU to narrow it further before saving or scheduling.
What is the difference between Inventory Value and Inventory Cost in this report?
Inventory Cost is what the units in a row cost you. Inventory Value is what that stock is worth. Reading them together tells you how much capital is committed at each location and where the heaviest concentration sits.
Does this report show available stock or committed stock?
The pre-made report shows the inventory quantity recorded for each variant at each location. If you track available, committed, or incoming stock separately, those inventory fields can be added when you customize the report.
Can I schedule this report to send automatically?
Yes. You can set it to run daily, weekly, or monthly and deliver to email, Google Sheets, or Google Drive, or export it as Excel, CSV, or PDF each time.