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
10 views

catalog:images:resize and indexing with cron in magento 2

i want to run magento 2 cli commands catalog:images:resize indexer:reindex run using cron automatically in magento 2. how to achieve this. please help.
user avatar
0 votes
0 answers
7 views

Why does Magento 1 reuse indexing events?

Before indexing event is saved, Magento 1 tries to find an existing event for a particular entity in Mage_Index_Model_Resource_Event::_beforeSave: protected function _beforeSave(...
user avatar
0 votes
1 answer
35 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 ...
user avatar
  • 118
0 votes
0 answers
19 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 ...
user avatar
  • 71
0 votes
0 answers
51 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
10 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 ...
user avatar
1 vote
1 answer
277 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.
user avatar
0 votes
1 answer
37 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
0 votes
1 answer
124 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
  • 300
0 votes
2 answers
1k 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?
user avatar
0 votes
1 answer
236 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
0 votes
1 answer
84 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 ...
user avatar
  • 526
0 votes
1 answer
258 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
109 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:...
user avatar
  • 1
1 vote
1 answer
368 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
1 vote
1 answer
366 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
1 answer
473 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
147 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
347 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
0 answers
684 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 ...
user avatar
  • 11
0 votes
1 answer
460 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 ...
user avatar
  • 101
1 vote
1 answer
34 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 ...
user avatar
0 votes
1 answer
44 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 ...
user avatar
1 vote
2 answers
540 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 ...
user avatar
  • 8,795
1 vote
0 answers
49 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, ...
user avatar
  • 111
0 votes
1 answer
212 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
user avatar
3 votes
4 answers
3k 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]: ...
user avatar
0 votes
0 answers
411 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] ...
user avatar
0 votes
2 answers
487 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.
user avatar
  • 29
0 votes
2 answers
99 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 ...
user avatar
  • 43
2 votes
1 answer
164 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 ...
user avatar
  • 6,687
0 votes
1 answer
35 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 ...
user avatar
  • 6,687
0 votes
0 answers
158 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 ...
user avatar
  • 6,687
1 vote
0 answers
36 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 ...
user avatar
1 vote
0 answers
287 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 ...
user avatar
2 votes
3 answers
1k 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
user avatar
  • 1,461
0 votes
1 answer
329 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. (...
user avatar
2 votes
1 answer
2k 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/...
user avatar
1 vote
1 answer
654 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 ...
user avatar
  • 648
3 votes
2 answers
5k 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 ...
user avatar
  • 63
0 votes
2 answers
567 views

Indexing product prices fails

We moved out Magento 2 to a new server. All works fine but indexing of the product prices. All other indexers work fine. An when we run bin/magento indexer:reindex we get the following error: ...
user avatar
  • 25
0 votes
0 answers
14 views

Magento 1 site indexed by google

Can any one tell me how to magento 1 website indexable by google. Any help?
user avatar
  • 700
2 votes
1 answer
654 views

Magento 2 Reindex error: snapshot in progress

I'm using Magento 2.3 with cloud ElasticSearch and sometimes reindex cron gives the following error [2019-09-18 19:24:13] main.ERROR: Cron Job indexer_reindex_all_invalid has an error: {"error":{"...
user avatar
  • 379
0 votes
1 answer
321 views

Advice about index stuck

I have not seen this case in the other topics: magento 1.9.2CE that has a reindex working for way too many hours seems stuck ; generally it takes few minutes to 1 hour. Context everyday at 02h10 a ...
user avatar
1 vote
1 answer
529 views

Magento 2: After migration, Customer reindex is not working

This is the issue I face on indexing from terminal. column 'created_in' used in key specification without a key length, query was: CREATE TABLE IF NOT EXISTS `customer_grid_flat` Kindly help me to ...
user avatar
3 votes
2 answers
4k views

"indexer_update_all_views" cron job runs seemingly forever

We are currently having the problem that the indexer_update_all_views cron job seemingly runs forever - even though there aren't that many entries in the backlog of the indexer. Last time we let the ...
user avatar
  • 648
1 vote
3 answers
2k views

purpose of "Catalog Product Rule" and "Catalog Rule Product"

What exactly is the purpose of the "Catalog Product Rule" and "Catalog Rule Product" indexes? Which functionalities do they cover? I am just wondering, because there are often a lot of entries in ...
user avatar
  • 648
0 votes
1 answer
3k views

Magento 2 : Index constantly clearing cache of our whole catalog

So I'm having a serious issue with Magento which is ruining performance since 90+% of the time we don't have caches. I'm running Magento 2.3.2 and Varnish and have had several issues with them. ...
user avatar
4 votes
2 answers
3k views

Magento 2 error when trying to reindex

I am currently running Magento 2.3.2. The process went smoothly but after installing some extensions, it appears that some of the reindex tables have been deleted. This is the message I get when ...
user avatar
  • 125
0 votes
0 answers
32 views

Flat Catalog Product rebuild error in magento 1.3

Can any one help me to solve this error https://prnt.sc/omfwt3 I am getting this error when i try to Rebuild Flat Catalog Product in magento 1.3
user avatar
  • 700

1
2 3 4 5
8