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. Using the All Time date range is important otherwise your report won't include all of your products and/or variants.
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.
We recommend you use the per-type inventory fields above such as Available inventory, if those do not work for your use case then please try Product total inventory, but we don't recommend using these in combination.
Limitations
SyncWith should report up to date accurate inventory levels for your store's inventory at all times. However, there is one known situation where we may report different inventory numbers.
Inventory as of a specific date
SyncWith does not have the ability to report on inventory as of a specific date, SyncWith can only report on current inventory which is your store's inventory levels as of right now (the current moment).
This means you can't use SyncWith to report on inventory from a date in the past. Whenever you run an inventory report with SyncWith it will show current inventory as of now.
Manual updates to Unavailable inventory
If your store's Unavailable inventory is updated manually via your Shopify store admin, then SyncWith doesn't (currently) notice this. Unavailable inventory is made up of Damaged, Quality control, Safety stock and Other, so manual updates to these are affected by this limitation.
We haven't heard of any users being affected by this limitation.
SyncWith will get back up to date the next time Available inventory is updated. So most of the time even if this did happen likely it wouldn't affect your reports, or if it did it wouldn't affect them for very long because we'd get caught up at a later point.