| Parameters | Description | Example | Mandatory |
| ClientId | The short name of the client that owns the order. | Client name: "Stjärna" Client short name: "STJ" | Note |
|---|
You must be sure of which short name to write so the order ends up in the right client system. |
| Yes |
| Orderno | An a available order number. | Info |
|---|
It is not possible to enter the same order number again, the registrant must check for available order numbers and prefix in XTND BackendExtend Commerce Backend. |
| "OC-111222" "12345678" | Yes |
| OrderDate | Orderdate | ÅÅÅÅ-MM-DD hh:mm | No |
| Orderreference | Order reference. Printed as "Your Reference" on order header. | "Anders Andersson" |
|
| CustomerNo | The customer number of the customer that has ordered the products.
| "17" | Info |
|---|
If entering a customer number that don not exists, the customer will be created. (Duplicates are not allowed). Do not mix and create new customers with existing ones. |
| Yes |
| DeliveryMethod | The short name of the available mode of transport for the client and customer.
| "SCHPAR" | Info |
|---|
You can find the short name of the delivery method you desire under the gearwheel in XTND Extend Commerce Backend > Generel settings > Transport settings. |
| No |
| DeliveryName1 | Name for delivery adress, row 1. |
| Yes |
| DeliveryName2 | Name for delivery adress, row 2. |
| No |
| DeliveryAddress1 | Adress for delivery adress, row 1. |
| Yes |
| DeliveryAddress2 | Adress for delivery adress, row 2. |
| No |
| DeliveryAddress3 | Adress for delivery adress, row 3. |
| No |
| DeliveryPostalCode | Postal code for delivery adress.
| "12345" | Note |
|---|
Postal code must be without spaces. |
| Yes |
| DeliveryCity | City, for delivery adress. | Stockholm | Yes |
| DeliveryState | Delivery state. | Type the state if needed or leave empty. | No |
| DeliveryCountry | County for delivery adress. | Type the state as "SE" or "NO" | Yes |
| PhoneNumber | Telephone number of recipient or notification service if such is included with the mode of transport.
| Type the phone number if needed or leave empty | Info |
|---|
Telephone numbers are also saved on the customer for new customer arrangements. On orders, they are saved by telephone and printed on orders under your reference.
(in ConsumerOrder as Phone in ShipTo). |
| No |
| InvoiceName | Name for invoice adress. |
| Yes |
| InvoiceAddress1 | Adress for invoice adress, row 1. |
| Yes |
| InvoiceAddress2 | Adress for invoice adress, row 2. |
| No |
| InvoiceAddress3 | Adress for invoice adress, row 3. |
| No |
| InvoicePostalCode | Postal code for invoice adress. |
| Yes |
| InvoiceCity | City for invoice adress. |
| Yes |
| InvoiceState | State for invocie adress. |
| No |
| InvoiceCountry | Country for invoice adress. |
| Yes |
| AskedDeliverydate |
| ÅÅÅÅ-MM-DD hh:mm | Yes |
| VATno | VAT number. | Note |
|---|
Only to be filled in for new layouts by a new customer. |
|
| No |
| OrgNo | Organisation number. | Note |
|---|
Only to be filled in for new layouts by a new customer. |
|
| No |
| GoodsNotification | Goods notification. Printed as Freight Marking on orders. (In ConsumerOrder as MKS on head) |
| No |
| PaymentType | Type of payment. Entered as: INV: BILLING AUTO: AUTOGIRO ADV: ADVANCEPAYMENT FAC: FACTORING CAS: CASHPAYMENT LAS: LASTSCHRIFT CC: CREDITCARD MOH: MANUALONHOLD FAM: INVOICEME |
| Yes |
| FreightFree | Freight free or not. 0: Freight 1: Freight free |
| Yes |
| RowCounter | Number of rows in the order. | Info |
|---|
If there are 3 lines with the same order number, a 3 is written on each line for the order. |
|
| Yes |
| Orderposition | Order line position. Fill in if you want a special order on the rows. |
| No |
| Item | Product numer. | Note |
|---|
Product must be stored in XTND Backend Extend Commerce Backend and linked to price list, warehouse and supplier agreement. |
|
| Yes |
| ItemName | Product name. | Info |
|---|
This will overwrite existing description. |
|
| No |
| Quantity | Ordered quantity. Always written in integers. |
| Yes |
| Unit | Sales unit. | Note |
|---|
The unit must be set in XTND Extend Commerce Backend and connected to the product and a price list. |
|
| Yes |
| PriceexVAT | Price ex VAT per unit. | Note |
|---|
If price is indicated on a row, all rows in the column must be registered with price. |
|
| No |
| VATPercentRow | VAT in percent. | Note |
|---|
If VAT is entered on a row, all rows in the column must be registered with VAT. |
|
| No |
| Currency | Currency as in ex. SE, DKK or NOK. | Note |
|---|
The currency must be on an active price list for the customer. |
|
| Yes |
| Notes | Notes for order. | Info |
|---|
Written as order line listing on order document. (In ConsumerOrder as MKS) |
|
| No |
| OrderEmail | Email for order confirmation. | "anders.andersson@andersson.se" | No |
| InvoiceEmail | Email for invoice. |
| No |
| Warehouse | Warehouse that's connected to the product. |
| No |
| OrderReviewReasonNotes |
|
| No |
| CustomerGroup | Customer Group column is always empty when exporting the template because this is only used/required if creating new customer.
|
| Yes/No This is only used/required if creating new customer. |