Categories
Magento

Deal With Magento Database Huge size

From time to time I need to replicate a Magento database from the production site to the staging environment. It’s common to find out that a mysql dump of a Magento database is two, three or more gigabyte. With such sizes, even when using gzip and catz, backup and restoring a database requires disk space […]

Categories
Magento

Using Magento local.xml to Override a Model/Helper/Block

Today I was modifying and debugging a Magento module and I found myself in the need to override a class of that module to make it to write to file instead of trying to send processed data to an external service (so it would have been easier to debug). Instead to change the original class (and the […]

Categories
Magento

Magento Model Events Explained

Events are an important set of features a Magento code must know. Events are not Magento specific: Drupal, WordPress and many others systems use events to let plugins and modules and extensions to interact with the code without changing it. Magento suffers of bad coders’ habits which rewrite or replace core classes making hard to […]

Categories
Magento

Simple Configurable Product for Magento: DO NOT Use It

I know, Magento is very weak about configurable products. The fact that you cannot force a configurable product to inherit the connected simple products full price is very annoying. This problem won’t be solved in Magento 2, as I read on latest news, but there is always a little hope to see that featured implemented in […]

Categories
Magento

Follow Up Email Extension for Magento

Recently I worked on a big e-commerce site, of course based on Magento, and one of the task was to fix an issue with a follow up email extension. I suddenly discovered the extension to be the aheadWorks follow up email module and I was really surprised to find it not working. aheadWorks has a […]

Categories
Magento

Magento and Google Webmaster 404 Report About product/upload

If you use the Google Webmasters tools (and you should), you may have noticed on the 404 reports panel one or more URL like /../catalog/product/upload/option_id/ That URLs are not “real”, they are only a part of a real URL then completed by some JavaScript when you upload a file to add a product to the […]

Categories
Magento

Magento Navigation Menu Caching Improvements

Working on different Magento based sites, I found the navigation menu being a very resource consuming part of the front-end generated pages. Most of the times, that menu was customized or even totally recreated without keeping in mind a basic thing: that menu is loaded in every single page of a Magento site and if it’s slow, […]

Categories
Magento

Magento Special Price Not Loaded With Massive Product Import

Every time I work in Magento, even a simple issue becomes a complex task. This time the problem was related to product special prices. In that Magento based e-commerce, the whole catalog is regularly imported from an external set of files, with product details and prices for many countries. The Magento is actually configured in […]

Categories
Magento

Magento: How To Add The Target To Grid Url Actions

Magento, on administration side, has the concept of “grid”, a table with ability to filter, order, page a collection of data. For example the product list is a grid. A grid is usually initialized on block implementation that “prepares columns” and when I needed to change the columns of a grid I overloaded the block […]

Categories
Magento

Magento: How To Sligtly Modify the Invoice Pdf

That’s good, we saw how to get the PDF version of a Magento invoice available in the frontend (inside the customer dashboard). Now I need to slightly modify the invoice PDF keeping all the original formatting but changing only the document number (on the PDF the Invoice # 10000000x). I need to format it as […]