Magento (32 Articles)

Redsys Payment Gateway support

Redsys is a popular payment gateway. It has extensions for many e-commerce solutions like WooCommerce, PrestaShop, Magento, etc. Currently it does not support the Let's Encrypt Certificate Authority and SNI . However, we support other options for the successful usage of the Redsys payment gateway. First, the communication between the website and the Redsys payment gateway can be managed over HTTP (without an SSL certificate). Another option is to purchase a Wildcard SSL or an EV SSL certificate from the User Area->Add Services section. It comes with a dedicated IP and is issued by Globalsign. A dedicated IP will also be assigned to your account if you order the installation of an external SSL certificate in case you already have…

Magento Compilation – What is It and How to Disable It If Needed

The Magento Compilation is a feature that allows you to compile all Magento installation files in order to create a single include path. This feature is designed to improve the performance of your online store and is supposed to give between 25% and 50% increase in your page load speed. Note that before making any changes to your Magento Installation files, the Magento compilation feature should be disabled. To disable Magento Compilation, go to your Admin Panel -> System -> Tools -> Compilation and click on the Disable …

How to enable a theme for my Magento mobile web site?

In order to use one theme for a Magento web site when it is loaded through a personal computer and a different one for mobile devices follow the steps listed below. First, pick the preferred mobile Magento theme and install it as shown in our tutorial: http://www.siteground.com/tutorials/magento/magento_themes.htm Do NOT enter its name in the Default theme field. This way the default theme will be loaded when the web site is opened through a computer. Next you should add exceptions for the mobile devices. Navigate to the Magento administrative area -> System -> Configuration -> Design -> Themes . Click on the Add Exceptions buttons besides the Templates , Skin and Layout labels. Enter the following line in the Matched Expression field: iPhone|iPod|BlackBerry|Palm|Googlebot-Mobile|Mobile|mobile|mobi|Windows Mobile|Safari Mobile|Android|Opera Mini In the Value field enter the name of your newly installed mobile theme and Save the changes. Then you can open your web site through your computer and your mobile phone. You will see that it loads with two different themes depending on the…

Reindex Magento Data via SSH

The fastest way to reindex Magento data is manually via SSH. To reindex the Magento data manually, you need to have an SSH access to your web hosting account. All SiteGround hosting accounts come with SSH access. More information on how to manage SSH access to your account can be found in our SSH tutorial . All you need to do to reindex your Magento data manually is to log in your hosting account via SSH, go to your Magento installation directory (e.g. public_html/store ) and execute the following command: /usr/local/php55/bin/php-cli -f shell/indexer.php reindexall This command will reindex data by all…

How to set up log cleaning in Magento

In order to make sure that your Magento is not being slowed down by a huge amount of old log records, it is recommended that you set up its log cleaning function to automatically purge old logs. You can do this from the Magento admin area > System > Configuration > Advanced section > System > Log Cleaning . Once there, modify the value for Save Log, Days . The default value is 180 but we recommend changing it to 60 or even 30 days. Then set Enable Log Cleaning to Yes and click Save Config to save the changes. Note that the Log Cleaning functionality depends on the Magento cron. You need to make sure you have set up the cron in order for your log cleaning to work properly. Another solution is to use the maintenance script provided here: http://briansnelson.com/stuff/magento-ce-db-optimize.script You will need to set the cron job according to the instructions in the article for the log cleaning to be completed…

How to speed up product imports and exports in Magento

Magento product imports and exports tend to gradually slow down. The reason for this usually is that the Magento database fills up with records and the larger it becomes, the slower product imports and exports become. Fortunately, there is an easy solution. To reduce the database size and speed up product imports and exports, you can delete old records by truncating a few tables. The tables that need to be truncated are log_url , log_url_info , log_visitor , log_visitor_info , dataflow_batch_import , dataflow_batch_export , index_event and report_event . You can truncate these tables through phpMyAdmin . Simply tick the 8 tables and from the With selected drop-down menu at the bottom of the page select Empty . An alternative of the above is to click the SQL tab in phpMyAdmin, paste these queries: TRUNCATE log_url ; TRUNCATE log_url_info ; TRUNCATE log_visitor ; TRUNCATE log_visitor_info ;  TRUNCATE dataflow_batch_import ; TRUNCATE dataflow_batch_export ; TRUNCATE index_event ;   TRUNCATE report_event ; and click the Go button to execute them. It is also recommended that you set up log cleaning in Magento so that your Magento can purge its logs automatically.…

How to debug Magento MySQL problems

Just as any modern PHP application Magento stores most of its information in the database (except media and xml configurations). Thus when debugging Magento problems it is useful to know a few things: 1. All MySQL queries can be logged and examined. For this purpose open the file lib/Varien/Db/Adapter/Pdo/Mysql.php and change the value of the protected property $_debug to true. You can also change the value of $_logQueryTime which is especially handy when debugging slowdowns. Once you make this change all queries will be logged in the file var/debug/sql.txt 2. Magento has an useful tool for fixing frequent database problems. This tool requires a working magento installation which database is used as reference for fixing a corrupted one. Please remember always to backup your Magento database before making any changes to it. Debugging Magento MySQL problems often requires advanced programming skills. Siteground is glad to offer you the best Magento hosting package with extensive expert support.…

How to install a Magento extension through the command line?

If you have SSH access to your web hosting account, you can easily install a Magento extension through the command line. To do it, open an SSH connection to your account and enter the following command: ./pear install Magento_extension_key In the above command line replace Magento_extension_key with the exact key for the chosen extension. In the following example we show you how to install a classic theme extension through the command line: ./pear install magento-community/magento_classic_theme_free downloading magento_classic_theme_free-1.4.1.2.tgz ... Starting to download magento_classic_theme_free-1.4.1.2.tgz (3,687,973 bytes) .......................done: 3,687,973 bytes install ok: channel://connect.magentocommerce.com/community/magento_classic_theme_free-1.4.1.2 …

How to install Magento extensions in alpha and beta states?

By default extensions in stable states can be installed through the Magento Connect Manager tool. If you want to install an extension which is in alpha or beta state you need to get the extension key. Then you should open your Magento admin area-> System->Magento Connect-> Magento Connect Manager . You will be prompted to enter once again the admin login credentials. Log in and navigate to Settings . In the Preferred State drop-down menu you can switch between the Stable , Alpha and Beta states. Once you are ready, save the settings and return to the Extensions area. There you can paste the extension key and install the extension.…

How to resolve the ‘Invalid package identifier provided’ error in Magento?

The Invalid package identifier provided error occurs when there is a problem with the installation of an extension through Magento Connect Manager . Often it is caused by the fact that the chosen extension is provided as a beta release. The switch between the stable and the beta states can be easily completed through the Magento Connect Manager->Settings->Preferred State . Alternatively, you can install an extension using the following shell command: ./pear install Magento_extension_key In the above command line replace Magento_extension_key with the exact key for the chosen extension. In the following example it is shown how to install a classic theme extension through the command line: ./pear install magento-community/magento_classic_theme_free downloading magento_classic_theme_free-1.4.1.2.tgz ... Starting to download magento_classic_theme_free-1.4.1.2.tgz (3,687,973 bytes) .......................done: 3,687,973 bytes install ok: channel://connect.magentocommerce.com/community/magento_classic_theme_free-1.4.1.2 …

How to fix ‘Fatal error: Call to a member function toHtml() on a non-object’ in Magento?

Sometimes, after a theme installation or a upgrade you can face the following error message in your Magento web site: Fatal error: Call to a member function toHtml() on a non-object in app/code/core/Mage/Core/Model/Layout.php on line 529 In order to resolve the issue, open the app/design/frontend/default/ YOUR_THEME /layout/page.xml file and change the following line: <block type="core/profiler" output="toHtml"/> to <block type="core/profiler" output="toHtml" name="core_profiler"/> Replace the YOUR_THEME string with the exact name of the Magento theme which you want to use. Then navigate to your Magento admin area-> System->Cache Management and flush your script's cache. Alternatively, you can follow the instructions from the How to clear the cache in Magento article. Once you are ready, reload your web site.…

How to enable/disable the demo store notice in Magento

Magento can be configured to display a notice when your store is in demo mode so that your customers know that their orders will not be processed. In order to enable/disable the Demo Store Notice in Magento, you need to log into the Magento administration area and navigate to the System tab > Configuration . Select the Design section, click HTML Head   and you will see a Yes/No drop-down menu for Display Demo Store Notice . Enable/disable the demo store notice and click Save Config to save the change.…

My Magento cronjobs are not executed properly

By default, the Magento application settings are such that when cron.php is being processed for a period longer than 15 minutes after a job was supposed to be completed, it is marked as missed and is ignored. This setting can be configured through the Magento administrative area -> System -> Configuration -> Advanced -> System -> Cron -> Missed If Not Run Within . That is why it is recommended to change this setting to a value greater than 30 minutes - for example you can set it to 35 minutes. Otherwise, tasks that are only scheduled once a day or so may get marked as missed. After that set Schedule Ahead for to 35 minutes and the cron jobs issue should be…

Magento Contact Us Form

A contact us form is available by default in Magento. A link to it can generally be found in the footer for your Magento installation. Of course you can add contact form on any page for your Magento online store. All you need to do is: Login to the administrator area. Then go to CMS -> Pages. Select the page you want to edit or start creating a new page. Once you are ready paste the following code using the HTML option for the WYSIWYG editor: <!– CONTACT FORM CODE BEGIN–> {{block type='core/template' name='contactForm' template='contacts/form.phtml'}} <!– CONTACT FORM CODE END–> That is all. The contact form will now appear on the desired page.…

How to setup a Blog in Magento

It is not hard to setup a blog in Magento. However you should take into account that blog functionality is not included by default and you need to use a custom extension for it. You can search Magento Connect for an extension that will fully suit your needs. One of the popular free extensions that you can use is the Magento Blog – Community Edition . All Magento extensions are installed in a similar way that is thoroughly explained in our Magento Connect Tutorial . In order to install the Magento Blog extension get the extension key and enter it in Magento Connect for your website. After the installation you will have one additional section in the Magento administrative area top menu called Blog. From there you can adjust the newly installed Blog settings, add posts etc. NB : If you get access denied when trying to access the blog extension for the first time after installation try to log out of the Magento administrative area and then log back in. This should rectify the…

How to start building your Magento site

It is easy to start building your online store site with Magento. The installation is fully automated. It comes with very intuitive and easy to use administrator area that will allow you to manage your Magento site with ease. Here are the basics of starting your Magento site. First of all you will need to have Magento installed for your web site. On SiteGround servers the Magento install can be easily accomplished via only a few clicks. SiteGround cPanel -> Site Software includes automatic Magento installation script that will setup Magento for you in a matter of seconds. The alternative is the manual Magento install. You can check our detailed tutorial How to perform manual Magento installation . Next you are ready to start with your Magento site configuration. Everything can be easily performed via the administrator area for your new installation. Detailed instructions you can find in our Magento configuration tutorial . Once you have setup the basics for your Magento site you should think about getting a custom template that will suit the design needs for your web site. You can check SiteGround tutorial How change the theme for your Magento site for more information. Also a good start is to adjust the main page for your Magento site. You can check the basics of altering the main page for Magento here . An important part of your Magento website is including SSL for secured transactions. It is really important that your website visitors feel safe when making their purchase. You can check the following tutorial for more information How to enable SSL for your Magento website . Last but not least – take some time to adjust your Magento website and make it Search Engine Friendly. By default Magento is one of the most search engine friendly e-commerce applications. SEO can be easily turned on as described in this tutorial .…

How to alter product price in Magento

Altering the price of products in Magento is an easy task. All you need to do is: Login to Magento Admin area. Go to Catalog -> Manage Products. Find the product for which you would like the price changed and click Edit. Select Price from the right-hand menu. You will see several fields that will allow you to set product price and also set special price for specific time frame. Once ready click the Save button in the upper right corner. …

Magento Report

In order to export a report in Magento you need to enter the administrator area for the installation.Once there, choose Reports and select the desired report type from the drop-down menu. On the new page that will load select the desired report type from the drop down menu. The available options are CSV and Excel.…

How To Enable Friendly URLs in Magento

In order to use Magento's feature for more user and search-engine friendly URLs, you have to login to the Magento's administration area (usually * http://YourDomainName.com/admin/* ), click on the *Configuration* button, under the *System* navigation menu, switch to the *Web* page from the sub-navigation panel on the left side of the page. When the page loads, you will see blue lines, which represents closed settings tablets. Click on the *Search Engines Optimization* tab, and turn on the *Use Web Server Rewrites* (mark as *Yes)*. Click on the *Save Config*button and you are done. Now you have enabled user-friendly URLs in Magento.…

How To Reset Admin Password in Magento

You can reset your Magento administrative password directly through the database related to your website application. You can access the database through cPanel -> phpMyAdmin tool. Once you have opened the phpMyAdmin tool choose the corresponding database* from the dropdown menu on the left side. After that click on the SQL tab in order to be able to execute the following MySQL query. Note that the query will differ depending on the Magento version you have: For Magento 1.9 and older [crayon-584496e91ae4f730972341/] For Magento 2: [crayon-584496e91ae5e622453262/] where: admin_user - this is database table from the Magento database. Bear in mind that this table may have a prefix such as " mg_ " or different one. You will see the prefix of the database once you access the phpMyAdmin tool and select the database. The database tables will be listed and you will see if there is a database prefix or not. If there is a prefix you should replace the admin_user name with the correct database table name, i.e. mg_admin_user . NewPassword  - the desired password which you want to be set.  The x..x character sequence is a cryptographic salt. It can be anything you want, but make sure you use the same value in both parts of the SQL statement. ADMINUSERNAME - your Magento administrative username, i.e. admin. Execute the query and your new password will be set. *If you are not sure exactly which database is related to your website you can find its name inside the following file: ~/app/etc/ local.xml You can open the file through cPanel -> File manager and search for the following line: [crayon-584496e91ae67476705305/] where user_magedatabase is the name of the…