Need Sql Query to update inventory

[Whispar1]

Since there is no easy way to update inventory through prestashop (and yes, I have tried several modules) I would like to update inventory though the database instead.

 

I have created excel spreadsheet with vlookup functions that link to my suppliers daily update sheet (either csv or xls). I need to be able to update my inventory from my spreadsheet. Unfortunately I do not know sql but someone who does should be an easy thing.

 

Since most of my products use combinations and all have a unique reference number for each attribute, I need to be able to JOIN ps_product and ps_stock_available to I can have a common reference point.

 

Ideally, the query should join any tables required to create a matching data set to my CSV file and then update the inventory amount. (ps_product and ps_stock_available or ps_product_attribute ???) 

 

Thanks for any help