Introduction

This guide explains how to use the Quick add order – Multi with deliveries feature in TRAEDE to create several production orders and their related deliveries in one single Excel import.
This workflow is useful when working with large product ranges or when you need to pre-plan multiple deliveries across different suppliers.

Start the multi-with-deliveries import

1. Go to Production → Quick add order.

2. Select Multi with deliveries.

3. Click Download template to get the Excel structure required for the import.

Understand the goal of the import

In this example, we will create:

• Two production orders, each from a different supplier

• Two deliveries per production order

• Each delivery contains two variants of the same product

• Quantities on the production order will be the sum of quantities on its deliveries

Fill out the Excel template

1. Supplier numbers

Enter the supplier number for each line:

5  
5  
4  
4  

This means:

• Supplier 5 → 1 production order with 2 deliveries

• Supplier 4 → 1 production order with 2 deliveries

2. Production order batch numbers

Add batch numbers to indicate which lines belong to the same production order:

1  
1  
2  
2

Batch 1 = one production order
Batch 2 = another production order

3. Delivery numbers

List each delivery separately. Since each production order has two deliveries—and each delivery has two variants—you write all delivery lines out:

1 1  
1 1  
1 2  
1 2  
2 1  
2 1  
2 2  
2 2

(Format varies based on the specific template layout, but the principle remains: each delivery gets its own grouping.)

4. Delivery dates

Enter the expected delivery date for each delivery. Example:

• Delivery 1 of Production Order 1: 1 October

• Delivery 2 of Production Order 1: 1 November

• Delivery 1 of Production Order 2: 15 October

• Delivery 2 of Production Order 2: 15 November

Copy the delivery dates down for each variant line.

5. SKUs

Enter the variants for each line. Example:

coolproduct - c01.201  
coolproduct - c01.202  
coolproduct - c01.201  
coolproduct - c01.202  
...

Each delivery lists the two variants.

6. Quantities

Add ordered quantities.
Since each delivery has 5 units per variant, and both deliveries belong to the same production order, the parent production order will show 10 units (5 + 5).

Example:

5  
5  
5  
5  
5  
5  
5  
5

Upload your Excel file

1. Save the Excel file (no CSV conversion required).

2. Return to TRAEDE and upload your file via drag-and-drop or Browse.

3. Click Create production order.

TRA EDE will now generate:

• Two production orders

• Four deliveries (two per production order)

Review the result

Open each new production order:

• The production order quantity will reflect the sum of all deliveries.

  • Example: 5 units per variant × 2 deliveries = 10 units on the production order

• Under each production order, open the deliveries:

  • Each delivery shows 5 units per variant

  • Delivery dates match those entered in the Excel template