Sync Zettle Purchases with Odoo Stock in Real Time 🛒📦

CRM and Contacts

eCommerce and Inventory

Adam Browder

September 3, 2025

Retail teams often struggle to keep in-store and online inventory aligned. A t-shirt sold at the counter might still appear in stock on your website, creating the risk of overselling. With Workload, you can solve this problem by syncing Zettle Purchases with Odoo stock in real time.

Each new purchase in Zettle sends product details like the name and ID into Odoo. Workload matches the product and subtracts the right quantity, so your stock levels stay accurate across systems without lifting a finger.

The benefits are clear: faster updates, fewer mistakes, and peace of mind knowing your inventory is always correct. This no-code automation saves time while helping your team deliver a smoother experience for both in-store and online customers.

🧩 Essentials

Before you build, here’s what you’ll need:

⭐ Zettle – Capture in-store purchase data as soon as a transaction happens.

✅ Odoo – Manage product inventory and keep stock levels up to date.

🚀 Workload – Create your automation without writing any code.

Workload makes connecting these tools seamless. Just sign in and grant access when prompted—no developer setup or configuration needed.

🎨 Make It Yours

🎯 Adjust by Purchase Quantity
Reduce Odoo stock by the exact number of items sold in each Zettle purchase.

🔍 Match Products by SKU
Use SKU or barcode instead of product name for more accurate stock updates.

📦 Handle Product Variants Separately
Update sizes or colors individually, so “Blue T-Shirt – Medium” reduces without affecting other variants.

🛑 Branch for Unmatched Products
Stop the automation and send an alert if a purchased product isn’t found in Odoo.

⚙️ How to Sync Zettle Purchases with Odoo Stock

Every app expects data in a specific format—whether it’s how dates are written, how names are separated, or how fields are labeled. You can use our in-house tool AI Wizard by Workload to clean up or adjust data between steps. If your trigger already sends clean data, you may not need formatting at all.

Step 1: Create a New Sync Zettle Purchases with Odoo Stock Automation

In the Workload dashboard, click Create Workflow.

Click the Create Workflow button in the Workload dashboard to start building your automation.

Give your automation a title, such as “Purchase in Zettle to Adjust quantity in Odoo“.

Enter a workflow name such as “Zettle Purchases with Odoo Stock Update” in the title field.

Step 2: Set Up the Trigger (PayPal Zettle)

Click inside the Trigger box and choose the app PayPal Zettle.

Search for and select PayPal Zettle as the trigger app.

Select the event New Purchase and click Continue.

Choose New Purchase as the trigger event to start the Zettle Purchases with Odoo automation.

Click Sign in to connect your Zettle account if you haven’t already. For help, follow our step-by-step guide on how to connect Zettle to Workload. Once connected, click Continue.

Sign in to connect your Zettle account to Workload.

Test the trigger to pull in a recent purchase. Confirm product details, especially the product name, are visible, then click Continue.

Test the Zettle trigger to pull in recent purchase data for the Zettle Purchases with Odoo automation.

Step 3: Add a List Products Step (Odoo ERP Self-Hosted)

In the action step, choose the app Odoo ERP Self-Hosted.

Add an action step and select Odoo ERP Self-Hosted as the next app.

Select the event List Products and click Continue.

Choose List Products as the action event in Odoo.

Sign in to your Odoo account if you haven’t already. For help, follow our step-by-step guide on how to connect Odoo to Workload. Once connected, click Continue.

Connect your Odoo account and select the correct database to continue the Zettle Purchases with Odoo automation.

Select your database and then click Continue.

Choose an Odoo database for product lookup.

Test the action to confirm your Odoo product list is returned, then click Continue.

Successful test showing products listed from Odoo.

Step 4: Extract the Product Name (AI Wizard by Workload)

Add another step by clicking the + icon and then choose AI Wizard by Workload (fka AI Formatter) from the TOOLS menu.

Add an AI Formatter step to prepare data for Zettle Purchases with Odoo.

Select Format Data as the event and click Continue.

Select the “Format Data” event in AI Formatter.

For Input Data, select the “products” array header from the Zettle trigger. Then, enter a short prompt to return only the product name as a clean response and click Continue.

Configure AI Formatter to extract the product name from Zettle Purchases with Odoo.

Test the action to confirm the name matches your Odoo product list then click Continue.

Successful AI Formatter test returning the product name.

Step 5: Search the Product List (Odoo ERP Self-Hosted)

Add a step and choose Array Functions → Search Array Items from the TOOLS menu.

Add an Array Functions step to the automation.

In the event field, click Search Array Items, then click Continue.

Select “Search Array Items” in Array Functions.

Configure the action fields by setting them to the following:

Source array: Products (from Odoo “List Products” step)
Search Key: Type “Name”
Search Value: Product Name (from AI Wizard step)

Once you have finished mapping the fields, click Continue.

Map data fields to match products for Zettle Purchases with Odoo.

Hit Test action and confirm that the response finds the matching product and returns the product ID, then click Continue.

Successful Array Functions response showing product details from Odoo.

Step 6: Adjust the Stock Quantity (Odoo ERP Self-Hosted)

Add a final action step and choose the app Odoo ERP Self-Hosted.

Add an Odoo ERP Self Hosted step to the workflow.

Select the event Adjust Stock Quantity and click Continue.

Select “Adjust Stock Quantity” event in Odoo for Zettle Purchases with Odoo.

Sign in to your Odoo account if you haven’t already. For help, follow our step-by-step guide on how to connect Odoo to Workload. Once connected, click Continue.

Connect your Odoo ERP Self Hosted account to Workload.

Configure the action fields by setting them to the following:

Database: Select your Odoo database
Product: Click Custom and map the product ID from the Array Search step (do not select a static product)
Quantity: Enter -1 to subtract one unit whenever a purchase is made

Once you have mapped the fields, click Continue.

Map fields by selecting the Odoo database, linking the product ID, and setting quantity to -1 for Zettle Purchases with Odoo.

Test the action to confirm the Odoo stock decreases correctly.

Successful test showing stock quantity reduced in Odoo.

Step 7: Activate the Sync Zettle Purchases with Odoo Stock Automation

Review all steps and confirm each has a green light. Then click the toggle at the top to turn your automation On.

Activate the automation so every new Zettle purchase updates Odoo stock automatically.

Make a test purchase in Zettle and check that Odoo updates the stock immediately.

🚀 Start Building this Automation

📦 Making Zettle Purchases with Odoo Part of a Complete Inventory System

Syncing Zettle Purchases with Odoo is just the start. Many retailers use this as the base for a complete inventory management system:

📊 Log Purchases in Sheets
Send each Zettle sale to Google Sheets for a full purchase history alongside your Odoo stock updates.

📣 Notify Teams in Slack
Alert your sales or operations team in Slack whenever a product’s stock is adjusted in Odoo.

📦 Auto-Reorder from Low Stock
Trigger a purchase order in Odoo or send an email to suppliers when inventory falls below your set threshold.

🛍️ Sync to Your Online Store
Push updated stock levels from Odoo into Shopify, WooCommerce, or another eCommerce platform to keep storefronts aligned.