Questions tagged [reindex]

Denotes Question about reindex data in index management in Magento 1 and 2.

Denotes Question about reindex data in index management in Magento 1 and 2.

https://devdocs.magento.com/guides/v2.0/config-guide/cli/config-cli-subcommands-index.html

547 questions
8
votes
1 answer

What indexes need to be reindexed for products to display correctly after stock is changed via script?

I have written a cron that updates the inventory of my products every night. What indexes need to be reindexed for products to display correctly after stock is changed via script? Does cache need to be refreshed? Trying to pinpoint the exact issue…
CaitlinHavener
  • 779
  • 2
  • 20
  • 42
5
votes
2 answers

Index management - most crucial factors of indexing time

What are the most important factors which affects the time of indexing ... product attributes product prices catalog url rewrites and also the indexes for flat tables. I know that the number of products and categories are important, but I want…
Alireza Amiri
  • 243
  • 1
  • 10
3
votes
1 answer

Problem with Multiple product imports + re indexing together

We (abc.com) have Magento Multiwebsite and multistoreview built in Magento CE 1.9.X. Each website has one store view. We are basically a marketplace system. We sale products from different magento systems. All the products of different magento…
user45388
  • 31
  • 1
2
votes
1 answer

How disable auto reindex after edit product or catalog

I have a problem when in edit catalog, product and save it. My website will reindex, that do my website run very slow. I want to disable reindex after save catalog,product But when i created new catalog, product other. Website will reindex…
Jerry Nguyen
  • 63
  • 1
  • 4
2
votes
1 answer

Catalogue search index not re indexing

I just updated form magento 1.7 to 1.9 and everything on my front end is working perfect. The only problem i have encountered is when i came to re-indexing my catalogue search index and a extension called "Lucene Search Index" it isnt timing out all…
Adam Allen
  • 2,205
  • 7
  • 37
  • 68
1
vote
1 answer

Can I close the browser while Magento is reindexing?

While Magento is reindexing data, can I close the browser? Or does the browser still need to be open?
John R.
  • 13
  • 4
1
vote
2 answers

Cron reindexer always gets stuck in "processing" when reindexing catalog URL rewrites index

Every time Magento's cron runs the reindexer, it always gets stuck in Processing for the catalog url rewrites index. As a result, the reindexer stops and leaves the other indexes in "Reindex Needed". However, if I run the indexer in SSH, it will…
rclai89
  • 121
  • 3
1
vote
1 answer

reindexing issue for catalog product flat

I am facing the catalog product flat reindexing issue in my project. I have tried many solution, but can't get any success. I have tried following solutions around Google: 1- I truncated all the catelog_producr_flat tables(like…
rkumar
  • 11
  • 2
0
votes
2 answers

Can't reindex product flat data

When I try to run the reindex process for product flat data I get this error message SQLSTATE[HY000]: General error: 1005 Can't create table 'mylal_mage233.#sql-4497_2115c' (errno: 121) The query being executed is: ALTER TABLE…
Filipe Sá
  • 381
  • 1
  • 4
  • 10
0
votes
1 answer

Reindexing error message in Product Flat Data

I am having the same problem with the error message "cannot initialize the index processor", however that is the only error message I have. I read some of the answers I do not have very big descriptions for my products, and I only added maybe 5…
sssteven
  • 11
  • 4
0
votes
1 answer

Reindex problem catalog_category_product_index_store10_replica

Recently I've been facing issues with reindex process, some indexes are shown with status Reindex Required and even if I achieve to reindex them they continue with the same status. After some days indexes got stuck and reindex never ends. So I…
ernestoslo
  • 11
  • 1
0
votes
1 answer

Magento 2 - Invalid Samesite attribute error on reindex command

I am getting "Invalid Samesite attribute." error while run the reindex command from CLI "php bin/magento indexer:reindex" in the magento 2 setup (version 2.4.4, PHP 8.1, and Apache). I have tried all the way to find out the solution but no luck. Can…
Sundar
  • 1
0
votes
1 answer

An error occurred while saving the URL rewrite in both System --> Index Management and through SSH

Magento 1.9.x The Error from the Error log is as follows: 2020-04-20T23:17:52+00:00 ERR (3): PDOException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry 'category/112-1-1' for key…
Allysin
  • 250
  • 1
  • 23
  • 72
0
votes
1 answer

Catalog URL Rewrites stuck - core_url_rewrite empty

My catalog url rewrite has been stuck for days, the core url rewrite table was empty, but the url rewrites did show on the website. we truncated the core url rewrite, the site url rewrite have gone, the reindex is still stuck and no rows showing in…
gill
  • 1
  • 1
0
votes
1 answer

There is a problem with reindexing process

I reindexed everything, except I can't get this last point to reindex, the "Catalog URL Rewrites Index product and categories URL rewrites ". In exception.log I get this error message when I try to reindex it: Exception message: SQLSTATE[42000]:…
1
2