Our client uses Magento CSV import/export functionality to import and export stocks and pricing regularly.
Special prices for the products keeps changing. While importing special prices, if we keep the special price row as blank it won't replace the special pricing in the product. Also, if we pass NULL the special pricing becomes 0 and we start giving customer freebies.
we need to remove the special price when customer imports using CSV. It is fine to pass some parameters if required.
Can anyone guide me how this needs to be done?