/
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

FTP Load Sales Orders
FTP Load Sales Orders
More like this
FTP Load Web Sales Orders
FTP Load Web Sales Orders
More like this
FTP Load Receipts
FTP Load Receipts
More like this
FTP Load Receipts
FTP Load Receipts
More like this
FTP Load Product Masters
FTP Load Product Masters
More like this
FTP Load Product Master Updates
FTP Load Product Master Updates
More like this