Load Product Master Updates

Owned by Dean Bazeley (Unlicensed)
Last updated: Dec 14, 2022 by James Seabrook
2 min read



Description

This method can be used to update product information for products you 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 and DateControlled cannot be updated

Available formats



API

FTP

Manual

XML

x

x



JSON

x





CSV



x

x

Updatable SKU data on system sales orders

Y

Can be updated

N

Can't be updated



Fields

In Production Tab

SO Status - Confirmed

To Be Picked

Being Picked

To Be Packed

To Dispatch

Dispatched

Fields

In Production Tab

SO Status - Confirmed

To Be Picked

Being Picked

To Be Packed

To Dispatch

Dispatched

ProductCode

N

N

N

N

N

N

N

ProductDescription

Y

Y

Y

Y

Y

Y

Y

EAN

Y

Y

Y

Y

Y

Y

Y

Supplier Code

N

N

N

N

N

N

N

Supplier Description

N

N

N

N

N

N

N

UOM















HTSCode

Y

Y

Y

Y

Y

Y

Y

GrossWeight

Y

Y

Y

Y

Y

N

N

GrossWeightUOM

Y

Y

Y

Y

Y

Y

Y

Colour

Y

Y

Y

Y

Y

Y

Y

Size

Y

Y

Y

Y

Y

Y

Y

Country of Origin

Y

Y

Y

Y

Y

Y

Y

Lot Controlled

N

N

N

N

N

N

N

Date Controlled

N

N

N

N

N

N

N

Hazardous

Y

Y

Y

Y

Y

Y

Y

Entity Relationships

This diagram shows the high level relationship between the entities detailed in the Field Level Details section of this page.

Field level details

ProductMaster













Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

ProductCode

Unique SKU identifier code. This is the reference that is used to identify the SKU in other services

nvarchar(100)



Mandatory

Dispatch Note, Commercial Inv



ProductDescription

Short description of SKU

nvarchar(200)



Mandatory

Dispatch Note, Commercial Inv



ProductLongDescription

Open reference field

nvarchar(500)









EAN

SKU International Article Number/Barcode. Must be unique to the SKU. An existing EAN is not removed if not included in an update.

nvarchar(50)



Conditional: if requiredby DC





HTSCode

Commodity code used to classify and define internationally traded goods. Must be numeric. Minimum of 10 digits. 

nvarchar(100)

Must be numeric

Conditional: if required for shipping

Commercial Inv



Hazardous

If set to TRUE, the SKU will be marked as Hazardous in SupplyStream

boolean

true, false

Conditional: if the Product List contains Hazardous SKU's





GrossWeight

Gross weight of SKU. Accepts up to 4 decimal places.

decimal(18, 4)



Mandatory





GrossWeightUOM

The Unit of Measure of the GrossWeight

char(2)

KG

Mandatory





CountryOfOrigin

Specifies which country the goods were manufactured

nvarchar(2)

ISO-2

Conditional: if required for shipping

Commercial Inv

 25

Brand

Product Brand

nvarchar(100)









Colour

Colour of SKU i.e. Blue

nvarchar(100)









Size

Size of SKU I.e Small

nvarchar(100)









Material

To hold the material of the product

nvarchar(200)





Commercial Inv





SupplierMapping













Field

Description

Data Type

Value Limits

Requirement

Use on standard documents

Field returned in service ID/table/field (multi services split by ";")

SupplierCode

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.

nvarchar(100)



Conditional: if required by DC





SupplierDescription

Name of supplier. If the SupplierCode specified already exists, the existing Supplier Description will be used rather than the one specified in this field.

nvarchar(200)



Conditional: if 'SupplierMapping → SupplierCode' provided