Questions tagged [reindex]

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

Filter by
Sorted by
Tagged with
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. [![enter image ...
0
votes
1answer
68 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
271 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
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 ...

1
2 3 4 5
11