My favorite of these is "GoCart". I want an Android phone just for this:

"GoCart is your shopping cart on-the-go. Users can scan the barcode of any product using their phone’s built-in camera. Once scanned, it will search for all the best prices on the internet and through the inventories of nearby, local stores."