Magento Batch Update Product Type in MySQL

I just want to share a simple MySQL snippet to batch update product type in Magento. This is a pretty basic SQL query, and I’ll just save it here in my blog so that I can remember what I did to update product types by batch.

I just went to my SQL database via phpmyadmin, click the SQL tab, and run this command:
UPDATE prefix_catalog_product_entity
SET type_id = REPLACE(type_id, 'simple', 'virtual')

If you’re using a custom table prefix, replace prefix with your prefix. Otherwise, just use catalog_product_entity.

This is what I did to change all my product types from simple to virtual. It’s quick and easy and I was able to change it all in 1 second.

First, Magento Connect Reviews are gone, now they are closing

First, Magento Connect Reviews are gone, now they are closing. Yep, you read it right. They will now close the good old Magento Connect and will move everything in the Marketplace. Good news is that they will filter all the extensions and will only retain the ones that are worthy to be retained. You can read more about the announcement here: https://magento.com/blog/magento-news/magento-connect-moving-marketplace

Below is the screenshot of my Magento Connect Manager that I took today. It will be practically useless, but still, you can use it when you have downloaded an extension package from Magento Connect using this freegento.com/ddl-magento-extension.php, or if you have your own packaged module from a Magento extension store.

All good things will come to an end eventually, and one of the pretty good things in my life is Magento Connect. I’m one of the Top 10 reviewers in the world in M1 connect extensions, and it’s sad to see that it’s gone for good.

Fixed: AW_Sarp2 (Subscription + Recurring Payments Module) conflict with IWD_Opc (Checkout Suite)

paypal-sarp2-error
If you’re using Aheadworks Subscriptions and Recurring payments with IWD One Page Checkout (Now IWD Checkout Suite), chances are, it won’t work without modifying IWD OPC’s module files. You won’t get redirected to PayPal, because you’ll get a message that says “PayPal does not support processing orders with zero amount. To complete your purchase, proceed to the standard checkout process.”

In order to use AW’s Subscriptions and Recurring Payments module, you need to activate PayPal Express checkout, then modify two files inside your OPC folder.
Continue reading “Fixed: AW_Sarp2 (Subscription + Recurring Payments Module) conflict with IWD_Opc (Checkout Suite)”

Magento Fix on simplexml_load_string error at lib/Varien/Simplexml/Config.php

If you’ve noticed that your system.log’s size is increasing every minute because of the error logs like this:

Warning: simplexml_load_string(): ^ in /lib/Varien/Simplexml/Config.php on line 383
2016-06-27T14:01:04+00:00 ERR (3): Warning: simplexml_load_string(): Entity: line 292: parser error : expected '>' in /lib/Varien/Simplexml/Config.php on line 383
2016-06-27T14:01:04+00:00 ERR (3): Warning: simplexml_load_string(): nkey.png</233><234>manufacturers/image.jpg</234><235>manufacturers/image.jpg</ in /lib/Varien/Simplexml/Config.php on line 383
2016-06-27T14:01:04+00:00 ERR (3): Warning: simplexml_load_string(): ^ in /lib/Varien/Simplexml/Config.php on line 383
2016-06-27T14:01:04+00:00 ERR (3): Warning: simplexml_load_string(): Entity: line 292: parser error : Opening and ending tag mismatch: config line 1 and unparseable in /lib/Varien/Simplexml/Config.php on line 383
2016-06-27T14:01:04+00:00 ERR (3): Warning: simplexml_load_string(): nkey.png</233><234>manufacturers/image.jpg</234><235>manufacturers/image.jpg</ in /lib/Varien/Simplexml/Config.php on line 383

Then consider your problem solved. After hours and hours of googling and searching at stackoverflow, I found nothing. Most of the solutions to the problem that is related to the simplexml_load_string error is something that is related to an XML file. But my problem wasn’t.
Continue reading “Magento Fix on simplexml_load_string error at lib/Varien/Simplexml/Config.php”

Magento blank sales order view page after SUPEE 7405 patch

If you applied the SUPEE 7405 patch or upgraded to Magento 1.9.2.3 and suddenly you found out that your sales order pages are blank, then here’s a quick fix. Just copy app/code/core/Mage/Adminhtml/Helper/Sales.php to app/code/local/Mage/Adminhtml/Helper/Sales.php, then open it. Find $links = []; then replace it with $links = array(); then save it.

Clear your cache and check your sales order view page. It’s now fixed. This is currently a bug for PHP 5.4 and below, so another fix is just upgrade your PHP version to 5.4 and above to resolve this issue fast.

Beware of CMS Ideas (CMSIdeas.net)

cmsideas-screenshot copy
According to their website, CMS IDEAS is one of the providers of state of the art Magento extensions. If you’re a long time Magento developer or extension integration specialist, then you may have noticed that all of their Magento extensions are not their own. They are reselling Magento extensions from reputable extension developers such as FME, AITOC, V-Design, Amasty, Aheadworks, and more.
Continue reading “Beware of CMS Ideas (CMSIdeas.net)”

Magento 1.9.1 Fatal error: Call to a member function isLockExists()

If you encountered the Fatal error: Call to a member function isLockExists() after trying re-index your Magento site, then don’t panic. It’s just a minor glitch after upgrading from 1.9.0.1 to 1.9.1. Just clear your cache then try re-indexing again. It will work afterwards. If your latest Magento site still doesn’t work, try logging out the logging in back again and all the errors will be gone in no time.