Price/cost report

Use the Price/Cost report to view or edit the current price and cost of a product by store, zone, or line before running optimizations. You can sort this report by cost and price to check for data anomalies.

About this task

You can override costs if inaccuracies exist, but subsequent data imports from OpenLink may overwrite manual cost changes in Price Management and Price Optimization. You should update in-house legacy systems.

The report displays information such as the product description, UPC, zone, size, price, and unit cost. If you have multiple costs available, you can edit the report to set the Cost 1 or Cost 2 fields to display additional cost types. You can also set the manufacturer of the product to display at the SKU levels from the Edit Report page.

CP users can view costs for their manufactured products in the Mfg. Cost column at the SKU/Zone level, if their costs have been imported through a data load. Costs for other products are calculated using a Gross Margin ratio or other percentage.

You can also set a product as pre-priced for all stores in the Preprice column, or locked in the Locked Price column (indicated by a lock icon) for specific stores or zones. See Price/cost report for more information about locking prices.

In this report, you can select and right-click on a product at the SKU levels to open the Product Relationships tab in the Product Analyzer utility (PRA). The Product Relationships tab shows details for the selected product, such as Product Group information, other items in the same Line Price Group, prices and costs for that product, competitive data, and other attributes related to that product.

Using Price Lock

To freeze the price of a product in specific stores or zones, use the Price Lock feature to support the stop or lock price movement of products at the store or zone level.

Prices are locked for one of two reasons:

The price of a product needs to remain constant in one zone, but can move for other zones
The price of a product needs to remain constant in one store, but can move for other stores

When locking the price of a product for a single store and that store is in a pricing zone, the Price Lock feature should be used in conjunction with the Zone Override field. This will freeze the price of one store and allow other stores in the zone to change.

For example:

Pre-optimization

Product	Store	Zone	Base Price	Locked and Zone Override?
16 oz soda	1	1	1.49	No
16 oz soda	2	1	1.49	No
16 oz soda	3	1	1.49	Yes

Post-optimization

Product	Store	Zone	Base Price	Locked and Zone Override?
16 oz soda	1	1	1.29	No
16 oz soda	2	1	1.29	No
16 oz soda	3	1	1.49	Yes

Because store #3 is locked and overrides the zone rule, the price does not move and store #3 can have a different price than other stores in the zone.

Note: If prices for a particular product in a particular store need to be exempt from the zone rules for pricing, then the Zone Override feature can be used in isolation of Price Lock. Simply choose the store within the zone that should receive an override, and then use unique price rules such as Price Product Group Limits, which can be used to apply pricing to a specific product in a specific store.

To price lock products:

Procedure

Choose Data > Data Maintenance to open the Data Maintenance page.
Choose the Price/Cost report from the Report drop-down menu.
The Price/Cost report displays.
Click Edit next to the report name.
The Edit Report page displays.
Set the Visible checkbox next to Locked Price to display the Locked Price column in the report. Set the same checkbox next to Zone Override to display the column in the report.
Click Save.
In the Price/Cost report, scroll to the right until the Locked Price column is visible.
For each product that you want to price lock, click in the Locked Price column so that the lock icon appears in the checkbox. The price will not adjust during the optimizations.
If you are locking prices at store level and the store is in a pricing zone, set the Zone Override checkbox so that the prices in the other stores in the zone change.