Slow Magento indexing and reindexing on large databases
Do you experience the problem of slow Magento reindexing? Tinybrick Lightspeed is a good solution. It’s a plugin that requires a little investment (500 dollar), but is worth all the speed improvements. Try it Lightspeed.
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: