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.
Hello @Davide2023 ,
Report Pundit will be a good workaround for your needs. We are a team of reporting experts specialized in creating custom reports tailored to user’s needs.
Our tool is efficient in generating reports with the key data you have mentioned, You can schedule a report at any intervals to be delivered at your space of convenience.
To know more, start with our 14-day free trial and contact us, Our team can assist you.
Best Regards,
Report Pundit Team