Is there a Shopify report I can pull that’ll have the date/time (or just date) of the last time a change was made to the SKU/variant? I’m having a problem with SKUs losing connectivity to my dropshippers app and inventory not getting updated. Thanks.
Topic summary
Main issue: A store owner seeks a Shopify report that shows the date/time of the last update to a SKU/variant—specifically the most recent change to variant inventory quantity. The goal is to diagnose drop-offs in syncing with a vendor’s dropshipping app that cause inventory mismatches and unfillable orders.
Clarification: Another participant asked what change type is needed. The requester confirmed they need the timestamp of the last variant inventory update.
Proposed solution: A third-party app (Report Pundit) is suggested. It claims to generate reports on the last changes at product, variant, or SKU levels and can schedule delivery to destinations like Google Drive, Gmail, or FTP. A 14-day free trial is offered.
Status/outcome: No confirmation from the requester that the solution works. It remains unclear if Shopify provides a built-in report showing last inventory update timestamps.
Notes on terms:
- SKU: Stock Keeping Unit, an item identifier.
- Variant: A specific version of a product (e.g., size/color).
- Dropshipping app: A vendor integration that syncs product availability; loss of connectivity can prevent inventory updates.
When you write “last time a change was made to the SKU/variant”, what types of changes are you looking to know about?
Specifically, the last time variant inventory qty was updated. I’m having an issue where my store loses connectivity with the vendor app and my store inventory for random SKUs isn’t getting updated to match the vendor. It leads to sales on my store that the vendor can’t fill. Thanks.
Hey @Glow_Up_Fits ,
To overcome this challenge, you can check out Report Pundit if you’re open to using a reporting app.
With Report Pundit, you can build reports with precise data about the last changes made at the product, variant, or SKU level. You can schedule these reports to be sent at required intervals to destinations such as Google Drive, Gmail, FTP, etc.
Let us know if this works for you, or you can try our 14-day free trial.
Cheers!