Important: For price increases this needs to be approved by the PRM. For price decreases or increases of more than 40% to our cost, you must flag this to your TL/Manager as it may cause issues with the pricing algorithm.

Also make a note to ask the supplier what date this list will take effect from on any outstanding POs (Order date or Delivery Date). This will help to avoid formstacks coming in from AP.

1. Import the new Price List into a fresh google sheet. Format it as plain text and then format the pricing as numbers. Duplicate the pricelist tab and name it "Worksheet".

2. Import the item price list from NAV for this vendor onto the same google sheet. Format it as plain text and then format the pricing as numbers. Name this tab "NAV Price".
   
   

3. Name the google sheet using the following logic "DD.MM.YYYY SUPPLIER NAME EFFECTIVE DATE"
   
   

4.  Add a column beside the SKU column from the supplier and name this "NAV SKU". Lookup the supplier's SKUs against the SKU column in NAV Price and return the NAV SKUs. If there are any N/A results,  look these up against the Vendor Item Number on NAV Price and return the SKU column. If there are still N/As, manually check these in sales portal to check if they are loaded. Note anything that has not been loaded and flag it in the response to the supplier and PRM.

5. Use this column for any lookup functions.
   
   

6. For all of the below steps, ensure you check any issues you spot or unusual price changes with your TL/Manager.  Pricing can be complicated to fix so it's best to call out the issues before any changes are made!
   
   

7. Using a lookup function on the worksheet, check the supplier's new invoice price against the nav price (column is called purchase price) by creating a new column beside the supplier's pricing. Name this new column "NAV Cost".
   
   

8.  Add another column beside this called "Diff". In this column subtract the NAV cost from the new supplier price.
   
   

9. Add another column beside this called "Percent". In this column, divide the difference by NAV cost and format it as a percentage.
   
   

10. Repeat steps 5-6 for the RRPs.
    
    

11. Inform your TL/Manager of anything with a decrease of 10% or more. This is important in case we need to look into price protection.
    
    

12. If not already approved, share the above details with the PRM and request their approval for any increased prices. If the prices are all decreases then you needn't request approval to load it.
    
    

13.  Once approved, update the NAV cost prices by making a copy of this sheet. Name it using the following logic "DD.MM.YYYY PRICE UPDATE TICKETNUMBER".
    
    

14. Filter to all SKUs that have a changed price on your worksheet. Then, using the examples as a guide, fill out the sheet accordingly and delete the example rows and headings. Download this as a CSV and move to your NAV desktop.
    
    

15. Go to the items tab on NAV and click "Import Purch. Prices" on the blue ribbon. Select your CSV file and click open. The prices will immediately update - double check a few SKUs to ensure it worked.
    
    

16. Go back to your worksheet and filter to all SKUs that had an RRP change. Update these using the RRP bulk update on PSS. Ensure the date is correct before submitting the change! Double-check a few SKUs to ensure it worked.
    
    

17. Ensure all your sheets are correctly titled and set sharing on all of them to Winnings. Attach a copy of any upload sheets to your ticket.
    
    

18. Update the Supplier Maintenance Sheet with this new price list, fill out the columns accordingly.
    
    

19.  Reply to the supplier (with PRM on CC) to advise the pricing has been uploaded. Ensure you flag any issues you uncovered and any SKUs that were not loaded on NAV in this email.

20. Compare the sku list in the new price list to the active skus under the vendors in NAV - anything that isn't on the price list but is active in our system , get update from supplier regarding availability and pricing 

NAV change 

1.  Check that there is no massive  changes in new price , confirm with PRM 

2.  Go into item tab in NAV > search SKU > Purchase prices 

3. Copy the main vendor number into the purchase price field 

4.  Enter in MOQ , enter in start from when supplier said new price is valid from , put new price in ( make sure you enter in price ex GST ) and tick WA standard 

5. Change the current prices ending date the day before the new one starts 

6. Hit the down arrow on the keyboard and hit yes to "  renaming the record "  

PSS change 

1.  Go into PSS  > SKU 

2. Hit edit and change RRP field into the new price hit save

3.  Refresh sku after a few seconds to make sure it went through 

4. For PSS future change you will need to do a bulk upload in RRP if you do this you need to set a reminder to make sure the change went through