Magento Commerce is very robust system which make me happy with its complexness, but on the other hand this robustness implied bad performance. There are few but reliable tips for Magento Performance Enhancements before you should upgrade your server. You can tune Apache web server, PHP engine configuration and modules, MySQL server configuration, and at last you have to setup Magneto to use this tunes.
This Post is step by step generic tutorial how to install Magento Commerce.
First of all you should setup your Environment, but if you are installing Magento first time you should check if you fit Magento Commerce System Requirements. In short you need: any os running Apache, PHP, and MySQL. Required PHP modules are: PDO_MySQL, Simplexml, mcrypt, hash, GD, DOM, iconv, SOAP (optional).
If you have to migrate Magento database from one server to another, or from your local working station to server (etc.), you sure noticed that Magento store informations about base urls in database, so you have to change this data. To fix this you need migrate the database to new server, and then through PHPMyAdmin, or mysql console submit this commands to change new base url and base secure url.
If somebody told you, you can't import images to Magento, he was definitively liar. Magento Dataflow can import images, but the trick is you have to upload or copy images you want to import into [installation_directory]/media/import/* . Then export (System -> Profiles -> Export All Products -> Start profile) your products if you have any, download (copy) and edit the file. Now you can fill columns small_image, image, thumbnail with absolute path from media/import directory - for example /my_image.jpg (note the / on the start).
Its pretty simple - you have to do edit your Home page. Go to your Magento admin, login, then go CMS - Manage Pages. Edit your Home page, and in the place you wanna have product list displayed put this row:
Čeština
English
{{block type="catalog/product_list"
category_id="1"
template="catalog/product/list.phtml"}}
Where you have to change the category_id attribute to category id you want to display. You can find this id in heading, if you editing any category.
Its quite simple. You just have to edit your local configuration file app/etc/local.xml too look like this:
<config>
<global>
<cache>
<prefix>apc</prefix>
<!-- this prefix should be unique for each Magento using this server -->
<backend>apc</backend>
</cache>
<!-- ... another content of your local.xml -->
</global>
</config>
Just send this SQL commands to your database console:
DELETE FROM log_customer; DELETE FROM log_quote; DELETE FROM log_summary; DELETE FROM log_summary_type; DELETE FROM log_url; DELETE FROM log_url_info; DELETE FROM log_visitor; DELETE FROM log_visitor_info;
If you used recently dataflow import or export, you can clean dataflow tables with these commands:
Many people have suffered a lot by Magento Commerce Dataflow speed. I had serious problem by myself, when i tried to import 10,000 items into Magento database. I wrote my own import script, one of possible solutions to Magento Dataflow speed problem. But my achieved results were about 30-60 seconds per item. That's terrible.
