Import guide for CSV uploads
Last updated: November 13, 2026
In the Coolset platform you can upload the following items in bulk using a csv upload:
Products,
Suppliers,
Order items (purchase or sales orders)
Origins.
Before you start
Each category has its own required columns and data types.
It’s important to use the exact column names and fill in the correct data types as shown in the template or the table provided below.
You can either:
Create your own CSV file following the required structure, or
Download a preformatted template directly from the platform.
Downloading the template
In the Coolset platform, select the category you’d like to upload.
Click “Import” in the top-right corner.
Download the provided CSV template for that category.

Opening the CSV template in Microsoft Excel
The template is a .csv file.
To open it with columns correctly displayed in Excel:
Open Microsoft Excel.
Go to the Data tab.
Click Get Data → From Text/CSV.
Select your downloaded template file and load the data.
Your file will now appear in a clear column structure.

Filling the template
When completing the template (or creating your own), follow the tables at the end of this page for guidance:
Column Name – The exact names to use for the columns in your file.
Data Type – The format of data expected in each column (e.g., text, number).
Description – Explains what information to provide.
Required – Indicates if the column must be filled in for a successful upload.
Uploading Your CSV File
Once your CSV file is ready:
Go to the item you want to upload to.
Click “Import” in the top-right corner.
Drag and drop your file into the upload area, or click the box to browse your computer.
Once your file is selected, click “Import” to start the upload.
Before you upload, check two things:
Save the file as CSV UTF-8. Coolset can only read CSV files saved in UTF-8 encoding. Excel often saves CSVs in a regional format instead, and this is the most common reason an upload fails. In Excel, go to File → Save As and choose CSV UTF-8 (Comma delimited) (.csv) as the file type.
One error stops the whole upload. If any row in your file has an error, nothing in the file is imported, including the rows that were correct. Fix the row that failed and upload the complete file again.
What happens when I upload the same file again? A re-import updates existing records and adds new ones. It never deletes anything. Coolset matches each row to an existing record by its external_id.

Required columns and descriptions
Products
Column name | Data type | Description | Required |
external_id | text | Unique identifier of the product from your external system (e.g., ERP, CRM). Used for linking data across systems. | TRUE |
name | text | The name of the product. | TRUE |
description | text | Additional descriptive information about the product. | FALSE |
hs_code | A whole number maximum 6 digits (no decimals) | The Harmonized System (HS) code identifying the product for customs classification. | TRUE |
commodity | text | The commodity category the product falls under (e.g. cattle, cocoa, coffee, palm_oil, rubber, soya and wood). | TRUE |
scientific_name | text | The scientific name of the species. Required only for wood-based products. | FALSE |
common_name | text | The common (non-scientific) name of the species. Required only for wood-based products. | FALSE |
sku | text | The stock keeping unit (SKU) of the product. | TRUE |
type | text | Indicates whether the product is produced, purchased, or manufactured. | TRUE |
bill_of_materials | text | Comma-separated list of external_ids of products that make up this product’s bill of materials (if manufactured). | FALSE |
Suppliers
Column name | Data type | Description | Required |
|---|---|---|---|
external_id | text | Unique ID from your ERP or CRM | TRUE |
company_name | text | Legal name of the supplier | TRUE |
description | text | Optional notes about the supplier | FALSE |
country_code | text (2 characters) | ISO 3166-1 alpha-2 code (e.g. NL, DE) | TRUE |
is_self_managed | TRUE or FALSE | Set to TRUE if you are self-declaring on behalf of this supplier | FALSE |
contact_name | text | Primary contact person, leave blank if self-managing | FALSE |
contact_email | text | Contact email used for invitations, leave blank if self-managing | FALSE |
additional_contact_emails | text | Extra email addresses to invite from the same supplier, in addition to the main contact. | FALSE |
type | text | The type of value chain partner. Always fill in "supplier" | TRUE |
Order items
Column name | Data type | Description | Required |
external_id | text | Unique identifier of the order item from your external system (e.g., ERP, CRM). Used for linking data across systems. | TRUE |
action | text | The type of activity for this order. Action is either 'buying' or 'selling'. | TRUE |
border_cross_country_code | text | Code of the EU country where the goods enter or leave the EU, i.e. NL, DE. | TRUE |
order_external_id | text | Identifier of the associated order. All items belonging to the same order share this ID. | TRUE |
order_created_at | date | The date the order was created (format: YYYY-MM-DD). | TRUE |
order_arrival_at | date | The date the order is expected to arrive (format: YYYY-MM-DD). | FALSE |
value_chain_external_id | text | External ID of the supplier (matching the supplier’s external_id from the supplier import). | TRUE |
buyer_product_external_id | text | External ID of the product (matching the product’s external_id from the product import). | TRUE when action is buying |
seller_product_external_id | text | External ID of the product (matching the product's external_id from the product import). | TRUE when action is selling |
volume | A number with decimals | Quantity of product included in the order item. | TRUE |
unit | text (max 3 characters) | Measurement unit of the product: kg. | TRUE |
Origins
Column name | Data type | Description | Required |
external_id | text | Unique identifier from your external system (e.g., ERP, CRM). Used for linking data across systems. | FALSE |
name | text | Human-readable name of the area or origin | TRUE |
description | text | Optional text describing the origin | FALSE |
country_code | text (max 2 characters) | ISO 3166-1 alpha-2 code (e.g., NL, FR, US) | TRUE |
coordinates | text (GeoJSON format) | Array of coordinates in [longitude, latitude] order; can represent a point or polygon boundary. | TRUE |