> ## Knowledge Base Index
> Fetch the complete knowledge base index at: https://staff.shelfconscious.com/sitemap.xml
> Use this file to discover available pages before exploring further.
> Pure-Markdown content can be obtained by appending a '.md' suffix to the content URLs listed in the sitemap (without the trailing slash).

# 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**


![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/image_mo88js.png)
At the bottom of the ${color}[#5ab9c1](Products) page click on ${color}[#f58a81]("Bulk Update Products")


![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/image_8m7ck9.png)
Click on ${color}[#f58a81]("Download Products")

Once this has downloaded you'll get a pop up which takes you to the ${color}[#5ab9c1](Reports) page where you can download the file.


![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/image_1q8cffr.png)

**2) Populate Top 50 Attribute**

|| ${color}[#5ab9c1](Video:) https://share.shelfconscious.com/KouYrA6p

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**

|| ${color}[#5ab9c1](Video:) https://share.shelfconscious.com/rRuN7OJY

Once the upload is complete you should get this message: 


![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/image_1uh285k.png)