Questions tagged [reindex]

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

Filter by
Sorted by
Tagged with
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 ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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
user avatar
  • 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 ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
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 "...
user avatar
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. ...
user avatar
  • 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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ...
user avatar
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 ?
user avatar
  • 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->...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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.
user avatar
  • 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->...
user avatar
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 ...
user avatar
  • 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?
user avatar
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) ...
user avatar
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 ...
user avatar
  • 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 ...
user avatar
  • 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
user avatar
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.
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
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-...
user avatar
  • 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/...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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() ...
user avatar
  • 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 ...
user avatar
  • 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 './...
user avatar
  • 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 ...
user avatar
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.
user avatar
  • 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 ...
user avatar
  • 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:...
user avatar
  • 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 ...
user avatar
  • 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 ...
user avatar
  • 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. [![enter image ...
user avatar
  • 526
0 votes
1 answer
161 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\...
user avatar
  • 526
2 votes
1 answer
330 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&...
user avatar
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 ...
user avatar
  • 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? ...
user avatar
  • 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 ...
user avatar
  • 121

1
2 3 4 5
11