Totally agree! Why isn’t there a standard Inventory Count function that shows variances and notes all on 1 printable summary? I can’t go into every item all the time to see if adjustments are made. Hoping Shopify adds this soon!
Topic summary
Request for a store-wide, filterable report of all inventory adjustments over a time period, ideally by location and user, without opening each product.
Proposed approach: Use Shopify’s Admin API (InventoryLevel resource) via a custom app to retrieve inventory levels and track changes; third‑party apps like Assisty or Sumtracker were suggested.
Key limitation: Multiple users and Report Pundit state Shopify does not expose historical inventory adjustment data via API, making a comprehensive adjustments report (especially retrospective) not feasible. Although adjustment history is visible per product, it’s not available in a native or aggregate report.
Impacts cited: Audit and security concerns, accounting accuracy (COGS = Cost of Goods Sold), brick‑and‑mortar shrink reporting (POS = Point of Sale), tracking donations/promos/damaged items, and tax/legal compliance. Workarounds (creating orders) skew sales metrics.
Related update: A linked thread indicates Shopify has added extended inventory history access (beyond 90 days) to “future recommendations,” with no timeline.
New workaround: Inventory History Guardian app records daily inventory per variant and logs adjustments with notes, offering a store‑wide report exportable to CSV (comma‑separated values); likely effective going forward.
Status: No native Shopify report; conflicting app capabilities; awaiting Shopify developer update. Discussion remains open.
4 Likes