If you re-index your data and you see this error: Product Attributes index process unknown error: exception ‘PDOException’ with message ‘SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (`your_database_name`.`catalog_product_index_eav`, CONSTRAINT `FK_CAT_PRD_IDX_EAV_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE)’ in . ..\lib\Zend\Db\Statement\Pdo.php:228 It causes by some products Full Article…
Search the Wiki
Fixing Magento catalog price rule disappears at night
I have developed the online store on magento platform. Everything works fine except the Catalog price rule for sale. I have created the simple rule that applies 15% discount on all products. When I save and apply the rule, it works fine the whole day. But after 12 at night, the sale is no more Full Article…
Negotiation:error – no acceptable variant
We faced this issue with Review function of Magento, it can’t access this function without index.php in the url. We spent many hours to research about this issue. Finally we found out the solution for it. You need to turn mod_negotiation OFF by adding the below line in Apache configuration file: Options -Multiviews After that Full Article…
Change Magento default increment ID for orders & invoices
Sometimes you will be required to change the default increment ID’s of orders, invoices, credit memos & shipments. To do this is surprisingly simple, yet cannot be done via the backend Admin area without an extension. Today I’ll show you how simple it is to change these numbers with some simple SQL queries to run Full Article…
Setting the default Timezone for PHP to use
he default time-zone used and displayed by PHP is UTC (Coordinated Universal Time)… Hence why it might look several hours off from your *local* time. While sometimes it’s best to leave the internal time-zone of PHP set on UTC (as it is a international time standard) and then convert (in PHP code) the UTC date-time Full Article…
How to Turn on PayPal IPN When Using Magento & PayPal
What I’ve been really surprised by over the past few weeks is the number of sites that don’t actually have this turned on and it’s just not limited to self builds even the really expensive Magento builds are missing this out this as a step. Turning on the PayPal Instant Payment Notification (IPN for short) Full Article…
Fix Product Flat Data index process unknown error in Magento
A client mentioned that he kept having to reindex the Product Flat Data but the notification in the admin section never went away. While trying to reindex from command line I was greeted with the following error: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 Full Article…
The Mailinator
What is Mailinator? Mailinator is a different kind of email service. The biggest difference is that you don’t need to sign up. Any email name you can think of already exists @mailinator.com and you can use any of them. Want [email protected]? You got it. Want PrettyMothra? ScaryGavyn? No problem. Those and any other mailboxes you Full Article…
CANNOT INITIALIZE THE INDEXER PROCESS IN MAGENTO
This phrase gave me nightmares for days as I was building the new website. We installed a ton of extensions to automate the website, and somewhere along the line some database tables got corrupted, so I had to start a what seemed like an endless game of cat and mouse chasing down what was really wrong Full Article…
Configurable product – Inventory – Stock Availability status doesn’t change when all associated Simple products go out of stock?
I have an Enterprise site (1.12.0.2) and a Community site (1.7.0) both doing the same thing. A configurable product (Manage Stock set to Yes) has just one simple product. Somebody orders the last remaining stock item pushing the simple product's Stock Availability Status into "Out of Stock". However the configurable parent's Stock Availability Status remains Full Article…