Help Merging Spreadsheets

Hi there, if someone is able to help it would be greatly appreciated! 

I have 1 excel spreadsheet which has over 3,000 products; providing general product information such as colour, material, descriptions images and sizing etc. 

I also have a second product document which includes trade prices, delivery and mark-up's. 

Both of these documents have the same column providing the Supplier Product ID Number and Product Name. 

I am hoping to be able to merge the prices document to the product information document, getting the prices at the end of every row of the matching product by name/id number. 

I hope this makes sense, I have attached an example document which includes a 'product' and 'prices' sheet to give you an idea of the situation.

Any help would be extremely appreciated! Thank you in advance.