Mapping rules for the Import Utility Wizard

This topic describes the mapping rules for the Import Utility.

When you are importing items or aliases using the Import Utility Wizard, ensure you follow the applicable mapping rules.

Rules for Items

• The Item Lookup Code column must be mapped. This is mandatory for item import.

• If you are mapping the Category Code, the Department Code must also be mapped. This is a requirement because of the relationship between Department and Category in the database.

• Any Supplier Code, Department Code, Category Code, Tag Along Item Lookup Code, Tax Code, Parent Item Lookup Code, or Item Message Code included in the import file must exist in the database prior to import. You cannot use the Import Utility Wizard to add these codes to the database.

• You cannot use the Import Utility Wizard to update the Item Lookup Code for existing items.

Rules for Aliases

• The Item Lookup Code and Alias columns must be mapped. This is mandatory for alias import.