Issues with re-indexing process on magento store
I have just re-index the data using custom script and its generate this error :
SQLSTATE: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= 'abs', ( - i.price), IF( = 'fixed', , ROUND(i.price * ( / 100), 4)))), 0) AS `' at line 1
I have tried by making the catalog_product_flat_1 table but still the same issue
Execute the below-mentioned command from Magento root folder
php -f indexer.php -- reindex all
Magento - Website/Store level indexing
We are working on Magento 126.96.36.199 (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. Consider the the scenario, we have 3 website (WEBSITE1, WEBSITE2, WEBSITE3) and 3 store (STORE1, STORE1, STORE1) 1. If we update WEBSITE1 and STORE1 then in...
Reindexing - Will my store load slower immediately after re-indexing has been completed?
I understand that during re-indexing my store may be slower, and also that after the flushing the cache, pages will load slower because they are un-cached, however I don't understand indexing well enough. Immediately after re-indexing is complete, would you expect pages to load any slower than immediately before commencing re-index (all other thing...
Request Path for Specified Store already exists during Indexing
In magento 1.9, whenever I save any configurable product in admin panel, all the product urls goes to 404 unless I do reindexing. In reindexing there are 8 processes, 7 of which works fine but the 8th one Vendor Product Url Rewrite get stuck with Reindexing Required And the error I get is Request Path for Specified Store already exists during Index...
Getting the product info from different store in checkout process
I have two stores. View one is in English and the other is the translation, each product has the same price and information but the difference is the translation. I want all orders in the back-end with the same items information taking in to account the fact the site/view that the item was ordered from. For example suppose I have the item with a na...