Update all pricing at once

Hello,

I have looked and think there is not an option but wanted to check one last time.

I have installed the Auto populate mod but it wont' really work for what I need.

I have 2600 items on this website and I have a new excel sheet where 1578 of the items are changing prices. There is nothing in common with the price changes though, some go up in price and some go down.

Is there an SQL statement I can run to update them at once? I could break the excel file apart and create a long sql statement but not sure how I should format the statement

I basically need to do something along these lines

Update PRODUCT PRICE = 59.95 where PRODUCTS_ID = 5695

ANY HELP WOULD BE GREAT

THANKS

how about using easypopulate,

Download Model/Price/Qty .csv file to edit

If you are ABSOLUTELY 100% CERTAIN YOU REALLY KNOW WHAT YOU'RE DOING and have RELIABLE BACKUPS and you know how to recover from a problem by restoring from those backups (and have tested it), you can try this:

update products set products_price = 55.55 where products_id = 123;

That's what the "Excel Populate" plugin/contribution was built around doing, using Excel.

bingo, thank you