You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hello,
We had the same problem with Magento 1.9 with MariaDB 10.1.
The subquery is not ordered like on MySql so the displayed price is not always the best.
If we modify the min_price it displays the buggy price and below "Special price = min_price" on the product list page, so instead we modified the price and the orig_price (modifying only the price displays the buggy price stricked though and then the correct price) :
...
'orig_price' => new Zend_Db_Expr('MIN(inner.min_price)'),
'price' => new Zend_Db_Expr('MIN(inner.min_price)'),
'min_price',
'max_price' => new Zend_Db_Expr('MAX(inner.max_price)'),
...
Hello,
I'm not sure but why 'OrganicInternet_SimpleConfigurableProducts_Catalog_Model_Resource_Eav_Mysql4_Product_Indexer_Price_Configurable'
has
but not
I had issue with minimal price on product listing but not on product view.
The table 'catalog_product_index_price"."min_price" was wrong before I added
=> new Zend_Db_Expr('MIN(inner.min_price)'),
on line 127
Magento 1.9.3.1
The text was updated successfully, but these errors were encountered: