PIF Details

Use this reference to further understand PIF Details.

PIF Attributes:

Note:

Name	Description	How to Complete	Source
Ref UPC	UPC from retailer	Do not change	UPC as defined by the retailer
Ref Customer Product Key	Retailer product numbering system. If not available, will default to UPC.	Do not change	UPC or retailer ID as defined in map
Included in Model	Place to "drop" products so that they will not be included in the model. These products are also not in the scenario.	Change to "No" if the product should not be modeled	Default is Yes
Description	Product description to be sent to Everyday Price Management	Typically, is not changed	Retailer description. If retailer has more than one description, check with map.
Demand Group	Collection of highly substitutable products	Alpha-numeric, 50 characters maximum, no spaces (use underscore to separate words). Must begin with an alpha character.	Default is DEFAULT_demand group
Size	Size (Volume of Measure) to be used for Modeling at the retailer/division/category level. This size can be inferred.	Numerical. If "free or bonus" product, include base size + amount "free".	Retailer's product file
UOM	Unit of Measure used for Modeling and Optimization. Should be consistent within a demand group.	Alphabetic CT, OZ, LOAD, SHEET, LB	Retailer's product file
Brand	Corrected/inferred brand to be used for modeling. Brands can be streamlined in the PIF or on the OpenLink Category Breakdown page.	Alphabetic only, no spaces or illegal characters (&, /, "", *)	Retailer's product file
Ref DT Status	Determined by aggregating the results of the Product Status Resolver rules.	Do not change	Result of Product Status Resolver, if run
Ref Customer Status	The product status as it is sent from the retailer.	Do not change	Retailer's location status file; defaults to ACTIVE if no value is sent
Ref Current Retail	Summary Statistic: Average of current retail price over the last 12 months across stores, if loaded	Do not change	Retailer's price file
Ref Avg Scan Price	Summary Statistic: Volume-weighted Average Scan price over the last 12 months	Do not change	From POS scan data
Ref Price per UOM	Summary Statistic: Price per UOM as divided by information on PIF	Do not change	Calculated on PIF
Ref Avg Weekly Volume	Summary Statistic: Average Weekly Volume over the last 12 months across all stores at chain level. If the application does not have a record for a week, the volume is not counted as zero.	Do not change	From POS scan data
Ref Cost	Summary Statistic: Cross store straight average of cost sent in the Current® Cost file, if available.	Do not change	From POS scan data
Ref First Scan Date	Date product first scanned (across all stores)	Do not change	From POS scan data
Ref Last Scan Date	Date product last scanned (across all stores)	Do not change	From POS scan data
Product ID	An DemandTec by Acoustic assigned unique SKU ID	Do not change	System assigned

Highlighted rows indicate fields which should be completed in the PIF.

Name	Description	How to Complete	Source
Size Class	Applied in OpenLink or Price Management. Each item in a Size Family is given a number/level: 8 oz = SMALL, 16 oz = MEDIUM, 24 oz = LARGE	Allowable Size Class formats are size classes that are defined for the category in Price Management. If the Size Classes have not yet been defined, use the default Size Classes (XXX-LARGE, XX-LARGE, X-LARGE, LARGE, MEDIUM, SMALL, X-SMALL, XX- SMALL, XXX-SMALL), which can later be modified in Price Management. 50 characters maximum. Do not include Bonus products or Trial/Travel sizes in Size Class.	Blank
Size Family	Applied in OpenLink or Price. Size Family is used to set rules for pricing on how different sizes of the same product should be priced on an absolute basis (for example, Small < Medium < Large), and on a relative basis based on the equiv price (for example, the large should be a better value than the medium.	Alphabetic, 50 characters maximum	Blank
Brand Class	A value which differentiates two products with a family. In this case, Brand Class differentiates products within a Brand Family.	NATIONAL, PRIVATE LABEL, or define as needed, 50 characters maximum	Retailer's product file, usually blank
Brand Family	A value which links two products together for the purpose of comparison through rules. The Brand Family is usually the type and size of the product being compared across brands.	Alphabetic, no illegal characters (&, /, *), 50 characters maximum	Retailer's product file, usually blank
Pre Priced	Indicated pre-priced product, supplied by the retailer. Populated with a 1 if the product is pre-priced. A pre-priced product will NOT change price during the course of the optimization.	Pre-priced product = 1 Non-prepriced product = 0	Default is 0; if the value comes from the retailer a value of 1 indicates a pre-priced product
Line Group	Line price group value sent by retailer.	Alpha-numeric, no spaces or illegal characters (&, /, *), 50 characters maximum	Retailer's product file
Other Family/ Other Class 1&2	Establish other relationships when Brand Family/Class is already being leveraged.	Define as needed	Blank
Ref Level 1-12 Code/Desc	Generally product hierarchy fields from host system. May help outline Demand Group structure.	Do not change	From Retailer data
Ref Attribute 0-9	If you send Location or SKU attribute values in your location or product file (typically sent by your IT dept), you can choose to populate these values on the PIF using the attribute field on the product table.	Do not change	From Retailer data