How to move pricing across to a new vendor card - with no updated price list from supplier 

• Before moving the items vendor across you want to secure all pricing of the skus for the new vendor no. , you should have a updated price list from the supplier to confirm this if they advise pricing stays the same based on pricing on old vendor card the below will show you how to action. 

1. Open the item page and select Item pricing information

2. Put in the current vendor no the items are loaded against (I.E if we are moving 000022 to 000032 then use 000022 in item pricing)

3. Click preview then the save icon once generated and save it into a folder of your choice on the X Drive. (Normally use the folder with your name on it)

4. Click the save icon again and right click the file you just saved then select open.

5. Copy all the details into a google sheet for use later

6. Go the pricing template update link - Here

7. Copy and paste the No. column into Sku column of the pricing template, put in the new vendor no (in this example 000032) and put the date to 1st of the current month and then copy the purchase price column in the item pricing information into the price column on the template

8. Remove the first row (headers) on the pricing template and download as CSV

9. On the item page click the Import Purch. Prices upload and copy the CSV into the X drive and load

10. Once Finished you want to move the items across to the new vendor

11. Go to Departments > Utilities > Reports and Analysis > Update Vendor No in Item Card (3rd last) and add the new vendor no in the New Vendor No field and the old vendor no in the item field. (You can add more filers to move specific move certain items over if the whole vendor is not changing like item products or Skus)

12. Sense check it was done by opening an item that should be on the new vendor, check the vendor no in the item card and the new vendor no in the purchase prices on the item card