Inventory sync between POS and WooCommerce (concepts)
Short answer: Treat inventory as a system of record problem—decide whether POS or ecommerce owns stock truth, then sync on a schedule you can afford.
Overselling during a Saturday rush hurts NZ shops that promised click-and-collect availability.
Concepts
- Near-real-time APIs vs nightly CSV—cost and complexity differ.
- SKU discipline—matching variants beats fuzzy titles.
Failure modes
Duplicate SKUs, manual stock edits bypassing sync, and cancelled web orders not returning stock.
Testing
Simulate concurrent sales; verify negative stock rules and backorder messaging.
Frequently asked questions
Which system should be master?
Often POS for physical-first retailers—ecommerce pulls or pushes depending on integration.
Is manual sync viable?
Only at tiny scale—plan automation before holiday peaks.