Posts made in July, 2012

How to Bulk update the prices in magento for a specific category?

Here I give you a code to update the prices of the products in bulk by Direct SQL query. Because when we use magento default query like setPrice() it’ll lead to maximum execution time error. ini_set('display_errors',1); require 'app/Mage.php'; session_start(); umask(0); Mage::app(''); if (!Mage::isInstalled()) { echo "Application is not installed yet, please complete install wizard first."; exit; ...

Read More

How to export out of stock products to csv file in Magento?

This post gives you some idea about importing product details in csv file which are out of stock. You cant  find list of out of stock products in default magento. So we can do this by creating a file called export.php or whatever name you want. Just paste the code shown below: $to = ""; $subject = "export start"; $message = "export."; $from = ""; $headers = "From:" ....

Read More

Change Title of a page in Magento

We can change the title of the any page by editing the corresponding XML file which is located in layout folder.Just add this reference below or after : <reference name="head"> <action method="setTitle"> <title>Title of UR page in Magento</title> </action> </reference> Thats It!!

Read More

How to format the date to MM/DD from MySql DateTime field using PHP?

In Php when we save the date to MySql table in DATETIME field, it’ll be stored as YYYY/MM/DD format. Then if we get the saved date from the MySql table, it’ll display in the same format as  YYYY/MM/DD. So We have to format the date using Php to display it in MM/DD/YYYY. Example: If we have date in db as 2012-07-05(YYYY-MM-DD). To change it to MM/DD/YYYY format <?php $date= '2012-07-05'; $foo = date('m/d/Y',...

Read More

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.