Load Product Master Updates (iHub.API)

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
LotControlled, SerialNumberControlled and DateControlled cannot be updated

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. Not case sensitive.	Alphanumeric Text - 200 characters	Mandatory
ProductDescription	Details	Short description of SKU	Alphanumeric Text - 400 characters	Mandatory
ProductLongDescription	Details	Open reference field	Alphanumeric Text - 1000 characters	optional
EAN	Details	SKU International Article Number/Barcode. Must be unique to the SKU. One EAN per SKU.	Alphanumeric Text - 100 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 - 200 characters	Conditional: if required for shipping
GrossWeight	Details	Gross weight of SKU	Number- 9 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 - 200 characters	optional
Colour	Attributes	Colour of SKU i.e. Blue	Alphanumeric Text - 200 characters	optional
Size	Attributes	Size of SKU I.e Small	Alphanumeric Text - 200 characters	optional
Currency	Attributes		Alphanumeric Text - 6 characters	optional
QCPercentage	Attributes		4 numbers	optional
Leadtime	Attributes		4 numbers	optional
SecondaryCurrencyCode	Attributes		Alphanumeric Text - 6 characters	optional
UnitPrice	Attributes	Unit price of SKU	Number- 9 decimals	optional
SecondaryPrice	Attributes		Number- 9 decimals	optional
Material	Attributes	content/component/what the product is made of	Alphanumeric Text - 400 characters	optional
Category1	Attributes		Alphanumeric Text - 100 characters	optional
Category2	Attributes		Alphanumeric Text - 100 characters	optional
MOQ	Attributes		4 numbers	optional
ProductUse	Attributes		Alphanumeric Text - 100 characters	optional
ClientProductStatus	Attributes		Alphanumeric Text - 100 characters	optional
Business	Attributes		Alphanumeric Text - 100 characters	optional
StyleCode	Attributes		Alphanumeric Text - 200 characters	optional
Hazmat	Attributes		Alphanumeric Text - 512 characters	optional
DangerousGoodsClass	Attributes		Alphanumeric Text - 256 characters	optional
ManufacturerMid	Attributes		Alphanumeric Text - 96 characters	optional
ManufacturerName	Attributes		Alphanumeric Text - 256 characters	optional
ManufacturerAddress	Attributes		Alphanumeric Text - 1024 characters	optional
StorageMethod	Attributes		Alphanumeric Text - 94 characters	optional
Season	Attributes		Alphanumeric Text - 256 characters	optional
Gender	Attributes		Alphanumeric Text - 256 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 - 200 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 - 400 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"
      }
    ]
  }
}