Acceder a Catálogo, Gestión de reescritura de URL, Añadir reescritura de url, y para cada idioma de nuestra tienda generar una nueva regla personalizada (custom) como en la siguiente imagen:

Con esto se imposibilita el registro de usuarios. Para habilitar de nuevo el registro deberíamos borrar las reglas de redirección que acabamos de crear.

To get a better IP and domain reputation when sending email marketing you need to configure SPF and DKIM records into your servers. This small guide helped me to setup OpenDKIM on i-MSCP Panel.

Amongst the first Google hits were exactly the interesting bits for me – a forum post announcing the availability of this plugin and an URL to its download section. I'm going to outline the complete process here, first for my personal future reference, but also for anyone who might come across this.

  1. Download the thing (should be – and left that way – in a tarball).
  2. Upload it on the server:
    1. Login as admin user
    2. Go to Settings page
    3. Section Plugin management
    4. Subsection Plugins upload
    5. Browse for the tarball, click upload.
  3. Login as root via SSH
  4. Install opendkim and opendkim-tools (package names in Debian).
  5. Go back to the web UI and click on the "Activate" icon on the right side of the OpenDKIM plugin.
  6. Go back to your SSH console and fix a small permissions issue: chgrp opendkim /etc/opendkim
  7. Restart opendkim service opendkim restart
  8. Back to your web UI, login as Reseller and click on Customers
  9. If all went well, you should be able to see a new menu item OpenDKIM
  10. Choose from the dropdown the domain you want DKIM entries on, submit.
  11. Profit!


Magento has lots of features as an ecommerce application. No doubt that’s why it is too popular too. These days most of the clients (end customers/users) prefer Magento by themselves. But there are some pitfalls within it. Once explore it specialy working as a developer (programmer), you will be in a trouble in such way that you are no more going to use Magento for any purpose because you will stucked in such a problem which neither can be solved nor you can directly change Magento’s code itself. Saying so, I don’t mean that we cannot solve those problems. Indeed we can solve the problems sometimes by hacking the core codes and in the other times by changing some values directly from the database. Since Magento is designed and developed with EAV (Entities, Attributes & Values) model, it is really difficult to find a particular data/value within the database too. And most of the times we extend its features by creating our own modules.

Anyway, here I am going to present a hack to solve a problem.

For SEO friendly URLS, Magento has a field for a Product and Category to create custom SEO friendly URL keys. But when you have multiple stores, then you cannot normally have different URL keys for different stores because the field url_key is ‘GLOBAL’ by default. For products, you can update the url_key attribute’s is_default field to ‘Store Views‘ from Attribute Management. But for the category’s url_key field, you don’t have that option in Magento. But the field does exist in the database with the same attribute code but having different backend_model so you need to go to the database directly and change the ‘is_global’ field 1 to 0.

- First of all, access your Magento database from phpmyadmin (or any MySQL client).
- Then run the following query:

SELECT * FROM eav_attribute WHERE attribute_code LIKE ’%url_key%’;

Then you will have following results:

  • 479 9   url_key NULL    catalog/category_attribute_backend_urlkey   varchar         text    URL key
  • 481 10  url_key NULL    catalog/product_attribute_backend_urlkey    varchar         text    URL key

- First attribute is for the category and second one is for the products. So note down the attribute_id of the first record (in my case 479).
- Then run the following query:

SELECT attribute_id, is_global FROM catalog_eav_attribute WHERE attribute_id=479;

To make sure if it has ’1′ by default or not because ’1′ is the value to make the attribute GLOBAL.

- If it is ’1′ then run the following query to update the value to ’0′:

UPDATE catalog_eav_attribute SET is_global=’0′ WHERE attribute_id=479;

- Now clean the cache and try to edit a category with different stores and see the field URL Key. This will now have ‘Store View’ scope.

When Updating ( or installing) your Magento theme to Version, and you had problem with error of SQL state, and you want to fix it as soon as posible.

This tutorial, we will guide you how to fix it to help your store in Magento
All you need to fix the issue with mega menu is to do as 4 following steps to fix SQL state:

Step 1:Go to file app\code\local\Sm\Megamenu\Block\Adminhtml\Menuitems\Grid.php and back up this file.

Step 2:In this file app\code\local\Sm\Megamenu\Block\Adminhtml\Menuitems\Grid.php please go to line 39 and edit it into:

Step 3: Please go to file app\code\local\Sm\Megamenu\Helper\Data.php and back up this file.

Step 4: In this file app\code\local\Sm\Megamenu\Helper\Data.php. please edit line 320 into:

Step 5: After that you can clear cache, log out and log in your admin and you should be able to use your menu again.

sacado de http://www.magentech.com/documentation/how-to-fix-sm-megamenu-error-when-update-to-magento-v1-9-2-0/


Tras actualizar a la última versión de magento me sa errores el índice de SM Shopby, y no actualiza correctamente, se queda en error. Para corregirlo hay que editar el fichero: app/code/local/Sm/Shopby/Model/Resource/Indexer/Attribute.php en la línea 65 aprox, donde la funcion _getAttributes() y quitar las comillas a '`main_table`.`frontend_input`' y a '`main_table`.`attribute_id`' y dejarlos así:

'main_table.frontend_input' y a 'main_table.attribute_id'.

El Editor de diagramas Dia en mi Ubuntu 14.04 tiene un bug en el campo comentario de las tabas de bases de datos. Lo he podido corregir siguiendo el hilo de este link:


Editar el fichero /usr/bin/dia y dejarlo así:

# Wrapped that calls dia in integrated version

LIBOVERLAY_SCROLLBAR=0 dia-normal --integrated "$@"


Tambien se puede editar el fichero /usr/share/applications/dia.desktop y modificar la linea Exec para dejarla así:

cd /magento/htdocs/shell/
php indexer.php --reindexall

SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction
Sometimes deadlock issues can be caused on the database.

This might happen if you are running a lot of custom scripts and killing the scripts before the database connection gets chance to close

If you login to MySQL from CLI and run the command


Solution – First Step

cd pkginfo
# rm -Rf Mage_All_Latest.txt Mage_All.txt
# cd ..
# sudo -u www-data ./mage upgrade-all
Installing package community/Mage_All_Latest
Package community/Mage_All_Latest installed successfully
Starting to download Interface_Adminhtml_Default- ...
...done: 1,014,275 bytes
Installing package community/Interface_Adminhtml_Default
Package community/Interface_Adminhtml_Default installed successfully
Starting to download Interface_Frontend_Default- ...
...done: 747,738 bytes
Installing package community/Interface_Frontend_Default

Now delete the maintenance.flag file and your shop is updated and online! :-)

Sacado de http://www.fly2mars-media.de/seoblog/magento/magento-1-9-2-2-upgrade-conflict-issue-supee-6788-security-patch-solution-for-this-problem-102558/

20 Command Line Tools to Monitor Linux Performance

It’s really very tough job for every System or Network administrator to monitor and debug Linux System Performance problems every day. For this reason, we’ve compiled the list of Top 20 frequently used command line monitoring tools that might be useful for every Linux/Unix System Administrator. These commands are available under all flavors of Linux and can be useful to monitor and find the actual causes of performance problem. This list of commands shown here are very enough for you to pick the one that is suitable for your monitoring scenario.

This post mentions some linux command line tools that can be used to monitor the network usage. These tools monitor the traffic flowing through network interfaces and measure the speed at which data is currently being transferred. Incoming and outgoing traffic is shown separately.

Some of the commands, show the bandwidth used by individual processes. This makes it easy to detect a process that is overusing network bandwidth.

The tools have different mechanisms of generating the traffic report. Some of the tools like nload read the "/proc/net/dev" file to get traffic stats, whereas some tools use the pcap library to capture all packets and then calculate the total size to estimate the traffic load.

En este artículo comentamos la forma de configurar una cache de dos niveles en Magento, configurando el servidor (debian) con APC y creando un segundo nivel de cache en RAM para mejorar todavía más el rendimiento.

Ponemos a prueba la caché alternativa de php: APC en nuestro servidor web. Por el momento parece que las webs cargan rápidito... fiuuuuu! El proceso de instalación es muy sencillo si ya dominas la línea de comandos, el gestor de paquetes apt y el editor vim.

El código de conversión de Adwords nos ayuda a seguir los movimientos de nuestros usuarios en la web. Esta vez os cuento como insertar un código de conversión en el formulario de contacto de Magento. Os propongo dos opciones:

  1. Activar el código de conversión cada vez que se accede a la página de contacto
  2. Activar el código SÓLO cuando se envía un email a través del formulario de contacto

Insertar Adwords js código de seguimiento de conversiones en la página checkout success de pedido de Magento

Featured Image


Añadir el código javascript de Adwords en la página de agradecimiento de pedido de Magento es relativamente fácil. Esta es la manera más adecuada de hacerlo, y además te puede servir de ejemplo para insertar código de seguimiento en otras páginas, como por ejemplo la del formulario de contacto:

Quiere contactar con nosotros?

Envíenos un Esta dirección de correo electrónico está siendo protegida contra los robots de spam. Necesita tener JavaScript habilitado para poder verlo. o llámenos a (+34) 698 259 856