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 Science modules and drive many analytical processes but are not required for some planning modules like MFP.

Table 6-5 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 type codes like SIZE must all have a single value associated with the group in this field, such as S or SZ. The value can be hard-coded if you do not have a code representing that group in your source system. This value must also match the ATTR_GRP_ID value on the other 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. 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
CHOC,Chocolate,FLAVOR,Flavor,FLAVOR
GRAY_43214,Gray,C,Color,COLOR
32X32_9957,32X32,S,Size,SIZE

Table 6-6 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. Varies by ATTR_GRP_TYPE value used:  ITEMDIFF, COLOR, PRODUCT_ATTRIBUTES = specify the Diff Type ID, equivalent to an attribute group ID for diffs (align to ATTR.csv group ID)  ITEMUDA = UDA Group ID (align to ATTR.csv group ID)  ITEMLIST = <N/A - Not Used for Lists, 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
91207973747,30007,ITEMUDA,5,,
91207973747,12756,ITEMUDA,3,,
190496585706,STEEL,ITEMDIFF,METAL,,
86323133004,GRAY_43214,COLOR,C,,
190085302141,CHOC,PRODUCT_ATTRIBUTES,FLAVOR,,
345873291,32X32_9957,PRODUCT_ATTRIBUTES,S,S13,Pant Sizes