When the same product sells through a store, marketplace, dealer network and physical shop, inventory cannot be four unrelated numbers. Dependable multi-channel stock requires one owning system, consistent product identifiers and clearly defined reservations.
Choose the primary inventory source
An ERP, inventory platform or other central system owns physical stock. Sales channels display derived availability. Two-way editing without a clear rule produces conflicting values.
Standardise SKUs and variants
Every sellable variant needs a unique identifier across channels. Colour and size labels do not need identical wording, but their mapping must be unambiguous. Bundles require rules for how component stock affects availability.
Separate physical stock, reserved stock and availability
A paid but unpicked order reserves a product. Safety stock or units allocated to B2B may reduce online availability. Decide when a reservation is created and when it is released.
Match update frequency to sales volume
A five-minute sync may be enough for a slow-moving product. During a campaign or with scarce stock, that delay can cause overselling. Event-based updates are fast, but a scheduled reconciliation remains valuable.
Make failures visible
The integration should detect unknown SKUs, negative stock and rejected API requests. An error queue, alert and controlled retry allow the problem to be fixed before a customer discovers it.
Monitor discrepancies
Create a view of products whose stock differs between channels or has not synchronised within an expected period. An operational dashboard turns integration health into something the business can monitor.
I build and improve websites, ecommerce, integrations and reporting around practical business needs.
About me · View selected work