Delete All URL Rewrites In Magento-1 (Truncate all existed url i magento)

You may wish to delete all URL rewrites from URL Rewrite Management in Magento at some point, especially if you are frequently importing/exporting product and category data.

By using this following SQL Query.

• SET FOREIGN_KEY_CHECKS = 0;
• TRUNCATE TABLE `core_url_rewrite`;
• SET FOREIGN_KEY_CHECKS = 1;

How to apply schedule for themes in magento-1 and magento-2 ?

Magento-1:

1) Login to Admin panel

2) Go to Content > Design > Schedule

3) Click on “Add new Design” theme

4) Select the theme,start date, from date and save the design theme

Magento-2:


1) Login to Admin panel

2) Go to Content > Design > Schedule

3) Click on “Add new Design” theme

4) Select the theme,start date, from date and save the design theme

Magento1: How to reinstall magento website without re uploading all files

To reinstall the Magento website without uploading all files to the server, we need to follow the following steps:

1. Log in to the database at phpmyadmin and select your database.
2. Empty the particular database or drop all tables from the selected.
3. Goto app->etc folder and remove the local.xml file from the existed files.
4. Now start the installation by running your domain url.

How to Change default homepage in magento-1 ?

Go to

 Admin -> System -> Configuration -> General (Left) -> Web > Default Pages ->  CMS Home Page

Select your required home page from drop-down.

You will have to change to the website / store view that you want to change (the drop down in the upper left corner).

How to enable contact us page in magento -1 ?

 1. Login to admin panel
 2. Goto admin-->system-->configuration-->General-->contacts
 3. Enable Contact Us->Yes
 4. Email options-->Send emails to-->(Enter your email id which you want to receive)

How to change page title of a category in magento-1 ?

 1. Login to admin panel
 2. Goto catalog-->manage categories
 3. Select category which you want to change the title
 4. Goto display options and enter there your desire page title
 5. Save category
 6. clear cache and refresh website frontend.

How to enable login for custom cms page in magento-1.9

1) First of all, you need to create the page in admin panel for the custom page.
open  app/design/frontend/base/default/layout/customer.xml file  from your root folder.</br>
You need to write the following code out of <default>tag.

<customer_logged_in>
    <reference name="top.links">
        <action method="addLink" translate="label title" module="cms"><label>Bulk orders</label><URL><![CDATA[https://www.domain.com/customage/]]></URL><title>Bulk orders</title><prepare/><urlParams/><position>10</position></action>
    </reference>
</customer_logged_in>


<customer_logged_out>
 <reference name="top.links">
     <action method="addLink" translate="label title" module="customer"><label>Bulk orders</label><url helper="customer/getLoginUrl"/><title>Bulk orders</title><prepare/><urlParams/><position>10</position></action>
 </reference>
</customer_logged_out>