Magento – How to get item details of abandoned cart

You may need to specify a more specific data type on the addColumn:

• action
• checkbox
• concat
• country
• currency
• date
• datetime
• input
• interface
• ip
• longtext
• massaction
• number
• options
• price
• radio
• select
• store
• text
• theme
• wrapline

You will find all these types in /app/code/core/Mage/Adminhtml/Block/Widget/Grid/Column/Renderer

You can also make your own grid renderers the same way.

• http://code007.wordpress.com/2012/07/16/grid-column-types-in-magento/

If you're making comments like these, question what you're doing is correct.

//Fix integrity constraint violation in SELECT

$cart = Mage::getModel('checkout/cart')->getQuote();
foreach ($cart->getAllItems() as $item) {
    $productName = $item->getProduct()->getName();
    $productPrice = $item->getProduct()->getPrice();
}

in $cart you got all collection of cart item and if you want to get product id,name you can get from using foreach loop