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

Optimizing the catalogrule_product_price indexing

We have a situation where catalogrule_product_price table has around 13 000 000 rows. Indexing it takes a lot of time and the main goal is to speed it up and leave more resources for the server. Major ...
1
vote
2answers
27 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
20 views

Why products disappear after import many products?

Every day at 1 am my client's store is importing a lot of products, something like 40k. After that products disappear from the catalogue and search, but the indexes are not invalided. So I've to ...
0
votes
0answers
24 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
29 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
41 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
95 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
18 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
26 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 ...
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
23 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
42 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
29 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
210 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
50 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
302 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
51 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
56 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
149 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
173 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
96 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
107 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 ...
2
votes
2answers
710 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
2answers
315 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
326 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
956 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
88 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
25 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
24 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
60 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
56 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
85 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
3k 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
118 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
174 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
451 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 ...
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
693 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 ...
1
vote
1answer
192 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
843 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
68 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
442 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 ...

1
2 3 4 5
7