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_ID on the other file.
ATTR_VALUE_DESC	Descriptive value for a user-defined attribute or product differentiator, such as Brown, Cotton, Size12, and so on
ATTR_GROUP_ID	Unique identifier for a group of user-defined attributes, or the name/code for the differentiator group. Reserved attribute types like SIZE and COLOR must all have a single, hard-coded value associated with the group in this field (For example, all sizes must be in the SIZE group, don’t specify group IDs for sizes_pants, sizes_shirts, and so on. This is handled separately). This group ID value must also match the ATTR_GRP_ID value on the second file.
ATTR_GROUP_DESC	Descriptive value for a group of user-defined attributes, such as Color Family or Web Exclusive Code, or the description of the differentiator type such as Color.
ATTR_TYPE_CODE	Indicates the type of UDA or differentiator. UDA types should be hard-coded as one of FF, LV, or DT, for Freeform, List of Values, or Date. LV type attributes are fixed lists and write values to translation lookup tables, while FF and DT fields do not. For non-UDA types, some diffs have special reserved codes for this field as well, which should be used when applicable, and include SIZE, FABRIC, SCENT, FLAVOR, STYLE, and COLOR. Other differentiators not using these codes should specify a hard-coded type of DIFF.

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_VALUE_ID on the other file.
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 ITEMDIFF, ITEMUDA, ITEMLIST, COLOR, and PRODUCT_ATTRIBUTES. These codes determine the target columns for the data (for example, lists, diffs, and UDAs use different internal columns in the data model). PRODUCT_ATTRIBUTES type code encapsulates the other named differentiator types like Size, Fabric, and so on. COLOR has a special type code due to it being a common level between Style and SKU for fashion retailers, so it is handled separately.
ATTR_GRP_ID	Identifier for the attribute group containing the value on this record. Must match a ATTR_GROUP_ID in the other file. Varies by ATTR_GRP_TYPE value used: If ATTR_GRP_TYPE is in ITEMDIFF, COLOR, PRODUCT_ATTRIBUTES, then specify the Diff Type ID or one of the reserved values like SIZE or COLOR. If ATTR_GRP_TYPE is ITEMUDA, specify UDA Group ID. If ATTR_GRP_TYPE is ITEMLIST, this field is not used, leave null.
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_GROUP.csv.
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