Odoo for Woocommerce

The question to answer before connecting anything: who is in charge

It is the decision that makes an integration between shop and management system work for years or turn into a daily problem, and hardly anybody takes it consciously.

When WooCommerce and Odoo are connected, both know how many units of an item exist. And both can change that number: the shop when somebody buys, the management system when a delivery arrives or somebody corrects an inventory count.

If you have not decided which of the two has the last word, sooner or later they tread on each other. The classic result is the worst of all: stock that rises on its own, duplicated orders and an inventory nobody trusts any more, so somebody ends up checking the warehouse by hand and the integration stops being any use.

The right answer is almost always the same: the management system rules stock, prices and product data; the shop rules orders. Each piece of data with one owner and one direction of synchronisation.

What the integration solves

• Products and prices flowing down from the management system to the shop, without entering them twice.
• Synchronised stock, so you do not sell what is no longer there.
• Orders flowing up to Odoo, where they get invoiced, picked and accounted for.
• Unified customers across both systems.

Odoo, formerly known as Open ERP, is an open source management and customer relationship solution used worldwide.

When a management system is needed and when it is surplus

Worth being honest about this because an integration like it carries setup and maintenance costs that do not pay off in every shop.

It is surplus if you sell from a small warehouse, invoice with a plugin and your accountant asks for a file once a month. WooCommerce does all of that alone and putting a management system in between adds a piece that can break.

It is needed when things appear that WooCommerce cannot do: buying from suppliers with purchase orders and receipts, holding stock in several places, manufacturing or assembling products from components, running genuine accounting, or selling through several channels at once and needing a single inventory behind them.

The clear signal is this: when your shop stops being where the business's information lives and becomes one of the places it comes out of, the moment has arrived.

How to build it without breaking the shop

One. Write down on paper which data each system rules. It is the step everybody skips and the one that prevents eighty per cent of the problems.

Two. Start with one direction only, usually products and stock coming down. Once that has been stable for a week, enable the order upload.

Three. Test with a handful of products before synchronising the whole catalogue. A first mass sync misconfigured leaves a mess that takes days to undo.

Four. Have a recent backup before the first full synchronisation. It is not paranoia: that operation touches every product at once.

Requirements

It needs WordPress, WooCommerce and an Odoo instance with its credentials. Worth confirming before buying that the Odoo version you run is supported, because things change between versions.

Alternatives in the catalogue

If your problem is only inventory and you need neither accounting nor purchasing, there are considerably simpler options: ATUM Multi Inventory handles stock across several warehouses inside WooCommerce itself, and Multi Locations Inventory covers the same case.

If what you need is connecting to a system with no plugin of its own, the general tool is WPGetAPI for fetching and sending data, and WP Webhooks for notifying your system when something happens in the shop.

And if you also sell on marketplaces, the inventory has to add up there too: WP-Lister for Amazon, for eBay and Woomelly for Mercado Libre. Once there are three channels, the argument about who rules stock stops being theoretical.

Frequently asked questions

Which system should hold the stock?
The management system, almost always. The shop rules orders. One value, one owner.

Do orders go up to Odoo?
Yes, for invoicing, picking and accounting from there.

Is it worth it in a small shop?
Normally no. WooCommerce alone covers that case well without adding another piece.

Can I synchronise the whole catalogue at once?
Better not the first time. Test with few products and have a recent backup.

Does it work with any Odoo version?
Worth confirming before buying, because things change between versions.

How do I know I need a management system?
When the shop stops being where the information lives and becomes just one of the sales channels.