Report on current product inventory from Shopify
SyncWith can report on your product inventory in Shopify. The quantities shown are the current stock levels.
Set your time range to All Time to report on all products, regardless of when they were first added to your store.
Inventory can have many states (see Inventory states on Shopify's documentation site). We have multiple fields that break out this inventory:
You can also add the Inventory type and Inventory quantity by type fields to break out the results by inventory type.
Its also possible to report on both orders and current inventory in the same report, e.g. to see sold quantity vs current inventory by product. To do so, use the Product total inventory field to show the available inventory for a given product. Unfortunately, you can't currently report on current product variant inventory when also reporting on orders.
Set your time range to All Time to report on all products, regardless of when they were first added to your store.
Inventory can have many states (see Inventory states on Shopify's documentation site). We have multiple fields that break out this inventory:
| Field | Description |
|---|---|
| Available inventory | Inventory that you can sell. It isn’t committed to any orders or set aside as unavailable. It also doesn’t include inventory that’s considered incoming |
| Committed inventory | Inventory that is part of a placed order but isn't yet fulfilled. When inventory is part of a draft order, it can’t be purchased by customers, but also doesn’t count as Committed until the draft becomes an order |
| Unavailable inventory | Inventory that is reserved for draft orders, set aside by apps, or other inventory hold reasons, such as damaged, quality control, or safety stock. Unavailable inventory is stocked at your location but isn't available to be sold |
| On hand inventory | Inventory you have at locations. The sum of Available, Committed and Unavailable inventory |
| Incoming inventory | Inventory that’s on its way to your location from transfers, purchase orders, or apps. Incoming inventory isn’t available to sell until it's been received at the location |
You can also add the Inventory type and Inventory quantity by type fields to break out the results by inventory type.
Combining current product inventory with orders
Its also possible to report on both orders and current inventory in the same report, e.g. to see sold quantity vs current inventory by product. To do so, use the Product total inventory field to show the available inventory for a given product. Unfortunately, you can't currently report on current product variant inventory when also reporting on orders.
Updated on: 10/30/2024
Thank you!