Magento SQL Snippets

Clear Temporary Data Tables TRUNCATE `log_customer`; TRUNCATE `log_quote`; TRUNCATE `log_summary`; TRUNCATE `log_url`; TRUNCATE `log_url_info`; TRUNCATE `log_visitor`; TRUNCATE `log_visitor_info`; TRUNCATE `index_event`; TRUNCATE `report_event`; TRUNCATE `report_viewed_product_index`; TRUNCATE `dataflow_batch_import`; TRUNCATE `dataflow_batch_export`; TRUNCATE `sendfriend_log`; ALTER TABLE `log_url` AUTO_INCREMENT=1; ALTER TABLE `log_url_info` AUTO_INCREMENT=1; ALTER TABLE `log_visitor` AUTO_INCREMENT=1; ALTER TABLE `log_visitor_info` AUTO_INCREMENT=1; ALTER TABLE `report_event` AUTO_INCREMENT=1; ALTER TABLE `report_viewed_product_index` AUTO_INCREMENT=1; ALTER…

How do I disable Magento Compiler?

Last update: 2013-01-20 Magento Compiler feature should be disabled on any changes in loaded Magento classes, in other words, you need to disable Magento Compilation every time before installing new extension or initiating upgrade/downgrade/installation or removal of any Magento module.   To disable Magento Compiler you can use one of the following methods:   Admin Interface navigate to System >…

How to get current currency in Magento

We know Magento support multiple currency. I have found the solution to check current currency in the Magento site frontend To get Current Currency < ?php echo $currency_code = Mage::app()->getStore()->getCurrentCurrencyCode(); ?> If you looking for current currency symbol use : < ?php echo Mage::app()->getLocale()->currency(Mage::app()->getStore()->getCurrentCurrencyCode())->getSymbol(); ?>

Inline translation in Magento

If you need translations for your site but translation packs are not fully translated, then inline translation is very nice feature. In this post I will cover entire process for inline translation in Magento. So I assume that you already instaled your language packs, and that you created diferent store views for diferent languages. Next…

The 7 Best Free FTP Apps for Your Mac

FTP, or File Transfer Protocol, is the standard way of transferring files between your computer and your server, whether it be shared or dedicated. One of the nice things about FTP is the fact that you can view and edit the entire file structure of your website or file server remotely, without ever touching your server. In order…