Magento Themes and Magento Extensions

Flat tables in Magento and product collection

Posted on September 8th, 2011 | Posted by admin

You probaly know that Magento uses EAV database structure for categories, products. In some cases this solution is not the best or fastest.

I will get you here example how to speed up product collection. Magento has config option: “Use Flat Catalog Product”. In order to see this option, go to Magento admin section and click on: System -> Config -> Catalog and Frontend.

If you enable this option, you will adjust Magento to use “Flat resource” for product collection. Take a look at product collection class “Mage_Catalog_Model_Resource_Eav_Mysql4_Product_Collection” you will see a method “_construct“.

Symfony2 Forms – Entity field type

Posted on September 8th, 2011 | Posted by admin

NOTE: Tested on Symfony2 Beta3. Might not work on later releases!

Symfony2 offers many prebuilt field types for using when creating forms. The one of them I found interesting is ‘EntityType’.

I had one case recently that I had to use Entity field type for creating form, but except using it in simple way like documented I wanted to use it on little more advanced way.I have table in database called statuses that have basic filelds like:

id (int11), status_name (varchar 50), status_type (varchar 20). I defined 3 basic statuses that will be used for all items I have to describe their state:

draft, live, deleted

but, also I have more statuses defined that is for other purposes.

How can I transfer my Magento store from another provider?

Posted on September 6th, 2011 | Posted by admin

If your store is currently hosted on another server, you may transfer it to us following these simple steps. If you have not yet signed up, please check out our Magento optimized hosting services.

Step 1 – Create a Database

First, you need to create a new MySQL database for your store. Log in to cPanel by following the instructions given in your Account Information email. Then click on the MySQL® Database Wizard icon. Type in a name for your new database (e.g. mystore) and click Next Step (see Figure 1). Now you need to assign a new user to your database. Type in a username and password then click Next Step. Finally, check the All Privileges checkbox and click Next Step to complete the database wizard.

You can now log out of cPanel and continue with the next step.

10 Ways to Speed Up Your Magento eCommerce Site

Posted on August 30th, 2011 | Posted by admin

Is your Magento store not as fast as you would like it to be? Below you will find our Top 10 Tips & Tricks to speed up your Magento site.

Note: some of the steps below require server administrator access.

  1. Ensure you are running the latest version of Magento. New releases often include performance improvements and other patches which affects performance.
  2. Enable the Flat Catalog module for products and categories in the Magento Admin Panel. We have seen quite significant improvements by turning on this feature, especially on large catalogs.
    Where: System -> Configuration -> Catalog
  3. Enable caching to reduce the number of database operations required for each page request.
    Where: System -> Cache Management
  4. Keep the number of third-party/community extensions to a minimum. Many extensions introduce extra processing and database queries which has a negative impact on the overall performance.

How to change the Magento Admin URL / Path

Posted on August 25th, 2011 | Posted by admin

To protect your Magento backend against hackers and brute-force attacks, we recommend that you change the default URL to the Magento Admin Pane. It is a quick way to add an extra layer of security to your site.

Follow these steps to change the admin URL/path.

Note: Do NOT use the web interface in the Magento Admin Panel to change the admin URL, as this is known to cause severe problems.

Step 1 – Change Path

First, open the local.xml configuration file in your favorite text editor, or use the Text Editor in the cPanel File Manager. The file is usually located in the app/etc/ directory under your Magento installation. Locate the following code segment: