Data Mapping involves creating connections between data fields in different databases or systems.
For example, mapping a “SKU Code” field in Client database to a “Product Code” field in iHub in order to fill in the data correctly into the WMS System.
Mappings on iHub are case-sensitive and space-sensitive. This means that even if the column titles are correct, they will not be recognized if the case or spacing does not match the mapping definition.
“Load Product Master” Mapping Example
Navigate to Settings Menu → Service Settings
Select “Load Product Master” Service to configure in the Service and Protocol Settings page
Choose File Format (xml or csv) and click SAVE button
See sample file:
Map the file
Upload a sample file/template
Check Sample file and click NEXT button
Define basic information such as column separator and header usage and click NEXT button
Map the columns to assign the column header of the template (“Your Heading”) to the iHub fields (“Business Meaning”). Drag the fields on the right table to match or assign in the left table until Mandatory fields are set.
Click “Finish” button to Save Mapping
A table will show what has been mapped for checking.
Click “Finish” button
insert SS of WMS Product List
“Load Sales Order” Mapping Example
Navigate to Settings Menu → Service Settings
Select “Load Sales Order” Service to configure in the Service and Protocol Settings page
Choose File Format (xml or csv) and click SAVE button
Map the file
Upload a sample file/template
Check Sample file and click NEXT button
Define basic information such as column separator and header usage and click NEXT button
Map the columns to assign the column header of the template (“Your Heading”) to the iHub fields (“Business Meaning”). Drag the fields on the right table to match or assign in the left table until Mandatory fields are set.
Click “Finish” button to Save Mapping
A table will show what has been mapped for checking.
Click “Finish” button