Manage Odoo Products from Shopify Updates

The workflow begins when a product is updated in Shopify, capturing details about the updated product such as title, variants, price, or inventory changes.

Fetch all products from Odoo's database to ensure alignment of product data with Shopify.

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.

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.

Determines the Odoo product ID by either retrieving it from an existing product or creating a new product if it doesn’t already exist.

Iterates through each variant of the Shopify product, ensuring that all variants are individually processed for syncing or updating in Odoo.

Fetches product attributes from Odoo to match and align with the attributes of the Shopify variant being processed.

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.

Searches Odoo for an existing product using the Shopify variant's SKU to ensure accurate mapping or to prevent duplicate entries.

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.

Confirms that product attributes are available and the product variant already exists in Odoo. Continues with variant updates or additional actions as needed.

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.

Determines that product attributes are missing but an existing product SKU is present. Proceeds to update the product based on the Shopify details.