...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
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> |