Product Hierarchy File
File name: prod.hdr.csv.dat
File format: comma-separated values file
The following table describes the fields in this file.
| Name | Label | Hierarchy Type | Parent |
|---|---|---|---|
|
SKU |
Item |
Main |
None |
|
SKUP |
Style/Color |
Main |
SKU |
|
SKUG |
Style |
Main |
SKUP |
|
SCLS |
Sub-Category |
Main |
SKUG |
|
CLSS |
Category |
Main |
SCLS |
|
DEPT |
Department |
Main |
CLSS |
|
PGRP |
Group |
Main |
DEPT |
|
DVSN |
Division |
Main |
PGRP |
|
CMPP |
Company |
Main |
DVSN |
|
STA1 |
Style UDA 1 |
UDA |
SKUG |
|
BRND |
Brand |
Alternate |
SKU |
|
VNDR |
Vendor |
Alternate |
SKU |
Example:
sku,sku_label,skup,skup_label,skug,skug_label,scls,scls_label,clss,clss_label,dept,dept_label,pgrp,pgrp_label,dvsn,dvsn_label,cmpp,cmpp_label,brnd,brnd_label,vndr,vndr_label 1000001,Lasagna,1000001,Lasagna,1000001,Lasagna,1000001,Lasagna,70000,Pasta,4000,Dry Goods,100,Shelf Stable Grocery,10,Center Store,1,Spaces Grocery,Brand,Placeholder Brand,Vendor,Placeholder Vendor 1000002,Spagetti,1000002,Spagetti,1000002,Spagetti,1000002,Spagetti,70000,Pasta,4000,Dry Goods,100,Shelf Stable Grocery,10,Center Store,1,Spaces Grocery,Brand,Placeholder Brand,Vendor,Placeholder Vendor 1000003,Rigatoni,1000003,Rigatoni,1000003,Rigatoni,1000003,Rigatoni,70000,Pasta,4000,Dry Goods,100,Shelf Stable Grocery,10,Center Store,1,Spaces Grocery,Brand,Placeholder Brand,Vendor,Placeholder Vendor 1234582,1234582 - Folgers Breakfast Roast Non-Flavored De-Caffeinated 12 oz Can,22222222,Ground De-Caffeinated Can,121212,Ground De-Caffeinated,100000,Ground,10000,Coffee,1000,Shelf Stable Beverages,100,Shelf Stable Grocery,10,Center Store,1,Spaces Grocery,Brand,Placeholder Brand,Vendor,Placeholder Vendor 1234600,1234600 - Maxwell House 100% Columbian Non-Flavored De-Caffeinated 12 oz Can,22222222,Ground De-Caffeinated Can,121212,Ground De-Caffeinated,100000,Ground,10000,Coffee,1000,Shelf Stable Beverages,100,Shelf Stable Grocery,10,Center Store,1,Spaces Grocery,Brand,Placeholder Brand,Vendor,Placeholder Vendor
Note:
For non-template customers, it is also recommended to align with the GA Product Hierarchy structure for the dimension names for sku, skup, skug, scls, clss, dept, pgrp, dvsn, and cmpp so that they can upgrade/implement other GA solutions in a multi-app environment. They can use different labels. The lowest dimension should be sku and it is mandatory. The rest of the dimensions are optional and their equivalents should be named accordingly.