--- title: "Action: Sales orders and order lines" description: "Sales orders (header). Imports sales orders into Sapera, creating or updating the order header with customer, address and order details." url: https://support.sapera.io/en/articles/613-action-sales-orders-and-order-lines collection: "SyncTool" updated: 2026-09-25 language: en alternates: [da] --- # Action: Sales orders and order lines Sales orders (header). Imports sales orders into Sapera, creating or updating the order header with customer, address and order details. **Sales orders (header).** Imports sales orders into Sapera, creating or updating the order header with customer, address and order details. **Order lines.** Imports sales order lines into Sapera, attaching each line to its sales order with product, quantity, price and VAT details. ## How to use the action 1\. Select the action in the **Action** field. 2. Point to your data source – a **file** (CSV or Excel) or a **SQL query**. 3. Map the source columns to Sapera's fields in the column mapping (see _Source fields_ below). 4. Run **Compare** to see what will be created, changed or stay unchanged – without writing to Sapera. 5. Run **Update Sapera** to perform the import. Use the **Allow create** and **Allow update** parameters to control whether new rows are created and whether existing ones are updated. ## How matching and updating works Import the **order header** first (the _Sales orders_ action) and then the **order lines** (the _Sales order lines_ action). - The order header is matched on the order's **identifier** (Identifier); matching orders are updated and new ones created with customer, address and order details. - Each order line is matched on **order identifier + line number**. If the order is in a state that cannot be changed, the line is skipped with a warning. - Direction: from file/SQL into Sapera. ## Key parameters ### Sales orders (header)

Parameter	Explanation
ForceIdentifierInHigherRangeThan	Forces newly created sales order numbers to start above the given value to avoid clashing with existing numbers.
TreatCompletedSalesOrdersAsWarning	When enabled, hitting an already completed sales order is reported as a warning instead of an error.
TreatExistingSalesOrdersAsWarning	When enabled, hitting an already existing sales order is reported as a warning instead of an error.

### Order lines

Parameter	Explanation
ForceSalesOrderIdentifierInHigherRangeThan	Forces newly created sales order numbers to start above the given value to avoid clashing with existing numbers.
TreatCompletedSalesOrdersAsWarning	When enabled, a line belonging to an already completed sales order is reported as a warning instead of an error.
TreatExistingSalesOrdersAsWarning	When enabled, a line belonging to an already existing sales order is reported as a warning instead of an error.

## Source fields ### Sales orders (header)

Field	Explanation
AddressLine1	First line of the order address.
AddressLine2	Second line of the order address.
Country	Country of the order address.
CurrencyCode	Currency code of the sales order, for example DKK or EUR.
CurrencyRate	Exchange rate applied to the order currency.
CustomerEmail	Email address of the customer.
CustomerFullName	Full name of the customer on the sales order.
CustomerIdentifier	Identifier of the customer the sales order belongs to.
CustomerOrganizationIdentifier	Organization or CVR number of the customer.
CustomerPhone	Phone number of the customer.
CustomerReferenceNumber	Customer reference shown on the sales order.
Identifier	Unique identifier (order number) of the sales order.
InternalNote	Internal note not shown to the customer.
InvoiceDate	Invoice date applied to the sales order.
IsCostPriceOrder	Whether the order is priced at cost price.
IsExemptVat	Whether the sales order is exempt from VAT.
MaxTotal	Maximum allowed total for the sales order.
OtherPayerIdentifier	Identifier of an alternative payer when someone other than the customer pays.
ParentSalesOrder	Identifier of a parent sales order this order is linked to.
PaymentTerm	Payment term applied to the sales order.
PostalCode	Postal code of the order address.
PostalDistrict	Postal district or city of the order address.
PromisedCompletionDate	Promised completion or delivery date of the order.
PublicNote	Public note shown on the sales order.
RelatedProductInstanceIdentifier	Identifier of a related serial-number item linked to the sales order.
RequisitionNumber	Requisition number associated with the sales order.
SalesOrderType	Type of the sales order.
Subject	Subject or heading of the sales order.

### Order lines

Field	Explanation
AwaitsDeliveryQuantity	Quantity on the line still awaiting delivery.
ContraAccountAccountNumber	Contra account number used when posting the line.
CostPrice	Unit cost price of the line.
DiscountAccountNumber	Financial account number used for the line discount.
DisplayName	Text shown for the line on the sales order.
InstanceIdentifier	Identifier of the specific serial-number item on the line.
IsExemptVat	Whether the line is exempt from VAT.
ItemOrder	Sequence number that orders the line within its sales order.
LocationDisplayName	Display name of the location associated with the line.
ManualDiscountAmount	Manual discount amount applied to the line.
Price	Unit sales price of the line.
ProductDisplayName	Display name of the product on the line.
ProductIdentifier	Identifier of the product on the line.
ProductKind	Kind of product on the line.
Quantity	Quantity ordered on the line.
SaleFinancialAccountNumber	Sales financial account number the line revenue is posted to.
SalesOrderIdentifier	Identifier of the sales order this line belongs to.
UsedVatFinancialAccountNumber	Financial account number actually used for the line VAT when posting.
UsedVatRate	Actual VAT rate used when posting the line.
VatAccountNumber	Financial account number used for the line VAT.
VatRate	VAT rate applied to the line.

* * * See also the overview [SyncTool – actions](https://support.sapera.io/en/articles/547-synctool-handlinger.md). * * * **Want to know more?** Read more in these related articles: [ Standard parameters for all actions The general parameters available on most SyncTool actions: step control, error handling, timeout, etc. ](https://support.sapera.io/en/articles/648.md)