Defining Shipping Import Mapping

The Shipping Import Mapping tab provides you with the ability to define an input file structure for a given shipping vendor for the selected warehouse. If shipping files are imported from more than one vendor then each shipping import mapping must be created for each warehouse.

The Shipping Import Mapping information works in correlation with the INV610 Shipping Import batch process, which allows you to take a file from a shipping vendor and from that file, update order shipping information in Personify360.

For more information on the INV610 batch process, see INV610 – Shipping Import Process.

To set up shipping import mapping:

1.    On the Warehouse Definition screen, click the Shipping Import Mapping tab.
The Mapping Information screen displays, as shown below.

2.    Click Add Mapping Information.
The fields in the Mapping Record section become enabled.

3.    Select a File Format Code from the drop-down.
Values in the drop-down are populated based on the fixed codes defined for the INV "FILE_FORMAT" system type code.

a.    If you select Fixed, perform the following:

i.      Enter the character length of the Fixed Field Length.

ii.     If necessary, select the Date Format Code from the drop-down.
Values in the drop-down are populated based on the fixed codes defined for the INV "DATE_FORMAT" system type.

b.    If you select Delimited, perform the following:

i.      Select a Delimiter Code from the drop-down.
This is the punctuation type to be the delimiter in the mapping file. For example, comma, pipe, tab, or tilda. Values in the drop-down are populated based on the fixed codes defined for the INV "DELIMITER" system type.

ii.     Select an Enclosed By Code from the drop-down.
This is the punctuation type by which to enclose the mapping records. For example, comma or double-quotes. Values in the drop-down are populated based on the fixed codes defined for the INV "ENCLOSED_BY" system type.

iii.   If necessary, select the Date Format Code from the drop-down.
Values in the drop-down are populated based on the fixed codes defined for the INV "DATE_FORMAT" system type.

4.    To add Mapping Detail information, perform the following:

a.    From the Mapping Detail section, click Add.
A new record is added to the grid below and the fields in the Detail section become enabled.

b.    Enter a Sequence Number.
This indicates the order of the fields in the input file.

c.    Select the Field Name Code from the drop-down.
Values in the drop-down are populated based on the fixed codes defined for the INV "INV610" system type.

One record should exist in the Mapping Detail section for each Field Name Code.

d.    If you selected Fixed as the File Format Code above, then enter the Field Length.

e.    Repeat for each Field Name Code.
One record should exist for each Field Name Code. Tracking Number is the only optional Field Name Code.

5.    Click Save.