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.
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:
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.
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 –>
/* <![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;
/* ]]> */
<img height=”1″ width=”1″ style=”border-style:none;” alt=”” src=”https://www.googleadservices.com/pagead/conversion/AAA/ZZZ”/>
Go to the file /app/design/frontend/default/default/template/checkout/success.phtml and add at the bottom of the file:
Would you like to make a shipping system based on location and weight?
Login to Magento
Go to System -> Configuration -> Select scope on website level -> Go to Shipping -> Table Rates
Click on the button Export to CSV
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
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.
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:
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:
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.