...
For example, mapping a “SKU Code” field in from Client database data 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.
Mapping is done for each service. A file template will be configured to match the data in WMS.
| Table of Contents | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
“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:
| View 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 and Drop Method: Drag the fields on the right table to match or assign (drop) 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
Once file is uploaded successfully in iHub, data will be visible in:
Seko 360 WMS Client site → Design Menu → Product List → In Production tab.
See More here: https://seko.atlassian.net/wiki/x/6AJ0qQ
iHub mapped fields in WMS
“Your Heading”= Client header description
“Business Meaning” = WMS fields
example: SKU Code = Product Code
...
Fields in the Properties tab
csv file column - fill in True or False
WMS date - True= toggled YES, False= toggled NO
...
“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
See sample file:
| View 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
...
To set Date Formatting, click + icon (Transform column)
Once file is uploaded successfully in iHub, data will be visible in:
Seko 360 WMS Client site → Sales Channel Menu → Sales Order → All Sales Order tab.
See More here: https://seko.atlassian.net/wiki/x/9gN0qQ
iHub mapped fields in WMS
Group Fields:
Web Sales Order/Header
...
Delivery Details
...
Sales Order Line Items
...
Retail Compliance
...