Articles on: Catalogue Maintenance

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


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'

Video: https://share.shelfconscious.com/QwuEL6ep


3) Populate Custom Attribute


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


Video: https://share.shelfconscious.com/7KuqL81g


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





Updated on: 14/01/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!