How to import / export categories in Magento

A common problem in Magento is the lack of an import / export program in Magento. One of the solutions is importing / exporting directly to the MySQL database, but there is a nice plugin as well, made by user Santhosh, well known from the Magento Commerce Forum.

Install the plugin by uploading it to your webdir. In the admin, a menu Santhosh will appear. You can run it now in order to import/export. The category sheet will appear in the following CSV format.

Export file .csv of categories

Download this plugin or read the forum post

Creating a Magento multidomain website

So you have a Magento webshop, but you would like to add additional Magento subwebshops linked to your webshop? Than the Magento Multi-store feature could be something for you.

First you’ll have to add a store or website. Most of the time a store is good enough since it uses the same client database. After adding a store, add a storeview and remember the code of the storeview.

After that make sure the domains are pointed in the same webhosting package or linked. In order for Magento to know what domain has to be linked to a store code, add the following code in .htaccess:

RewriteEngine on

RewriteCond %{HTTP_HOST} ^(.*)domainsub.com
RewriteRule ^ – [E=MAGE_RUN_CODE:substore_en]

In this case the domain: domainsub.com will be linked to the storeview: substore_en . After this, make sure the storeview is set up correctly in Magento. Go to: System > Configuration > Web and edit the url’s (insert domainsub.com).

After that, refresh cache. Everything should work now.

Google Adwords and Magento – Conversion tracking

So you started an Adwords campaign and would like to measure leads and conversions via Adwords. That’s possible of course! First, go to Adwords and to Conversions. Create a conversion and copy the code. It will look something like this:

<!– Google Code for Bestelling Conversion Page –>
<script type=”text/javascript”>
/* <![CDATA[ */
var google_conversion_id = XXXXX;
var google_conversion_language = “en”;
var google_conversion_format = “3”;
var google_conversion_color = “ffffff”;
var google_conversion_label = “YYYYY”;
var google_conversion_value = 0;
/* ]]> */
</script>
<script type=”text/javascript” src=”https://www.googleadservices.com/pagead/conversion.js”>
</script>
<noscript>
<div style=”display:inline;”>
<img height=”1″ width=”1″ style=”border-style:none;” alt=”” src=”https://www.googleadservices.com/pagead/conversion/AAA/ZZZ”/>
</div>
</noscript>

Go to the file /app/design/frontend/default/default/template/checkout/success.phtml and add at the bottom of the file:

<?php
$order_details = Mage::getModel(‘sales/order’)->loadByIncrementId(Mage::getSingleton(‘checkout/session’)->getLastRealOrderId());
$adwords_saleamt = $order_details->subtotal;
?>

Copy your Google Adwords code as well under this code. Under var google_conversion_value = 0; create a line and add:

if (<?php echo $adwords_saleamt; ?>) {
google_conversion_value = <?php echo $adwords_saleamt; ?>;
}

Source: With thanks to: http://www.noamdesign.com/blog/magento-how-to-setup-google-adwords-conversion-tracking/

Removing login step Magento


A common used unnecessary step is the login step. Most people are not interested in getting account. Therefore it could be better removing this step.

Excellence Magento Blog created a good solution that removes the login step.
Remove the login step in Magento

Go to http://www.excellencemagentoblog.com/magento-onestep-checkout-remove-login-step and follow the instructions or like them on Facebook in order to get the complete file.

Shipping based on location and weight (table rates)

Would you like to make a shipping system based on location and weight?

  1. Login to Magento
  2. Go to System -> Configuration -> Select scope on website level -> Go to Shipping -> Table Rates
  3. Click on the button Export to CSV
  4. Edit the CSV and insert a new row for each condition

The table rates sheet will look about this (don’t copy the first row):

Country,State,Zip-Code,”Subtotal and above”,Shipping Costs

BEL,*,,0.0000,14
NLD,*,,0.0000,4.50

So in the country column you place the column. In the state/province column * means all states/provinces. Subtotal and above means the subtotal for which the shipping rule is valid. And for shipping costs you will set the shipping costs that will be charged.

Linking Magento with MailChimp

Would you like to link Magento with Mailchimp?

  1. Create an account at http://www.mailchimp.com
  2. Download and install the MageMonkey plugin from: http://www.magentocommerce.com/magento-connect/mage-monkey-mailchimp-integration-4865.html
  3. Grab the API key from MailChimp. Login -> Account -> API Key -> Add a Key
  4. Insert the API key in Magento under System -> Configuration -> Clients -> MailChimp -> API Key

Magento MailChimp MageMonkey Plugin

Removing blocks from Magento

So you started a new Magento webshop and got overwhelmed by lots of features and widgets?

It could be that you would like to remove some widgets and plugins. In order to do that, navigate to: /app/design/frontend/default/default/layout and open local.xml (or create it).

On top, between the <default>…</default> tags place the removal codes:

Removing the shopping cart at the right side

<remove name=”right.cart_sidebar”/>

 

Removing the standard banners

<remove name=”right.permanent.callout”/>
<remove name=”left.permanent.callout”/>

Removing recently viewed products

<remove name=”left.reports.product.viewed”/>
<remove name=”right.reports.product.viewed”/>

Removing the top search

<remove name=”top.search” />

Removing the PayPal logo

<remove name=”paypal.partner.right.logo”/>

Remove the compare sidebar

<remove name=”catalog.compare.sidebar”/>

Remove compared products bar

<remove name=”right.reports.product.compared”/>

Remove reorder sidebar

<remove name=”sale.reorder.sidebar”></remove>

Improved Magento Checkout (Free one page step checkout)

One of the most important pages of your webshop is the checkout page. When people want to checkout, they expect a fast way of checkout. Unfortunately the current checkout of Magento is still a bit annoying, because of the illogical checkout process.

Free Better Checkout

So what should you do? Buy an expensive one step checkout for a starting webshop? No, that’s not necessary. There is a solution that only requires some CSS improvements and changes the process dramtically.

For example take a look on the improved checkout Dutch website Pyjamaonline:

Magneto Improved One Page Checkout

Looks better than the standard, doesn’t it? Want to make such improvements for your own webshop as well? Download it here: http://www.h-o.nl/blog/improved_magento_one_page_checkout_design_css_only/

Also want to know how to remove the unnecessary login step?

Changing the size of product pictures in Magento

Standard the size of Magento product icon pictures are 135 x 135 pixels. For most purposes that size is a bit to small. How to change the size of these picture?

Changing the size of product images on category list

To change the size of  the image open your website directory and navigate to: app/design/frontend/default/default/template/catalog/product and open list.phtml. Around line 98 you see the following code:

<img src=”<?php echo $this->helper(‘catalog/image’)->init($_product, ‘small_image’)->resize(135); ?>” width=”135″ height=”135″ alt=”<?php echo $this->stripTags($this->getImageLabel($_product, ‘small_image’), null, true) ?>” />

Change it to by example 200 x 200:

<img src=”<?php echo $this->helper(‘catalog/image’)->init($_product, ‘small_image’)->resize(200); ?>” width=”200″ height=”200″ alt=”<?php echo $this->stripTags($this->getImageLabel($_product, ‘small_image’), null, true) ?>” />

Upload the file to your webdir and refresh the cache. Now you see the images in the greater format.

Changing the size of product images on the product page

You can do the same for the images on the product page. Just go to /app/design/frontend/default/default/template/catalog/product/view and open media.phtml. Here you see the same tag with resizing to 265. Change this to your desired format and refresh the cache.