Shopify Odoo Connector User Guide

On the landing page of the app, you will find the installation option. To install the app, you need to enter the URL of the Shop where you want to install the app.

After the successful installation of the app, you need to purchase a monthly subscription for this app.

After the successful payment, the app will be listed in the Apps section on the Shopify end.

Upon clicking the app, you will land on the Odoo connector Home page.

You can create multiple Odoo instances and set different configurations and default settings for each Odoo instance. 

You can see your Odoo Instances in the Odoo Instance Listing Section. Navigate to Odoo Connector >> Configuration >> Odoo Instances Listing.

You can add your Odoo Instance in the “Add Odoo Instance” section.

Enter the Instance Name, select your Odoo version, Odoo URL, Port, Odoo Database name, Odoo User name, and Odoo Password. 

Now, click on ‘Add Instance’ to add an Odoo instance.

Once you added the Odoo Instance, navigate to Odoo Instance Listing and activate the Instance.

You will see a green button for connection status as “success” and for status as “states”.

There are two Default settings that you need to configure when you create an instance.

3.1 Instance Default Settings

Open the Instance Default setting page to set the default settings for the instance in the Default settings section.

Select Default Company(For Multi-company in Odoo):

If you have a multi-company in Odoo, then select your default company. All synchronisation will be performed for the selected company.

Kindly note that changing companies is not recommended. 

Select Odoo Warehouse

The warehouse set in this field will be the default warehouse for all the products getting synchronised from Shopify to Odoo.

Select Default Odoo Payment method:

If the Shopify payment method isn’t mapped to the Odoo Payment method, the payment method specified in this field will be used as the default invoice payment in Odoo.

3.2 Product Default Settings

Select Default Odoo Category:

The category set in this field will get assigned as the default category to all the products getting synchronised from Shopify to Odoo.

Sync product as: Select the product synchronisation based on stackable or serviceable.

Tracking of Products: Select the tracking of the product by which you want to track. The default settings will be “No Tracking”.

Product route: As per the installed Odoo module, select the available option to sync the route of products.

Product Invoicing Policy: Choose a product invoicing policy to sync from Shopify to Odoo as Order Quantity or Delivered Quantity.

You can set the different synchronisation settings for Orders, Products, and Customer synchronisation from Shopify to Odoo.

Sync order in Draft State: Use this option to sync orders from Shopify to Odoo as a quotation (in the draft state).

4.1 Order synchronisation

Auto Sync order invoices and Register Payment: Use this option to automatically sync order invoices from Shopify to Odoo and marked as paid.

Auto Sync order invoices without Registering Payment:

Enabling this option will automatically sync order invoices to the Odoo end without being marked as paid.

Auto Sync order shipment: Use this option to sync order Shipment details automatically to the Odoo end.

Automatically Sync New Orders: Use this option to sync newly placed orders at the Shopify end automatically to the Odoo end.

Sync the cost price in the Odoo order sale line: 

This feature will fetch the product’s cost price from Odoo at the time of order synchronisation and send the cost price to the Odoo order line item. 

Sync Shopify Order Note Attributes to Odoo: This feature will sync and update order note attributes from Shopify to Odoo.

Synchronise Shopify Order Tags to Odoo: This feature will sync and update the order tags from Shopify to Odoo.

Apply tax on discount line (if any) for orders:

If you enable this option, then the tax applies if applicable on the discount line; if an order has a discount.

Resync orders automatically after the first order-sync attempt fails:

This option will enable the automatic time-scheduled job and will process same-day orders that have failed to sync on the first attempt.

Map fiscal position and send to Odoo order while syncing: By this option, a fiscal position will get mapped concerning the country and will be added by syncing orders.

Sync Order in draft state with missing line items: Enabling this feature will sync the draft state order with missing line items at the Odoo end.

It will Check to sync Shopify order in draft state at Odoo if not all line items are mapped.

Force sync the Odoo delivery: Sync the order fulfillment to Odoo with completely fulfilled stocks without creating a backorder.

This may lead to negative on-hand quantities of product in case no sufficient quantities exist.

Do you manage the Odoo Taxes Excluded from the price ?

Enabling this config will sync the price of line items of Odoo excluding the Shopify tax.

4.2 For Orders- From Odoo To Shopify

Allow the Order fulfillment from Odoo to Shopify:

Using this open, the scheduler will run once a day for the same orders that have been fulfilled at the Odoo end and then update the order at the Shopify end.

Please note that if you enable this, then the Order fulfillment updation will stop from Shopify to Odoo.

Allow the Order Paid status from Odoo to Shopify:

Using this option, the scheduler will run for every hour orders that have been paid partially or fully at the Odoo end and then update the orders accordingly at the Shopify end.

Please note that if you enable this feature, then the order paid status updation will stop from Shopify to Odoo. 

Download the order invoice from the customer detail page: This feature enables you to download the Odoo order invoice at the User’s ‘account’ page of your store.

After enabling, please add the below line in the file ‘customers/account.liquid’

After line <th scope=”col”>{{ ‘customer.orders.total’ | t }}</th>:
Add <th scope=”col” class=”wk_invoice_show”>Action</th>

After line <td data-label=”{{ ‘customer.orders.total’ | t }}”>{{ order.total_price | money }}</td>:

Add <td data-label=”Invoice” class=”wk_invoice_show”><div class=”wk_invoice” id=”wk_invoice_{{order.id}}”></div></td>

4.3 For POS Order Address

Assign the POS location address to Odoo orders for POS orders without addresses:

This option assigns the POS location address to Odoo orders for POS orders without addresses.

4.4 For Product And Collection Sync

Auto Sync New Products: Use this option to sync newly created products at the Shopify end automatically to the Odoo end.

Auto Update Mapped Products: Use this option to automatically update mapped products from Shopify to Odoo.

You can also select what items you want to send with the Product update like Product Title, Product Weight, Product Image, Product description, etc. 

Auto Sync New Collections: Use this option to sync newly created collections (Categories) automatically from Shopify to Odoo.

Sync Product description as Website description in Odoo:

This option will sync the Product’s description into Website description fields at the Odoo end instead of the sale description field.

Use this feature only, if you are using Odoo Ecommerce.

Sync Shopify Variant price to Odoo: Use this option to Sync the Shopify Variant price to Odoo. 

Please note that to enable this feature, you need to install the Product Variant Extra Price module at the Odoo end.

4.5 For Customer Sync

Auto Sync New Customers: Sync Newly created customers at the Shopify end automatically from Shopify to Odoo.

Sync Customer type:– You can choose whether you want to sync the Customer as a company to the Odoo end or as an individual to the Odoo end.

Sync Address type:– Using this option, you can choose whether you want to create multiple addresses or create a single address for synchronized customers.

Individual Customer Sync:

To sync an individual customer you need to open that customer contact at the Shopify end.

Then click on ‘Synchronize Customer to Odoo’ to sync the respective customer from Shopify to Odoo.

4.6 For Bi-Directional Sync

4.6.1 Allow Bidirectional Inventory Sync on Selected Slots.

A script that will run 6 times a day to update product inventory from Odoo to Shopify.

4.6.2 Allow Bidirectional Inventory Sync on Event action

When using bidirectional inventory synchronisation from Odoo to Shopify with the “On Event Action” approach, it is necessary to configure Automation Rules to receive webhook notifications whenever inventory updates are pushed from Odoo to Shopify.

These webhook notifications help ensure that inventory changes are captured and synced in real time.

From Odoo 18 onward, Odoo provides native webhook support, allowing event-based notifications to be triggered directly from the Odoo system.

Note – This feature works with the ‘base_automation’ module. Make sure it is installed in Odoo.

How to Create an Automation Rule?

To create an automation rule, first enable the “Allow Bidirectional Inventory Sync” option from the Odoo Connector → Configuration → Synchronise Settings section. This option must be enabled to allow bidirectional inventory synchronisation from Odoo to Shopify.

Next, from the “How do you want to sync inventories?” dropdown, select “On Event Action”, and then click “Save” to apply the changes.

Next, go to your Odoo store and install the base_automation module. Once installed, navigate to Settings, scroll down to the Developer Tools section, and click on “Activate the Developer Mode.”

After enabling Developer Mode, the Technical menu option will appear in the header of the store.

From the Technical menu, select the “Automation Rules” option.

On the Automation Rules page, click the “New” button to create a new automation rule.

Now set an explicit name for the automation rule and select the “Quants” model.

After that, you can choose when you want this automation rule to be triggered and complete all the remaining configuration details according to your requirements.

Now, select “Send Webhook Notification” from the Type section.

Now, copy the URL from Shopify → Odoo Connector → Configuration → Synchronise Settings.

And, paste it here.

After that, add all the fields listed below in the Fields section, one by one.

Available Quantity
Counted Quantity
Location
Product
Product Template
Quantity
Reserved Quantity
Warehouse

You can copy these fields one by one, paste them into the Fields section, and then click “Save & Close.”

Once saved, the automation rule will appear on the Automation Rules page as shown below.

Product Mapping involves establishing a connection between products in Shopify and Odoo, ensuring that the two systems recognise and correspond to the same product.

Synchronization means that a product in Shopify is synchronized to Odoo by creating a new product in Odoo, which will be mapped to that Shopify product automatically.

There are three methods to map the Shopify product with the Odoo product.

5.1 Product synchronisation

When you are creating a new product at Shopify and the product is not available at the Odoo end. In this case, the newly added product is synchronized to Odoo.

Navigate to the product click on More “action” and then click to synchronize to Odoo this will synchronize your product.

Auto-Sync of New Product

Please note that If you have enabled the Auto-sync of new products from the configuration.

Then all the newly added products will get automatically synchronized from Shopify to Odoo.

Synchronize Unmapped Product

If you have several products that are unmapped at Shopify then in this case you can synchronize your product to Odoo.

Navigate to Odoo Connector >> Products >> Product Mapping. Then click on “Synchronize Now”. Then you will get a pop-up to choose the range.

Select the range and click yes. The unmapped product within the selected range will be synchronized to Odoo.

5.2 Manual Mapping

When you are creating a new product or products are already available on both ends. In this case, you can map the product via Manual mapping. 

Navigate to Odoo Connector App >> Products >> Product Mapping. Then click on Manual Mapping.

After clicking manual mapping you will see a product manual mapping page. Here you have to select the Shopify product that you want to map with Odoo.

Select Shopify Product and variant, search your Odoo product, and then select your Odoo product with their variant and click to add.

Once you select all the mapping products then click to the add products. The selected product will be mapped.

If your Shopify product does not have variants then the product will be available as product name – Default Title.

In case of any issues with the Manual product mapping, you can check Odoo Connector for Shopify: Manual Mapping user guide.

5.3 CSV Upload

If you have bulk products at both ends and you want to map them then you can use product mapping via CSV upload.

Before uploading the CSV Mapping you first need to make a CSV file for the product in the given CSV format.

Navigate to Odoo Connector App >> Products >> Product Mapping. Then click on the CSV Upload.

After clicking the CSV upload, you need to download the instructions and CSV format, so that you can manually fill your products in the given format in the CSV file.

Once you prepare your CSV file then you can choose the file and click to upload the CSV file, and your product will be mapped.

You can synchronize all collections from Shopify to Odoo with just a single click.

Please note that In case if the Auto-sync of the new Collections is enabled from the configuration.

Then all the newly added collections will get automatically synchronized from Shopify to Odoo.

Synchronize all order details from Shopify to Odoo end with just a single click from this section of the app.

Navigate to Odoo Connector App >> Orders >> Order Mapping. Then click on the “Synchronize Now” button.

When you click on the “Synchronize Now” button you will have to select a range to synchronize the orders.

In case the ‘Auto-Sync New Orders’ is enabled from the configuration, then all the newly added orders will keep getting synchronized automatically from Shopify to Odoo.

You can manually map the Shopify Payment methods with Odoo Payment Methods.

Navigate to Odoo Connector App >> Payment Mapping. Then click on “Manual Mapping”.

8.1 Payment Manual Mapping

Once you click on “Manual Mapping”, then select payment type, select “Payment Method” and “Odoo Payment Method”.

Then click on the “Map Now” button to map the payment between Shopify and Odoo.

In the tax mapping section, the Admin can manually map the Shopify Taxes with Odoo Taxes. Navigate to Odoo Connector App >> Tax Mapping.

Here you will see 3 options to map the tax between Shopify and Odoo.

9.1 Tax Mapping Via CSV Upload

The admin can also upload the CSV of tax-mapping the Shopify taxes with Odoo taxes.

You have to first download the CSV file format and Instructions. Once you read the instructions properly then make a CSV file as per the format.

Then select your CSV file and click to add.

9.2 Tax Override Mapping

By using this option, the admin can manually map the Tax override mapping.

Select your “Country”, and Region and Choose Collection then select your “Odoo Tax” then click on “Override”.

9.3 Tax Manual Mapping

By using this option, the admin can also manually map the Shopify taxes with Odoo taxes.

You can manually map tax by clicking on Manual Mapping. In this, you have to select the “country”, “Region”, “zip code”, “order line tax”, and “Shipping Tax”.

You can also map the currency from the Shopify Odoo Connector App. Navigate to Odoo Connector App >> Currency Mapping. Then click on “Manual Mapping”.

Once you click on the manual mapping then you need to select “Currency” and “Odoo Currency”.

NEED HELP?

Hope you find the guide helpful! Please feel free to share your feedback in the comments below.

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

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

Thanks for paying attention!!