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

  1. In the Coolset platform, select the category you’d like to upload.

  2. Click “Import” in the top-right corner.

  3. Download the provided CSV template for that category.

Screenshot 2025-10-09 at 16.37.11.png

Opening the CSV template in Microsoft Excel

The template is a .csv file.
To open it with columns correctly displayed in Excel:

  1. Open Microsoft Excel.

  2. Go to the Data tab.

  3. Click Get Data → From Text/CSV.

  4. Select your downloaded template file and load the data.

Your file will now appear in a clear column structure.

Screenshot 2025-10-09 at 16.39.40.png

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:

  1. Go to the item you want to upload to.

  2. Click “Import” in the top-right corner.

  3. Drag and drop your file into the upload area, or click the box to browse your computer.

  4. 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.

Screenshot 2025-10-09 at 16.51.46.png

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