Bulk Upload Imports

Easily add multiple import records at once using the bulk upload feature in kolum. This helps you save time, reduce manual entry, and keep your compliance data structured.

How it works

Download the provided import upload template (CSV/Excel) from kolum. Fill in each required field carefully for all your import records, and upload the completed file. kolum will process the data and display any errors that need correction before imports are created.

Key rules to avoid errors

To ensure a smooth upload, please ensure:

• EORI Number: Must exactly match an existing company you have already created in kolum. If the EORI number does not match, you will see an error. Double-check your company list and copy the EORI precisely.

• CN Code: Ensure the 8-digit Combined Nomenclature (CN) code is accurate, matching the goods being imported. Mistyped CN codes will result in rejected rows.

• Article Reference Number: Articles must already exist in your kolum system with the correct Article Identifier. If the article reference does not match an existing article, you will see an error.

• Country of Origin: Use the official 2-letter ISO country code (e.g., CN for China, IN for India) rather than country names. Uploads will fail if you write “India” instead of “IN”.

• Supplier Identifier: The supplier should already exist in your kolum system, and you should use the same Supplier Identifier exactly as entered.

• Production Facility Identifier: If you include production facilities, ensure they are pre-created in kolum and you are using the exact Facility Identifier.

• Applied and Previous Customs Procedure: Use the correct codes (e.g., CP01, CP42). Ensure you are using valid procedure codes as defined in your customs documentation.

• Date formats: Always use YYYY-MM-DD format to avoid upload issues.

Upload and Review

1. Prepare your file: Ensure your template is filled correctly according to the above rules.

2. Upload the file: Navigate to the Imports section, click Upload file, and select your prepared file.

3. Check for errors: kolum will validate your upload and display a clear error table highlighting incorrect rows in red with explanations (e.g., “The EORI number does not match an existing company”). You can download the error report if needed.

4. Correct and re-upload: Fix the errors in your file based on the validation feedback and re-upload until the file is accepted.

Tips for smooth uploads

• Validate your EORI, Article IDs, CN Codes, and Supplier Identifiers in kolum before preparing the file.

• Use the exact 2-letter country codes.

• Avoid unnecessary spaces or extra characters in identifier columns.

• Keep your upload files clean and remove any unused rows.

• If you have frequent large uploads, consider aligning your ERP export with kolum’s template to reduce manual preparation.

Next steps

After successfully uploading your imports:

• Your import records will appear in the Imports table.

• You can edit or delete any record individually if changes are required.

• Imported emissions data can now be tracked and linked with your reports seamlessly.