Thursday, July 26, 2012

Magento upgrade 1.5 to 1.7 and 1.6 to 1.7, Simplest way to upgrade 1.5 to latest Magento version

Magento version upgrade is not a simple method. Magento developers got an headache when they upgrade older version to latest version. Because, structure of the Magento versions different from one to another. So, it’s not just easy to upgrade Magento. Sometimes whole Magento store cause an error.

Finally I got solution to upgrade Magento store without using SSH access. In this method easily upgrade Magento store from 1.5 or 1.6 to latest version. Follow the below steps to upgrade Magento version easy way.

1. Before start upgradation process, need to download Magento latest version 1.7.X
 2.  Now you can export the current old version store database and import into phpmyadmin with any name you want to place.
 3. Create database connection in latest Magento 1.7.X store into current store database [1.5 version] and then run the frontend in the browser. Please wait until browser process complete.
 4. Now go to the database and find the table named as core_config_data.
 5. Change the base url as live website url. Now your upgraded Magento version is ready.
 6. For this time your upgraded version is ready without theme which you are used already. So, we need to move the theme folder to upgraded latest Magento version.
   Move the template theme as well as skin theme folder into new 1.7.X version
Template folder: app/design/frontend/default/THEMEFOLDER
Skin Folder: skin/frontend/default/THEME FOLDER
  7. Finally move the Extensions and custom modules from Magento old version to upgraded versions if you have installed. Check the modules app/code/local and app/code/community same place in the latest version.


Note: If any of the extensions / Custom module is not working, check with the supporting versions of the extensions. Tell your developer to upgrade the version.

Now we have successfully completed Magento upgradation from 1.5 to latest 1.7.X version. Hopefully this article useful for you. Please feel free to place your comments to help us to grow a level.

Share me, If you like

By PHP with 6 comments

Wednesday, July 25, 2012

Magento: Remove recently viewed lists in left side box, Hide Recently viewed box in left/Right Nav in Magento

In Magento, We researched over the admin panel to remove recently viewed items in left side box of my store. But I couldn't able to find the solutions in backend.

 Finally i got an idea to remove Magento recently viewed box via xml file manually. It’s easy method to remove box.

1. Go to the location: app/design/frontend/default/THEMEFOLDER/layout/
 Find the file names as "reports.xml"
If you can't found go to the base: app/design/frontend/default/base/layout/reports.xml
2. Find the below line in reports.xml file
<block type="reports/product_viewed" before="right.permanent.callout" name="right.reports.product.viewed" template="reports/product_viewed.phtml" />
3. Just remove or hide the above line.
4. Go to your store in the browser, refresh the page and you are done.


Hopefully, this article useful for you. Please comment if you find any other way to remove recently viewed products in our Magento store.

Please share me, if you like

By PHP with No comments

Monday, July 23, 2012

Export selected data's in the Magento Customer lists

 Magento easily Export Customer lists in the eCommerce store. Magento  also have the options to export selected data only in the customer profile.

 Magento customer profile have many data fields to store the customer  informations. We need to export particular data in our store profile. For ex. we need  to export only Firstname and Last name of the customer
profile.

Please follow the below steps to export,


  1.  Go to Admin -> System
  2.  Import / Export -> Dataflow profile


  In the data flow profile have the list of defaul export / Import  lists. We need to customize as per our requirment like to export Customer First name and Last name.

  Add new profile -> file the Profile form to update below way,

  - Name
- select customer
- select export
       - Export format xml or csv
- select only mapped data's
- Add Field Mapping
- Select First name
  - Select Last name

Now save profile

Now added new dataflow profile in our dataflow lists. Now click -> Run profile -> Run profile in popup

Now Go to download  all the exported data's stored in Var/Export Location.

Hopefully this article usefule for you. Please comment for your thoughts and be share this if its usefull.

By PHP with No comments

Magento Categorey lists display Order change, Sortby Magento Categories

How we can able to change category lists order in magento? Magento admin control panel having options to manually change the sort order in category lists.

 In Magento eCommerce store Category order changed in the following way,


  Need to logged in into Magento Admin Panel
  Then Go to Catalog on the top navigation
  catalog -> Manage Categories

See the categories,magento category lists on the left navigation.

 Click the category on the left, then drag to change order and drop.

Drag and drop method to sort category lists in magento.

By PHP with No comments

Magento Products Export via Admin control panel

Magento is most used eCommerce Opensource in PHPwe application development. Because its having many features related to eCommerce compare to any other.

  Magento have simple option to export products via admin panel. Magento export have 2 options to get the result which is XML format and CSV formats.

 In the following way to export products in our magento admin Store.

1. Goto Admin controll panel
2. System ->Export/Import 
3. Data Profile

 Default Data Profile have Products lists, customer Lists etc

 When we click into products lists, it will display options which we choose /Modify. Now click into Run profile in the left side tab

Click content area have the button called "Run profile popup"

The below screenshot shows products export completed successfully.


Now we can go to FTP ->Var ->Export then download exported magento product lists.









By PHP with No comments

Friday, July 20, 2012

PHP…MYSQL…JQUERY… Starting History at a glance

Nowadays one of most used open source web development script is PHP. Because PHP is easy to learn as well as easy develop website and web application easily with short period of time.

When we create PHP, No need to invest money to purchase all the supporting softwares are open source.

About PHP:

The great open source PHP creator is : “Rasmus Lerdorf”
Top know more about PHP language creator visit following,
  1. http://en.wikipedia.org/wiki/Rasmus_Lerdorf
  2. http://lerdorf.com/bio.php
  3. http://www.oracle.com/technology/pub/articles/php_experts/rasmus_php.html

About MYSQL:

PHP is frontend scripting language, When we need to store the data, we need backend database. MYSQL one of the powerful databases to store the data’s in the backend. Mysql is also an open source.
The creator of MYSQL is : “Michael Widenius”
  1. http://www.mysql.com/

About Jquery:

Process is done without page reloading... So we go for an jQuery. jQuery used to create fast web based application with any events, animations and also interact with ajax functionality. to know more about this,
  1. http://docs.jquery.com/Tutorials
Leader of jQuery :“John Resig”

By PHP with No comments

Monday, July 16, 2012

Magento backend at a glance video tutorial

How magento backend built. Watch online tutorial to learn about magento backend. Magento backend video online.



Hope is this useful please comment us

By PHP with No comments

Magento Installation video tutorial online

Learn how to install magento videos on-line. This video explained installation procedure for magento eCommerce shopping store. Watch online to install magento.



Magento installation is useful.. Please comment your thoughts.

By PHP with 1 comment

Magento Introduction Video Tutorial - What is Magento?

Magento Intorduction, What is magento, what is the use of magento vidoe online, Watch Magento video tutorial, Online Magento learning program.



Hope you are enjoying... Please share to friends..

By PHP with No comments

Sunday, July 15, 2012

Magento: Show all the Products from specific category

Here we display all the products from specific category in Magento. Below code needs category ID and product collection Object needed.  Please use the below code to show all the products using category ID.

<?php
$category_id = 10; // if you know static category then enter number

    $catagory_model = Mage::getModel('catalog/category')->load($category_id); //where $category_id is the id of the category

    $collection = Mage::getResourceModel('catalog/product_collection');

    $collection->addCategoryFilter($catagory_model); //category filter

    $collection->addAttributeToFilter('status',1); //only enabled product

    $collection->addAttributeToSelect(array('name','url','small_image')); //add product attribute to be fetched

    //$collection->getSelect()->order('rand()'); //uncomment to get products in random order    

    $collection->addStoreFilter();          

    if(!empty($collection))

    {

            foreach ($collection as $_product):

            echo $_product->getName();   //get product name        

        endforeach;

    }else

        {

            echo 'No products exists';

    }              

?>


In the above code to display all the product names from specific category. If you want display all the product information, under the foreach loop need to use belo informations

// get Product's name
echo $_product->getName();
//get product's short description
echo $_product->getShortDescription();
//get Product's Long Description
echo $_product->getDescription();
//get Product's Regular Price
echo $_product->getPrice();
//get Product's Special price
echo $_product->getSpecialPrice();
//get Product's Url
echo $_product->getProductUrl();
//get Product's image Url
echo $_product->getImageUrl();


Hope Magento product lists code is useful for you. Kindly update your comments. Thanks for sharing this.

By PHP with 1 comment

Magento: List out the products from Category ID

Here we have to display all the products from single category using category ID. If we know category ID, We display all the product lists. Category ID is 6. We need to display all the products under 6th category, Use the following code to display all the products,

<?php
$catid = 6;
$category = new Mage_Catalog_Model_Category();
$category->load($catid); //My category id is 6
$prodCollection = $category->getProductCollection();
foreach ($prodCollection as $product) {
$prdIds[] = $product->getId(); //Array to store all the product ids
}
?>


In the above code to get all the products ID from category 6. Then we  need to Use following code to get Product information from the $prdIds[] Array.

<?php foreach($prdIds as $product_id); {
$obj = Mage::getModel('catalog/product');
$_product = $obj->load($product_id);
// get Product's name
echo $_product->getName();
//get product's short description
echo $_product->getShortDescription();
//get Product's Long Description
echo $_product->getDescription();
//get Product's Regular Price
echo $_product->getPrice();
//get Product's Special price
echo $_product->getSpecialPrice();
//get Product's Url
echo $_product->getProductUrl();
//get Product's image Url
echo $_product->getImageUrl();
}?>


Please update your comments to improve Next level in Magento Product Display. Thank you.

By PHP with 2 comments

Magento display all the categories in the left Navigation lists

In magento themes have the option to list out category list in the left navigation. But some of the themes are not available.

So, we need to create manually to list out the category lists in left nav bar.

1. We need to create left.phtml file in the following location

app\design\frontend\default\YOUR THEME\template\catalog\Navigation\

Then place the followiing code to list out the left navigation category lists like category and subcategory lists.

<div id="leftnav">
    <?php $helper = $this->helper('catalog/category') ?>
    <?php $categories = $this->getStoreCategories() ?>
    <?php if (count($categories) > 0): ?>
        <ul id="leftnav-tree" class="level0">
            <?php foreach($categories as $category): ?>
                <li class="level0<?php if ($this->isCategoryActive($category)): ?> active<?php endif; ?>">
                    <a href="<?php echo $helper->getCategoryUrl($category) ?>"><span><?php echo $this->escapeHtml($category->getName()) ?></span></a>
                    <?php if ($this->isCategoryActive($category)): ?>
                        <?php $subcategories = $category->getChildren() ?>
                        <?php if (count($subcategories) > 0): ?>
                            <ul id="leftnav-tree-<?php echo $category->getId() ?>" class="level1">
                                <?php foreach($subcategories as $subcategory): ?>
                                    <li class="level1<?php if ($this->isCategoryActive($subcategory)): ?> active<?php endif; ?>">
                                        <a href="<?php echo $helper->getCategoryUrl($subcategory) ?>"><?php echo $this->escapeHtml(trim($subcategory->getName(), '- ')) ?></a>
                                    </li>
                                <?php endforeach; ?>
                            </ul>
                            <script type="text/javascript">decorateList('leftnav-tree-<?php echo $category->getId() ?>', 'recursive')</script>
                        <?php endif; ?>
                    <?php endif; ?>
                </li>
            <?php endforeach; ?>
        </ul>
        <script type="text/javascript">decorateList('leftnav-tree', 'recursive')</script>
    <?php endif; ?>
</div>

Please share this tips and also Don't forgot to enter your Ideas to go next level. Thanks for your support.

By PHP with 1 comment

Magento: Display Shopping cart on the header

In magento we have the option to display shopping cart in the header position.

Go to the app\design\frontend\default\YOUR THEME\template\page\html

In this html folder find the header.phtml file

If header.phtml is not available in your theme goto the base in the below url

app\design\frontend\base\default\template\page\html\header.phtml

to place the followinig code under "header-container" div, now we can able to view total number of  items and price in header.

<?php
  $count = $this->helper('checkout/cart')->getSummaryCount();  //get total items in cart
  $total = $this->helper('checkout/cart')->getQuote()->getGrandTotal(); //get total price
  if($count==0)
  {
    echo $this->__('Items: %s',$count);
  }
  if($count==1)
  {
    echo $this->__(' Item: %s',$count);
  }
  if($count>1)
  {
    echo $this->__(' Items: %s',$count);
  }
  echo $this->__(' Total: %s', $this->helper('core')->formatPrice($total, false));
?>

Please update your comments/feedback to improve in our magento knowledge.

By PHP with No comments

Magento Favicon update via admin control panel

Magento have the possibilities to upload favicon image via admin control panel. Favicon displayed top left browser window.

Login into Magento admin panel and follow the steps

1. Go to System in the Admin top navigation
2. Under the System select Configuration
3. Left General tab -> Design
4. Select HTML Head under the Design
5. Favicon Browse option to upload favicon

Alloweded favicon formats are ICO, PNG, GIF, JPG, JPEG, APNG, SVG. But not all the browsers supported. Better option to upload .ico format

Thankyou . KIndly update your feedback to go with better ideas and solutions.

By PHP with 1 comment

Magento set minimum Qty 1 in product detail page

In magento have the option to set minimum quantity near to the add to cart button in the front end. We Set the 1 as default qty input box via admin control panel.

1. Go to the Admin ->System ->Configuration
2. Select Inventory from Catalog section
3. Product Stock Option -> Minimum Qty Allowed in Shopping Cart
4. Then Add Minimum Qty ->Select All Groups and enter minimum qty as 1.

Magento also have the options to add minimum qty value based on the Customer groups


Thanks for keep reading our website. We are expecting better comments to update our magento knowledge.

By PHP with 1 comment

    • Popular
    • Categories
    • Archives