> ## 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 - Is Dispenser?

**Populating the "Is Dispenser?" Attribute**

KCP NA are using the custom attribute "Is Dispenser?" to be able to filter to see only Dispensers, or filter them out of reports. 
This attribute should be updated when catalogue updates are completed or new products added. 

**1) Determining which products are in the "Dispenser" category**

|| ${color}[#5ab9c1](Video - Exporting dispenser list from ePIM:) https://share.shelfconscious.com/04uLqYlA


**2) Download Product Update Template from Shelf Conscious**

Select relevant client account
on 'Products' page, select 'Bulk Update Products' and 'Download Products'
 
|| ${color}[#5ab9c1](Video: https://share.shelfconscious.com/QwuEL6ep)

**3) Populate Custom Attribute**

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

For reference this is the completed formula used:

||| =IFERROR(IF(VLOOKUP(H84, [NA_Pro_All_Product_Information_Export_20220113_110216.xlsx]Sheet1!$E:$E, 1, 0)=H84, "Yes", ""), "")

**4) Upload to Shelf Conscious**

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

When the import is completed successfully you'll get this message 


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