How to Update Product Price and Special Price Using CSV in Magento 2
“The moment you make a mistake in pricing, you’re eating into your reputation or your profits.”
An online store owner has to constantly monitor his pricing strategy as well as the competition so as to not damage the profit margin.
A merchant needs to update the product prices in cases such as:
- Change in customers’ demand
- Fluctuation in the market
- Change in budget
- The increased cost of raw materials
Product price and special price modification is a continuous process. You cannot set a price once, leave it and expect it to be profitable, and thus, you may require to update the product prices. Likewise Magento 2 auto update currency rate will also be helpful to you as updating manually is an tedious task.
Also, the special prices are set for only a specific time period and it needs to be reverted after the offer ends.
Updating the price and special price manually from the admin is not only tiresome but also the time-consuming process. Instead, you can use update product price and special price using CSV in Magento 2. Or you can update product price programmatically in Magento 2.
Check the below steps for updating the price from the admin panel:
Steps to Update Product Price and Special Price Using CSV in Magento 2
- Login to Magento 2 admin panel.
- Navigate to System > Import.
- Click on Products in Entity Type dropdown.
- Select Add/Update in the Import Behaviour dropdown.
- Import your updated CSV file as mentioned below to Select File to Import option.
sku price special_price 24-MB01 35 30 24-MB04 50 45 
- Price and Special price before following the above steps
- Price and Special price after following the above steps
That’s it.
If you have any doubts regarding this solution, mention them in the Comments section below.
I would be happy to help.
Feel free to share the solution with Magento Community via social media.
Thank You.
14 Comments
Hello,
Is it intended behavior that when updating product prices through an import, the prices are also applied to configurable parent products?
No it is only applied to used sku in csv
and the configurable product do not have the price.
Hi
Sanjay Jethva
Could you tell me how I can import the salable Quantity = “No Manage stock default stock” via CSV file and if I import products in Magento vis CSV file is there take time to update or immediately?
Hey Muhammad Ali Yousaf,
You have to specify it in column “custom_options”, to specify salable qty value, and if changes do not reflect then do Reindexing.
How can we import price for particular Store?
Already Tried with store_view_code it’s not working……
Hello Chandrasekhar,
The price attribute is global so you can not set value by store/website wise.
Thank You
What columns are needed if I want to update order status via CSV?
Hello Arthur,
The above solution relates with product not for orders.
Thank You
What about updating the “cost” field? I don’t see this field in the sample update CSV file. I only see “price” and “special_price”
Hello Fernando,
You can add the column as per your requirement in the CSV file.
So, add the cost column in the CSV file!
Thank You
Hello,
If I have already updated the special price and suddenly I want to return to the previous price (that is, remove the special price), how should I fill in the CSV?
Hello Sara,
No, the old price can not be restore if you don’t have backup of that file as it automatically overrides.
You have to change the price manually in the CSV.
Thank You.
What if I want change price to 10$ more than curren price? Becouse this soluttion doesn’t work :/
Hello,
Please export the product and remove every column except SKU and price.
Implement this formula: special_price = (price + 10) in the special_price column and import that CSV.
Thank you