Getting Ordered Items and their Detail from Order ID in Magento

$order = Mage::getModel('sales/order')->load($order_id);
$items = $order->getAllItems();
$itemcount=count($items);
$name=array();
$unitPrice=array();
$sku=array();
$ids=array();
$qty=array();
foreach ($items as $itemId => $item)
{
$name[] = $item->getName();
$unitPrice[]=$item->getPrice();
$sku[]=$item->getSku();
$ids[]=$item->getProductId();
$qty[]=$item->getQtyToInvoice();
}

Extension for delete orders

By using this extension we can delete only cancel order, so we need to cancel the order before delete.

Link : http://www.magentocommerce.com/magento-connect/Boutik+Circus/extension/873/delete-orders

SMTP magento extension

Link : http://www.magentocommerce.com/extension/1865

Link :
http://www.aschroder.com/wp-content/uploads/2010/03/Aschroder_SMTPPro-1.0.1.zip

sql order query

SELECT * FROM sales_flat_order_item t inner join sales_order s on s.entity_id =t.order_id where customer_id='1';

Solution of value has to be numeric error in magento

Error : Value '65,000000' has to be numeric.

Solution :

It just appeared, when your locale number format was not similar to the English one.

Reason:
In app/code/core/Mage/Directory/Model/Currency.php(203) you will find the method 'formatTxt()'.
In there is a fix for a problem with formatted price-values coming in.
In line 211 you'll find the following code:

$price = sprintf("%f", $price);

This sprintf-function does not return the type of its content correctly (has to be double/numeric) if this content (a price-value) is formatted in non-english-style (e.g. '0,0000000 instead of 0.0000000).

In app/code/core/Mage/Directory/Model/Currency.php(212) the method Zend_Currency->toCurrency() is called with the output of the sprintf-function.
So, testing this incoming variable in the Zend-Method to be of numeric type causes the error described above.

Solution:
Replace the sprintf-function with the following code:

$price = (float) $price;

Disable modules in Magento [Disable module increases little bit speed of site]

Magento has a huge number of features and there are few businesses that will need to use all of them

If you want to disable some features completely for your site you can do this easily through the administration options.

System > Configuration > Advanced > Disable module output or You can easily enable the module.

Hi friends,

      The blog is for Magento users and developers, contains helpful links and hints for Magento developers.Hints are taken from other helpful sites and created and tested by me as per my practical experience and knowledge of Magento.

    In the OS world, Magento absolutely stands alone in functionality and configuration, but... it is also absolutely not for the inexperienced or impatient because Lack Of Proper Documentation.

   I am trying to document all the essential funcitonalities of magento in this blog. Hope this blog will help you.

Cheers  :)