Supported Sales Order Sublist Data Imports
The Sales Orders import supports the import of the following sublist data:
Sublist |
Notes |
---|---|
Accounting Book Detail |
Available only when the Multi-Book Accounting feature is enabled, and only when more than one active accounting book exists. Selectively updateable based on Accounting Book key field. |
Auth. Code |
When the Gift Certificates feature is enabled. |
Items |
You must import at least one line item for all new records, and you must map required fields for this sublist on the Field Mapping page. See Required Items Sublist Fields for Transactions Imports. Selectively updatable based on Line/Order Line or Item key field. See Line Item Updates on Transactions Imports. |
Partners |
When the Multi-Partner Management feature is enabled. Selectively updatable based on Internal ID, External ID, or Partner. |
Sales Team |
When the Team Selling feature is enabled. |
Shipment |
When the Multiple Shipping Routes feature is enabled. |
If the Item Options feature is enabled in your account, you can import values for custom transaction item options along with Items sublist data. Transaction item options must first be set up at Customization > Lists, Records, & Fields > Transaction Item Options > New, with one of the following Applies To settings: Sale, All Items. For details, see Importing Transaction Item Options.
For imports that update existing Sales Order records, handling of sublist data updates depends upon the setting for the Overwrite Sublists advanced option, and on whether the sublist is keyed. Complete deletion of sublist data currently is not supported. For more information, see Sublist Data Import.
For non-keyed sublists, you shouldn't update main transaction fields and sublist fields during the same import job.
Related Topics
- Sales Order Import
- Custom Form Specification for Sales Order 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
- Sales Order Import Multi-File Example