Shopify And Odoo Integration - ajay3003/doc GitHub Wiki

Integrating Odoo Inventory with Shopify

Step 1: Choose an Integration Method

1️⃣ Use Odoo's Built-in Shopify Connector (Best for Simplicity)

  • Available in Odoo Enterprise (not in the free Community version).
  • Automatically syncs products, orders, and inventory.
  • Steps:
    1. Go to: Apps > Shopify Connector → Install it.
    2. Connect your Shopify store with Odoo using your Shopify API key.

2️⃣ Use a Third-Party Connector (Best for Odoo Community & Flexibility)

  • For Odoo Community Edition (Free), you’ll need an external app.
  • Recommended apps:
    • "Shopify Odoo Connector by Emipro" (Odoo App Store)
    • "Shopify Odoo Connector by Webkul" (Webkul Store)
  • These apps sync orders, stock, and products between Odoo & Shopify.

3️⃣ Custom API Integration (For Full Control)

  • If you need a fully custom setup, you can use Shopify's REST API to push/pull data from Odoo.
  • Requires Odoo API & Python scripting (Odoo runs on Python).
  • Best for businesses with custom order processes.

Step 2: Set Up Odoo & Shopify Connection

If Using Odoo's Shopify Connector (Enterprise Only)

  1. Go to Shopify Developer Dashboard → Create a private app.
  2. Copy your Shopify API Key & Password.
  3. In Odoo, go to Shopify Connector → Add Shopify Store URL & API Keys.
  4. Enable automatic sync for products, orders, and stock.

If Using a Third-Party Connector (Odoo Community)

  1. Install the connector from Odoo App Store.
  2. Follow the setup guide (Emipro/Webkul apps have wizards to link Shopify).
  3. Set up sync frequency for orders & stock updates.

Step 3: Sync Products & Inventory

  • Import Shopify Products → Odoo will pull your existing products.
  • Enable Stock Synchronization → Adjust inventory automatically when sales happen.
  • Sync Orders → Orders from Shopify will appear in Odoo's Sales Module.

Step 4: Automate Fulfillment & Reporting

  • Fulfill orders in Odoo → Shopify updates automatically.
  • Track inventory in real-time in Odoo to avoid overselling.
  • Set up reordering rules to restock dumbbells automatically.

Shopify API & Odoo API Setup

Step 1: Get Shopify API Credentials

  1. Log in to Shopify Admin.
  2. Go to Settings → Apps and sales channels.
  3. Click Develop apps → Create an App.
  4. Enter a name (e.g., "Odoo Integration").
  5. Enable API Access.
  6. Grant Permissions:
    • read_orders, write_orders
    • read_inventory, write_inventory
    • read_products, write_products
  7. Click Save and then Install App.
  8. Copy your API Key, Password (Admin API Access Token), and Store URL.

Step 2: Enable Odoo API Access

  1. Open Odoo and go to Settings → Users & Companies → Users.
  2. Select your user and enable API access.
  3. Install the XML-RPC module (if not already installed).
  4. Set up access to the Odoo API for your custom integration.

Additional Notes:

  • For Custom API Integration: Use the XML-RPC method to integrate Odoo with custom business processes.
  • For Third-Party Apps: Configure sync frequency to update stock and orders automatically based on your business needs.
  • Automation: Consider using cron jobs or task schedulers to automate the sync and reporting process.