Skip to main content

Calculate Revision Percentage

This automation allows you to generate a report on the amount of changes that occurred in revision planograms and mark which positions had revision changes.

Why you would use this feature

Planogram revisions submitted to Target need to have a percentage of overall change that falls within a predetermined threshold. This feature allows you to determine the amount of change in the revised planograms in order to validate that they are within the acceptable amount.

Feature Options

Planogram Selection

In order for the report to be generated and the positions to be updated, you must select the current (new) and previous (parent) planograms to be compared. Click the Add Parent Planograms button to add the previous versions of your planograms you are comparing the current ones to. Click Add New Planograms to select your planograms to be compared against the previous versions.
Your new planograms MUST have ‘REVISION’ in Desc 15(Planogram) to be included in the comparison.

Planogram Matching

Where is your parent planogram number stored?

Select the field in the field list that contains the parent’s planogram number for your new planograms.

Where is your planogram number stored?

Select the field in the field list that contains the location of the planogram’s pog number.
Planograms will be matched using the above fields. A planogram will be considered the parent of a child if the number specified in the Parent POG Number field of the child planogram matches the number in the POG Number Field of any of your specified parent planograms.

Output Options

Where do you want to save your results file?

Select an output location for the comparison results file. Browse for the folder to save the file into and provide a name for the exported file. The results will be exported to an Excel (xlsx) file. When the planograms are processed, the new planograms will be compared against their parent planograms to determine what has changed. The output file will contain details about the changes. The new planograms will have their Desc 10(Position) field updated with the revision change that was found (or blank if there was no change). The possible values are below:
  • ADD
  • MOVE
  • CHANGE FACINGS
  • MOVE, CHANGE FACINGS
  • REPLACE LABEL
  • REPLACE LABEL, CHANGE FACINGS