Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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 - 200 100 characters

Mandatory

ProductDescription

Details

Short description of SKU

Alphanumeric Text - 400 200 characters

Mandatory

ProductLongDescription

Details

Open reference field

Alphanumeric Text - 1000 500 characters

optional

EAN

Details

SKU International Article Number/Barcode. Must be unique to the SKU. One EAN per SKU.

Alphanumeric Text - 100 50 characters

Conditional: if required by DC

HTSCode

Details

Commodity code used to classify and define internationally traded goods. Must be numeric

Numeric - Minimum of 10 digits

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

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 - 200 100 characters

optional

Colour

Attributes

Colour of SKU i.e. Blue

Alphanumeric Text - 200 100 characters

optional

Size

Attributes

Size of SKU I.e Small

Alphanumeric Text - 200 100 characters

optional

Currency

Attributes

 

Alphanumeric Text - 6 3 characters

optional

QCPercentage

Attributes

 

4 numbersnumber

optional

Leadtime

Attributes

 

4 numbersnumber

optional

SecondaryCurrencyCode

Attributes

 

Alphanumeric Text - 6 3 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 200 characters

optional

Category1

Attributes

 

Alphanumeric Text - 100 50 characters

optional

Category2

Attributes

 

Alphanumeric Text - 100 50 characters

optional

MOQ

Attributes

 

4 numbersnumber

optional

ProductUse

Attributes

 

Alphanumeric Text - 100 50 characters

optional

ClientProductStatus

Attributes

 

Alphanumeric Text - 100 50 characters

optional

Business

Attributes

 

Alphanumeric Text - 100 50 characters

optional

StyleCode

Attributes

 

Alphanumeric Text - 200 00 characters

optional

Hazmat

Attributes

 

Alphanumeric Text - 512 256 characters

optional

DangerousGoodsClass

Attributes

 

Alphanumeric Text - 256 128 characters

optional

ManufacturerMid

Attributes

 

Alphanumeric Text - 96 48 characters

optional

ManufacturerName

Attributes

 

Alphanumeric Text - 256 128 characters

optional

ManufacturerAddress

Attributes

 

Alphanumeric Text - 1024 512 characters

optional

StorageMethod

Attributes

 

Alphanumeric Text - 94 32 characters

optional

Season

Attributes

 

Alphanumeric Text - 256 128 characters

optional

Gender

Attributes

 

Alphanumeric Text - 256 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 - 200 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 - 400 200 characters

 

GroupIdentifier

 

A group value for SKU classification i.e. Homeware, Coats, Glassware.

Alphanumeric Text - 100 characters

 

...