WooCommerce to iDempiere

From iDempiere en


Credits

  • iDempiere
  • WooCommerce developed by Automatic
  • WordPress
  • Oleksandr Mandryk or icoderman - Java wrapper for WooCommerce REST API

Background

WooCommerce is a free open-source plugin for WordPress. It is a popular e-commerce platform and drives an estimated 30% of all online stores. Some businesses with iDempiere use WooCommerce as a channel for online sales. It seems like a good idea to integrate those transactions back to iDempiere (ERP) for accounting and stock management

Functionality

The basic premise is to have a one way update of information from WooCommerce to iDempiere (ERP)

  • After a sales order/s is completed (items have been shipped) on WooCommerce then it will be transmitted to the ERP
  • We use the Mixed POS Payment functionality in iDempiere (Contributed by GlobalQSS) to generate a payment
  • Once the Sales Order (SO) is successfully synchronised to the ERP. The associated invoice, payment, shipment and allocation are generated and completed
  • The sales order document number will be the WooCommerce order number
  • The assumption is that the ERP will be the 'Master' for the the products. If a line has a product that is not recognised by the ERP then the default one, on the WooCommerce Default window will be used. We feel that stock management is better off done on the ERP
  • If a Business Partner (BP) is used for the e-commerce sale and it does not exist in the ERP, then a BP will be created using the e-commerce address and contact details. Defaults will be used, as set up in the WooCommerce Defaults window, if this info is not available

Download Source Code/Application

Development Environment

You can skip this step if you just want to install the plugin zip file

  • Operating System used is Ubuntu 20.04
  • Java: OpenJDK 11.0.5
  • Eclipse IDE for Enterprise Java Developers - Version: 2020-06 (4.16.0)
  • iDempiere 7.1.0

WooCommerce Changes

  • To generate your WooCommerce Rest API keys see: Generate Rest API keys
  • The plugin to enable integration from WooCommerce to iDempiere resides at the root of the plugin source on github (see details under 'Download Source Code' above): idempierePlugin.php
  • Copy idempierePlugin.php to your WooCommerceStore/wp-content/plugins directory of your Web server
  • If you go into your Wordpress dashboard, under 'Plugins' you should see the iDempiere plugin installed and active
WordPress Plugin screenshot.png





iDempiere Changes

  • Pack in the WooCommerce Defaults window and WooCommerce process from 'WooCommerce packin.zip' This file is located in root of the plugin source
  • Create tax rates to match the rates on WooCommerce
  • Create an inclusive sales price list
  • Create pos tender types exactly as follows:
 Search Key|1000000, Name|Credit Card, Tender type|Credit Card
 Search Key|1000001, Name|Cash, Tender type|Cash
 Search Key|1000002, Name|EFT, Tender type|Direct Deposit
 Search Key|1000003, Name|OnCredit, Tender type|Account
  • In the System Configurator, set:
 PAYMENT_OVERWRITE_DOCUMENTNO_WITH_CREDIT_CARD to 'N'
 CLIENT_ACCOUNTING to M
  • Populate the WooCommerce Defaults window. Ensure the 'organisation' is set correctly

For example:

Wc-defaults-example.png








Run WooCommerce process from iDempiere

  • Click on the menu item 'WooCommerce'
  • Inspect your sales orders on iDempiere to see if your 'Completed' WooCommerce orders reflect
  • The sales orders must be successfully completed on iDempiere



If you want to provide additional comments, please use the iDempiere forum post: iDempiere forum post

See Also