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!