Attributes Files
Product attributes are provided on two files: one file for the attribute-to-product mappings and another for attribute descriptions and codes. These files should be provided together to fully describe all the attributes being loaded into the system. The attribute descriptors file must be a full snapshot of all attribute types and values at all times. The product attribute mapping file should start as a full snapshot but can move to incremental (delta) load methods once nightly batches begin, if you can extract the information as deltas only.
Product attributes are a major component of the RI and AI Foundation modules and drive many analytical processes but are not required for some planning modules like MFP.
Table 8-7 Attribute File Required Fields
Column Header | Usage |
---|---|
ATTR_VALUE_ID |
Unique identifier for a user-defined attribute or product differentiator.
This interface contains ALL values regardless of whether they are used on items yet or not. These values must also match the |
ATTR_VALUE_DESC |
Descriptive value for a user-defined attribute or product differentiator,
such as |
ATTR_GROUP_ID |
Unique identifier for a group of user-defined attributes, or the
name/code for the differentiator group. Reserved attribute types like |
ATTR_GROUP_DESC |
Descriptive value for a group of user-defined attributes, such as |
ATTR_TYPE_CODE |
Indicates the type of UDA or differentiator. UDA types should be
hard-coded as one of
For non-UDA types, some diffs have special reserved codes for this field as
well, which should be used when applicable, and include |
Sample data for the ATTR.csv
file columns above:
ATTR_VALUE_ID,ATTR_VALUE_DESC,ATTR_GROUP_ID,ATTR_GROUP_DESC,ATTR_TYPE_CODE
13,No_Sugar_IN13,45008,UDA_ING_2018.01.16.01.00,FF
14,Zero_Carbs_IN14,45008,UDA_ING_2018.01.16.01.00,FF
3,Distressed,80008,Wash,LV
STEEL,Steel,METAL,Metals,DIFF
CHOC,Chocolate,FLAVOR,Flavor,FLAVOR
GRAY_43214,Gray,COLOR,Color,COLOR
32X32_9957,32X32,SIZE,Size,SIZE
Table 8-8 Product Attribute File Required Fields
Column Header | Usage |
---|---|
ITEM |
The item number associated with the specified attribute value. |
ATTR_ID |
Identifier for an attribute value, such as the UDA value ID or Diff
ID which is mapped to the item on the record, or the ID for the item list this item belongs to. These values must also match
the |
ATTR_GRP_TYPE |
The attribute group type. This is a set of fixed values which must
be selected from what RAP supports. Supported values are |
ATTR_GRP_ID |
Identifier for the attribute group containing the value on this
record. Must match a
|
DIFF_GRP_ID |
Differentiator group used to assign the diff attribute on this item; for example the Size Group ID used when generating SKUs from a parent Style. Only SKUs will have diff groups associated with them. Only diffs will have groups, not UDAs or other record types. This is not the same as an attribute group, which is the overall grouping of attribute values across all items. This is used mainly for Size Profile Science. Foreign key reference
to |
DIFF_GRP_DESC |
Descriptive value of the diff group mapped to this item/attribute record. |
Sample data for the PROD_ATTR.csv
file columns above:
ITEM,ATTR_ID,ATTR_GRP_TYPE,ATTR_GRP_ID,DIFF_GRP_ID,DIFF_GRP_DESC
91203747,13,ITEMUDA,45008,,
91203747,3,ITEMUDA,80008,,
190496585706,STEEL,ITEMDIFF,METAL,,
86323133004,GRAY_43214,COLOR,COLOR,,
190085302141,CHOC,PRODUCT_ATTRIBUTES,FLAVOR,,
345873291,32X32_9957,PRODUCT_ATTRIBUTES,SIZE,S13,Pant Sizes