Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
511
questions
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.
[
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
