// Template · eCommerce

Shopify Products → Odoo

Syncs products from Shopify to Odoo automatically. Reads product data from the Shopify API, drops irrelevant fields, computes active and published status, and upserts into Odoo's product catalogue using the Shopify product ID as the unique key — so your eCommerce catalogue and ERP stay in sync.

Uses

Shopify Input

Odoo Upsert

eCommerce ERP Sync 4 transforms Apache Hop

Get access

Apache Hop pipeline (.hpl)
Available to Putki subscribers

Pipeline

Putki

read-shopify-products

ShopifyInput

select-fields

SelectValues

transform-fields

ScriptValueMod

select-odoo-fields

SelectValues

Putki

insert-odoo-products

OdooUpsert

How it works

Reads product data from the Shopify API, drops irrelevant fields, computes active and published status from Shopify's status flags, and upserts the results into Odoo's product catalogue — using the Shopify product ID as the unique key so existing products are updated, not duplicated.

Read products from Shopify

The Shopify Input plugin connects to your Shopify store and pulls all product records — title, handle, status, published scope, vendor, product type, tags, and timestamps.

Select and transform fields

Irrelevant fields are dropped. Active and published status are computed from Shopify's status and published_scope fields into boolean values Odoo expects.

Upsert into Odoo

The Odoo Upsert plugin writes products into product.template using the Shopify product ID as the unique key. Existing products are updated; new ones are created.

What you need

Putki subscription

Access to the Shopify Input and Odoo Upsert plugins, both included in all Putki tiers.

Shopify API credentials

A Shopify Private App token with read access to products.

Odoo API access

An Odoo user with write access to product.template, plus your database URL and API key.