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.

PokemonGo: Why I cannot use my Lucky Egg and Incense anymore

Did you notice that after the recent update, you cannot use your Lucky Eggs and Incense anymore? Regardless of how much you tap or swipe, or do any unique gestures in your screen, you won’t be able to use your Lucky Eggs and Incenses? I don’t know if I’m alone or if someone is experiencing the same problem as mine.

This problem recently occurred after the new gym mechanics was implemented. I already search in Google, Reddit, Pokemongo blogs, and other sites, but to no avail.

I’m also having a hard time throwing berries to increase the chances of capturing Pokemons.

If you’re encountered the same problem as I did, please leave a comment below.

Btw, I’m using iOS (iPad) with the latest Pokemon Go app installed.

The extremely annoying WordPress 4.8 and its Visual Editor in Text Widgets

Yes, it’s extremely annoying. It should be optional in the first place. Let’s wait for the WP guys to fix this issue once and for all. I hope WP 4.9 will make it optional, or just completely remove it. This. Is. So. Annoying.!!!

For the meanwhile, you can use this plugin:

Add Paragraphs Option to Text Widget

Or just wait for the future release of WordPress.

And nope. I am not alone. There are a lot of us:
https://wordpress.org/support/topic/how-to-disable-visual-editor-in-the-text-widget/
https://wordpress.stackexchange.com/questions/269719/can-the-new-4-8v-text-widget-visual-editor-be-removed

And more. Oh please, Matt… for the sake of all the people of the universe, just disabled the visual editor in text widgets. T_T

The INTCoin Scam


Be careful of INTcoin, as it’s an absolute scam. People who invested in INTcoin’s ICO a few months ago lost all their money. It’s a brilliantly orchestrated scam that lured newbie and some veteran investors. It was featured in CoinTelegraph, The Bitcoin News, Cryptocoin News, News BTC, The Bitcoin Wire, and Bitcoin Wiki. All of these news sites are reputable cryptocurrency news sources, but they do accept sponsored post, and scam artists behind INTcoin sponsored a post on these sites to lure investors to their ICO.

It’s also mentioned in CNBC!!! Hahahaha! A known investor Timothy Enneking was also scammed, because according to him (as what I’ve read in CNBC), he invested during the INTcoin ICO. Be very careful as it’s also related to Intellicoin, another scam coin that is listed in some exchanges like Bittrex.

INTcoin discussion: https://bitcointalk.org/index.php?topic=1919454.0
INTellicion discussion: https://bitcointalk.org/index.php?topic=720292.0

Just be very careful everyone. A lot of ICO and cryptocurrency scams are popping up out everywhere in this very very dangerous world.

Fox Movies Premium is no longer premium

I noticed this just now. Fox Movies Premium in my cable TV is no longer premium. It now has commercials, which sucks right? After further research, I found out that last January 1, 2012, Star Movies HD was rebranded as Fox Movies Premium HD in selected Asian territories where Star Movies has been renamed to Fox Movies Premium. Then, just 3 days ago, 10th of June 2017, Fox Movies Premium HD has been renamed itself as Fox Movies HD. But this is not just a rename, and nothing was changed. The service itself was changed. You won’t enjoy watching movies without interruption anymore. Now watching movies at Fox are interrupted by commercials.

Saw a funny ad in their Facebook page, that says:

Continue reading “Fox Movies Premium is no longer premium”

Visited Brazil and Malta this 2017

I didn’t notice that I haven’t posted any updates for the past few months. I had a long vacation, and I visited two countries last March, April, and May 2017. I’ve been to Rio de Janeiro and Malta. Went with my friends to visit random cities that I’ve never visited before. Will be blogging again now because I missed blogging so much.

I also got a notification in my WordPress app that I got a lot of visitors last week. I was surprised that it’s about BPI express online error. An old post that received a thousand visitors in a few hours. Hahaha!

Anyway, that would be all for now.

Brand New iPad Mini 2 32GB at Lazada with passcode

If you bought a “brand new” iPad at Lazada.com.ph, specifically the “Apple Ipad Mini 2 Retina 32GB Wifi (White)/Silver” on sale for 11,499.00 and after you open it, it has a pass code, return it immediately. It isn’t brand new. It’s just resealed and it has a previous owner. Brand new iPads will never ever have a pass code by default.

Don’t attempt to unlock it or reset it via iTunes Recovery Mode, because you won’t be able to. It’s blocked and it will be locked forever, unless the previous owner unlocked it. Just return it to Lazada within 7 days after you purchased the item.

If you’re unlucky and 7 days have passed, then you’ll be stuck with that unusable iPad. You can’t resell it because it won’t be used by anyone, anymore.

Lucky for me I was able to return the iPad with passcode. It’s best to open it immediately while the Lazada delivery guy is at your doorstep, then return it on the same day if it has a passcode by default.