Page History
XML sales order
In this section, you are able to configure a XML sales order export either via FTP or a web service.
Info |
---|
If you wish to test or review the latest version of the XML sales order, you can download it here. |
Tabular message description
This table describes each XML element/tag and is continuously updated with the latest version being 38.
XML Tags / Attributes | Length | It. | Type | Description | ||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
<?xml version="1.0" encoding="utf-8"?> | XML version and encoding | |||||||||||
<Order Id="489307" XMLVersion="38"> | Sales order ID and XML version | |||||||||||
|-- <OrderHeader> | ||||||||||||
| |-- <Source> | string | |||||||||||
| |-- <ExternalSystemOrderNo> | int | Sales order number | ||||||||||
| |-- <OrderDate raw=123456"> | Sales order date with format 2024-03-25T23:02:07+0100 | |||||||||||
| |-- <CreatedBy> | 0 | string | Ordered by, first name + last name | |||||||||
| |-- <CreatedByEmail> | string | Ordered by, email-address | ||||||||||
| |-- <OrderNumber> | int | Sales order number | ||||||||||
| |-- <ExternalOrderNumber> | string | External sales order number, custom value | ||||||||||
| |-- <ExternalOrderReference> | string | External order reference, custom value | ||||||||||
| |-- <CustomerNo> | string | Customer number | ||||||||||
| |-- <CustomerId> | int | Nettailer customer id | ||||||||||
| |-- <CustomerGroupId> | string | Customer group id | ||||||||||
| |-- <CustomerGroupName> | string | Customer group name | ||||||||||
| |-- <CustomerGLN> | 0 | string | Customer GLN number | |||||||||
| |-- <CustomerErpId> | string | customer ERP id | ||||||||||
| |-- <CustomerGroupErpId> | string | Customer group ERP id | ||||||||||
| |-- <SalesPersonExportId> | string | Sales person export id | ||||||||||
| |-- <GoodsLabel> | string | Goods label | ||||||||||
| |-- <Currency> | string | Currency code e.g. EUR | ||||||||||
| |-- <CurrencyId> | int | Nettailer currency id | ||||||||||
| |-- <CurrencyDisplay> | string | Displayed curreny code | ||||||||||
| |-- <CurrencyDisplayId> | int | Displayed Nettailer currency id | ||||||||||
| |-- <CustomerPO> | string | Customer reference | ||||||||||
| |-- <InvoiceReference> | string | Invoice reference | ||||||||||
| |-- <Status> | int | Nettailer order status id | ||||||||||
| |-- <IsDirectDelivery> | string | Direct delivery, true or false | ||||||||||
| |-- <OrderAttester> | string | Order attester / approver | ||||||||||
| |-- <Administrator> | string | Administrator | ||||||||||
| |-- <AdministratorLogin> | string | Administrator login session | ||||||||||
| |-- <AdministratorExportId> | string | Administrator export id | ||||||||||
| |-- <SalesTeam> | 0 | string | Sales team label
| |||||||||
| | |-- <SalesTeamExportId> | 0 | string | Sales team export id
| |||||||||
| |-- <CustomFieldData> | ||||||||||||
| |-- <ExtrinsicFields> |
| |||||||||||
| | |-- <Extrinsic name ="sample_name"> | 0..n | string | Value added to extrinsic field
| |||||||||
| |-- <ResellerInformation> | 0..n | string | Reseller information | |||||||||
| | |-- <Name> | string | Reseller name / shop name | ||||||||||
| | |-- <CorpRegNo> | string | Company registration number | ||||||||||
| | |-- <VatNumber> | string | VAT number | ||||||||||
| |-- <CompanyInformation> | string | Company information | ||||||||||
| | |-- <Name> | string | Reseller name / shop name | ||||||||||
| | |-- <CorpRegNo> | string | Company registration number | ||||||||||
| | |-- <VatNumber> | string | VAT number | ||||||||||
| |-- <ContactInformation> | string | Contact information | ||||||||||
| | |-- <Contact> | string | Contact info first name + surname | ||||||||||
| | |-- <Name firstName="Netset" lastName="Demo"> | string | Contact info first name + surname | ||||||||||
| | |-- <Phone> | string | Contact info phone | ||||||||||
| | |-- <Mobile> | string | Contact info mobile | ||||||||||
| | |-- <Fax> | string | Contact info fax | ||||||||||
| | |-- <Email> | string | Contact info Email | ||||||||||
| |-- <DeliveryRecipientContactInformation> | string | Delivery recipient contact information | ||||||||||
| | |-- <Name> | string | Delivery recipient first name + surname | ||||||||||
| | |-- <Email> | string | Delivery recipient Email | ||||||||||
| | |-- <Phone1> | string | Delivery recipient phone | ||||||||||
| | |-- <Phone2> | string | Delivery recipient direct phone | ||||||||||
| | |-- <Mobile> | string | Delivery recipient cellular (mobile) | ||||||||||
| | |-- <Fax> | string | Delivery recipient fax | ||||||||||
| |-- <ShipmentOptions> | Shipment option information | |||||||||||
| | |-- <Rental> | string | - | ||||||||||
| | |-- <Payment> | 0..n | string | Payment option | |||||||||
| | |-- <Payed> | int | Payed value, 1 or 0 | ||||||||||
| | |-- <Delivery> | string | Delivery option | ||||||||||
| | |-- <DeliveryCode> | string | Delivery option code | ||||||||||
| | |-- <AllowPartialDelivery> | int | Allow partial delivery option, 1 or 0 | ||||||||||
| | |-- <PaymentInformation> | - | |||||||||||
| |-- <FinancingOptions> | ||||||||||||
| | |-- <FinancingPeriod> | int | Default finance period (month) | ||||||||||
| |-- <AddressingInformation> | Adressing information | |||||||||||
| | |-- <BillToAddress displayToCustomer ="true" id="12345"> | string | - | ||||||||||
| | | |-- <AddressName label="Name"> | 0 | string | Contact info > first name + surname | |||||||||
| | | |-- <Attention> | 0 | string | - | |||||||||
| | | |-- <Company label="Company"> | 0 | string | Invoice company name | |||||||||
| | | |-- <Address1 label ="Address"> | 0 | string | Address | |||||||||
| | | |-- <Zip label ="Zip code"> | 0 | string | Zip code | |||||||||
| | | |-- <City label="City"> | 0 | string | City | |||||||||
| | | |-- <Country code="dk" label="Country"> | 0 | string | Country | |||||||||
| | |-- <ShipToAddress displayToCustomer="true" id="12345"> | string | |||||||||||
| | | |-- <AddressName label="Name"> | 0 | string | Contact info > first name + surname | |||||||||
| | | |-- <Company label="Company"> | string | Direct-shipment company | ||||||||||
| | | |-- <Address1 label="Address"> | 0 | string | Direct-shipment address | |||||||||
| | | |-- <Address2 label="Attention"> | 0 | string | Direct-shipment attention | |||||||||
| | | |-- <Zip label=Zip code"> | 0 | string | Direct-shipment zip code | |||||||||
| | | |-- <City label="City"> | 0 | string | Direct-shipment city | |||||||||
| | | |-- <State label="State"> | 0 | string | Direct-shipment state | |||||||||
| | | |-- <Country code="dk" label="Country"> | 0 | string | Direct-shipment country | |||||||||
| | |-- <CrossShipmentAddress> | string | |||||||||||
| |-- <ShippingTotal> | Shipping total information | |||||||||||
| | |-- <VAT> | double | VAT | ||||||||||
| | |-- <ExclusiveVAT> | double | Exclusive VAT | ||||||||||
| | |-- <InclusiveVAT> | double | Inclusive VAT | ||||||||||
| | |-- <VATDisplay> | double | Display VAT | ||||||||||
| | |-- <ExclusiveVATDisplay> | double | Exclusive VAT display | ||||||||||
| | |-- <InclusiveVATDisplay> | double | Inclusive VAT display | ||||||||||
| | |-- <RentExclusiveVATDisplay> | double | Rent exclusive VAT display | ||||||||||
| | |-- <RentInclusiveVATDisplay> | double | Rent inclusive VAT display | ||||||||||
| | |-- <TaxCode> | double | Tax code | ||||||||||
| | |-- <ShippingArticleNo> | string | Shipping matrix article number | ||||||||||
| |-- <Fees> | - | |||||||||||
| |-- <OrderTotal> | Order total information | |||||||||||
| | |-- <VAT> | double | VAT | ||||||||||
| | |-- <ExclusiveVAT> | double | Total exclusive VAT | ||||||||||
| | |-- <InclusiveVAT> | double | Total inclusive VAT | ||||||||||
| | |-- <RentVAT> | double | Total rent VAT | ||||||||||
| | |-- <RentExclusiveVAT> | double | Total rent exclusive Vat | ||||||||||
| | |-- <RentInclusiveVAT> | double | Total rent inclusive VAT | ||||||||||
| | |-- <VATDisplay> | double | Total VAT display | ||||||||||
| | |-- <ExclusiveVATDisplay> | double | Total exclusive VAT display | ||||||||||
| | |-- <InclusiveVATDisplay> | double | Total inclusive VAT display | ||||||||||
| | |-- <RentVATDisplay> | double | Total rent VAT display | ||||||||||
| | |-- <RentExclusiveVATDisplay> | double | Total rent exclusive VAT display | ||||||||||
| | |-- <RentInclusiveVATDisplay> | double | Total rent inclusive VAT display | ||||||||||
|-- <OrderLines> | ||||||||||||
| |-- <ProductLine type=0" id="86162" groupid="86162" parentid="" quoteid=""> | 0..n | |||||||||||
| | |-- <LineId> | int | Order line ID e.g 1 | ||||||||||
| | |-- <ManufacturerArticleNo> | string | Manufacturer article number | ||||||||||
| | |-- <SupplierArticleNo> | string | Supplier article number | ||||||||||
| | |-- <Label> | string | Product label | ||||||||||
| | |-- <Labels> | string | Multiple label attribute | ||||||||||
| | |-- <Label iso="en" =language="English"> | string | Product label in different language e.g. English, Danish | ||||||||||
| | |-- <Manufacturer> | string | Manufacturer | ||||||||||
| | |-- <Restrictions> | Restrictions | |||||||||||
| | |-- <Supplier> | string | Supplier (Nettailer) | ||||||||||
| | |-- <SupplierExportId> | string | Supplier (Nettailer) export id | ||||||||||
| | |-- <Quantity> | double | Quantity | ||||||||||
| | |-- <CostPrice> | double | Cost price | ||||||||||
| | |-- <DiscountPercent> | int | Discount percent | ||||||||||
| | |-- <SupplierPrice> | double | Supplier price | ||||||||||
| | |-- <RegisteredPurchasePrice> | double | Registered purchase price | ||||||||||
| | |-- <CalculatedPurchasePrice> | double | Calculated purchase price | ||||||||||
| | |-- <CalculatedCostPrice> | double | Calculated cost price | ||||||||||
| | |-- <Instock> | int | In stock e.g. 50 | ||||||||||
| | |-- <StockETA> | Stock date | |||||||||||
| | |-- <PurchasePriceType> | int | Purchase price type | ||||||||||
| | |-- <MainCategory> | string | Main category | ||||||||||
| | |-- <MainCategoryExportId> | string | Main category export id | ||||||||||
| | |-- <Category> | string | Category | ||||||||||
| | |-- <CategoryCode> | string | Category code | ||||||||||
| | |-- <CategoryExportId> | string | Category export id | ||||||||||
| | |-- <UNSPSC> | UNSPSC code | |||||||||||
| | |-- <Family> | string | Product family | ||||||||||
| | |-- <Status> | int | Product status e.g 100 | ||||||||||
| | |-- <Bid> | string | Bid | ||||||||||
| | |-- <TaxCode> | string | Tax code | ||||||||||
| | |-- <ProductConditionCode> | int | Product condition code | ||||||||||
| | |-- <Comment> | string | Comment | ||||||||||
| | |-- <Image> | string | Image URL | ||||||||||
| | |-- <ProductId> | string | Product Nettailer-id | ||||||||||
| | |-- <TaxPercent> | double | Tax percent e.g 0.2500 | ||||||||||
| | |-- <SalesPrice> | Sales price information | |||||||||||
| | | |-- <VAT> | double | VAT | ||||||||||
| | | |-- <ExclusiveVAT> | double | Sales price exclusive VAT | ||||||||||
| | | |-- <InclusiveVAT> | double | Sales price inclusive Vat | ||||||||||
| | | |-- <RentVAT> | double | rent VAT | ||||||||||
| | | |-- <RentExclusiveVAT> | double | Sales price exclusive rent VAT | ||||||||||
| | | |-- <RentInclusiveVAT> | double | Sales price inclusive rent VAT | ||||||||||
| | | |-- <VATDisplay> | double | VAT display | ||||||||||
| | | |-- <ExclusiveVATDisplay> | double | Sales price exclusive VAT display | ||||||||||
| | | |-- <InclusiveVATDisplay> | double | Sales price incslusive VAT display | ||||||||||
| | | |-- <RentVATDisplay> | double | Rent VAT display | ||||||||||
| | | |-- <RentExclusiveVATDisplay> | double | Sales price exclusive VAT display | ||||||||||
| | | |-- <RentInclusiveVATDisplay> | double | Sales price incslusive VAT display | ||||||||||
| | |-- <DeliveredQuantity> | 0 | int | Delivered quantity e.g. 0 | |||||||||
| | |-- <PurchaseOrderNumber> | string | Purchase order number | ||||||||||
| | |-- <PurchaseOrderItemId> | string | Purchase order item id | ||||||||||
| | |-- <productforms> | 0..n | Product forms | ||||||||||
| | |-- <Flags> | 0..n | int | Flags | |||||||||
| | |-- <BusinessArea> | Business area information
| |||||||||||
| | | |-- <Name> | string | Name of business area
| ||||||||||
| | | |-- Export-<Id> | string | Export-id of business area
| ||||||||||
| | |-- <TotalPrice> | Total price information | |||||||||||
| | | |-- <VAT> | double | VAT | ||||||||||
| | | |-- <ExclusiveVAT> | double | Total price exclusive VAT | ||||||||||
| | | |-- InclusiveVAT> | double | Total price inclusive VAT | ||||||||||
| | | |-- <RentVAT> | double | Rent VAT | ||||||||||
| | | |-- <RentExclusiveVAT> | double | Total rent exclusive VAT | ||||||||||
| | | |-- <RentInclusiveVAT> | double | Total rent inclusive VAT | ||||||||||
| | | |-- <VATDisplay> | double | VAT display | ||||||||||
| | | |-- <ExclusiveVATDisplay> | double | Total price exclusive VAT display | ||||||||||
| | | |-- <InclusiveVATDisplay> | double | Total price inclusive VAT display | ||||||||||
| | | |-- <RentVATDisplay> | double | Rent VAT display | ||||||||||
| | | |-- <RentExclusiveVATDisplay> | double | Rent exclusive vat display | ||||||||||
| | | |-- <RentInclusiveVATDisplay> | double | Rent inclusive VAT display | ||||||||||
| | |-- <Suppliers> | Supplier information | |||||||||||
| | | |-- <Supplier> | 0..n | string | ||||||||||
| | | | |-- <Name> | string | Supplier name | ||||||||||
| | | |-- <SupplierExportId> | string | Supplier export id | ||||||||||
| | | |-- <SupplierArticleNo> | 0 | string | Supplier article number | |||||||||
| | | |-- <PurchasePrice> | double | Supplier purchase price | ||||||||||
| | | |-- <Instock> | double | Supplier instock | ||||||||||
| | |-- <ExtrinsicFields> | Extrinsic information
| |||||||||||
| | | |-- <Extrinsic name="Test"> | 0..n | string | Extrinsic field value
| |||||||||
| | |-- <Assortments> | ||||||||||||
|-- <Comment> | Comment information | |||||||||||
| |-- <AdminLink> | string | Admin URL to order | ||||||||||
| |-- <CommentText> | string | Comment text | ||||||||||
|-- <InternalComment> | Internal comment information | |||||||||||
| |-- <AdminLink> | string | Admin URL to order | ||||||||||
| |-- <CommentText> | string | Comment text |