Inventory Reconciliation

Inventory Reconciliations

Reconciliations happen when you have fulfilled an order outside of SKUSavvy, or there is an inventory discrepancy between Shopify and SKUSavvy where there is lower stock on Shopify than in SKUSavvy. By default SKUSavvy will try to make the reconciliation automatically if certain conditions are met. Below we will go through the key things to know about inventory reconciliations. 

How to Find Your Reconciliations

1. Go to your inventory table and sort by bin (descending) and all the reconciliations will show at the top

2. Go to a specific inventory item and click into it to view all reconciliations for that item or you can simply scan the item and tap make adjustment

3. Go to your inventory list, make sure you are on the flat list view, select the icon with an up arrow inside two boxes

To reconcile, simply tap 'Reconciliation Needed' and select the bin to reconcile from which will remove the stock from that bin and settle the reonciliation record.

When Are Reconciliations Made?

SKUSavvy determines when a specific quantity record can be reconciled (reused/merged) instead of creating a new reconciliation record that needs to be manually handled. Here are the conditions that allow automated reconciliation:

Reconciliation Conditions (in order of precedence):

1. Explicit Quantity ID Match

• If an exact match to the quantity is provided for the change, that specific quantity is always used to reconcile

• This is the highest priority condition

2. Serial Number Match

• If a change in quantity for a specific serial number item is specified and a quantity with that exact serial number exists, it's reconciled automatically

• Serial numbers are unique identifiers, so this ensures exact item matching

3. Single Quantity Exists

• If there's only one existing bin location quantity for this variant in the warehouse, it's automatically reconciled

• Assumes all items of this variant are fungible when there's no choice

4. Unallocated Quantity Available

• If any quantity exists that isn't assigned to a bin (binId == null), it's reconciled

• Unallocated quantities ('Assign Location' records) are considered available for consolidation

5. All Quantities in Same Bin

• If all existing quantities are stored in the same bin, the first one is reconciled

• Items in the same location can be logically grouped together

When Automatic Reconciliation Fails

SKUSavvy cannot make a reconciliation when quantities exist in multiple different bins, indicating that:

• Items are physically separated in different locations

• A new quantity record should be created rather than modifying existing ones

• This preserves location-specific tracking