Skip to main content

Questions tagged [catalog-product-price-index]

Filter by
Sorted by
Tagged with
0 votes
0 answers

How to fix this indexing error?

When I am running indexer:reindex command, I am getting this error. Integrity constraint violation: 1062 Duplicate entry '1448-0-1' for key 'PRIMARY', query was: INSERT INTO ...
Mujahidh's user avatar
  • 2,813
0 votes
2 answers

Layered Navigation Price Filter not working after update - Min/Max price in catalog_product_index_price is 0.000

Recently I upgrated magento to 2.4.2 and now I'm facing a problem with the Price Range filter by Mageplaza Layered Navigation. I have managed to solve a previous problem of the price slider not ...
Hector Solutions's user avatar
1 vote
0 answers

Price Indexer Fluctuate the Product Count in Magento

We have been continuously facing issues of Product Fluctuation in our Production Environment. We have our Magento backend and Front end uses React/Mobile App. We have an intermediate platform Algolia, ...
Saty's user avatar
  • 111
1 vote
1 answer

Magento 2.2.5 Enterprise Edition Price Reindexing On Checkout fails in case of backorder

I have been facing issue on checkout page in case of Back Order product. The exception I am getting "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '42438-0-1' for key 'PRIMARY',...
Rishabh Dwivedi's user avatar
4 votes
2 answers

Price filter returns wrong results - Price is stored as 0 instead of null and is set to special_price

We have a problem with our price filter. We are using magento 2.2.6 and Smile-SA/elasticsuite 2.6.x-dev. When I go to a category and set a price range filter 0-0,99 I get results with a higher price. ...
Daniel's user avatar
  • 2,229