When items are imported from the Dot Foods catalog into the entrée inventory file, key pieces of data need to be mapped to an appropriate field in the entrée database. The Dot Item Import Configuration tool allows you to specify how those pieces of data are mapped. The settings are the same in V4 SQL and V3.

 

Customize your import default settings by making selections from the drop down lists provided. This includes fields like: item number, item description, brand, category and class names.

 

The data fields are broken into three sub categories and are located down the left side of the dialog.

 

Along the right edge of the dialog is an instruction/informational panel, that details how the currently selected field relates to entrée and the options available for the import operation.

 

 

•Basic Item Information - Use the drop down lists to choose options for imported items.

▪Import item numbers  

▪Import number prefix - Enter an Item number prefix to identify the Dot Foods items in your catalog.

▪Import item description  

 

•Item Grouping - Use the drop down lists to choose your import grouping options.

▪Brand Import Field

▪Class Import Field

▪Category Import Field

▪Group Import Field

▪Group Import Field Default

•Special Codes - Fill in new values or use the defaults.

▪Item Misc. Code / Position

▪Kosher Misc. Code / Position

▪Hazmat Misc. Code / Position

▪Hazmat Comment

▪Matrix Misc. Code / Position

 

•Defaults - This button restores the system defaults.

 

Next Perform the Second System Preferences Update in the General Tab

•General Tab Add D-U-N-S Number