Compare published stock updates with order reservations when defining a Bling and WooCommerce integration.
Index
Updating the number displayed in the store is not enough to prevent competing sales of the last item. When integrating Bling and WooCommerce, decide where stock is calculated, when reservations occur and what releases a unit after cancellation or unconfirmed payment.
Published stock and reserved units are different
A flow can periodically send ERP stock to the store and still leave a mismatch window. Another can check availability during ordering but depend on the system response. The proposal should explain which risk each option accepts, accounting for counter sales, other channels and the same product variation.
Before commissioning new code, check whether the existing connector covers your warehouse, variations and reservation policy. Customization is justified by a rule the connector cannot support, rather than a wish to replace an integration that already works. Available operations and permissions must be validated in the current accounts.
Three items to settle the scope
- SKU mapping: check variation, sales unit and warehouse; matching names do not prove that records represent the same item.
- Reservation lifecycle: define pending payment, confirmation, cancellation and returns, including the exact point when stock changes.
- Visible discrepancies: record the latest update and route differences to a review queue instead of adjusting stock without context.
Test competition for the last item
Use a hypothetical scenario with one available unit and two nearly simultaneous orders. Also test payment confirmed after cancellation, product variations and partial returns. The supplier should demonstrate the agreed rule for accepting, blocking or routing an exception. Compare stock before and after in both the ERP and the store, including repeated attempts. A green synchronization button does not prove that the complete lifecycle preserves stock.
Reference for assessing scope
Official Bling developer documentation
Prepare your project with Quantum9
Send Quantum9 a SKU with variations, the channels selling the same stock and your current reservation rule. Discovery can distinguish connector changes, data corrections and necessary custom development.