# Loading products into a production order from Excel

URL: https://bimpsoft.com/en/help/production/production-order-import/
Updated: 2026-11-06

> Importing from Excel adds many products to a production order at once, and the system pulls in materials by specifications. In the created order, on the "Products" tab click "Import" and choose a file with the columns "Product", "Specification", "Modification", "Quantity" and "Unit". The names in the file must match the names in Bimp exactly.

## When you need to import products

Importing products from Excel saves time when you need to add dozens of items with specifications to a production order. The manager does not pick every part manually: Bimp pulls the product composition from the specification and calculates materials for the given quantity. For example, the product "Bracelet" with the specification "Classic" in a quantity of 100 pcs is broken down into gold, clasps and stones automatically.

## Before you start

1. All products (finished products and components) must be created in Bimp.
2. The specifications of these products must be set up. See [Specifications](https://bimpsoft.com/en/help/production/specifications/).

> [!WARNING] The names of products and specifications in the file must match Bimp completely. One extra space or a typo in a letter, and the row will not load.

## How to prepare the file

| Column | What to enter |
|---|---|
| "Product" | The full name of the finished product |
| "Specification" | The name of the product's specification. If left empty, only the product is loaded, without components |
| "Modification" | Fill in if the product has [variants](https://bimpsoft.com/en/help/products/variants/) (color, size) |
| "Quantity" | How many units to make |
| "Unit" | Must match the units in the system (pcs, kg, m) |

![Excel file with the columns Product, Specification, Modification, Quantity, Unit and one row: "Jewelry production", specification "Bolts", quantity 14, unit "pcs"](https://bimpsoft.com/help/_img/4d391b05-7928-471a-837c-af14740ee4be.webp)

## How to load the file

1. Open **Production → Production orders** and click **Create**.
2. On the "Products" tab click **Import**.
3. In the "Import file" window choose the file and click **Import**.

   ![The "Import file" window in a new production order: the selected file "Production order import template (1).xlsx" and the Import button; the Import button on the "Products" tab is highlighted](https://bimpsoft.com/help/_img/07e69b69-ac5e-4a6d-b111-46eb2efa8b1f.webp)

4. Check the result: the "Products" tab is filled in, and the list of its materials is expanded under the product.

   ![The "Products" tab after the import: the product "Jewelry production" with the specification "Bolts" in a quantity of 14 and three nested component rows of 14 pcs each](https://bimpsoft.com/help/_img/0bab12ae-4cea-4d1c-ade6-8bdee525c893.webp)

Then save the order and continue as described in [Production order](https://bimpsoft.com/en/help/production/production-order/): check the materials, reserve them and create an assembly.

## FAQ

**Why did the import not load the products?**

Most often the product or specification names in the file do not match the names in Bimp: an extra space or a typo in a letter is enough. Compare the names with the catalogs.

**What happens if I do not enter a specification in the file?**

The system loads only the name of the finished product without its list of components.

**Where do I get the file template?**

During the import, in the "Import file" window, use the template "Production order import template".