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
1answer
15 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
68 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?
0
votes
1answer
35 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.
0
votes
1answer
30 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 ...
0
votes
0answers
40 views

Update special prices: Problems with cache invalidation

i have strange problem/issue/bug/feature ... whatever... Case: Every day on defined times a module will import a few special prices for some products. So in this case the cache and the index has to be ...
0
votes
1answer
46 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
1answer
36 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:...
1
vote
1answer
102 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 ...
1
vote
1answer
132 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
1answer
129 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
63 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
172 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
0answers
452 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 ...
0
votes
0answers
12 views

8000+ Customer groups breaking site

I know that uploading this many customer groups would slow down reindexing, and I'm on with slow indexing, but it's taking almost 2 minutes just to load my customers tab now. It's also killing ...
0
votes
1answer
114 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 ...
1
vote
1answer
23 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
1answer
31 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 ...
1
vote
1answer
277 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 ...
1
vote
0answers
24 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, ...
0
votes
1answer
53 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
3
votes
4answers
2k 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]: ...
0
votes
0answers
311 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] ...
0
votes
2answers
182 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.
0
votes
2answers
61 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 ...
1
vote
1answer
109 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 ...
0
votes
1answer
29 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 ...
0
votes
0answers
93 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 ...
1
vote
0answers
15 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 ...
1
vote
0answers
170 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 ...
1
vote
1answer
615 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
0
votes
1answer
138 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. (...
2
votes
1answer
1k 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/...
0
votes
1answer
405 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 ...
1
vote
2answers
3k 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 ...
0
votes
1answer
266 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: ...
0
votes
0answers
13 views

Magento 1 site indexed by google

Can any one tell me how to magento 1 website indexable by google. Any help?
2
votes
1answer
504 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":{"...
0
votes
1answer
238 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 ...
1
vote
1answer
380 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 ...
3
votes
2answers
2k 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 ...
1
vote
3answers
1k 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 ...
0
votes
1answer
2k 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. ...
4
votes
2answers
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 ...
0
votes
0answers
31 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
0
votes
1answer
270 views

reindex catalog_category_product issues after migration from M1 to M2

After migration from M1 to M2 we get the following error when we run the following command bin/magento index:reindex catalog_category_product How can we solve these issues? .........58486', '...
0
votes
1answer
69 views

How to configure the indexer to run over the night?

I would like to run my indexer to run over the night since I'm already using the reindex by schedule, how could I do that?
3
votes
0answers
56 views

Order of indexers

On a Magento 2.2.8 store, we have a Catalog Price Rule for customer-group offers. The indexers involved are set to update on schedule which is running successfully and not producing any errors. Most ...
1
vote
1answer
186 views

Catalog URL Rewrites - Index Management and rebuild required indexes in Magento 1.9

I am seeing this message in the Magento admin-area: One or more of the Indexes are not up to date: Catalog URL Rewrites. Click here to go to Index Management and rebuild required indexes. I ...
0
votes
1answer
18 views

I Have Question on Google Indexing,

I have a one website with 2 languages arabic and english but english which is ranked in google within a 2 days but arabic language dint rank since from 3 weeks why? Whats the reason? It is a e-...
2
votes
1answer
207 views

How do I decide a value for MAGE_INDEXER_THREADS_COUNT?

Can anyone suggest to me how to decide a value for MAGE_INDEXER_THREADS_COUNT? I am managing a website that has 5 websites, 10 stores, 6 customer groups. I know adding this environment variable can ...

1
2 3 4 5
8