In a situation where you want Magento to display out of stock product options of a configurable products, overriding getAllowProducts() function in Mage_Catalog_Block_Product_View_Type_Configurable is where you should be looking, change

if ($product->isSaleable()) 
{
         $products[] = $product;
}

to

$products[] = $product;

Bingo!!!

If you are using the latest version of phpMyAdmin you have no doubt spotted the nice javascript table select system that allows you to type keywords that filter the list of tables down to the one you are looking for.

However if you are dealing with a system that has a lot of tables, the list is paged and unfortunately this javascript system does not filter the entire table list, just the current page.

The solution is to add one line to your config.inc.php in the phpMyAdmin root.

$cfg['MaxTableList'] = 500;

Ever started a long process running that you thought wouldn’t take long and then thought “I should have run that in screen”?

Well, thanks to an ingenious programmer, you can actually do that!

The app is called reptyr, is at https://github.com/nelhage/reptyr and there’s a ubuntu ppa here Note: I compiled from scratch as the ppa didn’t seem to work for me.

So, all you need to do is open a terminal (press Ctrl-Z to stop the task if you only have one and don’t want to open a new one), run screen (or tmux etc) and type “reptyr 1234″ where 1234 is the process id (pid) of the program to pull to your current terminal. To get the pid, “ps waux” usually gives all the info you need to identify it.

If you are running multi site Magento with different currencies and are finding that the sales reports on the stores that don’t use the Magento default currency all show zero this probably means the currency conversion rates have not been configured. Due to the way Magento orders work existing orders will not have there conversion rate updated. There is no way to do this from the admin, the only real option is to update the orders directly in the database.

So, this is documented in the manual, but isn’t obvious in any menu :-

To uppercase a selection, press Control+U then U.
To lowercase a selection, press Control+U then L.
and to reverse case in the selection (for when you have typed a whole line of code without checking your caps lock!), press Control+U then S.

Really useful but not well known.

If you are puzzled as to why inline translate in Magento is not saving a particular translation, this could be your issue.

Inline translate uses the table core_translation to store the translations.

The fields that store the data are set to VARCHAR(255) fields.

If your source string is longer than 255 characters, it will fail silently to save the translation.

The simplest solution is to shorten the source string and stick to using inline translate on strings that are shorter than 255 characters.

You could alternatively modify the table but we prefer not to do that kind of thing unless we really have to.

Another workaround for text sections that need to be long is to simply use a static block instead.