Master Data Mapping Tool for WooCommerce Connector in Integration Hub

Master Data Mapping Tool for WooCommerce Connector in Integration Hub

This tool allows the user to map the already exist customer and product data in WooCommerce and SAP Business One. This is needed in case the same product or customer master is already exists in both the applications and you would like to map their internal code to prevents the data duplicity between the applications.

 

To display the Master Data Mapping Tool window, choose Administration --> Integration Hub --> Master Data Mapping Tool.

Use the following steps to import the mapping data using the master data mapping tool:

1.                    Select a template from the Template dropdown list.

2.                   Select the customer or product from the Master Data Type dropdown list.

 Note

For downloading the product, specify the exact product count in No. of Products in WooCommerce available in the WooCommerce application. If the product count is not specified, the solution will download the product master using WooCommerce API product count. 

3.                   Choose the Download from App button to download the data from the WooCommerce.

4.                   To check the data download status, choose the Status button.

5.                   Once the data download is complete, choose the Prepare Template button to generate the Microsoft Excel-based template for the selected master i.e. Customer or Product. The application downloads the data from the WooCommerce.

6.                   Open the template and provide the relevant information:

§   For the Customer template, you need to provide the SAP B1 Card Code (Customer Code)

§   For the Product template, you need to provide the SAP B1 Item Code

7.                   Choose the Browse button to navigate to the template path.

8.                   Choose the Validate button to check the correctness and completeness of the data in the selected template.

9.                   Choose the Upload button to import the data.
    • 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 ...
    • 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 ...
    • 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 2 – Scenario Selection of WooCommerce in the Integration Hub

      The Scenario Selection summary displays the Scenario Name, Data Direction, and Field Mapping. The Field Mapping further displays information of Field in SAP Business One and mapped field in WooCommerce.       Configuration Summary 2.   The ...