How Bookkeep Changes Shopify Inventory Quantities
Bookkeep changes two Shopify quantities, incoming and available, and only through purchase orders.
Bookkeep's adjustments to Shopify inventory quantities follow the recommended pattern to never put a count outright, but instead, add or subtract from existing stock. every adjustment carries a reason and links back to the originating purchase order or receiving record, so you can see exactly what Bookkeep did in Shopify's adjustment history.
- Incoming is stock you are expecting. Shopify shows it as Incoming on the product's inventory page. It is not sellable until it is received, at which point it becomes
available. - Available is stock you can sell right now.
Note: other inventory concepts like reserved are not currently used but might be in the future.
The lifecycle at a glance
| What you do | Incoming | Available | Reason shown in Shopify |
|---|---|---|---|
| Create or edit a draft PO | |||
| Mark as ordered | + ordered qty | Movement created | |
| Receive units you ordered | − received | + received | Received |
| Receive more than ordered | + overage | Received | |
| Receive an item not on the PO | + received | Received | |
| Reject units on a receipt | − rejected | Movement canceled | |
| Void a receipt | reverses the receipt exactly | reverses the receipt exactly | Correction, Movement created |
| Cost correction | |||
| Cancel a PO | − ordered qty | Movement canceled | |
| Revert to draft | − unreceived qty | Movement canceled | |
| Delete or archive a PO | |||
| Duplicate a PO | |||
| Import from Stocky | |||
| Bill to QuickBooks |
Blank cells in the table mean no change
Pushing Updates to Shopify
Saving a receipt records your counts immediately, then a background sync makes the Shopify changes. The receipt's own status shows where it is:
| Receipt status | Shopify quantities |
|---|---|
| Pending sync | Unchanged. The sync has not started. |
| Syncing | Changing now. |
| Committed | Done. Incoming and available reflect the receipt. |
| Sync failed | Possibly part done. Click Retry on the receipt. Bookkeep resends only what did not land. |
A receipt cannot start syncing until the PO's incoming sync has finished. If you receive seconds after marking a PO ordered, the receipt waits for the order push first.
**Drafts: **No adjustments to stock. Add lines, change quantities, move lines between locations, delete the whole order...Shopify doesn't know the PO exists.
Marked Ordered: Each line's quantity pushes to Shopify's incoming at that line's location. A line with no location of its own uses the PO's destination location. If one item appears on several lines for the same location, Bookkeep adds them together and sends one change.
The push happens in the background, so you can keep working with your inventory.
** Edits to ordered PO's:** Once ordered, quantities and locations are locked. You can still change costs, notes, dates, tracking, and supplier references, because none of those affect Shopify quantities. To change a quantity, add a line, or move stock to a different location, revert the PO to draft, edit it, and mark it ordered again.
Receiving: Pushes Shopify's available counts up. Technically, Bookkeep supports three receiving modes:
- Units you ordered: Units received up to the quantity still outstanding on the line move from incoming to available in a single step. Incoming drops by the amount, available rises by the same amount, and Shopify records the change with the reason Received and a link to the receipt.
- More than you ordered: You can receive above the ordered quantity. Bookkeep warns you but lets you continue. The extra units go straight into available. Incoming is not reduced for them, because they were never expected, so incoming never drops below zero on Bookkeep's account.
- Items not on the PO: If a shipment includes something you did not order, add it on the receive screen as an unplanned item. Bookkeep adds a line to the PO for it and puts the received units straight into available. Nothing was ever added to incoming for these lines, and you cannot reject units on them.
Rejected units
Rejected units, whether damaged in transit, wrong item, or short, leave incoming and never enter available. Shopify records the change as Movement canceled with a link to the receipt. Rejection is the right tool for goods that arrive in bad shape. Goods that break after they are on the shelf are a Shopify adjustment, covered below.
On any line, received plus rejected cannot exceed the quantity still outstanding. The receive screen blocks the receipt until you fix the line.