Magento add custom textbox,select box to existing system -> configuration tab.

if we want to add custom fields like textbox,select box to existing system -> configuration tab -> catalog.

<?xml version="1.0"?>
<config>
   <sections>
        <catalog>
            <groups>
                <frontend>
                    <fields>
                        <mayankpatel translate="label">
                            <label>Custom Textbox Value</label>
                            <frontend_type>text</frontend_type>
                            <source_model>adminhtml/system_config_source_yesno</source_model>
                            <sort_order>1</sort_order>
                            <show_in_default>1</show_in_default>
                            <show_in_website>1</show_in_website>
                            <show_in_store>1</show_in_store>
                        </mayankpatel>
                      </fields>
                </frontend>
            </groups>
        </catalog>
    </sections>
</config>

Magento Mobile HTML5 Theme

Magento Mobile HTML5 Theme

Reindexing of Product Flat Data in magento:

You have to truncate all the 'catalog_product_flat_i' table:
where 'i' can be 1,2,3,4,....

In my case there are 3 table so i fire this query to my phpmyadmin:
TRUNCATE `catalog_product_flat_1`;
TRUNCATE `catalog_product_flat_2`;
TRUNCATE `catalog_product_flat_3`;

magento remove Product Type virtual product,bundle product and downloadable product.

app/code/core/mage/catalog/model/product/type.php

static public function getOptionArray()
    {
        $options = array();
        foreach(self::getTypes() as $typeId=>$type)
        {
            if($type['label'] != "Virtual Product" && $type["label"] != "Grouped Product" && $type["label"] != "Downloadable Product" && $type["label"] != "Bundle Product")
            {
                $options[$typeId] = Mage::helper('catalog')->__($type['label']);
            }
        }

        return $options;
    }

Magento Custom Backend Custom Module Development

Magento Custom Backend Custom Module Development

PHP Script to insert order into magento database for version 1.6.2.0 (Simple Product Only)

createorder.zip

Magento Manufacturer logo plugin

color_attributes_admin.zip

Clean Magento database

TRUNCATE TABLE `dataflow_batch_export`;
TRUNCATE TABLE `dataflow_batch_import`;
TRUNCATE TABLE `log_customer`;
TRUNCATE TABLE `log_quote`;
TRUNCATE TABLE `log_summary`;
TRUNCATE TABLE `log_summary_type`;
TRUNCATE TABLE `log_url`;
TRUNCATE TABLE `log_url_info`;
TRUNCATE TABLE `log_visitor`;
TRUNCATE TABLE `log_visitor_info`;
TRUNCATE TABLE `log_visitor_online`;
TRUNCATE TABLE `report_viewed_product_index`;
TRUNCATE TABLE `report_compared_product_index`;
TRUNCATE TABLE `report_event`;

magento: insert query for a custom table

Insert query for custom table

magento cash on devliary extension

http://www.magentocommerce.com/magento-connect/cashondelivery.html

magento mysql script to insert india's state into database

magento insert all india's state into database

Sending email from local system in magneto OR Sending email frommagento in local system

local system

How to change the Magento Admin Panel Title?

If you want to change default title of Magento Admin, there is an easy solution:

Just open the main.xml file, which is located in app/design/adminhtml/default/default/layout folder.

Find line like below:

<action method="setTitle" translate="title"><title>Magento Admin</title></action>

 and replace the words Magento Admin with the words you like to be in default title.

Magento - Reset the admin password

UPDATE admin_user SET password=CONCAT(MD5('admin123')) WHERE username='admin';

Magento product details store tablename

Product name store in : catalog_product_entity_varchar
product id store in : catalog_product_entity_int
product price store in : catalog_product_entity_decimal

Delete all Products and ResetProduct id’s in Magento

ResetProduct id’s in Magento

Truncate all categories and and Reset Categoryt id’s in Magento

Reset Categoryt id’s in Magento

Magento: How to solve indexing problem?

solve indexing problem

Magento add custom fields in admin side

http://www.excellencemagentoblog.com/magento-admin-form-field

Magento Export Categories

export_categories