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? – Dinesh Yadav Nov 27 '17 at 7:29

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.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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