Master Data Mapping Tool for Shopify Connector in Integration Hub
This tool allows the user to map the already exist customer and product data in Shopify 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 the Shopify.
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 selected master i.e. Customer or Product. The application downloads the data from the Shopify.
Note
Only Active customer will be download from the Shopify.
6. Open the template and provide the relevant information:
o For Customer template, you need to provide the SAP B1 Card Code (Customer Code).
o For Product template, you need to provide the SAP B1 Item Code.
7. Choose 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
Products Master Data - Shopify 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 Shopify is bidirectional. All products added to Shopify ...Customer Master Data - Shopify in the Integration Hub
The customer master data integration is unidirectional (in other words, from Shopify to SAP Business One). Customer information like Billing and Shipping Address , and other details are integrated from Shopify to SAP Business One. When the ...Shopify integration with SAP Business One
Shopify is an e-commerce platform that allows users to create online retail stores. This cloud-based platform gives the flexibility to access and run a business from anywhere. Shopify allows users to: Create and customize an online store. Sell in ...Initialization Process of Shopify in the Integration Hub
Once the Shopify feature is enabled in SAP Business One, you need to initialize the integration of the objects between SAP Business One and Shopify. The objects include customer, products and inventory. Note Ensure that the weight UOM code in SAP ...Location Mapping of Shopify in the Integration Hub
Location mapping information is used to integrate inventory data from SAP Business One to Shopify. A Shopify store can have multiple locations where inventory can be tracked and orders can be fulfilled. A Shopify location can be a retail store, ...