/
FTP Load Sales Orders

FTP Load Sales Orders

Templates and file examples

The example template below can be used as a starting point for an FTP integration. CSV file templates can be found here. The specific mapping is confirmed with the client during integration with SEKO.

LSO_Load_Sales_Orders.xml

FTP XML Response file examples

For XML FTP uploads, the system provides a response file. Below are examples of the response file. More information on response files can be found here.

SUCCESS&FAILURE_test.xml_22-06-21-134840_response.xml

FAILURE_test.xml_22-06-21-135734_response.xml

XML formatting

Example body

<Requests>
<Request>
<SalesOrder>
<SalesInvoiceNumber>string</SalesInvoiceNumber>
<DocumentIdentifier>string</DocumentIdentifier>
<NIFNumber>string</NIFNumber>
<ShippingVAT>1.1</ShippingVAT>
<ShippingExVAT>1.1</ShippingExVAT>
<CustomsValueTotal>1.1</CustomsValueTotal>
<DiscountPriceTotal>1.1</DiscountPriceTotal>
<GiftWrap>true</GiftWrap>
<GiftMessage>string</GiftMessage>
<ShippingTerm>string</ShippingTerm>
<ShippingTermLocation>string</ShippingTermLocation>
<GiftMessageFrom>string</GiftMessageFrom>
<GiftMessageTo>string</GiftMessageTo>
<ShippingTotal>1.1</ShippingTotal>
<TaxTotal>1.1</TaxTotal>
<SubTotal>1.1</SubTotal>
<OrderType>string</OrderType>
<CurrencyCode>string</CurrencyCode>
<CarrierCustomerAccountNo>string</CarrierCustomerAccountNo>
<CourierName>string</CourierName>
<CourierService>string</CourierService>
<DeliveryAddressLocationType>string</DeliveryAddressLocationType>
<DoNotPushToDC>true</DoNotPushToDC>
<GUID>string</GUID>
<LocationType>string</LocationType>
<Notes>string</Notes>
<NotificationMethod>string</NotificationMethod>
<OnHold>true</OnHold>
<SalesOrderDate>1970-01-01T00:00:00.001Z</SalesOrderDate>
<SalesOrderNumber>string</SalesOrderNumber>
<SalesOrderReference>string</SalesOrderReference>
<ScheduledShipDate>1970-01-01T00:00:00.001Z</ScheduledShipDate>
<ShipmentTerms>string</ShipmentTerms>
<SpecialInstructions>string</SpecialInstructions>
<UltimateDestination>string</UltimateDestination>
</SalesOrder>
<SalesOrderHeader>
<DCCode>string</DCCode>
</SalesOrderHeader>
<ShipToCompany>
<BranchCode>string</BranchCode>
<CompanyCategory>string</CompanyCategory>
<CompanyCode>string</CompanyCode>
<CompanyDescription>string</CompanyDescription>
<LookupDeliveryAddress>true</LookupDeliveryAddress>
</ShipToCompany>
<DeliveryDetails>
<City>string</City>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</DeliveryDetails>
<BillingDetails>
<City>string</City>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</BillingDetails>
<ForwardingAgent>
<City>string</City>
<CompanyCode>string</CompanyCode>
<CompanyDescription>string</CompanyDescription>
<ContactCode>string</ContactCode>
<CountryCode>string</CountryCode>
<County>string</County>
<EmailAddress>string</EmailAddress>
<FirstName>string</FirstName>
<LastName>string</LastName>
<Line1>string</Line1>
<Line2>string</Line2>
<Line3>string</Line3>
<Line4>string</Line4>
<PhoneNumber>string</PhoneNumber>
<PostcodeZip>string</PostcodeZip>
<Title>string</Title>
</ForwardingAgent>
<List>
<SalesOrderLineItem>
<UnitDiscountPrice>1.1</UnitDiscountPrice>
<OrderLineMessage>string</OrderLineMessage>
<SecondaryCurrencyCode>string</SecondaryCurrencyCode>
<SecondaryUnitPrice>1.1</SecondaryUnitPrice>
<SecondaryVAT>1.1</SecondaryVAT>
<ASNNumber>string</ASNNumber>
<CustomsValue>1.1</CustomsValue>
<Channel>string</Channel>
<CountryCode>string</CountryCode>
<CurrencyCode>string</CurrencyCode>
<EAN>string</EAN>
<ExternalDocumentNo>string</ExternalDocumentNo>
<GUID>string</GUID>
<LineNumber>1</LineNumber>
<LotNo>string</LotNo>
<ProductCode>string</ProductCode>
<Quantity>1</Quantity>
<UnitPrice>1.1</UnitPrice>
<VAT>1.1</VAT>
</SalesOrderLineItem>
</List>
</Request>
</Requests>

Example success response body (2 entities)

<Responses>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>60ce1670-b04e-485d-9441-4d7f0716db91</GUID>
</Response>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>60ce1670-b04e-485d-9441-4d7f0716db92</GUID>
</Response>
</Responses>

Example failure response body (2 entities)

Valid structure on first order, but failed to upload. Invalid structure on second order

<Responses>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting SalesOrder: TESTWSO123-2206 - Error. Sales Order already exists.</Message>
</CallStatus>
<GUID>dc3bea8c-5048-445f-bdec-9a2721709b00</GUID>
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>The Line1 field is required.</Message>
</CallStatus>
</Response>
</Responses>

Example success and failure response in a single XML file (2 entities)

Successful upload on first order, Valid structure on second order, but failed to upload

<Responses>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<GUID>88cd5bf6-55b6-4f53-9d6b-73fac7c8f060</GUID>
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting SalesOrder: TESTWSO234 - Error. Invalid Mapping - DC</Message>
</CallStatus>
<GUID>05bcf6d2-b914-4cab-ab7d-b9eee7b6cc1f</GUID>
</Response>
</Responses>

Related content

Uploading to the FTP server
Uploading to the FTP server
More like this
API Load Sales Orders
API Load Sales Orders
Read with this
FTP Load Sales Orders
FTP Load Sales Orders
More like this
Load Sales Orders
Load Sales Orders
Read with this
FTP Load Web Sales Orders
FTP Load Web Sales Orders
More like this
Sales Order Report – Dispatches
Sales Order Report – Dispatches
Read with this