What is the best approach to mass updating prices? We need to batch update pricing for almost 200 products in our catalog and would prefer to learn a more efficient method than individually editing products just in case we ever need to do this again. My assumption is to use Magento's export feature to get all the products into a single flat file, update columns or do percentage adjustments and reimport the CSV back into Magento. Should I consider any other method than this?

1 Answer 1


Assuming you have a dev instance of Magento, Export a products.csv file and then make the adjustments in the .csv file (Libre Office or Excel should work).

When you go to reimport, save as a .csv and make sure the required attributes (e.g., 'status', 'visibility' and 'tax_class_id') are in the .csv when you import.

Magento allows you to check the file prior to import.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.