The customs tariff number has 8 digits and can either be transferred via the catalogue (BMEcat) or in a separate CSV file.
How you can transfer customs tariff numbers via a CSV file is described below.
Create CSV file
The file consists of 2 columns and has the following structure:
1 2 3 4 5 6 7 |
SUPPLIER_AID;WA_NR 6862;82032000 03-A586;85369010 6633zf;85369010 123456;39269097 456789;39259020 789123;39269097 |
- The item numbers must be unique and correspond to the item numbers in your catalogue.
- Separator: Semicolon
- The first row with the header SUPPLIER_AID;WA_NR is mandatory information.
If you already use a price file or a conditions file (CSV) for your catalogue, you can also transfer the customs tariff numbers in this. To do this, simply create a further column with the header WA_NR. Nothing changes in terms of the naming of the file.
Transfer to Mercateo
After editing, save the Excel table for safety. Next, export the data as a CSV file:
File > Save as > File type: „CSV (separator-separated) (*.csv)“
Naming of the file:
catalogueID_tariffnumber.csv
Please note:
- The catalogue-ID will be provided by Mercateo
- Please keep the file naming. Without correct naming, the CSV file can either not be processed or not be assigned to the correct catalogue.
Transmission of the files:
The CSV file is transferred via FTP. The access data will be communicated to the supplier during onboarding. If you are an existing supplier, you already have the FTP login details.
Once you have created the CSV file, please contact support@unite.eu. Please indicate in the mail for which catalogue you would like to activate the file.
You then receive all further information from Mercateo.