how to update my products price if my supplier can only give me the SKU (reference) number?

[mtanislav]

Hello,
I just want to update the price and maybe the quantity of my products. My supplier only gives me the list with the product reference number. If I only import the list with reference number, name, quantity and price , prestashop import tool will just add new products because I do now have the ID of the products. So the question is how to update the products based on the reference number, not the ID.
Please help me.
If there is a module that can help me do that please let me know.
The supplier list is in .csv .

[mtanislav]

I managed to do this http://www.prestashop.com/forums/viewthread/89993/general_discussion/solvedupdate_pricing_from_price_supplier
but now when I import the reference and price I get this error

Warning: Function getIndexedCategories() is deprecated in /mounted-storage/home101a/sub009/sc62936-SSSL/www/prestashop/admin-dev/tabs/AdminImport.php on line 585
in /mounted-storage/home101a/sub009/sc62936-SSSL/www/prestashop/classes/Tools.php on line 1784

[jeevanoss]

You can take a list of product reference number & product id from shop DB, merge it with supplier list.Then use prestashop import tool.
If you want an automatic update using cron, make a module to do the update function

[mtanislav]

Thanks for your answer but I don't see (know) how to merge the files in such way to end up with a csv file with the correct id's .