I imported a very large number of products using magmi to magento, the import completed without problem. After that, i wanted to update the prices of the products, so i used magmi again with mode “update existing items” but after that, i discovered that now i see special price on my products (the special price being the old price value).
When i click on the product to add it to cart, the special price is ignored and the right price is displayed in the cart so i guessed the problem is with the view.
I don’t even have a column special_price in my csv file.
I tried to clean cache via backend but to no avail.