Master Data Mapping Tool for Magento Connector in Integration Hub

Master Data Mapping Tool for Magento Connector in Integration Hub

This tool allows the user to map the already existing customer and product data in Magento and SAP Business One. This is needed in case the same product or customer master is already exists in both the application 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.

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

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 Magento.

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

    • Product Master Data - Magento in the Integration Hub

      The System supports the integration of existing product data from Business One to Magento. Product add & update operations are supported from SAP Business One to Magento.  For non-inventory item synchronization, the manage stock in Magento should be ...

    • Customer Group Master Data - Magento in the Integration Hub

      The customer master Group integration is unidirectional i.e. from SAP Business One to Magento. Customer Group Name in SAP Business One is integrated to Customer Groups in Magento. If Customer Groups already exist in Magento, then manually create ...

    • Customer Master Data - Magento in the Integration Hub

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

    • Magento integration with SAP Business One

      The Magento is an eCommerce platform that provides online merchants with a flexible shopping cart system, as well as control over the look, content, and functionality of their online store. Magento offers powerful marketing, search engine ...

    • Payment Mapping of Magento in the Integration Hub

      Map the payment methods of Magento in the Payment Mapping tab in the Magento Settings window in SAP Business One.  To add Payment method, right-click on Magento Payment Method and Add Row to Map the payment method from Magento to SAP Credit Card. ...