FTP Load Product Master Updates

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.

LPU_Load_Product_Master_Updates.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_LPU_Load_Product_Master_Updates.xml_16-10-17-105515_response.xml

SUCCESS&FAILURE_LPU_Load_Product_Master_Updates.xml_16-10-17-112517_response.xml

XML formatting

Example body

<Requests>
<Request>
<ProductMaster>
<CountryOfOrigin>string</CountryOfOrigin>
<Brand>string</Brand>
<Colour>string</Colour>
<Size>string</Size>
<QCControlled>true</QCControlled>
<QCPercentage>1</QCPercentage>
<SerialNumberControlled>true</SerialNumberControlled>
<InwardProcessing>true</InwardProcessing>
<WetBond>true</WetBond>
<UnitPrice>1.1</UnitPrice>
<LeadTime>1</LeadTime>
<Category1>string</Category1>
<Category2>string</Category2>
<MOQ>1</MOQ>
<Currency>string</Currency>
<ProductUse>string</ProductUse>
<ClientProductStatus>string</ClientProductStatus>
<Business>string</Business>
<Bonded>true</Bonded>
<SecondaryCurrencyCode>string</SecondaryCurrencyCode>
<SecondaryPrice>1.1</SecondaryPrice>
<StyleCode>string</StyleCode>
<DateControlled>true</DateControlled>
<GrossWeight>1.1</GrossWeight>
<GrossWeightUOM>string</GrossWeightUOM>
<LotControlled>true</LotControlled>
<EAN>string</EAN>
<HTSCode>string</HTSCode>
<Hazardous>true</Hazardous>
<ProductCode>string</ProductCode>
<ProductDescription>string</ProductDescription>
<ProductLongDescription>string</ProductLongDescription>
</ProductMaster>
<List>
<Image>
<ImageData>string</ImageData>
<DefaultImage>true</DefaultImage>
</Image>
<SupplierMapping>
<SupplierCode>string</SupplierCode>
<SupplierDescription>string</SupplierDescription>
<UOM>1</UOM>
</SupplierMapping>
<ShipToCompanyMapping>
<BranchCode>string</BranchCode>
<CompanyCode>string</CompanyCode>
<MappedCode>string</MappedCode>
</ShipToCompanyMapping>
<ProductCategory>
<CategoryCode>string</CategoryCode>
</ProductCategory>
<ProductIdentifier>
<Name>string</Name>
<Values>string</Values>
</ProductIdentifier>
</List>
</Request>
</Requests>

Example success response body (2 entities)

<Responses>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
</Response>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
</Response>
</Responses>

Example failure response body (2 entities)

<Responses>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error. Product not found.</Message>
</CallStatus>
</Response>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error. Product not found.</Message>
</CallStatus>
</Response>
</Responses>

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

<Responses>
<Response>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error. Product not found.</Message>
</CallStatus>
</Response>
<Response>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
</Response>
</Responses>