Bulk Upload Articles

Uploading articles in bulk helps you save time by adding multiple articles at once instead of creating them individually. This is especially useful if your organization manages a large number of articles and suppliers. Before starting, ensure your suppliers are already created in the system, as you will need their identifiers for the upload to succeed. The bulk upload feature helps maintain structured, accurate data while allowing you to manage article lifecycles efficiently within your supply chain.

What You Need to Know

• Reference Number and Reference Number Type are mandatory for each article.

• Supplier Identifier is mandatory for all articles.

• CN Code is mandatory for every article you upload.

• If you provide Direct and Indirect Emissions, then Production Method becomes mandatory and must match the CN Code; otherwise, it will show an error during upload.

• If you do not provide emissions data, the Production Method field remains optional.

• Description is optional.

• Production Facility Identifier is optional.

Tip: Always use the correct Production Method corresponding to your CN Code; incorrect combinations will result in upload errors.

How to Bulk Upload Articles

1. Download the Template

   • Go to Articles in your Kolum workspace.

   • Click on Upload File and download the Sample Excel template.

2. Fill in the Template

   • Enter:

     • Name

     • Description (optional)

     • CN Code (mandatory)

     • Reference Number (mandatory)

     • Reference Number Type (mandatory; e.g., GTIN, EAN)

     • Type (ProducedArticle or PurchasedArticle)

     • Supplier Identifier (mandatory)

     • Country of Origin

     • Production Facility Identifier (optional)

     • Production Method (mandatory if emissions are provided)

     • Direct Emissions (optional)

     • Indirect Emissions (optional)

   • Ensure all identifiers and codes match your system data to avoid upload errors.

3. Upload the File

   • Return to the Articles page in Kolum.

   • Click Upload File and select your completed template.

   • The system will validate your data and highlight any rows with missing or incorrect values.

   • Correct any highlighted errors in your Excel sheet and re-upload until there are no invalid entries.

4. Review and Confirm

   • Once validated, you will see a confirmation screen with all your articles listed as valid.

   • Click Upload File to complete the upload process.

   • Your articles will now appear in your Articles list, and suppliers will see these articles on their side if they are connected.

What Happens Next

• Your articles will be visible in the Articles section.

• Suppliers connected to these articles will see them on their side and can provide emissions data if needed.

• You can always edit or delete articles after upload if adjustments are needed.