Odoo Shopify Integration

Shopify is a cloud-based ecommerce platform designed by small and medium sized businesses. E-commerce businesses integrate shopify with Odoo to manage all business operations like customer relationship management, inventory management, order management, invoicing, warehouse management, SKU’s etc. at one place. Odoo Shopify integrations automates & synchronizes ecommerce business operations and reduces employees time by automatically transferring data from shopify to odoo on real time bases. With Odoo Shopify integration you can seamlessly manage your shopify store.

Odoo shopify integration is the must have product for the sellers who are using odoo as their shopify backend.

Odoo Shopify integration offers a single software where you can manage all your business departments such as Sales, Products, Purchases, Accounting, Finance, Vendors, Suppliers etc. Therefor you do not have to login multiple times in different softwares, you can manage your complete business at one place.


Table Of Content

2Shopify Overview/ Dashboard
3Master Data

  • Meta fields
  • Product Tags
  • Collections
  • Shopify Product Variants
  • Shopify Product Templates
  • Customers
  • Fulfillment Services
 4 Operations

  • Products
  • Products Variants
  • Sale Order
 5 Error Log
6 Warehouse/ Locations


To connect odoo with shopify we need to add API Key and Password for Shopify Shop.

odoo shopify integration

Once you add API key and enter password, you will be redirected to above screen. Know you can start by filling the details as shown above in a screenshot.

Shop URL:  At the place of Shop URL, you have to add Shopify shop url.

API Key : At the API section, you have to add an API key to shopify private applications.

Password : Under password section, you have to add the password of your shopify private application.

Import/Export Automatically? :  On checking the import/export automatically box you can import or export data automatically.

Company :  Under company you need to select the company of shopify Application.

Active :  Active/Inactive shopify configuration

Sales Channels: Analytic Account which will be added on Sales orders and Invoices imported through this configuration.

Default Warehouse :  Default warehouse will be the one which will be added to Sales Orders.

Default Payment Journal :  You can set a default payment journal in default payment journal.

Default Tax Account :  Here you have to set a default Tax Account which will be added on taxes created throughout shopify.

Unearned Revenue Account: Account which will be used on invoice when there is advance payment.

Default Customer: Here you must set a default customer which will be used when there is no customer on shopify.

Credit Note Journal: You can set a credit note journal.

Auto Fill Services: Select Custom fulfillment services for which delivery orders should be processed automatically.

After filling up all the required fields. Click on the “Check Connection” button.  If all the credentials of shopify is valid it will go to “Success” State and you will find two new tabs , 1) Import from shopify & 2). Export to Shopify. if the credential is not valid it will raise an error of “Unauthorized Access: Invalid API key or Access token ” and goes to “Fail” state. Successful odoo shopify integration will help you to import and export data.

Odoo shopify Integration


Odoo shopify Integration


Odoo shopify Integration

Import Functionalities:

Import Customers

Import Refund

Import Orders

Import Locations

Import Fulfillment Services

Import Collections


Export Products

Sync Products


Import Location:

After successfully connecting to shopify first we have to import location from shopify to odoo. To import location click on the Import Location button or if scheduler is activated it will import locations on defined intervals. With odoo shopify integration you can even automate the import process,

Import Collections:

Click on “Import Collections” button and now you will be able to see all the collections of shopify to odoo  under shopify -> Master Data ->  Collections

Here you can Find Collection Name, handle, shopify Id, collection type.

Import Fulfillment Services:

To import Fulfillment Services you need to click on “Get Fulfillment Services”. Once you get fulfillment Services you can see it under Shopify -> Master Data -> Fulfillment Services.

Here You can see Shopify Id, Name , Handle, Shopify Location Id , Service name, Location id, Including Pending stock, Tracking Support, Inventory Management.

Import Customers

To import customers one can add a date to ‘Based on create date’ or ‘Based on update date’ and click ‘GET CUSTOMERS’. Customers will be imported from based on create or update date from selected date to ‘Import Upto date’. Once imported successfully the system will update  ‘Based on create date’ or ‘Based on update date’ with the last imported date so next time we don’t need to update it manually.

Another way is via scheduler we will have a scheduler which will import customers based on both create and update date selected in configuration to current date time. Once imported successfully the scheduler will update  ‘Based on create date’ and ‘Based on update date’ with the last imported date.

Import Sales Order :

In order to import sales orders manually, users need to select ‘Order Create Date’ or ‘Order Update date’ based on selected Order action and click on the “Get orders” button. Once imported successfully the system will update  ‘Order Create Date’ or ‘Order Update date’ with the last imported date.

if the scheduler is activated it will be imported automatically between ‘Order Create Date’ and‘ Order Update date’ to current date time.

Only Sales orders which are either fulfilled/partially fulfilled or paid/partial paid will be imported.

Along with sales order following will be created:

  • Fulfillment will be created with the same location as in shopify.
  • Invoice and payment will be generated if there is payment for a related sales order.
  • If there is no fulfillment advance invoice generated with an unearned revenue account.

Export Products:

There are 3 ways to export products.

  1. Export a particular product.
  2. Export all products.
  3. Export specific list of products.

In order to export products users must have to add Internal Reference no on product level or variant level. Products will be exported if there is a shopify line configured on product and at least one variant with particular store configuration.

Once successfully exported, the system will write product id, variant id and inventory item id from shopify.

Once Exported users will see the ‘UPDATE’ button in the shopify configuration line.

Odoo shopify integration

Odoo shopify integration

Export Product Variant:

From individual product variants you can export product variants. Here you can see shopify product variant ID.

You can export variants to multiple stores based on the configured line.

Odoo Shopify Integration 

Error Log:

Here you can see all the error logs which where generated during export or import of records. It will show description, date, object for which error occurred and shopify configuration. With odoo shopify integration you have an option to fix all the error logs.

Error Log: Here you can see all the error logs there were generated during export or import of records. It will show description, date, object for which error occurred and shopify configuration

Shopify Overview/ Dashboard:

In Dashboard you can see 3 Panel per shopify configuration

Shopify Overview/ Dashboard: In Dashboard you can see 3 Panel per shopify configuration

1. Sale Order :

Here you can find today’s  sales order and total number of Sales orders imported from that Shopify store. If you click on the button it will navigate to Sales Orders.

2. Error Log :

Here you can see today’s shopify Error Log and total number of Error Log.

3. Shopify Customer :

Here you can find today’s Customer and the total number of customers imported from that shopify store.

 Sales order with multi-warehouse:

Create a quotation with selected customer and products.

To fulfill different products from different warehouses you can select a warehouse on sale order line. In order to select the warehouse click on the button highlighted in below screenshot. When you click on that button it opens a pop up which lists the warehouses.

Odoo shopify integrtion

In lines you have to add pick qty against the warehouse name. Once you save it and click on Generate Delivery it will generate pickings based on selected warehouses with selected product quantities.

Odoo shopify integration

If you need to change it you can cancel picking before it has been delivered, System will allow you to select warehouse and quantity again.

Bista Solutions is an ERP consulting company that helps you choose and implement the right ERP for your business. Reach out to book a demo.