{"id":1582,"date":"2021-02-27T12:00:30","date_gmt":"2021-02-27T12:00:30","guid":{"rendered":"https:\/\/meetanshi.com\/blog\/update-product-price-and-special-price-using-csv-in-magento-2\/"},"modified":"2025-07-24T14:21:56","modified_gmt":"2025-07-24T08:51:56","slug":"update-product-price-and-special-price-using-csv-in-magento-2","status":"publish","type":"post","link":"https:\/\/meetanshi.com\/blog\/update-product-price-and-special-price-using-csv-in-magento-2\/","title":{"rendered":"How to Update Product Price and Special Price Using CSV in Magento 2"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\"><em>\u201cThe moment you make a mistake in pricing, you\u2019re eating into your reputation or your profits.\u201d&nbsp;<\/em><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">An online store owner has to constantly monitor his pricing strategy as well as the competition so as to not damage the profit margin.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">A merchant needs to update the product prices in cases such as:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Change in customers\u2019 demand<\/li>\n\n\n\n<li>Fluctuation in the market<\/li>\n\n\n\n<li>Change in budget<\/li>\n\n\n\n<li>The increased cost of raw materials<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">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&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/auto-update-currency-rates-in-magento-2\/\">Magento 2 auto update currency rate<\/a>&nbsp;will also be helpful to you as updating manually is an tedious task.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Also, the special prices are set for only a specific time period and it needs to be reverted after the offer ends.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Updating the price and special price manually from the admin is not only tiresome but also the time-consuming process. Instead, you can use&nbsp;update product price and special price using CSV in Magento 2.&nbsp;Or you can&nbsp;<a href=\"https:\/\/meetanshi.com\/blog\/update-product-price-programmatically-magento-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">update product price programmatically in Magento 2<\/a>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Check the below steps for updating the price from the admin panel:<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Steps to Update Product Price and Special Price Using CSV in Magento 2<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">1. <strong>Login<\/strong>&nbsp;to Magento 2 admin panel.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">2. Navigate to&nbsp;<strong>System &gt; Import<\/strong>.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">3. Click on&nbsp;<strong>Products<\/strong>&nbsp;in&nbsp;<strong>Entity Type<\/strong>&nbsp;dropdown.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">4. Select&nbsp;<strong>Add\/Update<\/strong>&nbsp;in the&nbsp;<strong>Import Behaviour<\/strong>&nbsp;dropdown.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/admin-import-first-1024x492.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13069\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">5. Import your updated CSV file as mentioned below to&nbsp;<strong>Select File to Import&nbsp;<\/strong>option.<\/p>\n\n\n\n<figure class=\"wp-block-table\"><table class=\"has-fixed-layout\"><thead><tr><th><strong><br>sku<\/strong><\/th><th><strong>price<\/strong><\/th><th><strong>special_price<\/strong><\/th><\/tr><\/thead><tbody><tr><td>24-MB01<\/td><td>35<\/td><td>30<\/td><\/tr><tr><td>24-MB04<\/td><td>50<\/td><td>45<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/admin-import-second-1024x433.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13070\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Click on&nbsp;<strong>Check Data<\/strong>&nbsp;button after successfully importing CSV file.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/validation-success-1024x139.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13072\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If everything is correct, then it will display a&nbsp;<strong>valid<\/strong>&nbsp;message and click on the&nbsp;<strong>Import<\/strong>&nbsp;button.<\/li>\n<\/ul>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/success-import-1024x99.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13073\"\/><\/figure>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Finally, after the successful process, a&nbsp;<strong>Success&nbsp;<\/strong>message will display.<\/li>\n\n\n\n<li>Now, you can check the update on your price and special price.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Price and Special price before following the above steps<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/product-before-1024x146.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13074\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><strong><strong>Price and Special price after following the above steps<\/strong><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/meetanshi.com\/blog\/wp-content\/uploads\/2021\/02\/after-update-grid-1024x148.jpg\" alt=\"How to Update Product Price and Special Price Using CSV in Magento 2\" class=\"wp-image-13075\"\/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">That\u2019s it.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Feel free to share the solution with Magento Community via social media.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Thank You.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u201cThe moment you make a mistake in pricing, you\u2019re eating into your reputation or your profits.\u201d&nbsp; An online store owner has to constantly monitor his&#8230;<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[34],"tags":[],"class_list":["post-1582","post","type-post","status-publish","format-standard","hentry","category-magento"],"acf":[],"_links":{"self":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1582","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/comments?post=1582"}],"version-history":[{"count":3,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1582\/revisions"}],"predecessor-version":[{"id":16276,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/posts\/1582\/revisions\/16276"}],"wp:attachment":[{"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/media?parent=1582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/categories?post=1582"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/meetanshi.com\/blog\/wp-json\/wp\/v2\/tags?post=1582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}