Odoo Integration: Connect Your Store to Flowcart in Minutes

Bringing your Odoo products, inventory, and orders into Flowcart is fast, simple, and designed for smart automation. 

Once connected, your catalog stays in sync, orders flow smoothly into Odoo, and your team never has to update things manually again.

Here’s how to set it up.

1. Gather Your Odoo Credentials

You’ll need a few details from your Odoo account before connecting:

• Domain URL & Database Name

Find these under My Databases.

• Username

Usually the email address you use to log in.

• API Key

Go to My Profile → Account Security → New API Key to generate one.

• Currency & Time Zone

Make sure these match your business setup—you’ll find them in your Odoo settings.

Once you have everything handy, you’re ready to connect.

2. Connect Odoo to Flowcart

Inside Flowcart:

1. Open Sidebar → Integrations → Odoo → Integrate
   
2. Select the catalog
   
3. Enter your Odoo credentials
   
4. Click Save
   

Then click Sync Products to instantly pull in your products and inventory.

What happens next?
A background sync runs automatically to bring in everything—product details, inventory counts, categories, and variants.

3. Updating Your Integration

Need to modify something later?

• Just update the field
  
• Click Reconnect

No need to redo the whole setup.

4. Tag Your Catalog (Important)

After syncing:

• Tag the catalog as Odoo Catalog
  
• Assign it to the relevant order route so orders flow correctly into your Odoo system
  

This ensures every order from Flowcart reaches the right workflow in Odoo.

How Product Sync Works (Behind the Scenes)

Flowcart keeps your inventory fresh and reliable—here’s how:

1. Automatic Sync Every 15 Minutes

A cron job checks for product updates every 15 minutes.
No manual refresh needed.

2. Product & Variant Handling

Flowcart fetches:

• All products
  
• Variants
  
• Parent/child product relationships
  

3. Category Mapping

Flowcart fetches category IDs → converts them to names → organizes your catalog correctly.

4. Smart Pagination & Batching

Large catalogs load smoothly without timeout issues.

5. Custom Pricing API Support

If you use custom pricing via another API, Flowcart can plug into that too through the ERP module.

How Order Sync Works

Flowcart ensures every WhatsApp order flows into Odoo accurately and automatically.

1. Customer Handling

Odoo requires a Partner ID for each customer.

• If Flowcart finds one → great, it uses it
  
• If not → Flowcart creates the customer automatically in Odoo
  

Flowcart also:

• Maps country names to Odoo country IDs
  
• Creates customers with full details
  
• Saves the Partner ID for future orders
  

2. Order Posting

Once a Partner ID exists:

• Flowcart posts the order into Odoo
  
• Stores the ERP ORDER ID for tracking
  
• Only updates the delivery address if needed
  

Everything stays clean, synced, and organized.

You’re All Set!

Once connected, your Odoo + Flowcart setup runs on autopilot:

• Products sync automatically
  
• Orders push into Odoo in real-time
  
• Inventory stays up to date
  
• No manual data entry ever again
  

If you need help with your setup, our support team is always here to assist.