Skip to main content

Questions tagged [indexing]

Questions about the Magento indexer. This includes the flat catalog index. For MySQL indexes, use the "mysql -indexes" tag instead.

Filter by
Sorted by
Tagged with
0 votes
0 answers
37 views

Caching/Indexing Deadlock Issue

The highlighted index tables that associate the Amasty label to products don't appear to updating
Nabeel Ahmed's user avatar
0 votes
0 answers
19 views

Indexing Optimisation: Do Simple products need to be categorised?

Magento 2.4.6 We're having issues with our indexing and are looking to optimise. We use Configurable products with Simple products as the variations. There are approx 200k simple products across ...
myshadowself's user avatar
0 votes
0 answers
40 views

How to add custom settings to Elasticsearch index from Magento 2.4.6

Need to add custom analyzer to Magento product index settings in Elasticsearch, but how to make this setting permanent? If I modify settings directly in Elasticsearch, Magento overwrites it with the ...
player's user avatar
  • 33
0 votes
2 answers
78 views

Can't create product with stock

I'm trying to create a product with stock (quantity), so I can do an example purchase. But whenever I try to create a product, I get the following error: "The stock item was unable to be saved. ...
Agustín Escobar's user avatar
1 vote
3 answers
40 views

Magento 2.4.4, Product count in layered navigation is incorrect after setting "Display Out of Stock Products" to "Yes"

Magento 2.4.4, Product count in layered navigation is incorrect after setting "Display Out of Stock Products" to "Yes". (STORES->Configuration->CATALOG->Inventory->...
GCS's user avatar
  • 11
0 votes
1 answer
173 views

Catalog Layer has been already created error during the search

I am experiencing a very strange issue on Magento (version 2.4). Due to a mistake, we imported some incorrect products. To rectify this, we reimported the correct ones. Now, all the products are ...
Safari's user avatar
  • 103
0 votes
2 answers
81 views

Error indexing catalogsearch_fulltext

I'm using the latest version of Magento2 (2.4.6p3) and Elasticsearch (7.17.14). I don't know really why but I can't index catalogsearch_fulltext anymore. I set ES as debug and the log shows this error:...
nlegall's user avatar
  • 23
0 votes
1 answer
142 views

Magento keeps creating multiple indexes in Elasticsearch

I have a couple Magento stores, and have them hooked up to an Elasticsearch server. On just one of the stores, it seems to regularly create new index names every day, which leads to overage issues ...
blueionRich's user avatar
0 votes
2 answers
449 views

Layered Navigation Price Filter not working after update - Min/Max price in catalog_product_index_price is 0.000

Recently I upgrated magento to 2.4.2 and now I'm facing a problem with the Price Range filter by Mageplaza Layered Navigation. I have managed to solve a previous problem of the price slider not ...
Hector Solutions's user avatar
1 vote
0 answers
214 views

Warning Memory size allocated for the temporary table is more than 20% of innodb_buffer_pool_size

I am using Magento 2.4.5 and getting 5 warning logs in system.log file while I run the command php bin/magento indexer:reindex Memory size allocated for the temporary table is more than 20% of ...
ishaq's user avatar
  • 195
0 votes
2 answers
914 views

How to remove ghost indices from ElasticSuite?

I'm using ElasticSuite and suddenly this message below appeared. What's ghost indices and how can I avoid having them?
Rafael Corrêa Gomes's user avatar
0 votes
1 answer
319 views

Explain meaning of column Schedule Status on the Index Management admin page

There are 2 columns on the Index Management page: Status and Schedule status. Could you please provide detailed explanation what does each combination of values mean? For example: Status Schedule ...
Ruslan Mavlyanov's user avatar
1 vote
2 answers
383 views

Magento 2 reindexing error on Product-attribute-process after migtaion

Indexing console Everything else is working perfectly. i also disabled the elasticsearch and checked but error still there. Error is with Query, at last word "AND (())", when i remove this ...
Asif hhh's user avatar
  • 263
1 vote
1 answer
520 views

How to create indexer for custom table

I want to create an indexer for my custom EAV entity (for learning purposes only). I have the following tables: custom_employee_entity custom_employee_entity_datetime custom_employee_entity_decimal ...
LolKek's user avatar
  • 176
1 vote
0 answers
274 views

mui/index/render loading slow, index reindex when I navigate pages in admin

A store we look after is experiencing odd behaviour recently. The admin dashboard is very slow and from what I can figure out, the indexes seem to reindex whenever you navigate to a different page. ...
Mr Pablo's user avatar
  • 131
0 votes
1 answer
200 views

How do I check the progress of a reindex with status 'processing'?

I am running the following command php -d memory_limit=-1 bin/magento indexer:reindex foo When running it on my table, my terminal goes haywire showing the following: Memory used: 706M Memory used: ...
glitchwizard's user avatar
0 votes
1 answer
1k views

Magento 2.4 reindex catalogsearch_fulltext issue with elasticsearch

I have Magento2.4 with an elastic search version (7.9.2), Indexing of the catalogsearch_fulltext shows error {"error":{"root_cause":[{"type":"...
fernandus's user avatar
  • 484
0 votes
1 answer
2k views

Magento 2.4.0 - Configurable Product Showing Out of Stock

We have Multiple configurable products but some of the Configurable Products are showing as Out of Stock. I have verified the following Multiple times All children are In Stock & have a quantity ...
Sheri's user avatar
  • 140
0 votes
1 answer
371 views

Catalog Search Indexer runs indefinitely with alot of backlog

I've run into this issue with my indexers lately where my Catalog Search Indexer will run indefinitely with a lot of backlogged tasks. And if, and when, I edit any product or even add any new ...
Zyzzx's user avatar
  • 81
0 votes
2 answers
506 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 ...
Arun Sharma's user avatar
  • 1,325
0 votes
1 answer
43 views

magento EE v2,4.1 products disappear from category pages, or appearing on wrong category pages

I have a magento EE v2.4.1 website. my products disappear from PLP (category pages) automatically sometimes or appear on wrong category pages. this issue seems to be due to indexing, because when we ...
Bilal Amjad's user avatar
1 vote
1 answer
2k views

ERROR: We couldn't change indexer(s)' mode because of an error

I'm facing this error when trying to change indexer mode from 'UPDATE ON SAVE' to 'SCHEDULED' Edit: We have already checked the logs, and seems to be nothing there.
Felipe Tarran's user avatar
0 votes
1 answer
143 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 ...
Kshitij Shah's user avatar
0 votes
1 answer
705 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.
Sabareesh's user avatar
  • 358
1 vote
2 answers
4k views

How to optimize MySQL for best Magento 2 performance and Increase indexing speed?

How to optimize MySQL for best Magento 2 performance and Increase indexing speed?
Sanjib Chowdhury's user avatar
0 votes
4 answers
3k 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.
Prits's user avatar
  • 625
0 votes
1 answer
323 views

Product always goes OUT OF STOCK in magento 2 after inserting through REST API

I have added product in my Magento 2 Store using REST API but it always goes out of stock like this. But when i run php bin/magento indexer:reindex the product will come in stock. Any idea why is ...
Prits's user avatar
  • 625
0 votes
1 answer
923 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/...
Prits's user avatar
  • 625
0 votes
1 answer
509 views

My reindexing is not working

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. this is what I tried to do: php bin / magento indexer:...
FUSS93's user avatar
  • 21
1 vote
1 answer
1k 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 ...
Prits's user avatar
  • 625
2 votes
1 answer
4k 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 ...
Prits's user avatar
  • 625
0 votes
1 answer
1k 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 ...
Prits's user avatar
  • 625
0 votes
2 answers
711 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 ...
Prits's user avatar
  • 625
0 votes
1 answer
686 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 ...
Prits's user avatar
  • 625
0 votes
0 answers
1k views

Magento 2.4 Elastic Search Categories Emptying

I have recently updated to Magento 2.4 and on my test site it works perfectly fine. However, on my production site my categories randomly empty. To fix it, I manually run the bin/magento index:reindex ...
Stu92's user avatar
  • 11
3 votes
1 answer
1k views

Magento 2: Creating a custom indexer for my own module

I am new to Magento. I have a custom module in Magento 2 that has a table with data and CRUD models. I want to create an indexer for it to be able to push it to Elasticsearch. I already created the ...
Max Krizh's user avatar
  • 131
1 vote
1 answer
209 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 ...
Friska Sianturi's user avatar
0 votes
2 answers
128 views

Magento Cloud Indexer and Catalog issue

I'm having a lot of issues during the reindex of my catalog in Magento Cloud, sometimes I saw error logs related to ElasticSearch. How could I know if I need to request some improvement related to ...
Rafael Corrêa Gomes's user avatar
1 vote
2 answers
1k views

Magento 2 - Catalog rules cronjob stuck at working with increased number of backlogs

Catalog Rule Product, it always shows as working and and 735 in backlog Tried these but didn't work for me: Reindexing Changed state to "Update on Save" then revert back to scheduled Wait ...
Shoaib Munir's user avatar
  • 9,482
1 vote
0 answers
126 views

Price Indexer Fluctuate the Product Count in Magento

We have been continuously facing issues of Product Fluctuation in our Production Environment. We have our Magento backend and Front end uses React/Mobile App. We have an intermediate platform Algolia, ...
Saty's user avatar
  • 111
0 votes
1 answer
692 views

Magento 2.3.4 indexing error in Catalog Search indexer

Error when running indexing: Notice: Undefined index: queries in /var/www/stage/vendor/magento/module-catalog-graph-ql/Plugin/Search/Request/ConfigReader.php on line 84
Arsalan Ul Haq's user avatar
3 votes
4 answers
5k views

Magento 2 Setup:Upgrade giving error of Cannot add foreign key constraint

I have moved my website files and DB from one server to another. Now, When I am running setup:upgrade command. I am getting below error: Updating modules: Schema creation/updates: SQLSTATE[HY000]: ...
Magento Team's user avatar
0 votes
0 answers
589 views

Magento 2: Unable to reindex catalogsearch_fulltext_scope1

I've migrated from Magento 1.9 to Magento 2.3. While running reindex command for catalogsearch_fulltext_scope1 I'm getting the following error: Catalog Search indexer process unknown error: [1064] ...
Chirag Patel's user avatar
1 vote
2 answers
2k views

Magento 2 Which Index should set "Index By Schedule" or "Update On Save" for performance purpose?

I have a site with Magento 2.3.3 version with over 10000 catalog products. For performance purposes which Indexer should set "Update on Save" or "Update On Schedule". Thank You.
Ye Yint's user avatar
  • 89
0 votes
2 answers
390 views

Run Magento2 Reindex only during off-peak hours

We have a Magento2 shop with 20.000+ products and multiple storefronts. So reindexing takes a long time (about 10 minutes). We want the reindexing of catalog_category_product and ...
Joris's user avatar
  • 43
2 votes
1 answer
360 views

Which indexers can be disabled from Magento 2 if I am not using Magento's frontend?

I am planning to use Magento's database and rest api to add/update/get data. Customer facing interface will be written in viewjs (Not using Magento's frontend). As we know few data is indexed in ...
amitshree's user avatar
  • 7,036
0 votes
1 answer
243 views

Which class/function is responsible for indexing of cataloginventory_stock?

As per Magento's document , function responsible for indexing of cataloginventory_stock is Magento\CatalogInventory\Model\Indexer\Stock::execute($ids). For debugging purpose, I have modified this ...
amitshree's user avatar
  • 7,036
0 votes
0 answers
384 views

How to skip any particular indexer from indexing when cron runs?

I have configured cron (php bin/magento cron:run) which runs every minute. One of the tasks this cron job does is to update all indexers in Magento. When the indexing is run via this cron job, I want ...
amitshree's user avatar
  • 7,036
2 votes
0 answers
133 views

Magento 2. Do I need custom code(e.g. Plugins) to trigger reindex logic for an Update on Save(realtime) configured Index?

My question is simple and straight forward. Do I need to add custom logic to call my indexer(e.g. plugin on afterSave) when the indexer is configured as Update On Save or is Magento supposed to call ...
vitoriodachef's user avatar
1 vote
0 answers
727 views

Magento 2 - Visual Merchandiser rebuild automatically

I'm using Magento Visual Merchandiser to create smart categories. I created conditions to add products into my smart categories, but if I update product attributes value, the products didn't add ...
Mirko Rapisarda's user avatar

1
2 3 4 5
8