Outline 

The price list contains three tabs:

• MDA & SDA, which is the price list covering the sell-ins, RRPs and purchase prices for all business units.

• Accessories, which is the price list (for their spare parts and add-on products) covering the sell-ins, RRPs and purchase prices for all business units.

• AEG, which is the price list for their AEG proforma range.

The deal sheet contains one tab

• It contains the sell-thru rebates for all business units.

• These are split vertically into promo periods, typically 2-5 periods containing sell-thrus for different dates.

Important things to watch out for

• EHP has a lot of vendor cards, the wholesale prices and rebates are for the following Vendor Numbers: 000136|000248|000326|000441|000504.

• We do not amend the pricing or upload rebates for any of the items that are not listed under these vendor numbers.

• Not all sell-thrus cover all items, nor do all sell-ins.

• Not all sell-thrus or sell-ins end at the same time or start at the same time so this needs to always be checked before loading. You must also ensure there is no overlap with previous months on NAV.

• Unlike the F&P pricelist, the sell-ins for EHP have different codes for their deal numbers so EHPAPRFOCEN25 means it’s the Focus Enhancer sell-in loaded in April 2025 and EHPAPRGA25 means it’s the Growth Agenda sell-in loaded in April 2025.

• EHP also includes additional columns to the rightmost of the sheet where we can see what affixes are associated with the SKUs (Left or Right hinges or fuelled by LPG or NG).

Deal Sheet

EHP put all their sell thru rebates on the “Deal Sheet” workbook. Some SKUs will have more than one rebate which will show under the SELL THRU 2 (red rectangle in the image below) column and the normal rebate will show under SELL THRU 1 (red rectangle in the image below).

For ease of loading, it's best to work off Excel for the Deal Sheet as importing it to Google Sheet causes problems for the formatting of dates.

Flagging Discrepancies

I would recommend opening a blank google doc and noting in it any questions you need to ask EHP so you can quickly send an email. There are often issues where a rebate has changed without notice or without being flagged on the sheet or where pricing doesn’t align with RRP changes. You can paste the link of this sheet into the action list step “Flag any pricing or rebate discrepancies”.

How to Action the Request

Name this “NAV Pricing”. I would also recommend colour coding any tabs you add to the document to distinguish them from the tabs sent by EHP.

Next, add a new column on MDA & SDA and Accessories beside the items column and name it NAV SKU (colour it in orange). In this column XLOOKUP the items against Vendor Item number on the “NAV Pricing” tab and pull the SKU into the column. 

All EHP SKUs have been updated so the Items that appear on the price list exactly match the Vendor Item Number so you should not have any #N/As.

#N/As may occur due to formatting issues, the SKUs not yet having been created on NAV or currently only set up on the commercial vendor. Resolve these accordingly.

Next, add a new column on MDA & SDA and Accessories beside the NAV SKU column and name it Vendor Number (colour it in orange). In this column XLOOKUP the SKUs against “NAV Pricing” and pull their vendor number in.

Now filter DESCRIPTION to have no blanks or zeros. 

Action List

Please copy and paste the table from this link into a new tab on the worksheet called “Action List”. The status column is for you to note where you are with finishing an action item and the  notes column is there to allow you to add any important information regarding the task.