How it works

Follow these 14 simple steps to automate this task automatically.

Shopify logo icon

A Shopify product is updated
The workflow begins when a product is updated in Shopify, capturing details about the updated product such as title, variants, price, or inventory changes.
Time to complete: 1 minute

Retrieve Odoo products
Fetch all products from Odoo's database to ensure alignment of product data with Shopify.
Time to complete: 1 minute

Skip product creation
Check if the product from Shopify already exists in Odoo. If a match is found, it skips the product creation step to avoid duplicates and ensures data consistency.
Time to complete: 1 minute

Create product template
Creates a product template in Odoo to serve as a base for managing variants, ensuring the product structure aligns with Shopify’s updated product details.
Time to complete: 1 minute

Retrieve or create Odoo product ID
Determines the Odoo product ID by either retrieving it from an existing product or creating a new product if it doesn’t already exist.
Time to complete: 1 minute

Loop over Shopify variants
Iterates through each variant of the Shopify product, ensuring that all variants are individually processed for syncing or updating in Odoo.
Time to complete: 1 minute

Retrieve product attributes
Fetches product attributes from Odoo to match and align with the attributes of the Shopify variant being processed.
Time to complete: 1 minute

Search for existing variant by SKU
Looks up an existing product variant in Odoo using the SKU from the Shopify variant to determine if it needs to be updated or created.
Time to complete: 1 minute

Search for existing product by SKU
Searches Odoo for an existing product using the Shopify variant's SKU to ensure accurate mapping or to prevent duplicate entries.
Time to complete: 1 minute

Path #1: Product attributes found, no existing variant
Determines if product attributes are available but no existing product variant is found in Odoo. Proceeds to create a new product variant under these conditions.
Time to complete: 1 minute

Path #2: Product attributes found, existing variant identified
Confirms that product attributes are available and the product variant already exists in Odoo. Continues with variant updates or additional actions as needed.
Time to complete: 1 minute

Path #3: No product attributes, no existing SKU
Identifies cases where neither product attributes nor an existing SKU are found. Proceeds to handle the product as a standalone entry or logs it for review.
Time to complete: 1 minute

Path #4: No product attributes, existing SKU found
Determines that product attributes are missing but an existing product SKU is present.
Time to complete: 1 minute
odoo logo icon

Update a product by ID
Proceeds to update the product based on the Shopify details.
Time to complete: 1 minute

Make it your own

Customize this workflow even further:

Set custom delays
Schedule actions to trigger after a set time period, such as sending follow-up emails 3 days after an event.
Chain multiple actions
Connect several steps together in one workflow, like tagging data, updating records, and notifying your team simultaneously.
Store data in tables
Save order details, customer preferences, or custom metrics in your own database for reference and reporting.
Deploy AI agents for smart decisions
Let AI agents evaluate complex scenarios and choose the right action path based on your defined rules.

Frequently asked questions

What is a template?
Templates are pre-made workflows by our team of experts. Instead of building a workflow from scratch, these have all the steps needed to complete the task.
Can I personalize a template?
Yes! Every step can be customized to meet your exact requirements. Additionally, you can even add more steps and make it more sophisticated.
Are templates free?
Yes! Our entire library containing hundreds of templates are free to use and customize to your exact needs.

Related templates you'll love

Recommended workflows that pair well with this template

Ready to automate this task automatically?

Join thousands who've automated their work and saved an average of 3.5 hours every week.

Use this template — It's free
7-day free trial • 14 min setup • Cancel anytime