Sharing my experience – 12th May 2015 1. Tools analyze the performance of websites: a. https://developers.google.com/speed/pagespeed/insights – This website helps you analyze the problems of your website, it also gives some suggestions and solutions to you, so that you can optimize your website. b. http://gtmetrix.com/ – This website helps you analyze the problems of your website, it also gives Full Article…
Search the Wiki
Viewing 181 to 190 of 233 items
Magento – Removing all products and log tables
You can use the following commands to remove all products and logs. SET FOREIGN_KEY_CHECKS = 0; TRUNCATE TABLE `catalog_product_bundle_price_index`; TRUNCATE TABLE `catalog_product_bundle_selection`; TRUNCATE TABLE `catalog_product_bundle_selection_price`; TRUNCATE TABLE `catalog_product_bundle_option_value`; TRUNCATE TABLE `catalog_product_bundle_option`; TRUNCATE TABLE `catalog_product_entity_datetime`; TRUNCATE TABLE `catalog_product_entity_decimal`; TRUNCATE TABLE `catalog_product_entity_gallery`; TRUNCATE TABLE `catalog_product_entity_group_price`; TRUNCATE TABLE `catalog_product_entity_int`; TRUNCATE TABLE `catalog_product_entity`; TRUNCATE TABLE `catalog_product_entity_media_gallery`; TRUNCATE TABLE Full Article…
Fix for Git error: “fatal: Unable to find remote helper for ‘http’”
This error is most commonly caused by Git being compiled without support for OpenSSL or Expatlibraries. The solution is to build Git yourself. It looks like not having (lib)curl-devel installed when you install git can cause this. If you install (lib)curl-devel, and then rebuild/install git, this should solve the problem: $ yum install curl-devel Step 1 – Install OpenSSL Full Article…
Removing products and categories from the database
Below queries will definitely delete products from database but still few tables have entries for e.g. catalog_product_flat_1, catalog_product_flat_2,etc. So its not wise to delete using below queries. Removing products and categories from the database These instructions have been copied from: http://www.magentocommerce.com/boards/viewreply/106786/ Truncate products This should remove all the products and their related records. TRUNCATE TABLE Full Article…
Beginning of SASS & SCSS
Installation: Step 1: Go to this site and download Ruby Installer http://rubyinstaller.org/downloads/ Step 2 : Open Terminal and execute these two line gem install sass gem install scss PHPStorm Intergration: Step 1: Go to File Watcher and create a Watcher Program : {RubyInstallFolder}/bin/scss.bat for .scss and {RubyInstallFolder}/bin/sass.bat Working Directory : The directory of the scss Full Article…
Optimize magento database by Cleaning log
Optimize Magento Database is one of a very important task of developer who maintain magento site. Let ‘s play around with the number relate to database size and performance because we need to know why we do cleaning magento database to get the best performance before we do it. For example you are running a magento Full Article…
How to check CMS block is active?
How to check CMS block is active? You can use the following command: Mage::getModel('cms/block')->load('static_block_identifier')->getIsActive()
How to disable email sending when programatically creating an order in Magento
Here is a little snippet of code that can come in handy if you are like me handling a task of programatically creating an order in Magento. My issue was that I had to disable emails beeing sent out to the customers, while at the same time leave the normal frontend process. Thus I could not Full Article…
Caching your GitHub, Gitlab password in Git
If you're cloning GitHub repositories using HTTPS, you can use a credential helper to tell Git to remember your GitHub username and password every time it talks to GitHub. If you clone GitHub repositories using SSH, then you authenticate using SSH keys instead of a username and password. For help setting up an SSH connection, see Generating SSH Full Article…
Removing all Magento orders
SET FOREIGN_KEY_CHECKS=0; ############################## # SALES RELATED TABLES ############################## TRUNCATE `sales_flat_creditmemo`; TRUNCATE `sales_flat_creditmemo_comment`; TRUNCATE `sales_flat_creditmemo_grid`; TRUNCATE `sales_flat_creditmemo_item`; TRUNCATE `sales_flat_invoice`; TRUNCATE `sales_flat_invoice_comment`; TRUNCATE `sales_flat_invoice_grid`; TRUNCATE `sales_flat_invoice_item`; TRUNCATE `sales_flat_order`; TRUNCATE `sales_flat_order_address`; TRUNCATE `sales_flat_order_grid`; TRUNCATE `sales_flat_order_item`; TRUNCATE `sales_flat_order_payment`; TRUNCATE `sales_flat_order_status_history`; TRUNCATE `sales_flat_quote`; TRUNCATE `sales_flat_quote_address`; TRUNCATE `sales_flat_quote_address_item`; TRUNCATE `sales_flat_quote_item`; TRUNCATE `sales_flat_quote_item_option`; TRUNCATE `sales_flat_quote_payment`; TRUNCATE `sales_flat_quote_shipping_rate`; TRUNCATE `sales_flat_shipment`; TRUNCATE `sales_flat_shipment_comment`; TRUNCATE Full Article…