Glossary For Bulk Upload Of Articles
Uploading articles in bulk is the fastest way to add or update many articles in your Kolum workspace while maintaining structured, clean, and compliant data. This glossary explains each field in the articlesTemplateFile Excel sheet, helping you fill in your data accurately and avoid errors during upload.
Using this glossary ensures your uploaded articles are ready for supplier connections, emission tracking, and accurate reporting without friction.
Column-by-Column Details
Name (Mandatory) Enter the name of the article clearly, e.g., “Steel Rod A,” “Aluminium Sheet B.” This name will appear in your articles list for easy identification and linking with suppliers and emissions data.
Description (Optional) Provide a brief description of the article if needed, e.g., “Hardened steel rods,” “Hot-rolled coil.” This helps your team and suppliers understand the product better.
CN Code (Mandatory) Add the customs classification code for the article, e.g., 72042190, 76129030. This is required and must match the article type. If the CN Code does not match the type of article or the production method later provided, the system will throw an error during validation.
Reference Number (Mandatory) Provide your unique identifier for the article, such as GTIN, EAN, or your internal SKU (e.g., 123456, 789012). This ensures tracking consistency across your supply chain.
Reference Number Type (Mandatory) Indicate what type of reference number you have entered. Valid entries:
Type (Mandatory) Choose the article type from the dropdown:
ProducedArticle: If the article is produced in your own facility.
PurchasedArticle: If the article is purchased from a supplier.
This field determines which additional fields will be needed:
For PurchasedArticle, Supplier Identifier is mandatory.
For ProducedArticle, Supplier Identifier can be left empty.
Supplier Identifier (Mandatory for PurchasedArticle) Provide the exact Supplier Identifier (e.g., SUP-1) as it appears in your Kolum workspace. If missing or incorrect, the upload will fail for purchased articles.
For produced articles, this can remain empty.
Country of Origin (Optional) Use the 2-letter country code (e.g., IN for India, CN for China, DE for Germany) to indicate where the article is produced. This helps with reporting and filtering but is not mandatory.
Production Facility Identifier (Optional) Add your internal identifier for the facility where the article is produced, if you wish to track articles by facility. This is optional but can be useful for advanced facility-based reporting.
Production Method (Mandatory if Emissions Provided, Optional Otherwise) If you enter values for Direct Emissions or Indirect Emissions, you must select a production method that matches the CN Code using the dropdown list:
Example options:
P03-Cement
P24-Blast furnace route
P12-Electrolysis of water
P30-Ferro-chromium (FeCr)
If you do not provide emissions data, this field can remain empty.
Direct Emissions (Optional) Numeric value indicating the direct emissions per unit of the article in tonnes CO₂e (e.g., 1.5, 0.8). If provided, ensure the Production Method field is filled.
Indirect Emissions (Optional) Numeric value indicating the indirect emissions per unit of the article in tonnes CO₂e (e.g., 0.5, 0.3). If provided, ensure the Production Method field is filled.
Where to Access the Template
Go to Articles in your kolum workspace.
Click Upload File.
Download the Sample Excel File to ensure you use the correct structure.
Fill in your article data using this glossary as your guide.
Re-upload the file in the upload modal for validation.
Validation & Tips
CN Code, Reference Number, Reference Number Type, and Type are always mandatory.
Supplier Identifier is mandatory for PurchasedArticle and must match existing suppliers.
Production Method is mandatory if emissions data is provided.
Match your CN Code with the relevant Production Method to avoid validation errors.
Use consistent and clear naming for articles to ease later supplier connections.
Use official 2-letter country codes for the Country of Origin field.
Use numeric values only for emissions fields to avoid upload failures.
What Happens Next
Once uploaded and validated, your articles will appear in your kolum workspace under Articles. You can then:
Connect suppliers to articles.
Track and collect emission data from suppliers if applicable.
Edit or delete articles individually if adjustments are needed.
Use your articles for reporting, import tracking, and supply chain management.
Last updated
Was this helpful?