HELP special price not working! Urgent issue !

[mario_khattar]

Hi team,

Please help me, i've exhausted so much time testing and trying to resolve this.

My developer is away, and i am having an urgent issue on my ecommerce website.

I have a magento 2 running multiple websites and when i update my special price through magento 2 a large majority of products special price do not update on the live website. I Would appreciate any help!

> I have tried through updating product attributes and also through importing CSV

 > It is not a reindexing issue

> I am updating special price correctly as it is working for some products.

> This issue is happening to around 25% of my products, it's as if the product is not communicating with the live website

*UPDATE*

I have further explored my exported CSV product file and found that the products that are infected and not updating have ONE THING in common...

They have a duplicate of the shoe and all its sizes with a "store_view_code" *

I wonder what this means?

[rodrigo_biassi]

Hi,

I had the same problem using the 2.3 version of Magento and solved it that way. Hope this helps you!

https://github.com/magento/magento2/pull/24624

[rkgilchrist]

Hi Rodrigo

Which table holds the special_from_date data, is it catalog_product_entity_datetime?

I have the same issue and want to check the data in the database before applying your fix.

Cheers

R