Sales Order Import Multi-File Example
The sales order template that you choose in the Custom Form field on the Advanced menu determines which fields are available on the Mapping page.
Sales Order
|
External ID |
Customer |
Date |
Status |
Sales Order: Location |
|---|---|---|---|---|
|
SORD-003-10009 |
Acme Landscaping |
02/22/2015 |
Pending Approval |
San Mateo |
|
SORD-003-20384 |
Jerry's Catering |
03/21/2015 |
Pending Fulfillment |
Chicago |
|
SORD-003-20384 |
Jerry's Catering |
03/21/2015 |
Pending Fulfillment |
Chicago |
Required fields:
-
External ID
-
Customer — The customer must exist in the account. Use the internal ID.
-
Date
-
Status
The location must exist in the account.
Sales Order Items
|
Sales Order Items: External ID |
Sales Order Items: Item |
Sales Order Items: Quantity |
Sales Order Items: Price Level |
Sales Order Items: Amount |
|---|---|---|---|---|
|
SORD-003-20384 |
Printer |
33 |
Base Price |
3300 |
|
SORD-003-20384 |
Scanner |
85 |
Base Price |
6375 |
|
SORD-003-10009 |
Keyboard |
42 |
Base Price |
2730 |
Required field: line ID or item. Item must exist in the account.
Sales Order — Shipping Address
|
Sales Order – Shipping Address: External ID |
Sales Order - Shipping Address: Country |
Sales Order - Shipping Address: Addressee |
Sales Order - Shipping Address: Address 1 |
Sales Order - Shipping Address: Address 2 |
Sales Order - Shipping Address: City |
Sales Order - Shipping Address: State |
Sales Order - Shipping Address: Zip |
|---|---|---|---|---|---|---|---|
|
SORD-003-20384 |
US |
Sandra Windham |
123 Elm Street |
|
San Francisco |
CA |
98765 |
|
SORD-003-20384 |
Canada |
Jerry Diner |
456 Oak Drive |
#829 |
Toronto |
ON |
N3V 2I3 |
|
SORD-003-10009 |
Czechia |
Martin Dravi |
932 Barva |
|
Brno |
|
6574 |
Required field: Country.
Related Topics
- Sales Order Import
- Custom Form Specification for Sales Order Imports
- Supported Sales Order Sublist Data Imports
- Supported Sales Order Subrecord Data Imports
- Setting Imported Sales Orders' Status
- Setting Sales Orders to Closed
- Importing Currency Values for Sales Orders
- Charging Custom Credit Cards for Imported Sales Orders
- Using Import Assistant for Sales Orders Mass Update