Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
509
questions
0
votes
1answer
26 views
Reindex single category programmatically
I would like to know if there is a way to reindex one single category programmatically in Magento 2.
Thanks
0
votes
1answer
26 views
What are recommended Re-index settings?
What are the recommended re-index settings? We run a store that has around 8,000 SKUs and is connected to a Warehouse Management System which processes our Amazon orders as well.
Currently we have ...
3
votes
0answers
46 views
Magento with ElasticSearch index
I'm trying to understand the "We can't find products matching the selection" issue that happens a few times a week with the Magento.
Most of the time(80%), this is resolved automatically in ...
0
votes
1answer
31 views
Catalog Search Index failed and products list doesn't work
Last Friday, I installed a new module (ERP embedded). Since this installation, the products list is empty on frontend. I'm using Magento 2.4.2 on apache2/php 7.4.24.
I try to reindex but I have an ...
0
votes
0answers
34 views
solved - reindex magento 2.3.4, replica tables "does not exist"
After running reindex in magento 2.3.4 in command line received the following errors
Table "mg_catalog_product_index_eav_replica" does not exist
Table "...
0
votes
0answers
48 views
Magento 2.4.2-p1 Indexing issue
Hi We have migrated our store from Magento 2.2.5 to Magento 2.4.1-p1. We are facing issues with Indexing its taking too long to complete Category Products index is taking 2 to 3 hours to complete. ...
0
votes
1answer
61 views
Reindex - 401 Authorization Required - nginx
I have set up a local version of our Magento 2 store on my local machine running on Valet+ with Docker serving Elastic Search.
Everything is working great, except I am running into a few errors when i ...
0
votes
1answer
30 views
Magento 2: Error on reindex
I have recently upgrade my instance from Magento 2.3.0 to 2.4.3 and products are not showing on the frontend. When I run php bin/magento indexer:reindex command I get this error:
Any help will be ...
0
votes
4answers
241 views
ElasticSearch connection to Magento 2.4.2
I'm new to Magento2.4 and Elasticsearch. I'm having an issue in connecting them in server setup. This works fine in my local(Windows) setup. When I try to setup in the server, it is not working as ...
0
votes
1answer
191 views
Magento 2.4.3 not showing products and error to reindex Catalog Search
I just installed an Adobe Commerce 2.4.3 B2B + SampleData, but when I open my catalogue of products in the frontend I don't see products in the list, even seeing products in the backend, I thought it ...
2
votes
0answers
25 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
41 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
102 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
11 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
58 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
49 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
270 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
30 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
26 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) ...
2
votes
1answer
461 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
30 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
94 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
102 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
225 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
232 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
17 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
9 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
45 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
160 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
59 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
36 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
123 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
27 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
35 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
30 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
76 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()
...
1
vote
1answer
259 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
121 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
1answer
35 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
49 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.
1
vote
1answer
250 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
64 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
319 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
85 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
287 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
409 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
127 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?
...
2
votes
0answers
421 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 ...
