Update Magento Prices in Bulk
There are 3 features that make the Price Changer extension is the most efficient way to change prices in Magento. Firstly, you can determine which products price you want to change by filtering your whole set of products using your existing product attributes. When you first enter the Price Changer section of your Magento Admin, you will see a grid contain all of your products next to a list of all of your product attributes (including the custom product attributes you've created in the Magento Admin). Each time you click an attribute it is added as a column to the grid and is filterable. You can use as many attributes as you need to filter your products until you the specific set of products you need to change.
Secondly, once you have your product set, rather than manually enter a price for each product, you can apply dynamic transformations to the whole set. To carry out a transformation, the Price Changer extension asks for a base attribute, a target attribute, a transformation type (fixed amount, percentage) and a rounding option. Both the base attribute and target attribute can be selected from a list of all of your decimal type product attributes (including custom attributes). The base attribute is used to get the base value in the transformation and the target attribute is where the transformation that has been applied on the base attribute is set. As an example, let us say that you want to set a special_price for your set of products with a 10% discount of the standard price. To do this you would set the 'price' attribute as your base attribute and 'special_price' as your target attribute. You would then set the transformation type to percentage and the percentage value to 90%. When you carry out this transformation, for each product in your set the extension would take the price stored in the base attribute (in this case the 'price' attribute), calculate 90% of this value and save this in the target attribute (in this case, 'special_price'). This would have the effect of putting all of the products on sale with a 10% discount.
To make this even cooler, you could set rounding options for the final price. Using the above example, you could set a rounding option of 'Round to nearest 0.99', which would then round the final value to the nearest 0.99. You can enter any number in this rounding field.
The third and final feature that makes the Magento Price Changer the most efficient way to bulk change prices in Magento is it's pricing import system. This system has been heavily optimised based on our knowledge of Magento's EAV database system so that we can import several hundred prices in just a few seconds!
Have Your Say...
If you have used Magento Bulk Price Changer and want to share your opinion, you can leave a review by clicking here.
- PaulFantastic product and great support :)
- NevilFirst time I actually take the effort to write a review. This thing is great! Been looking for something like this for a long time, you should up your SEO or something to get this found. It's great!
The rounding especially, great function :)
Keep it up!
- Richard Blezerbought the extension with install service. The extension was installed the very same day.
After testing the extension it apeard not to be working. After a quick examination by the programmer the problem was spotted and solved. The extension itself is quite easy to use. You can add percentages or fixed amounts. One product , ten products, one hundred products, no problem. Can potentionaly save hours of very dull work.
- KrogerI have been using a similar more expensive extension than this but I have 20,000 products and it takes forever to work. This extension updates 20,000 product prices in under a minute!
I really am impressed with the rounding feature. It wasnt available in my previous price changing module
- John JLTGreat extension that saves me hours every month. My only improvement would be to be able to filter products by category!
- FWMy suppliers have monthly price changes that have always been a nightmare to do (each brand changes the price by a different percent so I would have to do all them all manually!).
Using this extension, I am able to select all products by a specific brand and increase their price by a percent and round it to the nearest .95p!
Easily worth the money as it saves me about 10 hours a month in man hours
Installing the Magento Price Updater
The best way to install this extension is Magento Connect. After you have downloaded the .tgz file from your account on FishPig.co.uk, login to your Magento Downloader (add /downloader to your Magento URL) and login with your Magento Admin details. You can then use the Direct Package File Uploader form to upload and automatically install the extension.
If you do not have access to the Magento Downloader, you can install the extension manually by FTP. To do this, extract the files from the .tgz file and merge them with your Magento root. If you choose this method, you can safely ignore the packahe.xml file.
Next, refresh the Magento cache and if you're logged in to the Admin, log out and then log back in again. You should now see the option Catalog > Manage Prices in the top navigation of the Magento Admin.