User Guide for Opencart Odoo SaaS Connector

Introduction

Opencart Odoo SaaS Connector integrates your Opencart store with Odoo Online, allowing you to sync core e-commerce data directly to Odoo.

It helps manage customers, products, categories, orders, and order statuses with ease.

The connector ensures smooth data flow from Opencart to Odoo Online. You can configure sync settings, map data manually, and use real-time sync for selected operations.

Opencart Odoo SaaS Connector is ideal for merchants running Opencart stores who want to manage all their business operations inside Odoo SaaS.

Features

1. Configure real-time sync for products, categories, orders, and order status updates between Opencart and Odoo.
2. Import customers in bulk along with their addresses using the Opencart Odoo SaaS Connector.
3. Manually map customers, categories, and order states to match records between both platforms.
4. Sync product options, option values, and product templates in bulk for accurate product data in Odoo.
5. Create products in Opencart and sync them instantly to Odoo with real-time product sync option.
6. Synchronize and map payment methods, taxes, currencies, and shipping carriers from Opencart to Odoo.
7. Orders can be synced manually from the admin order page, while new orders created on the Opencart storefront are pushed to Odoo in real time if enabled.
8. Map Odoo order statuses, such as PAID, CANCEL, DELIVERED, CONFIRM, and DONE to Opencart statuses to keep orders aligned
9. Review detailed sync logs to identify errors and troubleshoot issues efficiently with our Opencart Odoo SaaS Connector.
   

Installation

1. Extract the file you received. Inside the OpenCart folder, there is a base module.
2. Base module: It is the main module, generally this module will contain two folders named admin and catalog. 
3. Copy all folders/files of this folder into the main OpenCart directory. After copying all files:

• Go to your OpenCart admin panel.
• Simply re-login to the OpenCart admin panel.
• Navigate to OpenCart Extension Installer and upload the modification file shared with the module

4. After uploading files, go to the extension >> Modification and then click on the Refresh button.

5. After that, go to the admin panel; System >> Users >> User Group; then edit and select all the permissions and access, and save it.

6. Navigate to the Extension menu >> Module >> then click on the Opencart Odoo Connector install button. Opencart Odoo SaaS Connector will be installed successfully

7. Click on the edit button and set the module status to Enabled to activate it successfully.

Workflow

Configuration

To start using the connector, we first need to configure the settings, such as connection setup and auto sync, for the connector to work as expected.

Connection Settings

• Navigate to Odoo Mappings >> Odoo Configurations to open the configuration menu.

• URL: Enter Odoo URL in this field to connect with Odoo instance
• Port: You need to enter Odoo port number here
• Database Name: Database name of Odoo instance
• User/Password: Odoo credentials of your Odoo instance
• Bulk API Limit: Bulk API limit can be set as per your preference to control the number of records to be bulk synced at one time. If there are 200 records for sync and the limit is set to 100, the connector will first sync the 100 records, and then sync the remaining records after it is successful.

Other Settings

• Product Type: Set the product type, whether variant or template, for the product sync from Opencart to Odoo
• Discount product: Select the default Discount product to be applied to all the orders.
• Default Payment Method: Set the default payment method for all orders
• Warehouse: Select the Warehouse where the products are stored
• Location: You can also select the warehouse location in case of multiple locations for a warehouse to choose the correct location for the shipment.

Auto Synchronization Settings

These settings help to decide the real-time sync settings, and if enabled connector will sync this data in real time.

• Category Real Time Sync: Enable this option to sync the category from Opencart to Odoo in real time
• Products Real Time Sync: When this option is enabled, it will sync all the products in real time from Opencart to Odoo
• Orders Real Time Sync: All the orders created on the store/website will be synced to Odoo when it is enabled
• Order Status Real Time Sync: Real-time order status syncs to Odoo when the status of a synced order changes in Opencart, when enabled.

Reset Mappings

“Reset Mappings” will delete the entire mapping, so use this option carefully. For specific mappings, delete them individually from the mapping page (this will not delete the related Odoo records).

Customer sync

With Opencart Odoo SaaS Connector, you can bulk sync all customers and their addresses, and with options to manually map them between Opencart customers and existing Odoo customers.

• Navigate to Odoo mappings >> Customers. You can see all the customers and can also sync them to Odoo by clicking on the Synchronize button at top.

• You can also manually map the Opencart customers with existing customers in Odoo by clicking on the plus button at top.

Customer Address Sync

• Click on the Customer’s Address under Odoo Mappings to view the customer address mapping.

• Click on the plus button at the top to manually map the addresses between Opencart and Odoo for the customer.

Product Category Sync

You can easily sync the product categories from Opencart to Odoo with the help of Opencart Odoo SaaS Connector.

If the real-time category sync option is enabled, it will sync all the categories created in Opencart to Odoo automatically.

• Navigate to Odoo Mappings >> Products Category. You can view all the category mappings and sync them to Odoo using the Synchronize button at top.

• Manual mapping can also be done between categories of both systems by clicking on the plus button at the top.

Product Sync

Product sync can also be done from Opencart to Odoo using the connector. You can choose to map the product options and option values between both platforms and sync the product.

• Open Odoo Mappings and navigate to Products. Click on Product Options to view all the option mappings for the products. Click on the Synchronize button to sync them.

• To manually map the product options, click on the plus button at the top

• Next, you need to sync the product options value. Navigate to Product options value in the Products under Odoo mappings to view the mapping and sync it to Odoo

• Product options value can also be manually mapped from Opencart values to Odoo values to maintain consistency.

• Now that the product options and values have been synced, we can sync the product. Click on the Product Templates to view the mapping and sync them to Odoo from Opencart.

• You can also directly sync the product to Odoo by navigating to Catalog >> Products. Select the product you want to sync and click on the Sync button at top.

Orders Sync

All the orders created from the store/website are automatically synced to Odoo if the real-time order sync settings are enabled.

Before syncing the order, we need to create the mappings for Tax, Currency, Carrier, and Payment methods for orders to sync correctly.

Tax Sync

• View all the tax mappings and sync them by clicking on the Tax menu under Odoo Mappings.

• Create manual tax mapping between Odoo and Opencart.

Currency Sync

• Navigate to Odoo Mappings >> Currency to view the mapping and sync the currency.

• Click on the plus button to manually map currencies on both platforms and click on save button to save it.

Carrier Sync

• Click on the Carrier menu under Odoo Mappings to view and sync the shipment carrier between Odoo and Opencart

• You can also manually map the carriers between Odoo and Opencart as per your preference, and save it

Payment method Sync

• View the payment methods currently mapped and sync them to Odoo from Opencart by clicking on the Payment Methods menu under Odoo Mappings

• Click on the plus button at the top to manually map Odoo payment methods with the Opencart ones and save them.

Orders

• To sync the orders manually, navigate to Sales >> Orders to view all the orders.
• Select the order you want to sync to Odoo and click on Synchronize Order button at top.

Please note: All the newly created orders from the store/website will be automatically synced to Odoo if the Orders Real Time Sync configuration is enabled.

Orders Status Mapping

You can set the order status mapping between Odoo and Opencart using Opencart Odoo SaaS Connector.

The defined order status is synced to Odoo when any changes happen in Opencart if the Order Status Real Time Sync configuration is enabled.

• Navigate to Odoo Mappings >> Order Status to view all the mapped order statuses.

• Click on the plus button at top to create a new order state mapping for order status in Odoo(PAID, CANCEL, DELIVERED, CONFIRM, DONE) with the respective Opencart order states.

Connector Log

The Connector Logs section displays all error logs of the Opencart Odoo SaaS Connector. It helps you quickly identify and troubleshoot any failed sync with clear timestamps and error details.

• Navigate to Odoo Mappings >> Connector Logs. You can view the logs and also choose to download or clear the logs using the buttons at top.

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: support@webkul.com

Thanks for paying attention!!