Objective
For each published planogram, you have the possibility to generate a report detailing:
- Delisted products: Products with positions on the old planogram which are not on the newly published planogram.
- New Products: Products with positions on the newly published planogram which are not on the old planogram.
- Substitute Products: New products as defined above with data/text present in the column [TBC].
Example of generated Planogram Comparison Report
Note: Under 'Substituted Products', PREDECESSOR & PREDEC_REASON columns are currently planogram generic, i.e the same value for every planogram.
Comparison
Compare the newly published planogram with the newest status “OLD” planogram which has the same assortment group and store number as the newly published planogram.
Output
The report output will be an Excel file with a single worksheet. The folder path and filename will match the my.Spaceman publishing output name, except for a ‘R’ suffix instead of the ‘P’.
Operation
This will be a standalone application which will regularly monitor the database for planograms who’s status changes to ‘PUBLISHED’. Once the status has changed the report will be generated.