/
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

FTP Load Product Masters
FTP Load Product Masters
More like this
FTP Load Product Master Updates
FTP Load Product Master Updates
More like this
FTP Load Product Master Updates
FTP Load Product Master Updates
More like this
FTP Load Companies
FTP Load Companies
More like this
FTP Load Sales Orders
FTP Load Sales Orders
More like this
FTP Load Sales Orders
FTP Load Sales Orders
More like this