The indexing tag has no wiki summary.
1
vote
0answers
30 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 ...
1
vote
2answers
65 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 ...
1
vote
1answer
25 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
2answers
49 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 ...
0
votes
1answer
47 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 has 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 ...
1
vote
1answer
27 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 ...
1
vote
0answers
46 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 - ...
0
votes
1answer
36 views
solr cannot index attribute/sku in integer
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 ...
0
votes
2answers
65 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
0answers
40 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 ...
0
votes
3answers
229 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 ...
0
votes
3answers
188 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 ...
1
vote
2answers
230 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 ...
0
votes
0answers
51 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
119 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
72 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
73 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 ...
2
votes
1answer
80 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 ...
0
votes
1answer
74 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 ...
2
votes
1answer
76 views
What's the reason for running a price reindex after placing an order?
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
123 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 ...
1
vote
2answers
69 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 ...
11
votes
6answers
1k views
Price re-index causes DB deadlocks during checkout
I'm experiencing an issue where I believe the Product Price re-indexing process is causing a deadlock exception in the checkout process.
I caught this exception in the checkout process:
Order ...
