XML sales order
In this section, you are able to configure a XML sales order export either via FTP or a web service.
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 ADD-ON | |
| | |-- <SalesTeamExportId> | 0 | string | Sales team export id ADD-ON | |
| |-- <CustomFieldData> | ||||
| |-- <ExtrinsicFields> | ADD-ON | |||
| | |-- <Extrinsic name ="sample_name"> | 0..n | string | Value added to extrinsic field ADD-ON | |
| |-- <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 ADD-ON | |||
| | | |-- <Name> | string | Name of business area ADD-ON | ||
| | | |-- Export-<Id> | string | Export-id of business area ADD-ON | ||
| | |-- <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 ADD-ON | |||
| | | |-- <Extrinsic name="Test"> | 0..n | string | Extrinsic field value ADD-ON | |
| | |-- <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 |