System behaviours
The SKU is defined by the ProductCode (unique identifier)
SKU's cannot be deleted once created
SKU created will have a status “In production”
Load Product Master 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 - 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. | Numeric - Minimum of 10 digits (no dots) | 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. | True or False | optional |
DateControlled | Properties | Set to true if SKU has a best before date. System will automatically operate on FEFO basis. | True or False | optional |
SerialNumberControlled | Properties | Serial Number Controlled flag. | 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:
{
"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"
}
]
}
}
Sample with Client required Fields only:
<Request> <ProductMaster> <ProductCode>5056602245444</ProductCode> <ProductDescription>DENIM JACKET BLACK UK12 / IT44</ProductDescription> <EAN>5056602245444</EAN> <HTSCode>6204329090</HTSCode> <GrossWeight>0.80</GrossWeight> <GrossWeightUOM>KG</GrossWeightUOM> <CountryOfOrigin>TR</CountryOfOrigin> <Brand>WOMENS</Brand> <Colour>BLACK</Colour> <Size>UK12 / IT44</Size> <GroupIdentifier>JACKETS</GroupIdentifier> <Material>100% ORGANIC COTTON</Material> <ManufacturerMid>TRALAMOD3419IST</ManufacturerMid> <ManufacturerName>ALI MODA</ManufacturerName> <ManufacturerAddress>No: 13, Somewhere Village STANBUL, 34197, Turkey</ManufacturerAddress> <Bonded>false</Bonded> </ProductMaster> </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"
}
]
}
}
Sample with Client required Fields only:
{
ProductMaster: {
ProductCode: "1336",
ProductDescription: "Glowup Make up",
EAN: "840157413366",
HTSCode: "3304995000",
Hazardous: false,
GrossWeight: 0,
GrossWeightUOM: "LB",
LotControlled: true,
DateControlled: true,
CountryOfOrigin: "IT",
Kit: false
}
}