Magento Certified Developer

mcd

Today I passed my Magento Certified Developer test!  I failed it when I attempted it before but I got it right finally.

It took a lot of studying to prepare  but it was worth it because it went a lot better than expected.  I think the first time I was just nervous.  I over-thought the questions and second guessed myself too much.  This time I went with my gut instinct and nailed it!

I did have a few things going for me.  I had 3+ years of working with Magento, I attended the Fundamentals of Magento Development course in Culver City and I spent many hours re-watching the same course on-demand (which is free right now btw – link is below).

If you’re into Magento then you should consider taking the courses, studying up and getting the certification!

Fundamentals of Magento Development – Video
Free for a limited time!
http://www.magentocommerce.com/training

Magento Certified Developer Information
http://www.magentocommerce.com/certification/

Set default images in Magento

Have you ever imported products in Magento, only to find out that the default images weren’t set?


tumblr_m0fhf9be1V1qixzqj

This SQL will set the defaults.  After running the following query, the first image will be selected instead of “No Image”.

UPDATE catalog_product_entity_media_gallery AS mg,
catalog_product_entity_media_gallery_value AS mgv,
catalog_product_entity_varchar AS ev
SET ev.value = mg.value
WHERE
mg.value_id = mgv.value_id
AND mg.entity_id = ev.entity_id
AND ev.attribute_id IN (79,80,81);

Replace 79,80,81 with the attribute values for “image”, “small_image” and “thumbnail”.

Use with caution and only try it after making a full backup!

Commodore OS Vision

I installed Commodore OS Vision on one of my old laptops last night.  Overall it’s a nice little linux-based OS.  The speed and graphics were impressive!    It was really neat hearing the old SAM voice reading the license agreement and playing some of the old midi style music from the extras disc.  You can get it free here:  http://www.commodoreusa.net/CUSA_OS_Vision.aspx