---
title: "Data import - Importing product data"
description: "A comprehensive guide to importing product data. This process populates the product catalog in bulk, streamlining order creation and ensuring consistency in descriptions and units of measure."
url: https://help.qargo.com/us/articles/410133-data-import-importing-product-data
locale: us
updated: 2026-02-26
---

# Data import - Importing product data

Importing product data allows a business to quickly populate its product catalog in Qargo. This is highly beneficial for organizations that transport a defined list of items. It streamlines the order creation process and ensures consistency in descriptions and units of measure. This article outlines the specific requirements, best practices, and common issues related to importing product data.

* * *

## 📖 Key terminology {#h_0f4a4a0dbc}

For clarity throughout this guide, the following terms are defined.

-   **ADR:** The **European Agreement concerning the International Transportation of Hazardous Materials by Road**. This treaty governs the safe transport of hazardous materials (HazMat) across international borders. It establishes regulations for their packaging, labeling, and documentation.
-   **Product:** A specific item or commodity that can be added to an order and transported.
-   **Product type:** A high-level classification used to group products with shared characteristics, such as packaging or form factor. For example, a single product type like **'Box'** can contain multiple individual products.


* * *

## ✅ Critical import requirements for products {#h_c5119125b9}

Before importing product data, the following requirements and warnings must be considered to ensure data integrity.

-   **Code:** Each product must have a unique **Code**. The import will fail if a duplicate code is detected within the import file or if it already exists in the Qargo system.
-   **Mandatory fields:** The product **Name** and **Type** are mandatory fields. An import will fail if either of these is left blank.


* * *

## 🛠️ Step-by-step data import process {#h_38b6b0b38e}

## Step 1: Download the template {#h_40aed53408}

A specific spreadsheet template is available to upload product data. **To edit and upload the data, a copy of the template must be downloaded:**

1.  Click the link: [Product data import template](https://docs.google.com/spreadsheets/d/1NFJZceH7FvUJWY6wSIzEROVpBGBiucTbcS-aoWyNlfk/edit?usp=sharing)
2.  Once the template opens, go to **File** and select **Download**
3.  Save the template **(in .xlsx or .csv format)** to the computer and begin entering the company data.

![](https://help.qargo.com/media/0a04b700cf85-image.png)

:::callout{tone="info"}
📚 Always use a blank template downloaded directly from here or provided by the Qargo team. Reusing an old template may lead to import errors
:::

## Step 2: Fill in the Excel template {#h_7cb8aa1d08}

Open the template and populate it with the required data. The template contains column headers that correspond to the fields in Qargo.

-   **Required fields:** Fill out all the required fields (a comprehensive list of required fields can be found in the next section of this article). An import will fail if these fields are left blank.
-   **Formatting:** Pay close attention to the specified data format (e.g., dates, numbers, text).


## Step 3: Submit for upload {#h_4d6b033ea1}

1.  **During onboarding:** Work directly with the **onboarding manager** to upload the initial business data. The onboarding manager guides the process and ensures a successful import.
2.  **After onboarding:** For all future data updates and imports, contact the **account manager**. The account manager assists with the upload process and provides ongoing support.


* * *

## 📝 Details of the product import template {#h_ada5ac2e6d}

The following table provides a detailed, field-by-field explanation of the Excel template for product import. It includes data formats, required fields, and best practices for populating each column.

| Column name | Required/optional | Remarks | Example |
| --- | --- | --- | --- |
| name | Required | Product name displayed in Qargo | Aardappelen |
| description | Optional |  |  |
| code | Optional |  |  |
| product\_type\_name | Required | Product type configured in Qargo. One product type can have multiple products. |  |
| adr\_internal\_code | Optional | ADR internal code assigned to the product. |  |
| adr\_edition | Optional | Edition of the ADR regulations. |  |
| adr\_class | Optional | ADR hazard class of the product. |  |
| un\_number | Optional | United Nations (UN) number for the hazardous material. |  |
| packing\_group | Optional |  |  |
| specific\_gravity | Optional | Specific gravity of the product. |  |
| absolute\_min\_temperature | Optional | Lowest temperature the product can handle. |  |
| absolute\_max\_temperature | Optional | Highest temperature the product can handle. |  |
| loading\_meters | Optional | Space the product occupies in loading meters. |  |
| pallet\_spaces | Optional | Number of standard pallet spaces the product occupies. |  |
| actual\_pickup\_temperature | Optional | Actual temperature of the product at pickup. |  |
| actual\_delivery\_temperature | Optional | Actual temperature of the product at delivery. |  |
| custom\_fields\_\_example | Optional | To import custom field values. Note: the format uses a double underscore (`__`) to connect the prefix **custom\_fields** to the unique field ID |  |

* * *

## 🔎 Troubleshooting common product import errors {#h_3692564b3c}

This section addresses specific errors that may arise during the import of product data.

-   **Duplicate product code:** The most common error occurs when a product **Code** in the template already exists in Qargo. Each code must be unique.
-   **Missing mandatory fields:** The import will fail for any row where the product **Name** or **Type** is left blank.
-   **Sheet name:** The sheet in the Excel template file must be named exactly **'Import'**. Any other name will cause an error when uploading the file.
-   **Case-sensitive column headers:** Column headers must be entered with the correct casing (e.g., `vat_number`, not `VAT_number`). Incorrect casing causes the data in that column to be silently ignored and not imported, as the system will not recognize the header.
-   **Leading apostrophe errors:** Data in a cell cannot begin with an apostrophe ('). If an apostrophe is used, the system will not recognize the value, and an error may occur. **This rule is waived only if the article explicitly instructs that an apostrophe should be used for a specific field.**
-   **Custom fields:** The column name must follow the convention **custom\_field\_\_\[ID\]** (the double underscore must be kept to connect the prefix **custom\_field** to the unique field ID). The specific ID is retrieved from the Qargo organization settings. Click the copy button next to the custom field to copy its ID:

    ![](https://help.qargo.com/media/8975b9ff9647-796a5c17-3b5e-4a0d-9642-08cfd8176cd4.png)


* * *

## ✨ Best practices for importing products {#h_2395fd4790}

To ensure a smooth and accurate import, consider the following best practices.

-   **Maintain consistent units:** Using a standard and consistent set of units of measure for all products ensures accuracy and avoids confusion during order creation.
-   **Test with a small batch:** It is recommended to first test the import process with a small sample of 5–10 products. This verifies that the data is formatted correctly before uploading a full catalog.


* * *

## ➡️ What to do next {#h_515218a975}

Once products have been successfully imported, they are available for use within the platform. The next logical step is to begin creating new orders and selecting these products from the catalog.

* * *

## 📈 Use cases for product import {#h_a2e599bfd2}

Importing product data is an invaluable tool for several key business processes.

-   **Populating the catalog:** The primary use case is to populate an entire product catalog in bulk. This ensures all commonly transported items are available in the system.
-   **Simplified order creation:** A predefined list of products allows dispatchers and sales teams to create orders more quickly and accurately. They simply select from a list rather than manually entering product details each time.


## Related articles

- [Data import: importing container data](https://help.qargo.com/us/articles/410131-data-import-importing-container-data.md)
- [Data import: importing order data](https://help.qargo.com/us/articles/418636-data-import-importing-order-data.md)
- [Data import: Importing contact data](https://help.qargo.com/us/articles/410121-data-import-importing-contact-data.md)
- [Data import: Importing driver data](https://help.qargo.com/us/articles/410123-data-import-importing-driver-data.md)
- [Data import – importing contact location data](https://help.qargo.com/us/articles/494334-data-import-importing-contact-location-data.md)
