On a weekly basis the country sends the supplementary files to Revionics so that they can be uploaded for price suggestions. These files require checking before they will be uploaded to Revionics’ Base Price Suite to make sure that no pricing relation issue occurs.

The supplementary files that need to be checked by SST are:

• Private Label Gap (PLG) File
• Product Group File
• Price Family (PF) File

After SST checks the files, we reply to them and tell them our findings.

Sheet Checkpoints

• Look at Duplicate PLG NO.

Sheet Revionics_ProductTierGaps

• Go to column G “PLG Number” and check if highest value of this column equals value in sheet Checkpoints.

1. Filter column E “Tier” to 1 and

• Check if column F “Parent Tier” is empty as it is the highest level.
• Check if column H “Price Gap Index” is empty as parent tiers are not indexed.

2. Then filter column E “Tier” by excluding 1 this time and check if there are values in column:

• F “Parent Tier” (all cells should have value as all articles have to be linked to a parent tier),
• G “PLG Number” (all cells should have value as all tiers need to be in a PLG Group),
• and H “Price Gap Index” (should have value as all tiers must be indexed to the parent).

3. Keep the filter (value 1 excluded). Then use a formula to check if “Parent tier” is smaller than “Tier”

• It means that tiers are linked to their parent tiers. Parent tier should be smaller than tier.
• Formula “=if(logical_test(F3>E3,0,1)”
• The result should always display 1 –> report articles which have value=0

4. Select all fields and insert a Pivot table

• Rows: article subsys
• Values: PLG Number

Check column B “Count of PLG Number”:

• It only should have value = 1 in each line. Otherwise the same PLG is linked to two different articles (duplicate PLG).
• If it is higher than 1. Check in sheet Revionics_ProductTierGaps the article via the subsys nr in column A and report the articles.

1. Select every field and insert a Pivot table

• Rows: article subsys
• Values: product group name

• Check if column B “Count of Product Group Name” only has value=1 in the cells.
• If it has a higher value, it means that the article is in 2 Product Groups. But an article must only be in one product group. check the lines in sheet Revionics_ProductGroups and report articles, which have values > 1.

2. Check in Manage config if there are the same product groups as in the excel

Sheet Revionics_PriceFamilies

1. Select every field and insert a Pivot table

• Rows: article subsys
• Values: Family Type

• Check column B “Count of Family Type”: an article subsystem must only be in one PF. Meaning check if every line has the value=1
• If the value is higher than 1: Look for article subsystem in Sheet Revionics_PriceFamilies. There you should be only 1 line if it is in 1 PF. If it is in two PFs, I would see two lines (below screenshot).
• Report the articles, which belong to two PFs

Communicate your results to the customer by replying to his request.