User Guide for Odoo Shopify Connector

Odoo Shopify Connector bridges the gap between your Shopify store and Odoo, enabling smooth data synchronization across both platforms. 

The tool should help manage the Shopify operation efficiently with Odoo. To solve this, we have introduced our Connector.

This module helps sync products, orders, and customer data between Odoo and Shopify.

That makes inventory tracking easier and improves overall operations.

Additionally, you can explore our Odoo 19 migration services to understand what the latest release adds.

1. Imports categories, products, orders, and customers from Shopify to Odoo.
   
2. It allows you to export categories and product templates from Odoo to Shopify.
   
3. This module syncs product quantities/stock from Odoo to Shopify in real time.
   
4. This module updates sale order statuses, including cancel status and shipment status, in real time.
   
5. Odoo Shopify Connector allows setting regular intervals for automatic data (order, product, customer, category) import using Cron.
   
6. It also provides an option to avoid product duplication during imports.
   
7. With this module, you can import data with various filters, such as all, ID, Date updated after and Date created after.
   
8. Track import history in the synchronization history tab.
9. Supports Shopify GraphQL API for faster synchronization, reduced API calls, efficient large-scale data handling, and improved integration performance.

Odoo Shopify Connector works in conjunction with the following module:

• Odoo Multi channel sale

You must install this module first for Odoo Shopify Connector to work.

For Odoo online(SAAS) users, you first need to migrate to Odoo.sh platform before installing this connector.

This is because Odoo restricts third-party software installations on Odoo online(SAAS).

1. Once you purchase the App from the Webkul store, you will receive the link to download the zip file of the module.
2. Extract the file on your system after the download finishes. As a result, you will be able to see a folder named- ‘shopify_odoo_bridge’
3. Copy and paste this folder inside your Odoo Add-Ons path.
4. Now, open the Odoo App and click on the Settings menu. Here, click on Activate the Developer Mode.
5. Then, open the Apps menu and click on ‘Update Modules List.’
6. In the search bar, remove all the filters and search ‘shopify_odoo_bridge
7. You will be able to see the module in the search results. Click on ‘activate’ to install it.

Configuration at the Shopify End

Step 1: You need to create an app on your Shopify

Reference doc: Create apps using the Shopify Dev Dashboard

Step 2: Place the Redirect URL in the Shopify app

Redirect URL – {ODOO-URL}/shopify_odoo_bridge/redirect

Your Redirect URL -Use the URL visible at the Odoo side instance creation.

Step 3: Give the following permissions:

read_assigned_fulfillment_orders,write_assigned_fulfillment_orders,read_channels,read_companies,read_customers,write_customers,read_price_rules,write_price_rules,read_discounts,

write_discounts,write_draft_orders,read_draft_orders,read_files,write_files,read_fulfillments,

write_fulfillments,read_gift_card_transactions,write_gift_card_transactions,read_gift_cards,write_gift_cards,write_inventory,

read_inventory,write_inventory_shipments,read_inventory_shipments,write_inventory_shipments_received_items,

read_inventory_shipments_received_items, write_inventory_transfers, read_inventory_transfers,read_locales,write_locales,write_locations,read_locations,

read_merchant_managed_fulfillment_orders,write_merchant_managed_fulfillment_orders,read_metaobject_definitions,write_metaobject_definitions,

read_metaobjects,write_metaobjects,write_order_edits,read_order_edits,read_orders,write_orders,read_product_feeds,

write_product_feeds,read_product_listings,write_product_listings,read_products,write_products,read_purchase_options,write_purchase_options,read_returns,write_returns,read_shipping,write_shipping,

read_third_party_fulfillment_orders,write_third_party_fulfillment_orders,read_translations,write_translations

Note: Remove the spaces while adding this in the scopes section

Step 4: Fill in the info below in their specified field:

app_url: {ODOO-URL} ==> ODOO DEMO URL

embedded: false

Use legacy install flow: false

Configuration at the Odoo End

1- After the installation, log in to your Odoo account. Navigate to the multi-channel app and click the connect button.

2-Add the channel and select the channel type as Multichannel Shopify.

Once you configure the channel type, the Multichannel Shopify channel configuration setting will be enabled.

3. Now, save the changes and then click on the ‘Test Connection‘ button

4. Go to the “Basic Configuration” tab and configure the Shopify connection with Odoo Shopify Connector

Channel basic configuration: The basic configuration of the channel includes the following settings:

Auto-evaluate: When you enable auto-evaluate, it will evaluate the feed of the imported data automatically.

Company: Select the default company for the imported data from Shopify to Odoo.

API Record Limit: In the API record limit, you can set the limit of data that will sync between Odoo and Shopify.

Channel time zone: Select the timezone to maintain the time zone in order with the channel.

Advanced configuration: Under the advanced configuration for Odoo Multichannel Sale, you can configure color, color index, blog URL, and store URL.

Channel Sales Order: The Channel Sales Order includes the following settings:

Payment Term: Configure the Payment terms for the payment of sale orders imported from Shopify to Odoo.

Sales Team: Configure the sales team for sales orders imported from Shopify to Odoo.

Salesperson: Configure the salesperson for sales orders imported from Shopify to Odoo.

Campaign: Configure the UTM Campaign for sales orders imported from Shopify to Odoo.

Medium: Configure the ordered medium for sale orders imported from Shopify to Odoo.

Source: Configure the order Source for the sale order imported from Shopify to Odoo.

Tax Type: Configure the Tax Type used in channel order. You can select the tax type as tax type tax included or tax excluded. 

E-Commerce Order Reference Sync: If enabled order will created with the ecomm sequence at Odoo end.

Discount Product: Configure the service product for the Service Product for Order Discount on the imported sale order.

Shipping Product: Configure the service product for the Service Product for Shipping product for the imported sale order.

With this setting, you can enable the real-time sync of the order status from Odoo to Shopify.

You can configure the real-time sync of the cancel and shipment status from Odoo to Shopify.

Default Settings

Category: At the ecom end user can apply multiple categories, but at Odoo end, only a single category is applied.

Set the default category in which imported orders will be stored

Price list: This price list stores the Original price of the product exported from ecom to Odoo.

Language: the set language in the language option will be applied to objects synced from ecom to Odoo.

Channel Category: While exporting the product from Odoo to Shopify, the product will be stored in the configured category.

SKU Pattern: The value configured here will be used as an SKU in case the SKU is not present.

Product avoid duplicity: If enabled, Product duplicity will be avoided based on the Internal Reference (SKU) along with the Barcode during import.

Stock Settings

Auto Stock: If enabled, stock will be synced from Odoo to Shopify in real time whenever there is a stock movement. 

Stock Action: Product Quantity will sync according to the selected option, Quantity on hand/forecast Field.

You can either select the sync of on-hand quantity or forecasted quantity.

Warehouse: It is the default warehouse that is used for the import of products from Shopify to Odoo.

Location: It is the default location where your stock will be stored when imported from Shopify to Odoo.

We have provided cron features that will import data from Shopify to Odoo. Data will be Imported Based on the Created/Updated after a defined date.

Cron Configuration

To configure the cron, navigate to Miscellaneous >> Global configuration >> Select the cron you want to configure.

Here, you will find the order product customer category and feed cron.

NOTE: Data will be imported based on the created/updated or defined date.

Model: It is the module on which the server acts.

Scheduler User: This user will be responsible for running the scheduler.

Execute Every: Here, you can configure the time interval for the execution of the cron.

Active: Enable if you want to enable the respective cron.

Next Execution Date: The next Planned execution date for this job.

Global Settings

Next, go to the ‘multi-channel> miscellaneous> global configuration.’

From here, you can configure the import scheduler and enable ‘Avoid Duplicity (Default Code)’ to avoid double imports or exports of unchanged data.

Synchronization History

In the ‘Synchronization History’ option, you can view the entire history of every sync. 

On clicking anyone, you can see all the details of the history sync in Odoo Shopify Connector

Whenever any data, such as orders, products, or customers, is received from your Shopify platform into Odoo, it first appears in the “Feeds” section.

The Feeds section acts as an area where our connector evaluates the incoming data to ensure that all necessary details are correct and complete.

If the feed data is evaluated successfully, it automatically moves into odoo through evaluation.

That applies when auto-evaluation is enabled, and otherwise the feed can be manually approved.

If the data contains errors, it will be marked as an error feed.

That happens when the product does not exist in Odoo or the customer information is incomplete.

If a record, such as an order or product, doesn’t appear in Odoo after the import, you can check the Feeds section to see the exact error.

This helps you understand why the data wasn’t imported.

In many cases, you can fix the issue yourself, such as mapping a missing product or customer.

You can then re-evaluate the feed without needing developer assistance.

You can view the mapping of all the imported and exported data, such as products, categories, orders, customers, and shipping methods, in Odoo.

On opening any page from the mapping menu, you can view the list view of every mapping. 

Mapping>>open the component mapping you want to see (category) 

On clicking any, you can view the details of that particular mapping with Odoo Shopify Connector

You can import data from the connection’s operation tab. You can also use the import button on the dynamic dashboard.

Note: Order of importing data: categories >> product >> order.

To import the order, your product must be imported, and similarly, to import the product, your categories should be imported from Shopify to Odoo.  

Moreover, you can only import the following data from Shopify to Odoo.

Products– You can import products using filters like all, ID, and Date updated after.

Order– Import using filters like all, ID, Date updated after and Date created after.

Category– Import categories using filters like all, ID, and date updated after.

Customer– Import them using the filters like all, ID, Date updated after and Date created after.

Shipping method Import: Import of shipping method is not available.

You can import all of this data using the filters mentioned above.

Moreover, for data import, you must select the ‘channel instance, object, and filter’ in the import wizard.

Navigate to the Odoo Shopify Connector dashboard and select the export button.

For exporting, choose the ‘channel ID, operation (Export/Update), and object’ in the Export wizard.

Our module provides you with two objects for export/update:

1. You can export/update the category from Odoo to Shopify. 

2. You can export/update the product template from Odoo to Shopify. It includes the product information. 

• Supports Shopify GraphQL API for faster and more efficient integration with Odoo.
• Fetches only required data fields like SKU, stock, and price for better performance.
• Reduces API calls by combining multiple requests into a single query.
• Handles large Shopify store data efficiently with improved synchronization speed.
• Ensures compatibility with Shopify’s latest API standards and long-term support.
• Enables faster syncing of products, customers, and orders with reduced server load.

Hope you find the guide helpful, and please feel free to share your feedback in the comments below.

If you still have any issues/queries, please create a ticket at the UV Desk.

I hope this helps. In case of any further queries, contact us at our support mail:support@webkul.com

Thanks for paying attention!!