How To: Import your Harmonisation Codes
Table Of Contents
The Stock Import Tool allows you to import or update Harmonisation Codes against existing stock items in bulk. This is particularly useful when preparing products for international shipping and customs requirements.
Important: This feature is only available if the Stock Import Tool is enabled on your system.
Before You Start
- Your import file must be saved as a tab-separated (.txt) file.
- The stock items should already exist if you are updating Harmonisation Code information.
- The STOCK_CODE column is required so Khaos Control can identify the stock item to update.
Supported Import Columns
The following columns can be used in the import file:
- Harmonisation:Code
- Harmonisation:Country
- Harmonisation:Duty
- Harmonisation:ZONE
- Harmonisation:SHORT_DESC
Import Rules and Notes
Country or Zone Requirements
Each Harmonisation Code must have at least one of the following:
- A Country
- A Zone
If only one code exists for a stock item, it should be configured as the default code.
Creating New Harmonisation Codes
If the Harmonisation Code does not already exist, it will be created automatically during the import.
Tip: Include Harmonisation:SHORT_DESC when creating new codes so the Short Description is populated in System Data.
Duty Values
Where applicable, duty percentages or values can be imported using the Harmonisation:Duty column.
Matching Stock Items
The STOCK_CODE column is mandatory and is used to match imported data to the correct stock item.
Importing Multiple Harmonisation Codes
You can import multiple Harmonisation Codes, Countries, and Zones against a single stock item.
When doing this, include all Harmonisation Code information on the same row as the stock item, repeating the Harmonisation fields as required.
Example Structure
| STOCK_CODE | Harmonisation:Code | Harmonisation:ZONE | Harmonisation:Code | Harmonisation:Country | Harmonisation:Code | Harmonisation:ZONE |
|---|---|---|---|---|---|---|
| ABC123_4 | 6211422222 | EU | 6211422222 | United Kingdom | 6211422222 | EU |
Import Harmonisation Codes
- Open a Stock screen (show me how).
- Press F9, or click the drop-down arrow next to the Other Actions button.
- Select Import Stock Items.
- Browse to and select the tab-separated .txt file containing your stock and Harmonisation Code information.
- Start the import process.
Import Results
When the import has completed, a summary message will be displayed showing:
- The number of stock items imported.
- The number of stock items updated.
- Any records that were skipped.
- Any errors encountered during the import.
Existing Stock Items
If a stock item already exists, the Harmonisation Code information will be updated using the values supplied in the import file.
New Stock Items
If a stock item does not already exist, Khaos Control will create the stock item during the import process, provided the file contains the required information.
Additional Information
- Import files must always be saved in tab-separated text (.txt) format.
- Multiple Harmonisation Codes can be assigned to the same stock item within a single import row.
- Including a Short Description when creating new Harmonisation Codes helps maintain clear and consistent customs data.
- Review any import warnings or errors before repeating the import to avoid duplicate or incomplete records.