Google Finance API stopped working as of September 2017

If you’re using the Google Finance Exchange Rate API and it suddenly stopped working, then don’t be shocked. At first, I thought they now require an API key, but that assumption vanished in seconds after I noticed that https://www.google.com/finance/converter was redirected to https://finance.google.com/finance/converter. So if you’re using file_get_contents to fetch the latest forex rates at https://www.google.com/finance/converter, just change it to https://finance.google.com/finance/converter and it will work just fine. No other major changes, it’s just that the API is now in the subdomain.

Maybe there are announcements this month, but I’m not subscribed to any. I googled “google finance forex API september 2017” but it seems nobody posted or blogged about it or asked about it in Stack Exchange. So, that’ it. I just want to share it!

Is Animoji an innovation?


Yes it is. It is awesome and it’s fun. Even if Devin Coldewey of Techcrunch said that it’s dumb and he detest it, it’s not. It’s actually one of the best innovations this 2017, according to me a whole lot of my friends in Seattle and Singapore.

And $1000 for a phone is not that expensive. It’s actually pretty cheap if you sum up the years of innovation and the long sleepless nights of the hardware & software nerds, and those geniuses who have a lot of prefixes and suffixes in their names, who made it possible to be put in your pocket. That small, but powerful device with that so-called neural engine that comes with your phone, for $1000.00, it’s a steal.

You cannot make a phone that sophisticated for $1000 all by yourself, can you? So please stop bashing iPhone haters. It’s the best iPhone yet.

Anyway, Animojis are awesome and I love animoji and I’m excited to pre-order it this October and receive it by November this year! And oh, the girl animoji model (pictured above) in the iPhone X page at Apple.com is pretty, I love you girl, whoever you are!

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.