/
FTP Load Product Masters

FTP Load Product Masters

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.

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

FAILURE_PM_Load_Product_Masters1.xml_22-06-21-143531_response.xml

SUCCESS&FAILURE_LPM_Load_Product_Masters.xml_22-06-21-143521_response.xml

XML formatting

Example body

<Requests>
<Request>
<ProductMaster>
<CountryOfOrigin>string</CountryOfOrigin>
<Brand>string</Brand>
<Colour>string</Colour>
<Size>string</Size>
<GroupIdentifier>string</GroupIdentifier>
<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>
<EAN>string</EAN>
<HTSCode>string</HTSCode>
<ProductDescription>string</ProductDescription>
<DateControlled>true</DateControlled>
<GrossWeight>1.1</GrossWeight>
<GrossWeightUOM>string</GrossWeightUOM>
<LotControlled>true</LotControlled>
<Hazardous>true</Hazardous>
<ProductCode>string</ProductCode>
<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>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting Product Master: PMTest123 - Error. Product code PMTest123 already exists in database.</Message>
</CallStatus>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>The field CountryOfOrigin must be a string with a maximum length of 2.</Message>
</CallStatus>
</Responses>

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

<Responses>
<CallStatus>
<Success>true</Success>
<Code>0</Code>
<Message></Message>
</CallStatus>
<CallStatus>
<Success>false</Success>
<Code>100</Code>
<Message>Error Submitting Product Master: PMTest234 - Error. Product code PMTest234 already exists in database.</Message>
</CallStatus>
</Responses>

Related content

iHub FTP Documentation
iHub FTP Documentation
More like this
Load Product Masters
Load Product Masters
Read with this
FTP Load Product Master Updates
FTP Load Product Master Updates
More like this
API Load Product Masters
API Load Product Masters
Read with this
FTP Load Sales Orders
FTP Load Sales Orders
More like this
iHub Documentation
iHub Documentation
Read with this