Bulk Update Harmonisation Codes

Bulk Update Harmonisation Codes

Problem
How can I bulk update my harmonisation codes?

Solution
You can bulk update harmonisation codes to stock items using the data import tool by following the steps below.

Getting your data

KCC Lite does not support the steps in this section. If you use KCC Lite we may be able to carry out this section for you as a chargeable service. Please email support@khaoscloud.com for full details. If you are using KCC Lite and need to setup harmonisation codes but do not require our assistance you will need use the guide here, Setting up Harmonisation Codes.
This process may take some time depending on the size of your KCC Stock database.
  1. Go to [Reports | Adhoc Reports].
  2. In the popup window select System - Products.
    1. This will produce a CSV file of all the stock items on your system.

Preparing your data

This section will setup the file generated above so that harmonisation codes can be imported to your system and added to stock items.
  1. Open the CSV file generated above.
  2. Delete all columns except the STOCK_CODE column.
  3. Add the following column headers to columns B, C, D & E.
    1. Harmonisation:Code (Column B)
    2. Harmonisation:SHORT_DESC (Column C)
    3. Harmonisation:Country (Column D)
    4. Harmonisation:Duty (Column E)
      1. The system will not use this rate for calculating tax, it is here purely for your own records. The [System Data | Tax Rates] screen will be used to determine the tax rates for the products on a sales order.
    5. COUNTRYMANUF_ID (Column F)
  4. In column B for every stock item enter the Harmonisation Code including trailing zeroes.
  5. In column C enter the international trade description of the code listed in step 4.
  6. In column D enter the country to which this code applies.
    1. If multiple countries are needed the item must appear on a separate line for each country.
  7. In column E enter the duty to be applied to the product under this harmonisation code when sold to the country specified in step 3.
    1. Only one duty rate can be applied per country, per product.
  8. In column F enter the country of manufacture name. This MUST exist in [System Setup | System Data | Countries].
  9. If you have more than 3000 rows of data the import may fail please split your file in to smaller chunks.
  10. Save your file(s) as Text (tab delimited) files.

Importing the data on to your KCC system

In order to import the updated data, please follow our data import guide here, Importing Your Data and then carry out Confirmation Check below.

Confirmation Check

Open any stock item that uses an ICN code and ensure the values in the Accounting area are as specified on your data import.


    • Related Articles

    • How To Set Up and Apply Harmonisation Codes

      This video explains how to set up and apply harmonisation codes in Khaos Control Cloud. Detailed instructions have been provided below the video. Instructions Setting up Harmonisation Codes in System Data Adding Harmonisation Codes Click on System ...
    • Setting up and Using Harmonisation Codes

      Overview Harmonisation Codes are required by some couriers when shipping goods overseas. There are three steps to setting up Harmonisation Codes, although one is optional: Setup the code in System Data and link it to the country or zone that will be ...
    • Bulk Import ICN Codes to products

      This feature is still in development and all instructions in this article MUST be adhered to. Please contact training@khaoscloud.com if you are unsure about any steps. When importing ICN codes, the system will only allow ICN codes that do not ...
    • Can I bulk update supplier availability for my stock items?

      Problem My supplier has sent me their stock levels, how can I import these onto my KCC system? Solution There are two parts this process and both will be covered here. Part 1 Getting your data from KCC. This process will export your stock file from ...
    • Can I Bulk Update customers?

      Problem Is it possible update customer records in bulk or via an import? Solution No, it is not possible at the present time to bulk update customers or suppliers or update them via import. Running an import will generate duplicates which will then ...