Home
ERP

How to integrate Odoo with Shopify or PrestaShop

Óliver Vega Lora · CTO at Webimpacto
Published: · 6 min read

What gets synced

A typical integration between Odoo and a Shopify or PrestaShop shop moves this data.

  • Products, variants and prices, from Odoo to the shop or the other way round, depending on who manages them.
  • Available stock, from Odoo to the shop.
  • Orders and customers, from the shop to Odoo.
  • Invoices, issued in Odoo from the order.
  • Shipping status and tracking number, from Odoo to the shop.

Which system is the master for each data point

Each piece of data must have a single source. If the price is sometimes changed in Odoo and sometimes in the shop, sooner or later there will be two different prices.

Usually Odoo is the master for stock, costs and invoices, and the shop is the master for content, photos and product copy.

Existing connector or custom integration

Ready-made connectors exist between Odoo and the most widely used ecommerce platforms. They work well when the business is standard.

When there are several warehouses, bundles, customer-specific pricing, marketplaces or special tax rules, a custom integration using each system's API usually pays off.

Common mistakes

These are the points that cause the most incidents after go-live.

  • Duplicate or mismatched SKUs between the shop and Odoo.
  • Taxes and rounding that don't match between the order and the invoice.
  • Returns and exchanges handled in the shop that never reach Odoo.
  • Payment gateway and marketplace fees not reconciled in the accounts.
  • Stock that only updates every few hours during peak sales periods.

How to test before go-live

Before connecting the live shop, test with every type of order: with a discount, with several products, cash on delivery if you offer it, with a partial return and with international shipping.

Every test order must end with the correct stock, the correct invoice and the payment reconciled.

Frequently asked questions

Can Odoo be connected to Shopify?

Yes. It connects through a connector or a custom integration with the Shopify API, to sync products, stock, orders, customers and invoices.

What about PrestaShop or Adobe Commerce?

Yes, as well. The approach is the same: decide which system is the master for each piece of data and choose between an existing connector or a custom integration.

Is it better to use Odoo's ecommerce instead of Shopify?

It depends. Odoo's ecommerce avoids the integration, but Shopify, PrestaShop or Adobe Commerce usually offer more options for design, marketing and conversion. Many brands keep their shop and connect Odoo behind it.

Want this applied to your business?

We’ll tell you what we would do in your case, no strings attached. A real person from the team replies.

Request a proposal
By
Óliver Vega Lora
CTO at Webimpacto · Webimpacto

Head of technology at Webimpacto. He leads the development teams that build, migrate and maintain shops on Shopify, PrestaShop, Adobe Commerce, VTEX and WooCommerce.