Total in stock inventory summary not working anymore?

[Mandalore]

Help! After the latest Shopify update, I can no longer see the correct inventory value.
Last time I checked for accounting purposes, we had SEK 1.2 million in inventory costs, but now after the latest update, it shows SEK 332K.
The “Total Inventory Value” is no longer available, and the final inventory value doesn’t seem to be correct either…
Does anyone have better insight into how I can retrieve the correct information?

[Pamela329Lac]

Hello!

After the latest Shopify update, your inventory value has drastically dropped from SEK 1.2M to SEK 332K, and the "Total Inventory Value" report is missing. To retrieve the correct information, first check your "Month-end inventory value" report under Analytics > Reports > Inventory. If the discrepancy persists, export your Products > Inventory data to verify Cost per item for each product and manually calculate the total. The issue might stem from altered cost price calculations, new report filters, or un-tracked inventory. If these steps don't resolve it, contact Shopify Support with your specific numbers and observations, as this is critical for accounting. 

[Mandalore]

Hi,

Thanks for the reply. We have not made any changes to altered costs or tracked inventory. The strang part is that when I check the "End of month" inventory in the Analytics I get the correct value : 3 527 Items, 1 254 780 SEK.

But on the same report on my Android app I only get the following: 3 586 items, 202 531 SEK

Both reports has these setting, but give different answers..

FROM inventory
SHOW ending_inventory_units,
ending_inventory_value
WHERE inventory_cost_is_recorded = true AND inventory_is_tracked = true
GROUP BY product_title,
product_variant_title,
product_variant_sku,
inventory_item_cost
WITH TOTALS, PERCENT_CHANGE
SINCE startOfMonth(-1m) UNTIL endOfMonth(-1m)
ORDER BY product_title ASC
LIMIT 1000
VISUALIZE ending_inventory_value TYPE table