I use Magento CSV import/export functionality in order to import and export stocks and pricing regularly and it works perfectly.

But I do not how to remove an existing "special_price" by using the CSV file. If I pass "NULL", will the special price becomes 0?

Can anyone help me? Please!

  • you want special price to be update or delete all price from product? Commented Aug 6, 2016 at 7:05
  • Thanks for reply. I want to delete all existing special price from the CSV import functionality.
    – rmalcazar
    Commented Aug 7, 2016 at 12:08

3 Answers 3


I encountered the same issue and it's actually quite easy to solve. Magento CSV import allows you to unset the value of an attribute by putting the Empty attribute value constant in the column value. In most case it is __EMPTY__VALUE__ as in import setting as can be seen in the screenshot

My sample CSV structure is like this:

enter image description here

  • You have to set import behavior to "Add/Update" for this to work.
    – khuenq
    Commented Jun 4, 2020 at 6:29
  • Only Available in 2.3.x
    – th3pirat3
    Commented Aug 21, 2020 at 1:10
  • @khuenq Nice answer Commented Jun 1, 2021 at 17:19

If i understand you , you have just to choose Import Behavior 'replace', and left 'special_price , special_price_from_date , special_price_to_date' empty with value inside csv


If the import file includes all the catalog/products you have on website, or you can filter priducts with common criteria,then you cans use mass update as a workaround in order to unset special price. After that import your file so only given special prices will be updated.

enter image description here

enter image description here

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.