KCP NA - Top 50's
KCP NA provide us with the Top 50 SKU's by retailer, which we need to update biannually.
1) Download Current Product Catalogue from Shelf Conscious
At the bottom of the Products page click on "Bulk Update Products"
Click on "Download Products"
Once this has downloaded you'll get a pop up which takes you to the Reports page where you can download the file.
2) Populate Top 50 Attribute
For reference this is the formula used:
=IFERROR(IF(VLOOKUP(H3, '[Copy of Top 50 eCom Items - Additional Distributors.xlsx]HD Supply'!$G:$G, 1, 0)=H3, "Yes", ""), "")Repeat this process for all other retailers with Top 50 information available.
3) Upload to Shelf Conscious
Once the upload is complete you should get this message:
Updated on: 14/01/2022
Thank you!