1.  Ensure the SKUs you are updating have been on NAV for at least 24 hours.
   
   

2. Locate the SKUs from the price list the supplier sent.
   
   

3. Go into PSS  > Bulk uploads 

4. Hit template under "New SKU Upload (Requires RRP and Base Price)"  and open it in excel.

5. Copy your SKU list into the relevant column. Do the same for their RRPs and ensure the RRP column and Base Price Column are the same. UNLESS the supplier provides a "go price". If the supplier has a go price in their submission, speak with your TL/Manager to confirm next steps.
   
   

6. Fill in the 'Site' column with AOL for AOL and WA for Winnings, ensuring all relevant cells are filled for each.
   
   

7. Once done, save this file to your computer with the date, supplier name and ticket number as the title. 

8. Go back to PSS and hit "Select File" and then find your file. Once selected, hit "Upload".

9. Check job reports after 20 - 30 seconds to confirm that pricing went through and highlighted green.

We can change two prices on the websites - the RRP and the Base Price. The RRP comes from the supplier and will be the same for every retailer. The Base Price is the supplier's "Go Price". For almost all SKUs the base price and RRP should be the same. Consult your TL/Manager if you believe they should be different.

1. • Go Prices, typically, should only be used when the item is loaded for the first time to the site. Your TL/Manager will help you with this if a supplier ever provides one. Essentially, a Go Price is a lower price point that the supplier believes we should start pricing at (this will help with algo pricing). 

   • It's important to remember that suppliers are not allowed to dictate our pricing exept for proforma products. 

   • IMPORTANT for proforma products, the Base Price needs to be updated as well when we update the RRP. You only need to update the RRP for wholesale products.

Need to update the below

1. To change website price this sku must not have a MMP meaning this cannot be priced based on the algorithm 

3. Go to your price list sheet  and put the SKU name in column A, the site in column B, the starting date in column C and the go price in column D

4. Make sure that columb " B " will be "AOL"  

• NOTE you don't need to load for WA as base price is changed for both sites 

5. Go to Bulk Uploads in PSS and under Base price upload click "Select File" and upload the document. ( if you schedule make sure you set a reminder to check on the day that it went through ) Double check it is loaded both in PSS and the website after 1-2 minutes 

6. Title all the your google sheets properly (Supplier Sheet, RRP Upload and Purchase Price Upload) and put them in the Supplier Maintenance Sheet and set sharing to Winnings

• This change should only be done for proforma SKUs except for certain winning appliances SKUs where the PRM or your TL will approve.

• Note that certain promotions can only be handled by the promotions team. Examples are combo deals (buy-one-get-one-discounted) or staggered discounting (1 item is 10% off but 2 items are 15% off and so on).

Need to update the below

1.  Cleaning & preparing the sheet for upload

1. Check that there is no current promotional pricing loaded for this / these skus , you do this by going into PSS and under promotional prices tab search each SKU one by one by make sure the WA-ONLINE and AOL are ticked ( easiest way to see if there is a price loaded is if there is a delete field ) 

2. Sense check data - For price increases this needs to be approved by the PRMs , go to your TL to confirm 

3. Locate and import the Supplier Price List into a fresh google sheet.

4. Add one new google sheet on the same google document and copy and paste the suppliers price sheet as plain text paste (ctrl+shift+v) 

5. Copy the following columns to create a sheet that has just the relevant information

• SKU

•  Supplier SKU (if applicable)

• RRP 

• Barcode/EAN 

6. Search and obtain a list of the vendor items in Navision ( easiest way to do this is search for a sku in the price list in Sales Portal to find vendor number ) 

7. Search the vendor number in items tab then CTRL+E on that list in navision to export it as excel. 

8.  Import that into your google sheet

9. Select that entire imported Navision list and set it as plain text

10. Create two new columns left of " A " and then paste EDI barcodes into column "A" and vendor item number into column " B " 

11. Go back to the new sheet that has the cleaned SKU/RRP/Barcode you pasted earlier

12. Add a filter to the whole sheet and filter out any blank spaces so you just have the titles of each column and the SKU's that are being updated

Validating the Data

1. IMPORTANT CHECKS 

   1. Always check if the RRP has changed as this will impact any discounts done as a %. RRP will need to be updated on the website for the promotion to appear correctly even if it is not % based.

   2. For laundry appliances such as washers and dryers, check for KitBoms of the products. These will have to be amended separately as a lot of Vendors will not include them in the price list.

2. Add 3 columns on the right of the sku column in the suppliers price sheet copied data and enter in this vlook up for the first column 

•  =VLOOKUP(A3,Sheet11’!C:C,1,0) - this one is to check sku vs sku in NAV 

• =VLOOKUP(A3,Sheet11’!B:C,2,0) - this one is to search the vendor item number but print the NAV sku 

• =VLOOKUP((EAN column ) ,Sheet11’!A:C,3,0) - this one searches the EAN vs EAN in NAV and brings the sku in nav 

3. Drag down the vlookup formulas you created so it applies to the entire pricelist. This will compare the SKU in column A to the entire box of data ( or the EAN if applicable) you selected from the Navision export

4. Add a filter, filter out the first vlookup column for all #N/As and copy any non #N/As into the filtered column . Look at the other two vlookup columns for the non #N/A models and then bring these across to filtered column so that all data that has been found is in one column 

5. Once done, filter the first vlookup column  so there are no N/A's and that leaves you with a list of SKU's and their new pricing that's in our system.

Uploading into PSS 

1. Open PSS > go into bulk uploads > hit template under promotional prices 

2. Open template and copy the vlookup template you filtered and paste into column " A "

3. Read the email sent by the supplier to understand what site we are publishing to

4. Enter either AOL or WA-ONLINE into column " B " . If both need to duplicate data and change site to the opposite eg if you did AOL then the duplicate data would be WA-ONLINE 

5. Put start date as directed by supplier as dd/mm/yyyy in column " C "

6. Put the end date as directed by supplier in column " D "

7. Put the new promotional price into column " E " , this is the price that will be live on the website , hit control + " S " 

8. Under promotional price bulk upload , select file and upload 

9. Make sure if it is in the future we set a reminder to check otherwise if same day check 15-30 minutes after upload on the website. 

• 1.  Sense check data - For price increases this needs to be approved by the PRMs, go to your TL to confirm 

• 2. Copy this template, and fill each field 

• 3. Get the vendor no. and use it to filter all SKUs under that vendor. Export this list and filter it to only existing SKUs.

• 4. VLOOKUP to check both SKU and supplier SKU in NAV , if the skus do not exist in the system remove them from the upload 

• 5. Save and share the link with winning

• 6. Upload to PSS

• 7. Update in Supplier maintenance - Pricing / SKU / Rebates sheet