iHub Mapping Sample Guide

Data Mapping involves creating connections between data fields in different databases or systems.

For example, mapping a “SKU Code” field from Client 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.

“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

  1. Upload a sample file/template

  2. Check Sample file and click NEXT button

  3. Define basic information such as column separator and header usage and click NEXT button

  4. Map the columns to assign the column header of the template (“Your Heading”) to the iHub fields (“Business Meaning”).

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

  6. Click “Finish” button to Save Mapping

  7. A table will show what has been mapped for checking.

  8. Click “Finish” button

Mapping LoadPM.gif
Map columns.png
Client fields mapping to the iHub fields

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: WMS - In Production (Product List)

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:

  • Map the file

  1. Upload a sample file/template

  2. Check Sample file and click NEXT button

  3. Define basic information such as column separator and header usage and click NEXT button

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

  1. Click “Finish” button to Save Mapping

  2. A table will show what has been mapped for checking.

  3. 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: WMS - All Sales Order

iHub mapped fields in WMS

Group Fields:

Web Sales Order/Header

Delivery Details

Sales Order Line Items

Retail Compliance