Inventory_location_name no longer works for inventory reports

Shopify Discussion
, , ,
1

There is a thread here just 8 months ago that claimed I could filter by inventory when pulling a report from inventory and inventory by location. Link here: New Month-end Inventory Value report is not filtering by location However, after talking with the AI and support it was determined that this is not possible. Is this a bug or a deprecated feature? Being able to see and export units in inventory by location is a simple and important task, and then be able to lookup and compare inventory levels to sales over time. This makes inventory reports for multiple POS locations unusable.

Yes, you can use the Products - Inventory page to pull this, but the export does not have a variant ID and the variant name is split up into options. As a work around, I can concatenate through a series of IF statements in my spread sheet to form the proper variant names and then use an XLOOKUP. It works, but its clunky. I would rather have the variant ID as the identifier to look up between the two tables. Heck, you should be able to combine sales and inventory reports without the extra tables work in a spreadsheet. I should not have to pay $600/year for yet another add on to generate this report.

For reference here is the Query that works if you take out the inventory_location_name.

FROM inventory, inventory_by_location
SHOW ending_inventory_value, ending_inventory_units_at_location,
ending_inventory_value_at_location
WHERE inventory_is_tracked = true
AND product_vendor = ‘Neometal’
GROUP BY product_title, product_variant_title, product_variant_sku,
inventory_item_cost, product_variant_id, inventory_location_name WITH TOTALS
SINCE startOfDay(-30d) UNTIL today
ORDER BY ending_inventory_units_at_location DESC
LIMIT 1000
VISUALIZE ending_inventory_value_at_location TYPE table

2

Try removing “Ending inventory value” from metrics and keep only “(by location)” metrics.
Then you should be able to add “location” as either dimension or filter

4

I tried this before and thought I remembered errors. It worked this time though. Thank you, for the assist. Although, I wonder why both the AI and support were unable to find this solution.

5

Well, AI’s AI, one shouldn’t expect it to know real answers to everything. Sometimes it has no info, sometimes it hallucinate.
You can’t expect AI to go into Shopify admin and run a couple of tests there…

Anyways, great if your problem is solved.

if my post is helpful, please like it ♡ and mark as a solution -- this will help others find it
6

You are dang right on that. I don’t use AI for definitive answers, but in general it gets you to brick walls that allow you to pivot to the right answer by weeding out the wrong ones. Trial and error. LOL. Thanks again.