Create and update an External Order
This page explains how to create new external orders or update existing ones using the CSV import job.
✅ Prerequisites
Before importing external orders, make sure the following conditions are met:
- The Supplier (Supplier External Id) must already exist in DJUST
- The Account (Account External Id) and the Customer User must already exist in DJUST
- The update is only permitted if the Order Logistic is in a status that supports modification:
For detailed rules regarding what can be updated based on the current status of the Order Logistic, refer to the Update Rules Based on Order Logistic Status section.
⚙️ How It Works
Each row in the CSV represents one Order Line.
You may:
- Use the same Order External Id across multiple rows to create a multi-line order
- Use the same Order Line External Id across imports to update that line
- Add a new line by using a new Order Line External Id under an existing order
📋 Fields
Required fields
| Field name | Required | Editable | Default Value |
|---|---|---|---|
| Order External Id | ✅ | — | — |
| Order Line External Id | ✅ | — | — |
| Account External Id | ✅ | — | — |
| Supplier External Id | ✅ | — | — |
| Net Unit Price | ☑️ (unless Offer Price External Id is provided) | ✔️ | — |
| Order Line Quantity | ✅ | ✔️ | — |
| Offer Price External Id | ☑️ (unless Variant External Id and/or Net Unit Priceare provided) | — | — |
| Variant External Id | ☑️ (unless Offer Price External Id is provided) | — | — |
✅ Required ☑️ Conditionally required
Required Custom FieldsAny custom fields configured as required in DJUST must also be included in the CSV.
Optional fields
| Field name | Required | Editable | Default Value |
|---|---|---|---|
| Order Status | — | — | ORDER_DRAFT_ON_HOLD |
| Gross Unit Price | — | ✔️ | — |
| Classification External Id | — | ✔️ | — |
| Customer External Id | — | — | The first Customer User associated with the Account |
| Tax Amount | — | ✔️ | — |
| Variant Name | — | ✔️ | — |
| Variant Description | — | ✔️ | — |
| Shipping Address Full Name | ☑️ Required if any shipping field is filled¹ | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address Country | ☑️ Required if any shipping field is filled¹ | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address Street Name | ☑️ Required if any shipping field is filled¹ | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address City | ☑️ Required if any shipping field is filled¹ | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address Zip Code | ☑️ Required if any shipping field is filled¹ | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address State | — | ✔️ | The first Shipping Address associated with the Account |
| Shipping Address (Additional) | — | ✔️ | The first Shipping Address associated with the Account |
| Mark Order Line For Deletion | — | ✔️ | False |
¹ These fields become required if at least one of them is provided. This rule does not apply to Shipping Address State or Shipping Address Additional.
📌 Key Business Rules
- If both Offer Price External Id and Variant External Id are provided:
- The variant must exist in DJUST.
- It must be linked to the provided offer.
- Each CSV row represents one order line.
- You may create multiple lines for the same order in the same file.
Updated 10 days ago