Availability calculation in Faire
The current Faire/Cin7 integration means the availability figure in Faire can be wrong. Please install the easy fix suggested by Faire.
When Cin7 allocates stock for a Faire order, the "Available" quantity in Cin7 drops. That reduced number is then synced to Faire, but it's being sent to Faire's On Hand endpoint. Faire then subtracts Committed (unfulfilled orders) from On Hand to work out what shows as available to retailers, so the stock for that order gets removed once by Cin7 and again by Faire. This means popular products can show incorrectly as out of stock.
There is an easy solution suggested by Faire Support: the fix is for the Cin7 to Faire sync to switch endpoints. It needs to call:
PATCH /external-api/v2/product-inventory/available/by-product-variant-ids
When Cin7 sends its Available quantity through PATCH /external-api/v2/product-inventory/available/by-product-variant-ids, Faire treats that number as the stock that is actually free to sell. It then adds back the quantity committed to your unfulfilled Faire orders to work out Faire’s On Hand quantity.
Faire’s available-to-sell figure is still On Hand minus Committed. Because Committed was added into On Hand first, the two cancel out, so the stock shown to retailers matches the Available quantity Cin7 sent. Stock for a Faire order is therefore only deducted once, by Cin7, and not a second time by Faire.
For example, suppose Cin7 shows 10 units on hand and 4 are allocated to unfulfilled Faire orders, so Cin7 Available is 6. Cin7 sends 6 as available_quantity. Faire sets On Hand to 10 (6 + 4 committed), and the available-to-sell figure in Faire is 10 - 4 = 6.
The Committed deduction in Faire stays in place, so Faire retailers still can’t order stock that has already been promised to someone else. The change only affects which field Cin7 sends (available_quantity instead of on_hand_quantity), which is why it needs to be made on the Cin7 side.
Comments
0 comments
Please sign in to leave a comment.