Load Product Master Updates (iHub.API)
- Mai Labagnoy
This service is used to update product information for the products created using Load Product Masters.
System behaviours
The SKU is defined by the ProductCode (unique identifier)
If fields are left blank in Product Master Updates, any previously uploaded information will be removed: ProductDescription, Brand, Colour, Size, ProductLongDescription, HTSCode, Hazardous, GrossWeight, GrossWeightUOM, etc.
Multiple suppliers can be added to a single SKU
ProductCode, LotControlled, SerialNumberControlled, DateControlled, SupplierCode and SupplierDescription cannot be updated at any status
GrossWeight cannot be updated if the status are “To Dispatch” and “Dispatched”
Load Product Master Updates Parameters
Field | Product Master Category | Description | Data Type & Maximum length | Requirement |
ProductCode | Details | Unique SKU identifier code. This is the reference that is used to identify the SKU in other services. Can't be updated. | Alphanumeric Text - 100 characters | Mandatory |
ProductDescription | Details | Short description of SKU | Alphanumeric Text - 200 characters | Mandatory |
ProductLongDescription | Details | Open reference field | Alphanumeric Text - 500 characters | optional |
EAN | Details | SKU International Article Number/Barcode. Must be unique to the SKU. One EAN per SKU. | Alphanumeric Text - 50 characters | Conditional: if required by DC |
HTSCode | Details | Commodity code used to classify and define internationally traded goods. Must be numeric (no dots). Minimum of 10 digits. | Alphanumeric Text - 100 characters | Conditional: if required for shipping |
GrossWeight | Details | Gross weight of SKU | Number- decimals | Mandatory |
GrossWeightUOM | Details | The Unit of Measure of the GrossWeight | 2 characters | Mandatory |
CountryOfOrigin | Details | Specifies which country the goods were manufactured. Only one per SKU. | 2 characters | Conditional: if required for shipping |
Hazardous | Properties | If set to true, the SKU will be marked as Hazardous in SupplyStream | True or False | Conditional: if the Product is a Hazardous SKU |
LotControlled | Properties | Set to true if lot numbers are to be recorded on inbound/outbound. Can't be updated. | True or False | optional |
DateControlled | Properties | Set to true if SKU has a best before date. System will automatically operate on FEFO basis. Can't be updated. | True or False | optional |
SerialNumberControlled | Properties | Serial Number Controlled flag. Can't be updated. | True or False | optional |
Kit | Properties |
| True or False | optional |
InwardProcessing | Properties |
| True or False | optional |
WetBond | Properties |
| True or False | optional |
Bonded | Properties |
| True or False | optional |
Brand | Attributes | Product Brand | Alphanumeric Text - 100 characters | optional |
Colour | Attributes | Colour of SKU i.e. Blue | Alphanumeric Text - 100 characters | optional |
Size | Attributes | Size of SKU I.e Small | Alphanumeric Text - 100 characters | optional |
Currency | Attributes |
| Alphanumeric Text - 3 characters | optional |
QCPercentage | Attributes |
| number | optional |
Leadtime | Attributes |
| number | optional |
SecondaryCurrencyCode | Attributes |
| Alphanumeric Text - 3 characters | optional |
UnitPrice | Attributes | Unit price of SKU | Number- decimals | optional |
SecondaryPrice | Attributes |
| Number- decimals | optional |
Material | Attributes | content/component/what the product is made of | Alphanumeric Text - 200 characters | optional |
Category1 | Attributes |
| Alphanumeric Text - 50 characters | optional |
Category2 | Attributes |
| Alphanumeric Text - 50 characters | optional |
MOQ | Attributes |
| number | optional |
ProductUse | Attributes |
| Alphanumeric Text - 50 characters | optional |
ClientProductStatus | Attributes |
| Alphanumeric Text - 50 characters | optional |
Business | Attributes |
| Alphanumeric Text - 50 characters | optional |
StyleCode | Attributes |
| Alphanumeric Text - 00 characters | optional |
Hazmat | Attributes |
| Alphanumeric Text - 256 characters | optional |
DangerousGoodsClass | Attributes |
| Alphanumeric Text - 128 characters | optional |
ManufacturerMid | Attributes |
| Alphanumeric Text - 48 characters | optional |
ManufacturerName | Attributes |
| Alphanumeric Text - 128 characters | optional |
ManufacturerAddress | Attributes |
| Alphanumeric Text - 512 characters | optional |
StorageMethod | Attributes |
| Alphanumeric Text - 32 characters | optional |
Season | Attributes |
| Alphanumeric Text - 128 characters | optional |
Gender | Attributes |
| Alphanumeric Text - 128 characters | optional |
SupplierCode | Supplier | Supplier code of the supplier to be assigned to the SKU. Supplier code created in Load Companies using CompanyCode. SupplierCode can also be created 'on the fly', but no Supplier address details will be recorded. | Alphanumeric Text - 100 characters | Conditional: if required by DC |
SupplierDescription | Supplier | Name of supplier. If the SupplierCode specified already exists, the existing Supplier Description will be used rather than the one specified in this field. | Alphanumeric Text - 200 characters |
|
GroupIdentifier |
| A group value for SKU classification i.e. Homeware, Coats, Glassware. | Alphanumeric Text - 100 characters |
|
XML file sample
Standard Template:
<?xml version="1.0"?>
<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>
<Material>string</Material>
<Kit>true</Kit>
<DangerousGoodsClass>string</DangerousGoodsClass>
<Hazmat>string</Hazmat>
<ManufacturerMid>string</ManufacturerMid>
<ManufacturerName>string</ManufacturerName>
<ManufacturerAddress>string</ManufacturerAddress>
<StorageMethodCode>string</StorageMethodCode>
<Season>string</Season>
<Gender>string</Gender>
<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>
JSON file sample
Standard Template:
{
"ProductMaster": {
"CountryOfOrigin": "string",
"Brand": "string",
"Colour": "string",
"Size": "string",
"QCControlled": true,
"QCPercentage": 0,
"SerialNumberControlled": true,
"InwardProcessing": true,
"WetBond": true,
"UnitPrice": 0,
"LeadTime": 0,
"Category1": "string",
"Category2": "string",
"MOQ": 0,
"Currency": "string",
"ProductUse": "string",
"ClientProductStatus": "string",
"Business": "string",
"Bonded": true,
"SecondaryCurrencyCode": "string",
"SecondaryPrice": 0,
"StyleCode": "string",
"Material": "string",
"Kit": true,
"DangerousGoodsClass": "string",
"Hazmat": "string",
"ManufacturerMid": "string",
"ManufacturerName": "string",
"ManufacturerAddress": "string",
"StorageMethodCode": "string",
"Season": "string",
"Gender": "string",
"DateControlled": true,
"GrossWeight": 0,
"GrossWeightUOM": "string",
"LotControlled": true,
"EAN": "string",
"HTSCode": "string",
"Hazardous": true,
"ProductCode": "string",
"ProductDescription": "string",
"ProductLongDescription": "string"
},
"List": {
"Image": [
{
"ImageData": "string",
"DefaultImage": true
}
],
"SupplierMapping": [
{
"SupplierCode": "string",
"SupplierDescription": "string",
"UOM": 0
}
],
"ShipToCompanyMapping": [
{
"BranchCode": "string",
"CompanyCode": "string",
"MappedCode": "string"
}
],
"ProductCategory": [
{
"CategoryCode": "string"
}
],
"ProductIdentifier": [
{
"Name": "string",
"Values": "string"
}
]
}
}