Catalog Product update Magento 1.x – CSV

If you want to update attribute value for Magento catalog product in bulk, you can use CSV. Just create a CSV file with column SKU and respective attribute values for a product.

Using the above PHP script you can update multiple attribute value programmatically. You can set CRON to run this script automatically.

The above script capable to upload above 1 lakh products attributes value via CRON and CSV read from bottom to up that help when you have a very large file.

 

 

 

Magento load CSS and JS in footer

By some online tools(tools.pingdom.com or Gtmetrix.com) It’s suggested that either load JavaScript(JS) files in footer of the page or deferred so that they don’t block downloading of other assets of the page like images etc.

By default Magento load JavaScript and CSS files in header section. Magento footer block is not designed to load JS and CSS in footer of page.

Here is solution for this problem:

Step 1: Add new layout in page.xml

Create a block same as page/html_head with name “footerjscss” to the page.xml

Step 2: Add JS/CSS using xml layout:

Now you can add JavaScript(JS) and CSS files in pages using any of your XML files

Step 3: Create view file:

Create .phtml file in page/html/footerjscss.phtml and add following

In your page template files “1column.phtml”, “2columns-left.phtml”, “2columns-right.phtml”, “3columns.phtml” and etc. you will need to output this block before <body> tag:

If you want to improve/increase Magento speed or optimize Magento performance read this: Magento Optimization

Thanks!!!

  • Rahul Dadhich.

.htaccees for Magento Performance Optimization

Magento is one of the most widely used eCommerce platforms today that people to choose to grown their online business. Optimizing the speed of your Magento allows customers to have the best user experience while shopping in your e-commerce store. In this post, you will get some tips to increase Magento speed and Magento performance optimization techniques.

Every e-commerce shop owner and users love the faster website. If website speed is slow user may leave a website and buy products from your competitors.
So you want to speed up your Magento store, here are some htaccess file tips:

Browser Caching & htaccess Configuration

Enable Output Compression
The apache mod_deflate module, which compresses text, CSS, and javascript before it is sent to the browser. This result lower file size.

Gzip Compression
This will compress stylesheet and web page before sending them to browser

Enable Expires Headers
To determine how long web page components cached in a browser cache. Web page static components like images, stylesheets.

Disable ETags
Entity tags (ETags) are a mechanism that web servers and browsers use to determine whether the component in the browser’s cache matches the one on the origin server. ETags were added to provide a mechanism for validating entities that are more flexible than the last-modified date.

Mime Type Caching

 

Magento load JavaScript(JS) and CSS files in footer: http://blog.rahuldadhich.com/magento-load-css-js-footer/

Thanks.

  • Rahul Dadhich