KCP EMEA - Update Existing Data

Services Provided: 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: Shelf Conscious
How frequently should we refresh data in Shelf Conscious: 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:

Once logged in you'll need to make sure you are in the EMEA section, here's how to do that:

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:

UK: Shelf Conscious Copy Update Template UK
DE: Shelf Conscious Copy Update Template DE
FR: Shelf Conscious Copy Update Template FR
IT: EMEA KCP General EMEA KCP All Product Information IT-IT
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.

UK - Remove Obsolete, Redundant, Prior to On Sale
DE - Remove Obsolete, Redundant, Prior to On Sale
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.

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'

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.

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.

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.

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

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 Shelf Conscious Fields using the updated data (considering pack size variations)

Updated on: 08/03/2022