Bulk Updating Pricing?

[stitchup]

Hi guys

My store has over 350 products of varying prices.

What I wish to do is to reduce the price of every product that's presently £16.99 to £13.99.

How can I do this quickly?

Regards

John

 

[zigojacko]

Catalog > Manage Products

Filter by price 16.99.

Select all visible products.

Update attributes from the 'Actions' dropdown and click 'Sumbit'.

Scroll down the 'Attributes' section until you find 'Price'.

Enter 13.99 after clicking the checkbox to make the change.

Then click 'Save'.

This will update all products that are currently 16.99 to 13.99.

 

[stitchup]

Thanks for the reply and sorry I didn't reply sooner - wasn't aware of your reply!

I've been struggling with this issue for a while and having followed your instructions, Price still doesn't appear as a filterable field!

I've included two pictures, if you see something that's not set right, I'd appreciate your reply





Regards

John

 

[Chris Ashdown]

Bet you have spent more time trying to sort it than manually doing it for the 300 odd products

 

[stitchup]

You're probably right

 

[stitchup]

When viewing Manage Products - I don't have a 'Price' column I believe the 'Price' attribute is configured correctly.

 

[zigojacko]

If you don't have a 'Price' column in Catalog > Manage Products then someone must have made a modification to your store thus removing it. It should be visible from that page by default.

It is more than likely a Mage local code pool modification unless you are using 3rd party extensions that allow you to change the columns there.

 

[Amasty]

Hi! I hope you've managed to change the prices according to your needs
Next time you may try using this extension - https://amasty.com/mass-product-actions.html
It will help to apply different bulk actions on the product grid, price change included.

 

[Crystal Web Designs]

Hi Stichup,

It appears you have solved this problem but just wanted to still comment.


Whenever something funny happens on our Magento websites our first task is generally to disable 3rd party extensions. 99% of the time it's a 3rd party extension that has broken or modifed your website in ways you didn't want (unless you have developers modifying core code which is much much worse).

So if the price column or anything else doesn't work, just disable the extensions (if they don't effect your website too much), then perform the actions you need (you may need to clear the cache before then too), then enable the extensions again.