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
2
votes
2answers
4k views

Recalculating a product's price (applying 'catalog price rules')

I have a module that directly changes a product's price in the database. I would like for the catalog price rules, the various discounts on our site, to get applied to the product's price after I ...
0
votes
1answer
544 views

Magento keywords usefulness (SEO) when using Apache Solr as search engine

I am studying implementing Solr as a search engine in a startup Magento store. Since it's indexing the text in a (desirably) efficient way, the keywords I presume are irrelevant for the store ...
4
votes
1answer
1k views

Programmatically run Catalog product flat index

I have system,in there system i want to run catalog product flat index process pragmatically. I have code is Mage::getModel('index/indexer')->getProcessByCode('catalog_product_flat'); Can any one ...
1
vote
1answer
209 views

override Mage_Index module

i need to override the Mage_Index module to reindex data in a different database. I can't find where can i override the current connection. I need to execute it via shell through "php shell/indexer -...
4
votes
1answer
2k views

difference between event and process in creating custom Index in magento?

Can someone please explain difference between Process and Events when creating a Custom Index in Magento? When are the functions _processEvent(Mage_Index_Model_Event $event), _registerEvent(...
0
votes
4answers
5k views

Magento 1.8 reindex all

Since a few weeks our reindex will not work anymore and crash with the following error: Product Attributes index process unknown error: exception 'PDOException' with message 'SQLSTATE[23000]: ...
24
votes
2answers
31k views

Indexes Stuck on “processing”

Both the Product URL Rewrites index and Category/Product association have been running for days according to the Magento Admin However, there are no reindex php processes running, the var/locks ...
1
vote
0answers
74 views

index single product in EE 1.10.1.1 [closed]

I need to reindex individual products after updating price in EE 1.10.1.1 - this post: Reindex single product shows a way to do that in CE 1.6 but I think EE 1.10 might correspond to CE 1.5. Anyway, ...
0
votes
1answer
618 views

Why does Magento Indexes Drop Table before Recreating Index? Any workaround?

Magento drops the index tables and then rebuilds them. Meanwhile, clients dependent on those tables are out of service. E.g., if the catalog_product_flat index becomes invalidated or is in the ...
1
vote
0answers
89 views

Can Magento support 5 million SKUs? [duplicate]

I'm interested in adding a very large range of crowd-sourced digital products (in time, perhaps 500,000+) to my Magento setup. Each would appear on about 10 websites (one per country/region) via a ...
2
votes
3answers
11k views

PDO Exception error on index

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2002] No such file or directory' in lib/Zend/Db/Adapter/Pdo/Abstract.php:129 I get the following error on my local ...
0
votes
1answer
1k views

Unable to reindex after adding extension using Multi-Warehouse 'Insert value list does not match column list'

I'm having a conflict between two plugins, and can't reindex Product Prices. The plugins are X-Multi-Warehouse and Simple Configurable Products. It looks like Multi-Warehouse added the column ...
5
votes
1answer
6k views

Category Products Indexing

If I re-index catalog_category_product, shouldn't the tables catalog_category_product and catalog_category_product_index have the same amount of entries afterwards? If not, what is the difference or ...
3
votes
1answer
2k views

Catalog Rules Don't Get Applied on Product Save

I'm seeing an issue occur where the catalog price rules aren't getting applied when a new product is enabled and saved at the same time. When I look in the CatalogRule module, I see that there is an ...
0
votes
1answer
4k views

Magento 1.8 Flat Product and Category Data

In Magento 1.8.0, the flat product and flat category indexes have been removed. Does Magento 1.8 no longer support the flat product and category tables? If Magento 1.8 does support the flat product ...
1
vote
2answers
3k views

Catalog Search Index not changing status “required index”

I ran many time reindex process and system always returning the status "required index". I truncate the table without success.
0
votes
1answer
5k views

Problems with reindexing products

Magento tells me that I need to reindex, but Product Prices fails with either "There was a problem with reindexing process." or "Cannot initialize the indexer process". I have tried removing ...
1
vote
1answer
5k views

How to speed up reindexing process [duplicate]

I'm testing a Magento store (CE 1.7.2) with 180k fake products. A big problem is the reindex time process (reindex all), 2-3hrs. (2hrs with Magento CE 1.8). Has anyone any suggestions about how to ...
1
vote
3answers
2k views

Can't re-index after product import

I have a client call and say he could not re-index after importing 100 products. I attempted to re-index in shell and received this error exception 'PDOException' with message 'SQLSTATE23000: ...
6
votes
3answers
3k views

Does magento clean cl tables on it's own

In the magento setup we are working on we've noticed some of the _cl tables are insanely huge, one being catalogsearch_fulltext_cl is 0.86GB in size having 30,001,369 records in it We know that the ...
2
votes
5answers
16k views

“Cannot initialize the indexer process.” error while Reindexing Product Flat Data Index

While reindexing "Product Flat Data", I am getting the following error message, "Cannot initialize the indexer process". Please suggest how to fix this and allow reindexing.
1
vote
2answers
371 views

Why would product not be indexed?

I have a configurable product which is enabled, and visible in catalog, search. It has a child product which is also enabled, and in stock. But the product is not visible on the frontend. I have ...
1
vote
4answers
751 views

alternative indexing solution , is there any suggestions?

the original magento indexing happened to be so slow , in my case I had millions of SKUs need to be indexed , converted to flat table & url rewritten . I am not talking about search indexing . ...
1
vote
1answer
5k views

Reindex price issue (value list does not match column list)

Someone has used the Innoext_AdvancePricing module? After upgreade to Magento 1.7 reindex crashes or inserts invalid data. Crash stack trace: Exception 'Zend_Db_Statement_Exception' with message '...
0
votes
2answers
1k views

Magento - Website/Store level indexing

We are working on Magento 1.7.0.2 (community). We have created multiple websites. Our query is, is there way to indexing on selected website or store? like website or store level configuration. ...
1
vote
1answer
251 views

Why wasn't the Product Attributes Index Included in the Scheduled Updates in 1.13?

In 1.13 most of the indexes now use triggers in the DB to track when changes are made to entities and the indexes are updated via cron selectively for just the entities that have changed. The Product ...
0
votes
1answer
2k views

Catalog Flat Category reindex issue

I am using magento 1.7. I came up with the following issue 'cannot create table column without comments'.I have attached the log 2013-07-26T08:33:24+00:00 DEBUG (7): Exception message: Cannot create ...
2
votes
2answers
3k views

check if reindexing is needed

I need to easily and quickly check if indexing needs to be done. I have been looking around and have $process = Mage::getSingleton('index/indexer')->getProcessById(); or $process = Mage::...
3
votes
1answer
3k views

Ignoring Child Product Attributes in Layered Navigation

How would I go about modifying layered navigation to only look at attributes on the parent configurable product, and not the child? Child and parent products both have the attribute set and it is ...
4
votes
2answers
5k views

Indexing for large database is taking so much time

I have imported more than 1M of products for two stores. I am trying to indexing those products but it is taking long time through Admin and SSH. "Catalog URL Rewrites, Product Flat Data, Catalog ...
2
votes
2answers
1k views

Order of Indexing

Can someone please tell me is there any specific order for indexing needs to follow. My current order is, catalog_product_attribute catalog_product_price catalog_url catalog_product_flat ...
1
vote
3answers
4k views

Avoid invalidating product flat table reindexing upon product attribute value save

Magento 1.7. I noticed that when you update inventory quantities, a reindex of catalog_product_flat is not required. That's useful, because I can set up a cron job to update inventory every night at ...
9
votes
1answer
14k views

Parent category is showing products in subcategories, even though product was not assigned to parent category

Let's assume I have a category, Clothing and this category have a sub-category, T-shirts. Now I add a product to the T-shirts category (by checking the box in the add product screen), but I don't ...
2
votes
1answer
46 views

What are the rules that govern which entity “wins” in the case of conflicting URL paths

If multiple entities (e.g. a category, a product, a CMS page and a module frontname) all attempt to use the same SEF URL, what is the algorithm or process that Magento uses to decide which will be ...
5
votes
2answers
2k views

price_index table indexes wrong max_price?

We're currently experiencing a strange behaviour with the price_index table. We're having grouped products with several simple products associated, e.g. Grouped product Associated product 1 - 25,93€ ...
3
votes
1answer
1k views

solr cannot index attribute/sku in integer [closed]

I'm using magento enterprise 1.12, and I found that solr doesnt index and unable to search for some conditons: (1) cannot search sku which is in all numbers if the sku is in all numbers (where i ...
10
votes
5answers
11k views

Reindex single product

I would like to reindex a single product after an update. Now I use: $product = Mage::getModel('catalog/product')->loadByAttribute('sku', 'foobar'); // edit something $product->save(); $...
1
vote
1answer
267 views

Catalog URL Rewrites Duplicate Index (HY002)

I've seen this problem all around the internet and have yet to find a reasonable solution yet. I've truncated the core_url_rewrite table, set my permissions properly, etc. It seems there is an issue ...
1
vote
4answers
14k views

Can't reindex Catalog Category/Product Index via admin

I have a Magento Enterprise 1.13 installation that won't allow me to trigger reindexing the Catalog Category/Product Index and other indexes through the admin. The "Reindex Data" Action is not ...
4
votes
3answers
10k views

Indexer model is not defined

I'm using Magento CE 1.7. here is the error I get suddenly, each time I access the "index management" screen (so I canot access it anymore), or each time I try to update a product (so i can't save ...
2
votes
2answers
2k views

Magento 1.8 Alpha1 CE Sample Data

Is there a version of Magento's sample data that works with the 1.8 CE Alpha 1 release? I just installed the package and I'm seeing errors when re-indexing. $ php shell/indexer.php --reindex ...
4
votes
1answer
5k views

Magento index_process* tables cleanup

Magento's index_process* tables (index_process_event and index_event) are getting quite big. I was looking in Mage_Index (Magento 1.7.0.2) module if there is something in place for cleanup (deleted ...
0
votes
1answer
2k views

Magento Product Flat Data and Catalog Search Index issue

We are running Magento store having 8k products. The tow indexing is not working. Throwing some errors. Product Flat Data Error Product Flat Data index process unknown error: exception '...
1
vote
1answer
172 views

Possible to index multiple products at a time? (Not all products at a time, not one at a time)

Back in Magento 1.3x there was a programatic way to kick off the index processing for a list of products. But somewhere between 1.3.x and 1.6.x Magento's indexing code was refactored and I can't ...
0
votes
1answer
404 views

Error on indexing flat data?

I have a magento website based on community edition 1.7.0.2 which i have upgraded from magento 1.5.0.1.My website is having more than 40,000 products. My problem is that the indexing process on flat ...
5
votes
3answers
4k views

Products (seemingly) randomly disappearing until reindex

Curious question, one of my clients keeps noticing that randomly* individual products will disappear from the front end store view. * Obviously, I know it isn't random, there must be something ...
1
vote
2answers
1k views

What would cause Catalog Rewrites Indexer to need refreshed immediately after it completes?

Immediately after reindexing the Catalog URL Rewrites, Magento says we need to reindex them again. I'm using the command line to run indexer.php as a background task: nohup php indexer.php --reindex ...
3
votes
1answer
2k views

What's the reason for running a price reindex after placing an order? [duplicate]

After placing an order Magento triggers a price reindex (which sometimes takes too long) and fails placing the order (because reindex is part of the transaction): > SQLSTATE[HY000]: General error: ...
1
vote
1answer
2k views

Products occasionally disappear

A Client has mentioned to me a bug which is near impossible to re-produce thus only leaves theory based solutions. I thought I would check to see if anyone else has stumbled upon this issue and with ...
3
votes
2answers
1k views

Locking indexer programmatically

I tried locking my indexer programmatically with this code as I used to do: $indexer = Mage::getSingleton('index/indexer'); $indexer->lockIndexer(); I noticed that my indexer didn't ...

1
4 5 6
7
8