Odoo WooCommerce Connector

by
Odoo

346.66

v 10.0 v 11.0 v 12.0 Third Party 21
Required Apps Inventory Management (stock)
Sales (sale)
Invoicing (account)
Technical Name ks_woocommerce
LicenseOPL-1
Websitehttps://www.ksolves.com/
Also available in version v 13.0 v 12.0 v 11.0
You bought this module and need support? Click here!
Required Apps Inventory Management (stock)
Sales (sale)
Invoicing (account)
Technical Name ks_woocommerce
LicenseOPL-1
Websitehttps://www.ksolves.com/
Also available in version v 13.0 v 12.0 v 11.0

Odoo WooCommerce Connector

WooCommerce is a flexible, open-source eCommerce plugin on Wordpress which provides a customizable platform for building your online business. If your backend operations are getting managed by Odoo and you have a WooCommerce store, then Odoo WooCommerce Integration becomes a must for you.

With Ksolves Odoo WooCommerce connector facilitates you complete Open source ERP software "Odoo" with renowned eCommerce trading Business "WooCommerce". It lets you integrate and manage your WooCommerce stores in Odoo and thus resolves the need to go in Woocommerce backend to handle things which can be managed from Odoo.This app provides bi-directional synchronization of data from your WooCommerce website into Odoo and vice-versa.

WorkFlow

bidirectional-sync
order-management
auto-jobs
webhook

Key Features

Sync Features :
  • Creating and updating product, coupon, customer and order from WooCommerce to Odoo using WEBHOOK in Real time
  • Creating and updating product, coupon, customer and order from WooCommerce to Odoo using WEBHOOK in Real time
  • Map your existing record in Odoo
  • 2-way sync of Customer
  • 2-way sync of Product attributes along with its values
  • 2-way sync of Product along with its variants, display image and gallery images
  • Import Sale Order from WooCommerce to Odoo
  • Export the default sale order
  • Auto product syncing from WooCommerce to Odoo
  • 2-way sync of Product categories, Tags and Coupons
  • Auto product stock update from Odoo to WooCommerce
  • Stock update for products on WooCommerce from odoo
  • Import Stock from WooCommerce to Odoo
Functional Features :
  • Sale order cancellation in WooCommerce from Odoo end
  • Update sale order status from Odoo to WooCommmerce
  • Auto sales order import from WooCommerce to/ Support Odoo
  • Auto sales order status update
  • Publish or Unpublish Products to WooCommerce Store from Odoo in Real time
  • Ability to select which way to sync i.e. from WooCommerce to Odoo or vice versa and then a single click import/export of all the data both ways
Business Features:
  • Integrate multiple WooCommerce stores with a single Odoo database
  • Set automatic jobs using crons to update data in Odoo from WooCommerce periodically
  • Detailed WooCommerce logs available for syncing operations done along with the filtering feature
  • Search functionality of WooCommerce data in Odoo for all the modules using module specific keywords

See Screenshots

  • webhook

    WEBHOOK

  • Import-Customer

    Import Customer from WooCommerce to Odoo

  • Import-Product

    Import Product from WooCommerce to Odoo

  • Import-Sale-Order

    Import Order from WooCommerce to Odoo

  • Export-Customer

    Export Customer from Odoo to WooCommerce

  • Export-Product

    Export Product from Odoo to WooCommerce

  • Export-Order

    Export Order from Odoo to WooCommerce

  • Sale-Order-Status

    Update Order Status from Odoo to WooCommerce

How to Setup

Before using the module you need to generate the API from the WooCommerce Backend. In order to do the same, Go to WooCommerce > Settings > Click on Advanced

woo_1

Once you click on “Advanced” tab, you need to create the API key which will be interacting with Odoo. In order to do the same, Go to, Advanced > Rest API > Click on Add keys

woo_2

After clicking on “Add Keys” button, a page will be open, where you need to give the username and provide the permissions > Generate API key.

woo_3

In order to maintain the keys for future use, you need to save them as shown below:

woo_4

After installing the module you will be able to view that there is Woocommerce Menu created where in WooCommerce menu you can create the instance. WooCommerce > Configuration > Instances

woo_5

Click on the Create button to create a new instance.

woo_6

Enter the name of your instance, WooCommerce Store URL, Consumer Key & Consumer Secret. If your WooCommerce store carries an SSL certificate, check ‘Verify SSL’, after putting all the information you can click on “Save” button.

woo_7

Once you are done with creating the instance, you can test your connection by clicking on Connect Instance button If everything is added properly you will receive a message on the same page “Connection Successful”. In case the connection is not successful you can correct the information entered.

woo_8

After your instance get connected, you need to setup basic details for WooCommerce instance.

In Configuration tab you need to fill the below details as stated:

  • Warehouse: Select the warehouse from where you wish to manage WooCommerce Inventory.
  • Currency: Select the currency used by your WooCommerce Store.
woo_9

In Configuration tab you need to fill the below details as stated:

  • Stock Field Type: Select the stock field of product whose quantity will be updated as WooCommerce Inventory.
woo_10

In Order tab you need to complete the below details as stated:

  • Order State Configuration: Select the sync WooCommerce order status Orders which you wish to import in Odoo
  • Sales Team: Select the Sales Team for WooCommerce Orders
  • Sales Person: Select the Sales Person for WooCommerce Orders
  • WooCommerce Fees: Select the Fees Product for WooCommerce orders
  • WooCommerce Shipping Fees: Select the Shipping Fees Product for WooCommerce orders
woo_11

In Accounting tab you need to complete the below details:

  • Payment Method: Select the payment journal that need to be set at the time of register invoice payment if not set in WooCommerce Payment Gateway
woo_12

In Automatic Jobs tab you need to fill the details for automatic process for Import Order, Import Product, Update Order Status and Update Product Stock.

woo_13

In Webhooks tab you will notice the Topic and its Delivery URL on the basis of WooCommerce Instance to implement Webhook on WooCommerce Side.

woo_webhook

After Configuring all the required fields, click on "Activate Instance" to perform the synchronization operations.

woo_15

You can overview the details of multiple created WooCommerce Instances from the dashboard and manage them as per your need.

woo_16

You can manually sync your data or you can implement webhooks on WooCommerce side to create or update the records on Odoo in Real Time.

Click on the configuration of the WooCommerce Instance for which you wish to configure the Webhook.

woo_config

Click on the Webhooks tab as shown below, Here you will notice the Delivery URLs according to the Topic for the configuration of WooCommerce WebHook.

woo_webhook

Now, you need to setup the Webhook from the WooCommerce Backend for that, Go to WooCommerce > Settings > Advanced > webhook > Click on “Add Webhook” button to create a new WebHook.

woo_23

Now you need to enter the Name , Status, Topic, Delivery URL, Secret, API Version and then click on “Save Webhook”

woo_24

After saving you will receive a message as “Webhook updated successfully” if the Webhook is successfully updated.

woo_25

Note: Enter the Delivery URL as the URL defined under the “Webhooks Tab” according to the Topic of WebHook.

You can manually sync your data or you can activate cron to do the syncing automatically.

You can manually sync your data or you can activate cron to do the syncing automatically. Click on the configuration of the WooCommerce Instance , for which you wish to configure the Automatic jobs

woo_config

Click on the Automatic Jobs tab > Check the operations for which you wish to set up the Cron Automatic Jobs and click on Save

woo_18

Note:

  • The Last updated field will auto update after the execution of the specific cron automatic job.
  • Please make sure that the Instance is Active before moving forward.

Go to Settings, and then Activate the developer mode

woo_19

Now go to Settings > Technical > Scheduled Actions > The Auto Cron jobs are as shown below:

woo_20

Activate the Cron Job you want to perform for that you need to select the Auto Cron Job > Action > Click on Unarchive button

woo_21 woo_22

You can map your WooCommerce Category, Product and Variant with the existing odoo records so that when you import the records from the woocommerce to odoo, it wouldn’t duplicate the records in odoo. For that, Go to WooCommerce > Mapping

woo_mapping

Select the model for which you want to perform mapping and then click on Next as shown below:

select_model

After selecting the model, you will be able to see the records which does not have WooCommerce ID .

map_record

Now update the Woocommerce ID and WooCommerce Instance for the record of your choice in Odoo.

woo_id woo_id_instance

Then Click on “Execute” button, this will update the Woocommerce Id and Instance on the selected model record.

execute

Note:

  • You can see the mapped WooCommerce ID and Instance in the Log of that particular record.
map_log

Note:

  • The next time when you will perform the Syncing Operation, the mapped records will get updated.
updated_record

This will allow user to view the entire logs of the operations with respect to unsuccessful and successful status, so that you can keep a track on the records synced.

woo_log

Our Releases

13th jan, 2020

Latest Release 1.1.0

Fix- The Order Configuration for Instance

Enhancement- Implemented mapping for existing records

Enhancement- Implemented mapping for existing records

Enhancement- Implemented Stock Import

Enhancement- Price management for Variants and Products.

FAQ's

  • Is this app compatible with Odoo Enterprise?
    Yes, our app works with Odoo Enterprise as well as Community.
  • Need some customization in this app, whom to contact?
    Please drop email at sales@ksolves.com or raise a ticket through Odoo store itself.
  • Do you provide any free support?
    Yes, we do provide free support for 90 days for any queries or any bug/issue fixing.
  • Is handles WooCommerce Multiple stores?
    Yes, this app provides to create multiple woocommerce store instances.
  • Do sync Woocommerce Coupons?
    Yes, you can sync coupons data.

FREE 90 DAYS SUPPORT

Ksolves will provide FREE 90 days support for any doubt, queries, and bug fixing (excluding data recovery) or any type of issues related to this module. This is applicable from the date of purchase.

Note:

Extensively Tested on Odoo Vanilla with Ubuntu OS

Ksolves Odoo Services

ksolves
Odoo-Implementation
Odoo Implementation
Odoo-Community-Apps
Odoo Community Apps
Odoo-Support-Maintenance
Odoo Support & Maintenance
Odoo-Customization
Odoo Customization
Odoo-Integration-Services
Odoo Integration Services
Odoo-Developer-Outsourcing
Odoo Developer Outsourcing
sales@ksolves.com
+91 120-4299799‬
Odoo Proprietary License v1.0

This software and associated files (the "Software") may only be used (executed,
modified, executed after modifications) if you have purchased a valid license
from the authors, typically via Odoo Apps, or if you have received a written
agreement from the authors of the Software (see the COPYRIGHT file).

You may develop Odoo modules that use the Software as a library (typically
by depending on it, importing it and using its resources), but without copying
any source code or material from the Software. You may distribute those
modules under the license of your choice, provided that this license is
compatible with the terms of the Odoo Proprietary License (For example:
LGPL, MIT, or proprietary licenses similar to this one).

It is forbidden to publish, distribute, sublicense, or sell copies of the Software
or modified copies of the Software.

The above copyright notice and this permission notice must be included in all
copies or substantial portions of the Software.

THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR
IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY,
FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT.
IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM,
DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE,
ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER
DEALINGS IN THE SOFTWARE.

Please log in to comment on this module

  • The author can leave a single reply to each comment.
  • This section is meant to ask simple questions or leave a rating. Every report of a problem experienced while using the module should be addressed to the author directly (refer to the following point).
  • If you want to start a discussion with the author or have a question related to your purchase, please use the support page.