How to Import Orders into Extensiv (3PL Warehouse Manager)
1.7 min read
|Absolutely — here’s a clean, warehouse-friendly Help Article version you can use in your internal knowledge base or share with customers 👇
📦 How to Import Orders into Extensiv (3PL Warehouse Manager)
Importing orders is one of the fastest ways to bring in large batches of shipments for fulfillment.
This guide explains which fields are required, what each means, and how to use the official import template.
🧩 Option 1: Use the Official Extensiv Order Import Template
Download the latest template:
👉 Order Import Template (CSV)
This file contains 35 columns, but you don’t need to fill them all in.
Only a small number of fields are required for the import to succeed.
✅ Required Fields (Minimum for a Valid Order)
| Field Name | Description | Example |
|---|---|---|
| Customer Name | The customer (your 3PL client) the order belongs to. Must match exactly in your account. | ABC Electronics |
| Facility Name | The warehouse / facility where the order will ship from. | Los Angeles DC |
| Reference Num | Your internal or external order reference. Must be unique. | WEB-12345 |
| Ship To Company Name | Company name for the delivery address. | Target Stores |
| Ship To Name | Contact name for delivery. | John Doe |
| Ship To Address 1 | Street address. | 222 N PCH Hwy |
| Ship To City | City name. | Redondo Beach |
| Ship To State | State abbreviation. | CA |
| Ship To Zip | ZIP or postal code. | 90277 |
| Ship To Country | Country code (2-letter). | US |
| SKU | Product SKU (must exist in your inventory). | B163500708 |
| Qty | Quantity to ship. | 10 |
⚙️ Recommended (but not strictly required)
| Field Name | Purpose |
|---|---|
| Ship To Phone Number | Helps with parcel carriers and delivery notifications |
| Ship To Email Address | Useful for shipment confirmations |
| Carrier / Mode / Billing Code | If provided, auto-assigns routing info |
⚙️ Option 2: Importing Orders via API (Custom CSV)
If you’re uploading orders programmatically using the Extensiv API (for example, via /importOrdersFromCsv), the minimum required data is the same as above but in JSON or CSV field format:
{
"customerIdentifier": { "name": "ABC Electronics" },
"facilityIdentifier": { "name": "Los Angeles DC" },
"referenceNum": "WEB-12345",
"shipTo": {
"companyName": "Target Stores",
"address1": "222 N PCH Hwy",
"city": "Redondo Beach",
"state": "CA",
"zip": "90277",
"country": "US"
},
"orderItems": [
{ "itemIdentifier": { "sku": "B163500708" }, "qty": 10 }
]
}
⚠️ Common Errors and Fixes
| Error Message | Cause | How to Fix |
|---|---|---|
Customer not found |
Customer name doesn’t match your Extensiv account. | Double-check spelling/capitalization. |
Facility not found |
Invalid or missing Facility Name. | Use the exact facility name. |
Duplicate Reference Number |
The same Reference Num already exists. |
Use a unique order number. |
No items on order |
SKU or Qty missing. | Add at least one SKU with quantity. |
🧾 Example: Valid Minimal Order (CSV Row)
Customer Name,Facility Name,Reference Num,Ship To Company Name,Ship To Name,Ship To Address 1,Ship To City,Ship To State,Ship To Zip,Ship To Country,SKU,Qty
ABC Electronics,Los Angeles DC,WEB-12345,Target Stores,John Doe,222 N PCH Hwy,Redondo Beach,CA,90277,US,B163500708,10
🔗 Related Links
Extensiv API Onboarding Portal
Would you like me to format this as a Markdown (.md) help article file (ready for your KB or portal upload)?