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

General Notices