Questions tagged [reindex]

Denotes Question about reindex data in index management in Magento 1 and 2.

Filter by
Sorted by
Tagged with
2
votes
0answers
15 views

Magento 2 : Price mismatch

In magento 2.4.2, the admin catalog product has price 40 & in frontend also 40 but in 'catalog_product_entity_decimal' the same product's price is 50. Why so ? What can be done to fix this ?
0
votes
0answers
12 views

magento 2.4 how to programmatically reindex specific index without using reindexList()?

I have a cron class that needs to reindex some product ids. Normally, I would do something like this: $productIndexer = $this->indexerRegistry->get('my_custom_index'); $productIndexer->...
0
votes
1answer
13 views

Magento2: How can you check/set which Elasticsearch index is currently being used

We have a large catalog (400k products) that takes a day or two to reindex. Occasionally I've had something go wrong with the indexing process and then nothing is searchable (code errors). I don't ...
0
votes
0answers
9 views

Unable to display products in flat table even after reindexing

I imported few products in magento2.4 and also enable Flat tables through configuration. After that I tried to run php bin/magento indexer:reindex but didn't display that product in ...
0
votes
1answer
15 views

Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2

Can anyone explain how magento sync/index data to Elastic search in Magento 2.4.2. How it works and what are files called to index the products.
0
votes
2answers
18 views

Schedule indexer programmatically

I have a custom index my_index that observe the change in a custom table entity_data. When changes happen in entity_data, my index's execute function is called by Magento like this $indexer->...
1
vote
1answer
83 views

Magento 2: What is causing slow reindexing of catalogsearch_fulltext with large catalog?

We have 400k line items, so I expect things to take a little while, but reindexing has started taking days, and often errors out in the middle. Checking in the database processlist, it looks to be ...
0
votes
1answer
22 views

How to check reindex triggers from Magento 2.4 database?

I would like to check my database triggers related to stock updates in my Magento 2.4. I need to know what are the triggers to stock updates specifically. How could I check it?
0
votes
1answer
18 views

Magento 2 (ver. 2.3.6) reindex not working

I have a single view Magento 2, with about 5000 products on it, running on a cloud hosting with 4GB RAM. What happens is that every time the reindex process is triggered (by the cron job or by hand) ...
1
vote
1answer
124 views

Magento 2 | Reindex very slow in local server

On my server with: MariaDB 10.4 PHP 7.4 Elasticsearch 7.9.1 Elasticsuite 2.10.0 I am trying to relaunch the full reindex for Magento2 but I have seen that catalog_category_product is very slow, its ...
0
votes
2answers
24 views

reindex rule product catalog

sorry for my language... I have a little problem with magento 2.3 . I use product catalog rules to create discounts for groups of users. once every day or two, there is no specific time or in any case ...
3
votes
1answer
56 views

Error while reindexing using cron

Cron job failed to reindex we have to index the data manually. job_code : indexer_reindex_all_invalid status : error messages : Error when running a cron job
0
votes
1answer
36 views

How to re-index only one product in Magento 2?

I have added the product using REST API in Magento 2 I want to re-index only one inserted product not fully reindex just one that inserted product. How to do that ? Any help is appriciated.
4
votes
3answers
109 views

How to manage Magento store with 60 Million Products

I have completed the product import process of 60 Million products in Magento 2. But products are not visible on the front-end, while debugging this I found that re-indexing of products is still in ...
0
votes
1answer
138 views

How to Configure Elasticsearch with hostgator Hosting in Magento 2.4.1

I have installed magento 2.4.1 in my hostgator shared/Reseller hosting.All things are working fine but I am getting error Of Catalog/search Indexing required. But when I reindex from admin panel or ...
0
votes
0answers
13 views

How to implement Partial Re indexing in Magento 2?

I have 5 Lakh product in Magento 2. I want to implement partial re-indexing in Magento 2. I have checked one post related to that https://maxchadwick.xyz/blog/digging-into-magento-2-partial-reindexing-...
0
votes
0answers
7 views

How re-indexing process is works in Magento 2 if new product is added?

If i have 1 lakh product in my store and i have re-index in Magento 2. And i have added 50 more product in my store. so if it is just re-index all the product from starting or just re-index the ...
0
votes
1answer
32 views

How reindexing process is works in Magento 2?

If i have 1 lakh product in my store and i have re-index in Magento 2. If i changed a product price so it is required to re-index in magento 2 to see the updated price. And if it is required to re-...
0
votes
1answer
46 views

Getting error on re indexing in Magento 2.4 after change batch size

I have change the Batch size for Magento 2.4 var/www/html/Mag/app/code/Reg/Indexer/etc/adminhtml/di.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/...
0
votes
0answers
38 views

Reindexing Catalog Product Rule and Catalog Rule Product

I am stuck for two days because my reindexing does not work by, I tried several things that I found on the net but nothing helps it does not work. php bin / magento indexer: reset catalogrule_product ...
0
votes
0answers
22 views

Indexer not taking correct batch size in Magento 2

I have created a module and a file app/code/Mag/Indexer/etc/di.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:...
0
votes
0answers
106 views

Magento - SQLSTATE[23000]: 1452 Cannot add or update a child row: a foreign key constraint fails

I get the following error when I try to reindex product Flat Data. This error happened after I deleted all products using SQL query. Exception message: SQLSTATE[23000]: Integrity constraint ...
0
votes
1answer
24 views

Re-indexed procedure in Magento 2

If i update 10K products and re-indexed it first time it will re-indexed all. But if i update 10 more product so it will require re-index so my question is is it re-index all the products from ...
0
votes
1answer
24 views

How to Make Indexing process Async. in Magento 2

I am using Indexing process in Magento 2. I have 60 Million products and when i run indexer it just struck in processing from past 4 days. When i check indexer status on sow processlist it will run ...
0
votes
0answers
21 views

Unable to delete product entry in catalog flat tables on deleting product from admin in Magento2

I have enable catalog flat tables configuration. I try to delete product from admin but still it is displaying in frontend with message "Out of stock". Also i checked database entry for ...
0
votes
1answer
49 views

reindex command generates error: Argument 2 passed to Magento\Catalog\Block\Product\ImageFactory::getLabel()

When I run reindex command bin/magento index:reindex catalog_data_exporter_categories I get the following error on console. Argument 2 passed to Magento\Catalog\Block\Product\ImageFactory::getLabel() ...
0
votes
0answers
9 views

How does catalog_category_product ( Category Products ) reindexer works according to mysql in Magento 2

I want to know about catalog_category_product ( Category Products ) indexer in Magento 2 like how it will work according to mysql. Like in which table's it will enter the data then further which table ...
1
vote
1answer
107 views

Table in MySQL to show product data in Magento 2 after reindexing process

I want to know about those MYSQL tables which is used to fetch data for Front-end Products in Magento 2 after re-indexing process. Like which table will be used after re-indexing process to show ...
0
votes
1answer
81 views

Catalog product and Stock index Error

I am getting this strange error while reindex, and I cannot find any solution on google or on stackoverflow. Stock index exception: SQLSTATE[42S01]: Base table or view already exists: 1050 Table './...
0
votes
0answers
32 views

How to check the result of temp and replica table in Magento 2 indexing

I have running indexer index command in Magento 2 for 60 million products. But when i check in back end after 2 days it will show processing catalog_category_product and when i have go to error log ...
0
votes
0answers
10 views

magento 2.4.1 not saving product positon on index table

When I change the position of the products in the category panel, I don't get any errors (not even in the re-indexing process). However, in the table "catalog_category_product_index_store1" ...
0
votes
1answer
17 views

catalog search full text Index error

We just came across this issue where the catalog_search indexer was stuck and I just do what I always do reset the indexer and re-index it. however, This time we received this error: We double checked ...
0
votes
1answer
46 views

Is there a way to show products on frontend without indexing in Magento 2?

I have 60 million products in my store so I want to show products on front-end without using php bin/magento indexer:reindex command. Is there a way to show products on front-end without indexing.
0
votes
0answers
15 views

On indexing catalog_product_price its just struck in Magento 2

On indexing the catalog_product_price it will be in processing mode from 24 hr and still not completed. On checking show processlist it shows this query INSERT INTO catalog_product_index_price_replica ...
1
vote
1answer
133 views

How to check indexer reindex progress in Magento 2?

I have 60 million products in my Magento 2 Store and i have run php bin/magento indexer:reindex query using terminal. Now the issue is that the indexer running from around 100 hours but it will show ...
0
votes
0answers
48 views

Magento2.4 products are not getting displayed in catalog list page

Magento2.4 products are not getting displayed on the catalog list page. I am feeling it is due to some elastic search issue. I used following command to Delete index curl -X DELETE 'http://localhost:...
0
votes
1answer
130 views

Indexer Re-index goes to suspend in Magento 2?

I have 60 million products in my magento 2 store. I have started indexer:reindex so it will struck on catalog_category_product it shows processing in this and on schedule status it shows suspended in ...
0
votes
2answers
63 views

indexer:reindex not running in Magento 2

I have 60 million product in my Magento 2 Store. On running sudo php bin/magento indexer:reindex it will run successfull for only 2 the don't know why it doesn't show any error. Any it will not ...
0
votes
1answer
173 views

I have 60 Million product in my Magento 2 but indexer:redindex not working

I have 60 Millions products in my Magento 2 Store. But when i run bin/magento indexer:reindex command. It is struck on Category Product Index. When i check on backend it is stuck here. [![enter image ...
0
votes
1answer
40 views

On opening Product Single page gave error from Admin in Magento 2?

I have 60 million Products in my Magento Store. In my Magento 2 Admin When i go to admin panel and click on to view a product it gives me an error . Class StripeIntegration\Payments\Model\Adminhtml\...
2
votes
1answer
161 views

Can't Reindex Catalog Search: 405 Not Allowed (Magento 2.4)

My Catalog Search needs reindexing, but sudo bin/magento indexer:reindex catalogsearch_fulltext won't work and returns the following: Catalog Search index process unknown error: <html> <head&...
0
votes
1answer
202 views

Illegal Argument Error When Re-indexing

I've ben having some trouble with my site since upgrading to Magento ver. 2.4.0. My products don't appear in the category pages and when I try to reindex I get the following error message: Catalog ...
0
votes
1answer
48 views

Magento 2 - Column tier_price is set NULL in catalog_product_index_price table

I tried to populate column tier_price of catalog_product_index_price table but every time that reindex this column return NULL. Why tier_price column return NULL every time i reindex magento 2? ...
0
votes
0answers
20 views

Magento 2.3.0 Frontend showing errors after reindexing

Hi I have created a clone of the main website https://magento-498758-1578521.cloudwaysapps.com/ working but products not showing then I run reindex command and then clone website showing the following ...
1
vote
0answers
239 views

Reindex process hangs and blocks website

I have a problem in my Magento 2 (version 2.3.4) shop that reindex process sometimes runs indefinitely and brings the whole site down (502 nginx error or timeouts). I noticed on the DB level, that in ...
0
votes
1answer
59 views

ElasticSuite Reindex Fatal Error

I'm trying to reindex Elastic Search but I'm running into an error I don't know how to fix. The reindexing runs fine on 2 other machines. I've deleted all indices with the "curl -X DELETE http://...
1
vote
1answer
23 views

404 Not Found when displaying a product after reindexing

Before reindexing Magento I can see a product detail but after reindexing, I can't see the product detail. And the weird thing is when I search for some products I can find it, this one works well ...
0
votes
0answers
69 views

Magento 2 - How to debug indexer. error on customer_grid reindex

newly created customers are not appearing in the customer grid. Then i noticed that my customer_grid index is not validating properly. if i reset the index and reindex again. it will take forever and ...
0
votes
0answers
6 views

How is magento creating flat

I have some products with stock which are not appearing in my flat store table. I would like to understand why these products are not handled by the indexer. Can anyone tell me where magento is going ...
0
votes
1answer
25 views

How to improve reindexing magento 2.3.3 [EE]?

How to improve reindexing Magento 2.3.3 [EE]? 60K products It takes around 20min to reindex full. Thanks

1
2 3 4 5
11