> ## 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 EMEA - Update Existing Data Services Provided: ${color}[#f58a81](**Shelf Monitoring, Buy Online**) ePIM Logins: URL: https://epim.thinkars.com/ User: tom.stott@kcc.com Password: This changes regularly so check with the team on the most recent password if you don't already have it. Data required (and source): * Product categorisation (ePIM) * Product imagery (ePIM) * Product data (ePIM) * Keywords (no source) * Retailer product URLs (no source) * Retailer category URLs (no source) Who is responsible for loading/maintaining this data: ${color}[#5ab9c1](**Shelf Conscious**) How frequently should we refresh data in Shelf Conscious: ${color}[#5ab9c1](**Quarterly**) **Product Data (ePIM) & Product categorisation (ePIM)** When logging in, you may be asked to do an OKTA Push. Make sure you click 'Do not challenge me on this device again' and message Tom to approve the push: ![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/push_8cpe5s.png) Once logged in you'll need to make sure you are in the EMEA section, here's how to do that: || ${color}[#5ab9c1](Video:) https://share.shelfconscious.com/NQuwNRyb ||| Note that you'll need to select "Europe, Middle East & Africa" __not North America__ like in the video. You __do not__ need to change the content language/country depending on the account that you're updating, this is done by selecting the relevant export instead. The steps below are the same for each country. ![](https://storage.crisp.chat/users/helpdesk/website/8ee77ec08b8cc000/epim-better-quality_14mfz9g.jpeg) **Defining the product catalogue for Shelf Conscious** Product Filters: **Sales and Distribution Status** -> On Sale, Rollovers **Target Market** -> _EITHER_ United Kingdom _OR_ Germany _OR_ France _OR_ Italy _OR_ Spain **Exporting the product catalogue from ePIM** Tick 'Include Versions' box and batch export all as below Select batch options -> Export -> Apply to all Results Choose the correct Export: ${color}[#5ab9c1](UK:) Shelf Conscious Copy Update Template UK ${color}[#5ab9c1](DE:) Shelf Conscious Copy Update Template DE ${color}[#5ab9c1](FR:) Shelf Conscious Copy Update Template FR ${color}[#5ab9c1](IT:) EMEA KCP General EMEA KCP All Product Information IT-IT ${color}[#5ab9c1](ES:) EMEA KCP General EMEA KCP All Product Information ES-ES Export All Versions Uncheck 'Include Obsolete Products' Select Export Content -> Data Click Export Head to https://outlook.office365.com/mail/inbox and log in as tom.stott@kcc.com (same password) Please remember to re-run the product filter for the relevant target market before running each export **Cleansing the ePIM export file** Within the export there is a column named "Target Market Sales Status (*COUNTRY*)". Filter and delete any items marked as 'Obsolete' or 'Redundant' in this list (this may be in local language). We are then left with our list of codes that should be in Shelf Conscious. ${color}[#5ab9c1](UK) - Remove Obsolete, Redundant, Prior to On Sale ${color}[#5ab9c1](DE) - Remove Obsolete, Redundant, Prior to On Sale ${color}[#5ab9c1](FR) - Remove Obsolete, Echantillon, Fin serie ss. rempl., Prior to On Sale We also need to check for duplicates and make sure we only use information for the "Current" version of the product. The video below shows how to do that. || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/DOu6Lrq4) ||| **IMPORTANT:** The following videos use data from NA Accounts, however the process is the same. **Exporting the product catalogue to be updated from Shelf Conscious** Select relevant client account (UK, DE, FR, IT, ES) on 'Products' page, select 'Bulk Update Products' and 'Download Products' || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/QwuEL6ep) **Identifying NEW Products** Open a new spreadsheet to use for your working file and copy the full list of 'Short Code' from the ePIM file. Complete a lookup to the Shelf Conscious file, anything returning an error means the code is not in the Shelf Conscious file and will need to be added. Note that you will need to convert text to numbers within the export files in order for VLOOKUPs to work. || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/04uAEeme) We __cannot __load these codes using the Update export, these need to be added using the 'Bulk Add New Products' Template. As such, for now we need to ringfence these codes for later. || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/z8u6Lv7b) **Identifying Products to be DELETED & Deleting them** We need to identify any codes that are in the Shelf Conscious file but are NOT in the ePIM file. This will indicate any codes that are obsolete and do not need to be in Shelf Conscious any more. To achieve this, run a lookup from the SC MPNs to the ePIM MPNs. Anything in the SC list that is not found in the ePIM list can be deleted (do some spot checks in ePIM to validate). To delete, populate the 'Delete Product' column in the SC file and upload. It makes sense for us to run the process of deleting products at this stage, before we update the product information for the remaining products. || ${color}[#5ab9c1](Identifying Codes to be deleted Video: https://share.shelfconscious.com/eDuj5AXo) ||| IMPORTANT: The Video describes using a 'Y' to delete products, this should be 'X' || ${color}[#5ab9c1](Deleting Codes Video 1: https://share.shelfconscious.com/YEuRrlJQ) || ${color}[#5ab9c1](Deleting Codes Video 2: https://share.shelfconscious.com/5zuBLpkX) ||| **IMPORTANT: RUN THE PROCESS TO DELETE CODES AND THEN RE-DOWNLOAD THE UPDATE FILE TO COMPLETE THE DATA UPDATES. THIS IS THE EASIEST APPROACH.** Updating Product Information in Shelf Conscious You may remember that the biggest difference between the two files we're working with is that the ePIM file contains one row of data per product, whereas our SC file contains one row of data per product pack size. This makes the update process a little more complicated as there are different actions to take depending on the product pack size. There are multiple approaches to getting this data updated, so you may have a preferred method to the one I'm taking. **Here's the steps I to take to update product data:** 1) Re-download the bulk update file, check codes have been deleted 2) Ensuring we have an up to date list of attributes in Shelf Conscious 3) Adding rows to the ePIM file to replicate the number of pack size variations 4) Copying data over 5) Populating our content source of truth with pack size variations taken into account **1) Re-download the bulk update file, check codes have been deleted** || ${color}[#5ab9c1](Video Steps 1 & 2: https://share.shelfconscious.com/6qu8ZWvk) **2) Ensuring we have an up to date list of attributes in Shelf Conscious** || ${color}[#5ab9c1](Video Steps 1 & 2: https://share.shelfconscious.com/6qu8ZWvk) **3) Adding rows to the ePIM file to replicate the number of pack size variations** || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/Jru4OvkP) **4) Copying data over** || ${color}[#5ab9c1](Video: https://share.shelfconscious.com/WnuYydAA) **5) Populating Shelf Conscious Fields using the updated data (considering pack size variations)** || ${color}[#5ab9c1](Video - Adding Categories: https://share.shelfconscious.com/bLuAKxRg) || ${color}[#5ab9c1](Video - Title & Long Description Update: https://share.shelfconscious.com/v1ujzeO2) || ${color}[#5ab9c1](Video - Upload to Shelf Conscious: https://share.shelfconscious.com/9ZuxmDQr)