Overlay zoomed image in node? How can I implement a zoom functionality on my content nodes? Like I need to put a zoom button next to my image and clicking it brings a floating zoomed image over the page like it's done here. I'm using Drupal Commerce. 

I know that it can be done through Colorbox or Lightbox2 but these modules only function in Views (or not?). How can I put this functionality on my node (product page)?

I have themed my custom node.tpl.php template for the product display page.
I have achieved this on a node before using Fancybox by setting up an image preset for your thumb size that opens with Fancybox. For the image to link to Fancybox you need select a Fancybox image preset under display settings for full node within your content type. 

Make sure you initialize the plugin before activation using the appropriate jQuery selector.