Description |
This method can be used to update product information for products you created using Load Product Masters. |
Version changes
Date | Version (if applicable) | New fieldsNotes | V4 |
| Initial Release |
|---|
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
...
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 |
|---|---|---|---|---|---|---|---|
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 SEKO360in SupplyStream | boolean | TRUEtrue, FALSE |
|
|
| 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 |
|
| ||||||
LotControlled | Set to TRUE if lot numbers are to be recorded on inbound/outbound | boolean | TRUE, FALSE |
|
|
| ||||||
DateControlled | Set to TRUE if SKU has a best before date. System will automatically operate on FEFO basis. | boolean | TRUE, FALSE |
|
|
| ||||||
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) |
|
|
|
| ||||||
QCControlled | Placeholder | boolean |
|
|
|
| ||||||
QCPercentage | Placeholder | int |
|
|
|
| ||||||
SerialNumberControlled | Serial Number Controlled flag | boolean |
|
|
|
| ||||||
InwardProcessing | Inward Processing flag | boolean |
|
|
|
| ||||||
WetBond | Wet Bond flag | boolean |
|
|
|
| ||||||
UnitPrice | Unit price of SKU. | decimal(18, 4) |
|
|
| 25 | ||||||
LeadTime | Lead time in days to deliveries | int |
|
|
| 25 | ||||||
Category1 | Category 1 | nvarchar(50) |
|
|
| 25 | ||||||
Category2 | Category 2 | nvarchar(50) |
|
|
| 25 | ||||||
MOQ | Minimum Order Quantity | int |
|
|
| 25 | ||||||
Currency | Currency of unit price. No ISO-3 validation. | nchar(3) |
|
|
| 25 | ||||||
ProductUse | Product Use. Open text field. | nvarchar(50) |
|
|
| 25 | ||||||
ClientProductStatus | Product Status. Open text field. Does not show on SEKO360 | nvarchar(50) |
|
|
| 25 | ||||||
Business | Business open text field | nvarchar(50) |
|
|
| 25 | ||||||
Bonded | Bonded flag | boolean |
|
|
|
| ||||||
SecondaryCurrencyCode | Secondary currency, for example, the purchase currency. No ISO-3 validation | nchar(3) |
|
|
|
| ||||||
SecondaryPrice | Secondary price, for example, the purchase price | decimal(18, 4) |
|
|
|
| ||||||
StyleCode | Style code coper text field | nvarchar(100) |
|
|
|
| ||||||
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) |
|
|
|
| ||||||
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 |
|
| ||||||
UOM | Placeholder | int |
|
|
|
| ||||||
ShipToCompanyMapping |
|
|
|
|
|
| ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") |
| |||||
MappedCode | Placeholder | nvarchar(100) |
|
|
|
|
| |||||
CompanyCode | Placeholder | nvarchar(100) |
|
|
|
|
| |||||
BranchCode | Placeholder | nvarchar(50) |
|
|
|
|
| |||||
ProductCategory |
|
|
|
|
|
| ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") | ||||||
CategoryCode | Placeholder | nvarchar(100) |
|
|
|
| ||||||
ProductIdentifier |
|
|
|
|
|
| ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") | ||||||
Name | Different attributes that can be assigned to a SKU. | nvarchar(100) | Double Packaging, Individual Packaging, Material, Material Code, Season |
| 'Material' appears on Commercial Inv |
| ||||||
Values | This the value in which you want to assign to the attribute specified in ProductIdentifier Name. | nvarchar(200) |
| Conditional: if 'ProductIdentifierName' provided | 'Material' appears on Commercial Inv |
| ||||||
Image |
|
|
|
|
|
| ||||||
Field | Description | Data Type | Value Limits | Requirement | Use on standard documents | Field returned in service ID/table/field (multi services split by ";") | ||||||
ImageData | Placeholder | byte[] |
|
|
|
| ||||||
DefaultImage | Placeholder | Boolean | TRUE, FALSE |
|
| Material | To hold the material of the product | nvarchar(200) | Commercial Inv |