Export Magento categories to CSV

Using the below code, you can export magneto category list as CSV format. Place the code in your root directory, and the exported file will be saved on var/export directory. CSV format includes "Root Category Id", "Category Id", "Category Name", "Category URL", "Category Image", "Category Page Title", "Category Meta Keywords", "Category Meta Description","Category Is Active"... Continue Reading →

Magento: One Page Checkout Order Review

During Magento One Page Checkout, i used to display order details (subtotal, tax, shipping, grand total ) at Payment Information section. Use checkout session, to retrieve order data. //Order Totals $orderDetails = Mage::getSingleton('checkout/session')->getQuote()->getTotals(); //Total object $subtotal = $orderDetails["subtotal"]->getValue(); //Subtotal value $shippingAmount = Mage::getSingleton('checkout/session')->getQuote()->getShippingAddress()->getShippingAmount() //Shipping Amount $taxAmount =Mage::helper('checkout')->getQuote()->getShippingAddress()->getData('tax_amount') //Tax Amount if(isset($orderDetails['discount']) && $orderDetails['discount']->getValue()) { $discount =... Continue Reading →

How to Add Custom Column in Sales/Order Grid in Magento

Magento admin orders custom field. For example, add custom field into grid as Order Type (Virtual Order Or Shipping Order). File Path: app/code/core/Mage/Adminhtml/Block/Sales/Order/Grid.php protected function _prepareCollection() { $collection = Mage::getResourceModel($this->_getCollectionClass()); //New Lines $resource = Mage::getSingleton('core/resource'); $orderReference = $resource->getTableName('sales/order'); $collection->getSelect()->join(array('so' => $orderReference),'main_table.entity_id = so.entity_id',array('')) ->columns('(CASE WHEN so.is_virtual = 1 THEN "Virtual Order" ELSE "Shipping Order" END) AS... Continue Reading →

2018 7Design.Studio | Web Design, Web Application Development & UX Design | Chennai | India

Up ↑