Synchronising inventory: how much stock should your store sell?

An item can be physically present but reserved, damaged or awaiting release. An expected delivery may already be planned without having arrived. Those states should not silently become the same number.

Odoo’s inventory forecast distinguishes quantities on hand, incoming and outgoing. Which value should feed the store remains a business decision. A forecast is not automatically a promise of immediate availability.

First agree whether the store sells only immediately available goods or also accepts preorders. In a simple immediate-availability example, ten physical units minus three reservations not yet deducted and one safety unit would release six units for sale.

This is not a universal formula. If the source value already accounts for reservations, do not subtract the three units again. Record what the source field means. Errors can arise here even when each system processes its values correctly.

We would test at least six events:

• New order: sellable stock changes at the agreed point.
• Cancellation: released reservations are handled correctly.
• Return: goods become sellable only after the required check.
• Second channel: a sale outside the store is included.
• Receipt: actual arrivals remain distinct from expected deliveries.
• Outage: stale data is detected and reconciled after recovery.

Include quantities close to zero. An error among a thousand available units might go unnoticed. The same discrepancy affecting the last item can immediately produce an unfulfillable order.

Faster updates may reduce the period during which information is stale. They do not fix an incorrect calculation or ambiguous product mapping. Two channels may also attempt to sell the same remaining stock almost simultaneously. Agree reservation timing and the treatment of scarce quantities.

For particularly scarce or valuable products, channel allocations or a buffer may be useful. Suitability depends on the range and sales process. The trade-off can be a channel showing less availability while goods remain in stock. Make that decision deliberately rather than allowing the connector to determine it accidentally.

As an Odoo Learning Partner, we favour assessing inventory alongside the related purchasing and sales workflows. Odoo is a natural option for that review. An existing ERP that works well does not need replacing solely for this purpose.

PrestaShop, Shopify, Shopware and other channels should use the same business meaning for quantities, although implementation can differ. For each connection, we check the transferred field and how the store derives visible availability. A blanket promise covering arbitrary connectors would be unjustified.

Assign an owner and agree regular comparison cases, such as scarce products, recently returned items and products with multiple variants. An error message needs a response process: what is checked, which value takes precedence and how is the correction recorded?

Our Odoo consulting would start with those cases. The PrestaShop ERP guide explains data ownership, while connecting Shopify and Odoo covers orders. Together they form a testable process rather than a connection that simply moves numbers between systems.