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.
LWSO_Load_Web_Sales_Orders.xml
FTP XML Response file examples
...
Example body | <Requests> <Request> <WebSalesOrder> <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> </WebSalesOrder> <SalesOrderHeader> <DCCode>string</DCCode> </SalesOrderHeader> <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>7a9a31a9-9b11-45ae-a7b3-139f06cdb155</GUID> </Response> <Response> <CallStatus> <Success>true</Success> <Code>0</Code> <Message></Message> </CallStatus> <GUID>7a9a31a9-9b11-45ae-a7b3-139f06cdb156</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 | . Invalid Mapping - DC<Submitting SalesOrder: TESTWSO123-2206 - Error. Sales Order already exists.</Message> </CallStatus>
| <GUID /> <GUID>dc3bea8c-5048-445f-bdec-9a2721709b00</GUID> </Response> <Response> <CallStatus> <Success>false</Success> <Code>100</Code>
| <Message>Error. Invalid Mapping - DC<<Message>The Line1 field is required.</Message> </CallStatus> |
<GUID /> </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>7a9a31a9<GUID>88cd5bf6- | 9b1155b6- | 45ae4f53- | a7b39d6b- | 139f06cdb155<73fac7c8f060</GUID> </Response> <Response> <CallStatus> <Success>false</Success> <Code>100</Code> <Message>Error Submitting SalesOrder: TESTWSO234 - Error. Invalid Mapping - DC</Message> </CallStatus>
| <GUID /> <GUID>05bcf6d2-b914-4cab-ab7d-b9eee7b6cc1f</GUID> </Response> </Responses> |