Questions tagged [indexing]
Questions about the Magento indexer. This includes the flat catalog index. For MySQL indexes, use the "mysql -indexes" tag instead.
374
questions
0
votes
0
answers
18
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 ...
- 41
0
votes
2
answers
48
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 ...
0
votes
0
answers
46
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 ...
- 161
0
votes
0
answers
14
views
Add NOINDEX meta tag to product review
I have added NOINDEX, and NOFOLLOW meta tags to the /catalogsearch page to remove already indexed pages from search engine indexes. However, I still have trouble removing indexed results for the /...
- 1
0
votes
0
answers
34
views
Magento2 Some product not showing in frontend
I have the problem that no products are listed in the categories in the frontend, although they are available and the index status in the backend is indicated as "Ready" for all indexers. ...
0
votes
2
answers
388
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?
- 12.9k
0
votes
1
answer
71
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 ...
- 370
1
vote
2
answers
288
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 ...
- 263
1
vote
1
answer
299
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
...
- 116
1
vote
0
answers
163
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. ...
- 131
0
votes
1
answer
78
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: ...
- 101
0
votes
1
answer
635
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":"...
- 454
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 ...
- 120
0
votes
1
answer
295
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 ...
- 81
0
votes
2
answers
446
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 ...
- 1,205
0
votes
1
answer
20
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 ...
- 11
1
vote
1
answer
1k
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.
0
votes
1
answer
85
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 ...
0
votes
1
answer
537
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.
- 328
1
vote
2
answers
3k
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?
- 141
0
votes
4
answers
2k
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.
- 626
0
votes
1
answer
281
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 ...
- 626
0
votes
1
answer
778
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/...
- 626
0
votes
1
answer
436
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:...
- 11
1
vote
1
answer
873
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 ...
- 626
1
vote
1
answer
2k
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 ...
- 626
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 ...
- 626
0
votes
2
answers
578
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 ...
- 626
0
votes
1
answer
585
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.
[
- 11
2
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 ...
- 121
1
vote
1
answer
135
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 ...
0
votes
2
answers
88
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 ...
- 12.9k
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 ...
- 9,284
1
vote
0
answers
96
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, ...
- 111
0
votes
1
answer
549
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
- 385
3
votes
4
answers
4k
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]: ...
- 719
0
votes
0
answers
541
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] ...
- 15
0
votes
2
answers
1k
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.
- 79
0
votes
2
answers
290
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 ...
- 43
2
votes
1
answer
311
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 ...
- 6,885
0
votes
1
answer
148
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 ...
- 6,885
0
votes
0
answers
310
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 ...
- 6,885
2
votes
0
answers
116
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 ...
- 3,460
1
vote
0
answers
595
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 ...
- 445
2
votes
3
answers
3k
views
"Catalog Search indexer process unknown error: null" with Elasticsearch
After enabling Elasticsearch6+ as Catalog Search engine in Magento
admin (M2.3.3) I'm receiving this error while reindexing:
Catalog Search indexer process unknown error: null
- 1,581
0
votes
1
answer
876
views
Indexer configured as update on save, get triggered after an update through web api?
Documentation says:
Configure indexers
Use this command to set the following indexer options:
Update on save (realtime): Indexed data is updated as soon as a change is made in the Admin. (...
- 1,008
2
votes
1
answer
3k
views
Notice: Undefined index: default in vendor/magento/module-catalog/......BatchSizeCalculator.php
I got this error when try to reindex catalog_product_price
php bin/magento indexer:reindex catalog_product_price
Notice: Undefined index: default in
/public_html/vendor/magento/module-catalog/...
- 952
1
vote
1
answer
1k
views
EAV indexer optimization: cannot find option
There is a section in the Magento 2.3 documentation that is titled EAV indexer optimization. It says that you should basically disable the EAV indexer, if you are not using a MySQL based search ...
- 737
3
votes
2
answers
6k
views
Magento 2.3 inventory index gives The product that was requested doesn't exist. Verify the product and try again
The inventory index doesn't get re-indexed, it gives this message:
The product that was requested doesn't exist. Verify the product and try again.
In other questions I found that there could be ...
- 63