Bulk Pricing - Update all products at once?? Can it be done?

[flotsam_jetsom]

Hello,

What I want to do is update all of my products prices at once by a percentage. For example; reduce all products prices by 5-10-15%, without having to do it one at a time. That is a really slow process with 3000 products.

Can this be done?? Please help.

Thanks,
Jason

[michael_s]

use easypopulate in the admin.

[flotsam_jetsom]

Thanks for the quick reply. But I still dont see how to do them all at once. I have used easypopulate and I would still have to go through and update each product one at a time in excel and reupload them 300 at a time. Because easypopulate wont update 3000 products all at once, as far as I know anyway.

Maybe I am missing something. Could you please be more specific?

Thanks,
Jason

PS - Have a good 4th of July!

[michael_s]

Must be new to excel. Run a formula on the entire column, - 5% or whatever, in excel. It will raise or lower all at once. Very easy. Something like:

=SUM(A1-(A1*0.05))

[flotsam_jetsom]

THanks! Yeah, I havent done much with formulas in excel. But I know a few basics. I think with your example I will be able to figure it out. Thanks alot!

Jason

[auntie22]

Hello,
Is there anyway to do this update but for specials. What I mean is I would like to put everything in the entire store on sale for a period of time that will expire on a certain date and return the products to its original price.

Thank you,
auntie22