How To: Import your Harmonisation Codes

	This only works if you have the Stock Import Tool enabled

Overview

To import harmonisation codes (assuming the stock items exist), the following columns can be used in the Stock Import file, this will need to be in the format tab-separated format .txt file.

• Harmonisation:Code
• Harmonisation:Country
• Harmonisation:Duty
• Harmonisation:ZONE
• Harmonisation:SHORT_DESC

Notes:

1. There should be at least one Country or Zone specified for each Harmonisation Code and if there is only one code it should be made the default.
2. If the code does not exist it's created, it might be useful providing SHORT_DESC there as well if the code is meant to be created so it has the Short Desc set against the code in System Data.
3. Duty can be added where applicable.
4. The STOCK_CODE column is needed to match to the stock item to update.
5. If importing multiple Harmonisation Codes and zones against one stock item then the file will be along the lines of the following table. You could have more columns and add the short description, but essentially for one stock item, you enter all the details on one line with the stock code at the start:

Usage

1. Open a Stock screen (show me how).
2. Press F9 or clicking the down arrow immediately to the right of the to open the 'Other Actions' menu.
3. Select Import Stock Items.
4. Select a .txt file containing the stock information to be imported. This file should be in a tab-separated format.
5. A message will appear detailing how many item lines were imported or updated, how many were skipped, and errors that were encountered during the process.
   1. If a stock item already exists, it will be updated according to the values in the import file.
   2. If a stock item does not already exist, it will be created.

See Also

• System Data overview
• Stock screen