Importing a production order from Excel

  • Updated

Introduction

This guide explains how to use the Quick add order feature in TRAEDE to create production orders from Excel files. You can use this tool to generate a single production order or multiple production orders at once, making it especially useful when working with larger assortments or repeated workflows.

 

 

Create a single production order with simple Excel import

  1. Go to ProductionQuick add order.

  2. Select Simple Excel import.

    • This option creates one production order from your Excel sheet.

  3. Click Download template to get the correct Excel format.

Fill out the Excel template by adding:

  • SKU (e.g., cool product - series 1 - user 1)

  • Quantity per line (e.g., 10)

You do not need to convert the file to CSV. Save the Excel file normally.

  1. Upload the file using drag-and-drop or by clicking Browse.

  2. Click Create production order.

A new production order will be created automatically.
Opening it will show the products with the quantities you entered.


Create multiple production orders using Multi without deliveries

If you want to generate several production orders from one Excel sheet:

  1. Go to Quick add order.

  2. Select Multi without deliveries.

  3. Click Download template.

This template requires the supplier number.
To find a supplier number, open the supplier in TRAEDE and locate its ID.

Complete the Excel template

In the sheet, fill out:

  • Supplier number (e.g., 5 for My new supplier, 4 for Supplier D)

  • Batch number (used to group lines into the same production order)

    • Example: Lines with batch 1 become one PO, lines with batch 2 become another

    • This does not determine the final production order number in TRAEDE

  • SKU

  • Quantity

Example structure:

SupplierBatchSKUQty
51cool product – user 1.0110
51cool product – user 1.0210
42cool product – user 1.0110
42cool product – user 1.0210

Save the file (no CSV conversion needed).

  1. Upload your file.

  2. Click Create production order.

TRAEDE will now generate two new production orders, each containing the products grouped by batch.


Summary

Using Quick add order allows you to create production orders rapidly with minimal manual input.

  • Simple Excel import → creates one production order

  • Multi without deliveries → creates multiple production orders from one file

This is especially useful for large assortments, repeats, or bulk production planning.

Was this article helpful?

0 out of 0 found this helpful