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 Product XML Feed for Google Merchant Center

In this post, I will describe you how to add Magento products to Google Merchant Center.

What is Google Merchant Center?

Google Merchant Center is a tool that helps you upload your store and product data to Google and make it available for Shopping ads and other Google services.

Setting up the Google Merchant Center account

In order to use Google Merchant Center, you must first sign up for an account with Google. If you already have an account with Google (like Gmail), visit merchants.google.com and sign in to get started.

Just install extension from here: https://github.com/rahuldadhich/productxmlfeed

If you need more attributes or in case of any query/suggestion feel free to reach me on rahuldadhich87@gmail.com

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

Magento – Introduction & Installation – 1.x

Hello, Are you a Magento beginner? Want to create eCommerce website?

If so, this article is written specifically for you.

In order to start with Magento, admin, and customization, it is very important that you have a strong understanding of Magento, its installation steps.

What is Magento?

Magento is most powerful, flexible online eCommerce platform, which is open-source and builds upon Zend Framework. Magento comes with a fully functional back office to administer the site from site design to product and order management also with user area which is account management for your customers. Magento comes in two different flavors: Community Edition and Enterprise Edition. The community edition of Magento is free available.

Follow these steps to install Magento:

The first thing you need to do to install Magento manually is to download the latest installation package from the official Magento website.
After download Magento zip, extract the content of package in the public_html folder on your site(http://yourweb.com), or on a local machine in your htdocs(in xampp) or www(in wamp) directory.
Create MySQL database and assign a user to it. Remember the database details, you will need these during Magento installation.
Now navigate to http://yourweb.com

Magento install step 1
Magento install step 1

Click on the checkbox “I agree to the above terms and conditions” and click on the Continue button.

Next, choose your preferred Locale, Timezone, and Currency and click on Continue button.

choose the preferred Time Zone, Locale, and Currency and press the Continue button

Magento install step 2
Magento install step 2

Now, enter the database details: Database Host, Database Name, User Name and User Password. You can leave the other options. Make sure that check on the “Skip Base URL validation before next step” option. Then, click the Continue button to proceed.

Magento install configuration
Magento install configuration

enter the database details: Database Name, User Name, and User Password

Magento create admin account
Magento create admin account

Now, It’s the last step, you just enter the personal information and admin login details. You can leave the Encryption Key field empty. Click on Continue button.

Finally, Your Magento installation was successfully completed. Now you can navigate to its Frontend or Backend.

KEEP CALM and READ ON!!!

Rahul Dadhich