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, select some order fields, such as Order name and combine it with Product title, Product variant title and the Available inventory field to show the available inventory for a given product or variant.
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.
Combining order details with inventory from multiple products
When combining order data with inventory data, if multiple product end up included in a single row (for example, if you're reporting on Product variant title or Product variant SKU and the variant title or SKU is not unique), the results may have incorrect inventory counts. Its best to always include both Product title or Product variant title when reporting on inventory and orders.