So i need to update price of multiple product the record of which i have got in excel . I have sku code of the product and their updated prices .

I know i can update the prices by finding each product from the backend and updating them one by one , but that takes a lot of time and seems kind of impractical if i have hundreds of product to update .

Does anyone have a script or way , so that i can update the prices at once using the products sku code to find them and update the price with the price provided in the excel sheet.

  • Don't you know how to import product csv? Commented Nov 27, 2017 at 7:29

1 Answer 1


Create your csv file as shown in below image.

enter image description here

Now navigate to

System >> Import

Choose Products in Entity Type and Add/Update in Import Behaviour.

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.