Item List Master Data Template File Description

The fields in the itemlist_template.csv file and the conditions to be maintained when updating this file are described.

Header Field Description
ITEMLIST Indicates the title of the entity type. Do not modify this row and its contents.
RECORDID (ACTRID) Indicates the identifier of the record for the action. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
ACTION Specify the action to be performed on this record. The valid values are Manage, Create, Modify and Delete. The default value is Manage.
RECORDID (ITMRID1) Indicates the identifier of the record for the item. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
ITEMID Enter the identifier of the item. This is a mandatory field. The master data upload will fail if you do not provide a value in this field.
UOM Enter the unit of measure of the item.
SUBCATORG Enter the name of the sub-catalog organization that maintains the item definition.
RECORDID (ITMRID2) Indicates the identifier of the record for primary information of the item. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
DESCRIPTION Enter the description of the item, for example, Brazil Jersey.
EFFECTIVESTARTDATE Enter the date on which the item is available for order creation.
EFFECTIVEENDDATE Enter the date until which the item is available for order creation.
MANUFACTURERITEM Enter the identifier used by the manufacturer to identify an item.
MANUFACTURERNAME Enter the name of the manufacturer of the item.
TAXABLEFLAG Specify whether the item is taxable or not. The valid values are Y and N.
UNIT COST Enter the cost of a single item.
IMAGEID Enter the filename of the image, for example, braziljersey.jpg. This attribute is used to display the preview of the item image in the Item Details screen in Sterling Business Center. Ensure that the value of IMAGEID does not exceed 24 characters.

Additionally, the value of IMAGEID can contain the relative file path only if the file path does not exceed 24 characters.

IMAGELABEL Enter the name of the image that is displayed in the Sterling Business Center user interface. This attribute is used to display the preview of the item image in the Item Details screen in Sterling Business Center.
IMAGELOCATION Enter the URL of the image server. This attribute is used to display the preview of the item image in the Item Details screen in Sterling Business Center.
DEFPC Enter the default product class of the item.
EXTDESC Enter the extended multiple-line description of the item.
ISMODEL Specify whether the item has variations (model item). The valid values are Y and N. An item with variations represents a group of items with a similar set of attributes.
ISPICKUP Specify whether the pick delivery method is allowed for the item. The valid values are Y and N. The default value is N.
ISSHIP Specify whether the ship delivery method is allowed for this item. The valid values are Y and N. the default value: is N.
ISVALID Specify whether the item is valid. The valid values are Y and N.
KITCODE Specify the kit code for this item. The allowed values and their descriptions are as follows:
  • LK - Indicates a logical kit.
  • PK - Indicates a physical kit.
  • DPK - Indicates a dynamic physical kit.
  • BUNDLE - Indicates a bundle item.
MAXORDQTY Enter the maximum order quantity.
MINORDQTY Enter the minimum order quantity.
SHORTDESC Enter the short description of the item.
BUNDLESTRAT Specify the bundle pricing strategy, that is, how a bundle will be priced. The allowed values and their descriptions are as follows:
  • PARENT - Bundle pricing should only include the totals from the bundle parent.
  • COMP - Bundle pricing should only include the totals from the components of the bundle.
  • ALL - Bundle pricing should include the totals from both the bundle parent and its components.
RECORDID (ITMRID3) Indicates the identifier of the record for alternative unit of measure of the item. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
QUANTITY Enter the quantity of the item.
UOM Enter the alternative unit of measure of the item.
RECORDID (ITMRID4) Indicates the identifier of the record for the item instructions. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
INSTRUCTIONTYPE Specify the type of instructions for the item, for example, Packaging.
INSTRUCTIONTEXT Enter the description of the instructions for the item, for example, Mark This Side Up.
RECORDID (ITMRID5) Indicates the identifier of the record for additional attributes of the item. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.

You can add multiple additional attributes to the ITMRID5 record in the master data file. You can provide these recurring values in the master data file by copying the recurring group (ITMRID5 and its corresponding fields) one after the other in the master data file.

The ITMRID5 recurring group includes ATTRIBUTEDOMAINID, ATTRIBUTEGROUPID, NAME, and VALUE fields.

ATTRIBUTEDOMAINID Enter the unique identifier of the attribute domain.
ATTRIBUTEGROUPID Enter the unique identifier of the attribute group.
NAME Enter the name of the attribute, for example, Color.
VALUE Enter the value of the attribute, for example, Green.
RECORDID (ITMRID6) Indicates the identifier of the record for the item asset. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.

You can add multiple additional attributes to the ITMRID6 record in the master data file. You can provide these recurring values in the master data file by copying the recurring group (ITMRID6 and its corresponding fields) one after the other in the master data file.

The ITMRID6 recurring group includes ASSETID, ASSETTYPE, ASSETLABEL, DESCRIPTION, CONTENTID, and CONTENTLOCATION fields.

ASSETID Enter the identifier of the asset.
ASSETTYPE Specify the type of asset associated with the item, for example, images, video, audio, or text files.
ASSETLABEL Enter the label of the asset, for example, ImageJersey_004.
DESCRIPTION Enter the description of the asset, for example, image of jersey of the Brazilian team.
CONTENTID Enter the filename of the asset, for example, braziljersey.jpg.
CONTENTLOCATION Specify the path that identifies the location of the asset, for example, the URL where the image file is stored.
RECORDID (ITMRID7) Indicates the identifier of the record for the item component. Do not modify the order of this field in the master data file. When adding a new row, you must copy the value in this column to the new row. Any row that does not contain the RECORDID value will be considered as an invalid record and this record will not be processed.
COMPGRPCODE Enter the item group code of the component item.
COMPITEMID Enter the identifier of the component item.
COMPORGCODE Enter the code of the organization that maintains the catalog for the component item.
COMPUOM Enter the unit of measure of the component item.
KITQTY Enter the quantity of the component item that is contained in the parent item.
Notes: