Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

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

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_LWSO_Load_Web_Sales_Orders.xml_16-10-17-111035_response.xml

XML formatting

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>
<Responses>
<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)

<Responses>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error. Invalid Mapping - DC</Message>
</CallStatus>
<GUID />
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error. Invalid Mapping - DC</Message>
</CallStatus>
<GUID />
</Response>
</Responses>

Example success and failure response in a single XML file (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>false</Success>
<Code>100</Code>
<Message>Error. Invalid Mapping - DC</Message>
</CallStatus>
<GUID />
</Response>
</Responses>

...