Products Master Data - WooCommerce in the Integration Hub

Products Master Data - WooCommerce in the Integration Hub

The Integration Hub supports the integration of existing product data as well as new product data between both applications. In other words, product synchronization between SAP Business One and WooCommerce is bidirectional. 

All products added to WooComerce or updated in WooCommerce are synchronized in SAP Business One with the default item group configured in the WooCommerce General Settings. 

WooCommerce products for which the Manage Stock is not selected are marked as non-inventory items in SAP Business One.

The Item Code in SAP Business One is mapped with the Stock Keeping Unit (SKU) in WooCommerce for integration. 

To synchronize products from SAP Business One to WooCommerce, in the SAP Business One Main Menu, choose Inventory  Item Master Data. On the Integration Hub tab, choose the Sync button.

The following fields have been added to the Item Master Data window and is relevant to the Integration Hub. For details of other fields on the Item Master Data window, refer to the SAP Business One online help.


Field Name

Description

Template Name

Displays the name of the WooCommerce template.

Cross Reference Code 

Displays the WooCommerce product ID for normal products or the variant product ID for variant products.   

Sync

Select this checkbox to synchronize the product information from SAP Business One to WooCommerce. 

 

              Caution


You cannot delete products from WooCommerce and SAP Business One. If a deleted product is used in a transaction, then data inconsistency will occur.


 Note

Ensure that the Weight Unit and Dimensions Unit defined for product in SAP Business One is the same as the default Measurement unit defined in WooCommerce.

 Note

Only Simple and Variable Products type are downloaded from WooCommerce.

Simple Products

The integration of Simple products is bidirectional between WooCommerce and SAP Business One. 

Variable Products

The integration of variable products is unidirectional (in other words, from WooCommerce to SAP Business One). Variants can be added to a product that comes in more than one attribute, such as size or color. Each combination of attributes for a product is a variant of that product.

For example, a user sells t-shirts with two attribute: size and color. The size attribute has three values: small, medium, and large. The color attribute has two values: blue and green. One specific variant from these attribute is a small, blue t-shirt.

Each variant is integrated as a separate item in SAP Business One

Product Prices

The prices integration between SAP Business One and Woocommerce is bidirectional. The application uses the default price list defined in the General Settings for WooCommerce to integrate the prices from SAP Business One to WooCommerce. 

To open the WooCommerce General Settings, in the SAP Business One Main Menu, choose Administration  Integration Hub  WooCommerce Settings → General Settings tab.  

The price list selected in the Default Price List for Items Prices Integration field is the integrated price list from SAP Business One to WooCommerce. 

Product Inventory 

The inventory integration is unidirectional (in other words, from SAP Business One to WooCommerce). The inventory status is updated from SAP Business One to WooCommerce. 

From SAP Business One, inventory data is integrated from the warehouse that is defined in the Default Warehouse for Items stock Integration in the WooCommerce General Settings

To open the WooCommerce General Settings, in the SAP Business One Main Menu, choose Administration  Integration Hub  WooCommerce Settings → General Settings tab.  

 The inventory can be synchronized from the Synchronization tab of the WooCommerce window. To synchronize inventory, choose Administration  Integration Hub  WooCommerce Settings → Synchronization. 

 There are two ways to synchronize inventory:

1.    Manual Synchronization of Inventory:

Whenever required, choose the Sync Now button to synchronize the inventory from SAP Business One to WooCommerce.


2.    Automatic Synchronization of Inventory: 

Select the parameters for Object Type, Run, On, Hour, and Minutes to schedule synchronization and then choose the Save Schedule button to schedule inventory synchronization at the predefined day and time. 

 

Field Name

Description

Object Type 

Select Stock from the dropdown list. 

Run 

Specify if you want to run the synchronization daily or weekly. 

On

If you chose the Weekly option, select the day of the week.

Hour

Select the hour on which you want the synchronization to run. 

Minutes

Select the minutes on which you want the synchronization to run. 

Sync Now

Choose this button to start the synchronization immediately.

Save Schedule

Choose this button to implement the selected schedule for the synchronization. 

 

 Next Step:     WooCommerce Transactions in the Integration Hub 


    • Related Articles

    • Customer Master Data - WooCommerce in the Integration Hub

      The customer master data integration is unidirectional i.e. from WooCommerce to SAP Business One. Customer Information like Name, E-mail, Billing and Shipping Address, and other details are integrated from WooCommerce to SAP Business One.  When the ...
    • WooCommerce integration with SAP Business One

      WooCommerce is an open-source e-commerce plugin for WordPress. It is designed for small to large-sized online merchants using WordPress. The integration between WooCommerce and SAP Business One facilitates automated, bi-directional data exchange ...
    • WooCommerce Transactions in the Integration Hub

      The following WooCommerce transactions are supported:  Sales Order Payment Order Cancellation Delivery Refund  Windows Enhancements in SAP Business One New fields that are relevant to the Integration Hub have been added to different document windows ...
    • General Settings of WooCommerce in the Integration Hub

      Configure the general settings in the General Settings tab in WooCommerce Settings window. The General Settings tab of WooCommerce Settings window contains the following fields: Field Name Description Default Price List used for Items Prices ...
    • Step 1 – Set Connectivity of WooCommerce and SAP Business One

      Choose the SAP Business One SLD to provide the connection between SAP Business One System Id and WooCommerce Id. Note By default, the solution displays all the SAP Business One SLDs available in SLD Category selected during customer creation.   To ...