Questions tagged [reindex]
Denotes Question about reindex data in index management in Magento 1 and 2.
508
questions
0
votes
0
answers
20
views
Magento2: After reindexing products goes out of stock, records deleted from cataloginventory_stock_status table
I have imported 7000+ products, everything works fine
I have one cron which is reindexing every day
After reindexing all those products goes out of stock, After debugging I have found that the records ...
- 1,019
0
votes
2
answers
58
views
Magento 2 Reindex by Website or Store id
Is there any possibility to run Magento 2 indexer based on Website id. I have tried identifying events for indexer but couldn't find one.
Is there any option to validate website id or run indexer for ...
- 61
0
votes
1
answer
358
views
Magento 2 Elastic.co reindexing issue
I have connected my magento 2 instance with elastic.co for elasticsearch service, the connection is successfull but upon reindexing I get the following error
{"error":"no handler found ...
- 95
0
votes
2
answers
31
views
Products on category pages keep disappearing until reindex
The products on my website in the category achieves pages keep disappearing and I have to run indexer reindex every 24 hours or so. I tried both Reindex by schedule and Update on save but the problem ...
- 11
0
votes
0
answers
71
views
After upgrading to magento 2.4.3-p1 catalog search not working
Elasticsearch 7 is used and all the configuration setting are as same
as given on devdoc.
Elasticsearch connection is also returning Succesfull
When searching any of the product it does not display ...
- 487
0
votes
1
answer
54
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
- 652
0
votes
1
answer
39
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
0
answers
92
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 ...
- 41
0
votes
1
answer
69
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
0
answers
65
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 "...
- 21
0
votes
0
answers
196
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. ...
- 269
0
votes
1
answer
129
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
1
answer
53
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 ...
- 89
0
votes
4
answers
441
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
1
answer
483
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 ...
- 11.4k
2
votes
0
answers
38
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 ?
- 230
0
votes
0
answers
82
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->...
- 129
0
votes
1
answer
442
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 ...
- 69
0
votes
0
answers
16
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 ...
- 561
0
votes
1
answer
147
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.
- 298
0
votes
2
answers
115
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->...
- 144
1
vote
1
answer
554
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 ...
- 69
0
votes
1
answer
41
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?
- 11.4k
0
votes
1
answer
29
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
1
answer
982
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 ...
- 297
0
votes
2
answers
39
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
3
votes
1
answer
131
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
- 185
0
votes
1
answer
303
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.
- 526
4
votes
3
answers
359
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 ...
- 526
0
votes
1
answer
342
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
1
answer
71
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-...
- 526
0
votes
1
answer
296
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/...
- 526
0
votes
1
answer
37
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 ...
- 526
0
votes
1
answer
49
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 ...
- 526
0
votes
0
answers
43
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 ...
- 561
0
votes
1
answer
125
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()
...
- 341
1
vote
1
answer
409
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 ...
- 526
0
votes
1
answer
185
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 './...
- 464
0
votes
1
answer
47
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
1
answer
59
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.
- 526
1
vote
1
answer
418
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 ...
- 526
0
votes
0
answers
90
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:...
- 3,446
0
votes
1
answer
524
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 ...
- 526
0
votes
2
answers
168
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 ...
- 526
0
votes
1
answer
362
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.
[
- 31
0
votes
2
answers
602
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 ...
- 350
0
votes
1
answer
244
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?
...
- 297
2
votes
0
answers
588
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 ...
- 121