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
0answers
7 views

indexing for category product to reflect after add category

In my site category products are not reflected after adding on admin. I have set all indexer as update on schedule.If I want to show only categories to reflect which indexer should to set as update on ...
1
vote
0answers
9 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
12 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
22 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
26 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. (...
0
votes
0answers
15 views

Customer Grid Index: Update on Schedule finally supported?

The official documentation mentions, that the Customer Grid Index (customer_grid) cannot be "Updated on Schedule" via the cron. It links to a support article, which concerns Magento 2.2.2. But is ...
1
vote
1answer
71 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
0answers
21 views

Magento 2.3.0: Handling More than 10 Lac customers

I am working on a project which is having 10 lac plus of customers, now condition is that whenever I am registring a new customer, it shows below error - might be temporarily down or it may have moved ...
0
votes
1answer
32 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 ...
0
votes
1answer
138 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
46 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
33 views

ElasticSearch 6 & Magento 2 product indexing issue

Currently running M2 2.3.2 & Elasticsearch 6+. Having some problems with product indexing. We have 2000+ products imported. When using MySQL, we get the position of products indexed according ...
0
votes
0answers
73 views

Magento 2.3 Catalog Inventory index tables are missing records

We recently upgraded from 2.1 CE to 2.3 We are having a lot of issues with the catalog inventory tables in the database. All products in our store are set to "in stock" status. Cache is totally ...
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
112 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
72 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
0answers
69 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 ...
1
vote
2answers
378 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 ...
0
votes
2answers
170 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
187 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. ...
2
votes
2answers
639 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
28 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
56 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
19 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?
2
votes
0answers
21 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
51 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
0answers
44 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 ...
2
votes
2answers
80 views

Issue with Index Management

I am running bin/magento indexer:reindex command for indexing. In admin panel Systems->Index Management Updated column shows the updated indexing date for all except ' Product Categories ' and '...
0
votes
3answers
1k views

cache_dir “/var/www/html/Magento2/var/cache/” is not writable

I'm running a fresh Magento2.3 install on ubuntu 18.04. I managed to edit sample data yesterday, but today I had a go at adding a new product. After saving - I got the error : One or more ...
2
votes
1answer
84 views

How Elastic search 6 works in magento 2.3.1

I have following questions Does the search result page datas are rendering from Elastic search or from Magento, can you explain me briefly? Does the product listing page datas are rendering from ...
4
votes
2answers
133 views

Understanding the Magento 2 index

Generally Magento's index can be updated in 3 ways (depending on usage and configuration): "On Save" "By Schedule" Using indexer:reindex command This is what I can gather from the description in the ...
0
votes
2answers
349 views

magento product flat tables row size too large

When I re-index data in magento 1.x with large attribute set about 200 attributes. The got me followin MySQL error. Product Flat Data index process unknown error: exception 'PDOException' with ...
0
votes
0answers
47 views

Magento 2 custom indexer (update by schedule) does nothing?

On the admin UI it says that it last updated the last minute (every minute). So it's updating every minute, but, the execute method is not called and I don't see my table in the database changing. ...
5
votes
1answer
57 views

Catalog indexing take 3 to 4 days

I have facing problem about manual indexing from cli and my command php indexer.php reindexall will take 3 to 4 day to compelete the indexing. Here is some states of current catalog. Number of ...
1
vote
2answers
45 views

Reindex from different computer

Ok so basically I have been given this one task to manage the admin side for a website that used Magento 2. But then, I have encountered some problem with the reindexing. I have been searching about ...
-1
votes
1answer
543 views

removing categorty in product page is giving error [duplicate]

We are facing issues - https://prnt.sc/mgdybf why we are not able to remove the Deal and Pre Owned category. Could not save product "26652" with position 0 to category 435 What is this error ...
0
votes
0answers
24 views

Grouped products, attributes changes on save not visible in frontend. - ver. 1.9

I have a strange behavior in ver. 1.9.3.9 with atributes and grouped products. Steps to reproduce: Choose a single product which is part of GROUPED PRODUCT. Change desired attribute value (it's a ...
1
vote
1answer
182 views

”Undefined offset: 4” when reindexing “Search indexer”

After module update I've got such error for indexing via SSH Catalog Search indexer process unknown error: Notice: Undefined offset: 4 in /home/sellastu/public_html/vendor/magento/module-catalog-...
3
votes
2answers
1k views

Magento 2.2.6 Catalog Search indexer process unknown error - Notice: Undefined offset: 53

I'm currently using Magento 2.2.6. I've recently encountered the following error while trying to reindex the catalogsearch_fulltext: Notice: Undefined offset: 53 in vendor/magento/module-catalog-...
4
votes
1answer
744 views

Magento 2 Is it possible to run reindexing per storeview?

My site has more than 100.000 products and almost 20 storeviews. Each time I run a full reindexing, it takes about 10 hours for reindexing to be finished. I wonder if it's possible to just run ...
1
vote
1answer
60 views

Magento1.9 Indexing fast

My catalog_product_flat indexing take too long time. How to make this indexing faster in Magento 1.9
1
vote
1answer
368 views

Error Elasticsearch on reindexing - No handler for type [text] declared on field [search]

When I launch a full reindex (php bin/magento indexer:reindex), I have two errors for these indexes : "Catalog Search" , "ElasticSuite Category" I have the Smile/Elasticsuite module installed on my ...
0
votes
2answers
40 views

Can't reindex from web admin

I can't reindex catalog_category_flat index from web admin, I see an error message. But I can reindex it from the console by running php shell/indexer.php --reindex catalog_category_flat without ...
2
votes
3answers
622 views

Magento 2 Down: replica Tales not found when reindexing!

My server went down because the disk was full, after fixing it, I noticed that the magento 2 website never came back: (Magento 2.2.4, PHP 7.0.30) When re-indexing, i get the following error: ...
0
votes
2answers
821 views

Magento 2 : Schedule Status : suspended

I'm on Magento 2.2.4 with php7. I have a cron job already set that reindexes it all twice a day. I usually also reindex manually and when i see a suspended index I reset it. But, when I do reindex:...
9
votes
2answers
2k views

How to solve indexer status “suspended” (n in backlog)

One of the indexers that are configured to be updated on schedule is locked in the state "suspended" and does not get updated anymore. Output of bin/magento indexer:status +-------------------------...
5
votes
2answers
190 views

Magento 2.1 - On reindex start event

I am looking for an observer event that is triggered when any re-index starts. I want to create an observer that sends out an email whenever an index has been initiated for re-indexing.
0
votes
0answers
165 views

DROP TABLE customer_grid_flat hangs - deadlock during customer grid indexing?

We have had an issue with Magento 2.2.5 on an AWS RDS instance (MySQL 5.7): Every then and when, essential Magento Admin functionality is blocked. It is possible to login, but order and customer list ...
0
votes
1answer
40 views

Magento 2.2 : Execute customer grid reindex after customer gets locked

My question is basically on the title, I've been trying to find some event being dispatched when an user gets locked for password attempts but so far I haven't find anything, maybe I'm coming at this ...