Jewelry can be physically present and still be unavailable for a new sale. Before changing a quantity, ask which number you are looking at: the physical stock at a location, the amount already committed, a hold, or the balance available to sell. A correct count does not make every unit unclaimed.
Reconcile the states with a small example
Shopify's current inventory definitions separate on-hand stock into available, committed, and unavailable quantities. Incoming stock is separate until it is received.
In a hypothetical case, five necklaces are on hand. Four are committed to existing work, and one is unavailable because it is held for review. Available quantity is therefore 5 − 4 − 1 = 0. The physical count of five and the available count of zero can both be correct.
Setting on hand to zero because the screen says “unavailable” would erase real stock from the record. Setting available to five without resolving the existing commitments could expose the same pieces to additional orders. The next step is explanation, not whichever edit makes the screen look familiar.
Trace the reason behind each protected quantity
List the records contributing to the committed total and the reasons behind unavailable units. Use exact variant, location, quantity, event time, and record reference. Check whether an order, draft reservation, transfer, app, or quality hold is involved rather than treating all protected stock as one anonymous bucket.
For each record, ask whether it is still active and whether the physical item is where the record expects it. An outdated hold needs an authorized release; a valid order needs its allocation preserved. If the source record cannot be identified, retain the uncertainty and escalate it instead of inventing a reason.
Shopify's adjustment history helps trace changes across inventory states. Read the affected state and activity, not merely the latest total. A movement between states may change availability without changing how many objects are physically present.
Check the location and timestamp
A total across locations does not prove that the exact variant can be fulfilled from the intended location. Check that variant's fulfillment activation at that location, not merely whether the location itself is active. Shopify can show on-hand stock while Available is a dash because the variant is inactive for fulfillment there. The dash does not establish that the whole location is disabled or that the physical stock is zero.
Compare observations at the same time. A count taken before a pick, a screenshot taken after a reservation, and an export from the previous evening need a transaction bridge before they can be reconciled. Incoming quantities should not be used to fill today's available balance simply because a delivery is expected.
The layered pearl-style statement necklace is a useful unit example: its layers belong to one item. Neither those layers nor the catalog photograph establish a current stock quantity or a free allocation.
Do not force different platforms into one formula
Faire's brand inventory guidance describes its available quantity using on hand minus committed. That is not a reason to omit Shopify's unavailable state when reconciling Shopify. Document which platform, account, location, and synchronization time each number represents.
If an import or integration is involved, identify the record it actually updates. A number changing on one platform is not proof that every connected channel has received the same change. Check the intended destination before offering the stock again.
Treat a negative balance as an investigation trigger
A negative available balance is not a literal negative object on a shelf. Examine the events, quantity basis, commitments, and settings that produced it. Do not turn off tracking or erase an order merely to remove the warning. Route any correction to the person authorized to resolve the underlying record.
The inventory template guide covers the wider stock record. For an exact product availability question, use the wholesale inquiry page; a displayed design is not a supply commitment.