Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

Description

This method can be called to create new products in SupplyStream. If you have not created any products then this should be the first method you call.

System behaviours

  • The SKU is defined by the ProductCode (unique identifier)
  • SKU's cannot be deleted once created
  • SKU is created in status 'In production'
  • In CSV, multiple suppliers can be loaded as long as the row for the product entity are together.

Available formats


API

FTP

Manual

XML

x

x


JSON

x



CSV


x

x

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. Not case sensitive.

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. One EAN per SKU.

nvarchar(50)


Conditional: if required by DC



HTSCode

Commodity code used to classify and define internationally traded goods. Must be numeric (no dots). 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 is a Hazardous SKU



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



LotControlled

Set to true if lot numbers are to be recorded on inbound/outbound. Can't be updated.

boolean

true, false




DateControlled

Set to true if SKU has a best before date. System will automatically operate on FEFO basis. Can't be updated.

boolean

true, false




CountryOfOrigin

Specifies which country the goods were manufactured. Only one per SKU.

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)





GroupIdentifier

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

nvarchar(100)





MaterialTo hold the material of the productnvarchar(200)

Commercial Inv


  • No labels