Friday 22 November 2013

#!/usr/bin/perl

# Configuration params
$backup_dir = '/home/username/public_html';
$file_prefix = 'doc_backup_';

# Get the timestamp for today
$date = `date "+%Y%m%d"`;
chomp($date);

chdir('/home/username/backup/doc_backup') ;

`tar -cv -f $file_prefix$date.tar $backup_dir`;

`bzip2 $file_prefix$date.tar`;

# Below line is used to remove the backups older than 5 days to free up the server space
system("find . -mtime +5 -type f -name 'doc_backup_*' -exec rm {} \\;");

Perl script for Database backup

#Configuration params
$host = 'localhost';
$user = 'username';
$pass = 'password';
$database = 'dbname';
$backup_dir = '/home/username/backup/db_backup';
$file_prefix = 'database_backup_';

# Get the timestamp for today
$date = `date "+%Y%m%d"`;
chomp($date);

`mysqldump --host=$host --user=$user --pass=$pass $database | bzip2 -c > $backup_dir/$file_prefix$database$date.sql.bz2`;

Friday 4 October 2013

How to use locks in PHP cron jobs to avoid cron overlaps

http://stackoverflow.com/questions/10552016/how-to-prevent-the-cron-job-execution-if-it-is-already-running

http://abhinavsingh.com/blog/2009/12/how-to-use-locks-in-php-cron-jobs-to-avoid-cron-overlaps/

Wednesday 25 September 2013

Using Dynamic Class names

http://stackoverflow.com/questions/1539530/is-it-possible-to-extend-a-class-dynamically

http://www.codingforums.com/showthread.php?t=100806

Increase number of emails to be sent via Nesletter

To increase the number emails to be sent for every 5 min:

In app/code/core/Mage/Adminhtml/controllers/Newsletter/QueueController.php

Change the

$countOfSubscritions = 20;

To

$countOfSubscritions = 100; // whatever number you want

Also in app/code/core/Mage/Newsletter/Model/Oberver.php

Change the

$countOfSubscritions = 20;

To

$countOfSubscritions = 100; // whatever number you want

Extend the core admin controller

Working example can be found at :

http://www.magentocommerce.com/boards/viewthread/25942/P15/#t348401

Tuesday 24 September 2013

PHP syntax checker online tool

http://www.piliapp.com/php-syntax-check/

http://phpcodechecker.com/

Creating Virtual Host on Mac

Restart Apache on Mac:
http://www.cyberciti.biz/faq/restart-apache2-mac-osx/
http://www.cyberciti.biz/faq/restarting-apache-under-oxs-commandline/

Creating a Virtual Host on Mac:
http://foundationphp.com/tutorials/vhosts_leopard.php

Subdomain Setup on Mac:
http://content.websitegear.com/article/subdomain_setup.htm

Sunday 22 September 2013

Get Default Magento store ID

$defaultStoreId = Mage::app()
    ->getWebsite(true)
    ->getDefaultGroup()
    ->getDefaultStoreId();

Thursday 19 September 2013

World wide Countries and States SQL

http://stevephillips.me/blog/mysql-dump-every-country-and-state-world

Improve Magento native search

Follow the tips at http://markustenghamn.com/improve-search-function-magento

Install the following free extension:
http://www.magentocommerce.com/magento-connect/enhanced-default-search-9697.html

Tuesday 17 September 2013

Magento Newsletter UnSubscribe Link

Script to get Unsubscribe link:

Mage::getModel('newsletter/subscriber')->loadByEmail($email)->getUnsubscriptionLink();

Code snippet to be used in email templates:
<a href="{{var subscriber.getUnsubscriptionLink()}}">{{var subscriber.getUnsubscriptionLink()}}</a>

Friday 13 September 2013

Why Does Magento Reindex?

http://www.magentocommerce.com/knowledge-base/entry/ce-18-indexing#overview-what-is

Tuesday 10 September 2013

How to Display the most recently added products first in magento

http://mydons.com/how-to-display-the-most-recently-added-products-first-in-magento-1-6-0-0/

Tuesday 3 September 2013

Magento Newsletter Integration

MailChimp:
http://www.magentocommerce.com/magento-connect/mage-monkey-mailchimp-integration-4865.html

Constant Contact:
http://www.magentocommerce.com/magento-connect/constant-contact.html
http://www.freelunchlabs.com/store/constant-contact-and-magento-sync.html

IContact:
http://www.magecoders.com/index.php/magento-extensions/icontact-sync.html
http://www.magentocommerce.com/magento-connect/icontact-sync-9752.html

Monday 2 September 2013

Get product URL without categpry and product ID

$product = Mage::getModel('catalog/product')->load($productId);
$url = Mage::getUrl($product->getUrlPath());

Integrating Onstagram with Magento

Instagram API:
http://instagram.com/developer/authentication/#

Free Extension:
http://magento.ikantam.com/store/free-instagram-magento-extension.html

Installation Guide:
http://magento.ikantam.com/store/media/catalog/product/pdf/Instagram_Extension.pdf

Extension on Magento Connect:
http://www.magentocommerce.com/magento-connect/instagram-extension-2508.html

Paid Extension:
http://www.magazento.com/english/magento-ext/magazento-extensions/instastream-instagram-integration

Friday 30 August 2013

Magento XML explanation

http://wiki.clearandfizzy.com/Technical_Articles:Magento/XMLFiles/Extension/etc/config.xml

http://alanstorm.com/magento_dispatch_admin_cms_default_routers

Tuesday 27 August 2013

How to allow certain tags (iframe, embed) in Magento's CMS editor?

http://stackoverflow.com/questions/5163518/magento-how-to-allow-certain-tags-iframe-embed-in-magentos-cms-editor

CyberSource Payment Gateway Field validations and Guides

Field Validation

http://support.cybersource.com/cybskb/index?page=content&id=C1251

Notification

As part of its commitment to maintain industry-leading security and data integrity, CyberSource will be implementing additional front-end validation of transaction data entering it's Systems, starting on January 22nd, 2013.

As part of this effort, CyberSource will start performing additional validation on certain API field values coming into the Production environment across all connection methods, including several fields in the following groups:

Customer Information and Address Fields

Order Tracking Fields

After extensive testing versus past production transaction data, we are confident that these changes will be transparent to the vast majority of our customer base. However, if you do see any perceived changes in data validation-related declines, please feel free to contact CyberSource Customer Support for further assistance in troubleshooting said transactions.

Cyber Source Simple Order SDK Tool Kit:

http://www.cybersource.com/developers/develop/integration_methods/simple_order_and_soap_toolkit_api/

Documentation on fields:

http://apps.cybersource.com/library/documentation/dev_guides/CC_Svcs_SO_API/html/wwhelp/wwhimpl/js/html/wwhelp.htm#href=app_fields_SO_ENT.10.2.html

Development Guides:

http://apps.cybersource.com/library/documentation/dev_guides/Getting_Started_SO/Getting_Started_SO_API.pdf

http://apps.cybersource.com/library/documentation/dev_guides/Simple_Order_API_Clients/Client_SDK_SO_API.pdf

Monday 26 August 2013

WorldPay payment gateway test account

It has no test account however you can use the LIVE in test mode for testing
http://www.ukbusinessforums.co.uk/forums/showthread.php?t=211474

Magento Extension:
http://www.magentocommerce.com/magento-connect/worldpay-extension.html

Support - Forum:
http://www.magentocommerce.com/boards/viewthread/10803/P150/

Guides:
http://www.worldpay.com/support/kb/bg/pdf/tgl.pdf
http://www.worldpay.com/support/kb/bg/testandgolive/tgl.html

Tuesday 20 August 2013

SSH using .pem

http://blog.linuxacademy.com/linux/connect-to-amazon-ec2-using-putty-private-key-on-windows/

Search the date range between two dates SQL

CREATE TABLE `product_sales` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`From_date` date NOT NULL,
`To_date` date NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ;

--
-- Dumping data for table `Product_sales`
--

INSERT INTO `Product_sales` (`id`, `name`, `From_date`, `To_date`) VALUES
(1, 'Product 1', '2013-08-20', '2013-08-30'),
(2, 'Product 2', '2013-08-14', '2013-08-27'),
(3, 'Product 3', '2013-08-25', '2013-08-31'),
(4, 'Product 4', '2013-08-10', '2013-08-22'),
(5, 'Product 4', '2013-08-24', '2013-08-28'),
(6, 'Product 4', '2013-08-23', '2013-08-30');

QUERY:
SELECT * FROM Product_sales WHERE ( From_date >= '2013-08-19' AND To_date <= '2013-08-23' ) OR ( To_date >= '2013-08-19' AND From_date <= '2013-08-23' )

Tuesday 13 August 2013

Magento Extensions for Grid manager or extending

https://github.com/magento-hackathon

Adding order attribute to the orders grid in Magento 1.4.1
http://www.ecomdev.org/2010/07/27/adding-order-attribute-to-orders-grid-in-magento-1-4-1.html

How to extend Magento Order Grid?
http://inchoo.net/ecommerce/magento/how-to-extend-magento-order-grid/

The proper way to add columns to Sales Order Grid in Magento 1.7
http://stackoverflow.com/questions/15172137/the-proper-way-to-add-columns-to-sales-order-grid-in-magento-1-7

Grid Manager
http://ecommerce.aheadworks.com/magento-extensions/grid-manager.html
http://www.magentocommerce.com/magento-connect/grid-manager.html

Wednesday 7 August 2013

Sales Order Grid Customization

http://www.excellencemagentoblog.com/magento-sales-order-grid

Tuesday 30 July 2013

Remove index.php from Magento admin URL

http://www.bestdesigns.co.in/blog/remove-index-php-url-magento

http://www.magentocommerce.com/magento-connect/clockworkgeek/extension/3692/clockworkgeek_adminrewrites

Change admin URL and Path:
https://www.properhost.com/members/knowledgebase.php?action=displayarticle&id=15

Custom Router in Magento:
http://inchoo.net/ecommerce/magento/custom-router-in-magento/

Get Magento admin custom URL:

Mage::getConfig()->getNode('admin/routers/adminhtml/args/frontName');

Get Router, Module, Controller and Action names:
http://blog.chapagain.com.np/magento-how-to-get-controller-action-and-module-name-in-template-file/

Thursday 25 July 2013

Gmail: Bad Authentication error with the application

Solution is here:
https://support.google.com/mail/answer/14257?p=client_login&rd=1

Thursday 18 July 2013

Add custom field / attribute to Google Calendar Event using API

An extended property is an arbitrary name/value pair that can be added to an event and retrieved via the API. It is not accessible from the calendar web interface.

https://developers.google.com/gdata/docs/2.0/elements?hl=fr#gdExtendedProperty

Friday 12 July 2013

How to optimize the ReIndexing process in Magento

http://www.magentocommerce.com/magento-connect/dn-d-patch-index-url-1364.html

Tuesday 9 July 2013

Magento Extension conflict Checker

http://magebase.com/magento-tutorials/magento-extension-clashes-winners-and-loosers/

http://docs.google.com/a/oztek.in/viewer?a=v&pid=sites&srcid=d2Vic2hvcGFwcHMuY29tfHdlYnNob3BhcHBzLXdpa2l8Z3g6NzdkMTk5OGFkNmNkNzY1ZA

Monday 8 July 2013

Using FTP commands on Linux

http://linux.about.com/od/commands/a/blcmdl1_ftpx.htm

http://linux.about.com/od/commands/l/blcmdl1_ftp.htm

Friday 5 July 2013

Adding new / update / delete category attribute in Magento

<?php
/** @var $this Mage_Eav_Model_Entity_Setup */
$this->startSetup();

/** Remove existing atribute */
$this->removeAttribute('catalog_category', 'size_chart');

/** Add new atribute */
$this->addAttribute('catalog_category', 'short_description', array(
    'group'         => 'General Information',
    'input'         => 'textarea',
    'type'          => 'text',
    'label'         => 'Short Description',
    //'source'        => 'categoryattributes/source_sizechart',
    'backend'       => '',
    'visible'       => 1,
    'required'      => 0,
    'user_defined'     => 1,
    'note'             => 'Category Short Description will be shown in bottom 3 boxes of other category pages',
    'global'        => Mage_Catalog_Model_Resource_Eav_Attribute::SCOPE_GLOBAL,
));
/** Update existing atribute */
$categoryEntityTypeId = $this->getEntityTypeId('catalog_category');
$this->updateAttribute($categoryEntityTypeId, 'short_description', 'is_wysiwyg_enabled', 0);
$this->updateAttribute($categoryEntityTypeId, 'short_description', 'is_html_allowed_on_front', 0);

$this->endSetup();

?>
http://www.atwix.com/magento/add-category-attribute/

Thursday 4 July 2013

Check Module existance in Magento

Following snippet can determine wether the module installed and it is active:

$modules = (array)Mage::getConfig()->getNode('modules')->children();
if (isset($modules['Company_Module']) && $modules['Company_Module']->is('active')) {
// Do something
}

Installing APC Cache and setting up in Magento

http://www.euperia.com/website-performance-2/how-to-add-apc-cache-to-magento/799

http://magento2x.com/apc-configuration-for-magento/

http://www.aitoc.com/en/blog/apc_speeds_up_Magento.html

http://www.magentocommerce.com/boards/viewthread/8937/P45/
http://www.designguru.org/blog/120810/how-install-apc-media-temples-gridserver-accounts

Saturday 29 June 2013

Wednesday 26 June 2013

Fast Asynchronous Re-indexing and Caching

Fast Asynchronous Re-indexing

http://mirasvit.com/magento-extensions/magento-asynchronous-reindex.html

Asynchronous Cache

http://mirasvit.com/magento-extensions/magento-asynchronous-cache.html

Tuesday 25 June 2013

Magento Dataflow - Optimized Product Import

http://blog.baobaz.com/en/blog/magento-dataflow-optimized-product-import-part-3

Pointers to get started with Magento

Below are the pointers to get started with Magento

System Requirements

http://www.magentocommerce.com/system-requirements

Folder Structure

http://www.magentocommerce.com/wiki/2_-_magento_concepts_and_architecture/magento-folder-structure

Technical Documentation

http://docs.magentocommerce.com/

Knowledge Base

http://www.magentocommerce.com/knowledge-base
This will have following:

Knowledge Base Home
Installation & Configuration
Build Your Store Manage Your Store
Expand Your Store
Themes and Design Development
Magento Connect

User Guides

http://www.magentocommerce.com/resources/magento-user-guide

Magento API

http://www.magentocommerce.com/api/soap/introduction.html

Monday 24 June 2013

Adding custom product attribute to quote and order items in Magento

http://www.atwix.com/magento/custom-product-attribute-quote-order-item/

Saturday 22 June 2013

Working with Google Calendar events

https://developers.google.com/google-apps/calendar/v1/developers_guide_php

http://framework.zend.com/manual/1.12/en/zend.gdata.calendar.html

Wednesday 19 June 2013

Generate BarCodes with PHP, ZEND and Magento

Zend Framework:
http://framework.zend.com/manual/1.12/en/zend.barcode.creation.html

It seems very easy to generate bar codes using Zend framework

PHP:
http://davidscotttufts.com/2009/03/31/how-to-create-barcodes-in-php/
http://www.barcodephp.com/en/download

How UPC Bar Codes Work:
http://electronics.howstuffworks.com/gadgets/high-tech-gadgets/upc.htm

Tuesday 18 June 2013

Error fetching http headers in SoapClient

http://stackoverflow.com/questions/4824799/soapfault-exception-http-error-fetching-http-headers

http://php.blogaboutwhatever.com/2011/11/error-fetching-http-headers/

http://stackoverflow.com/questions/9403486/error-fetching-http-headers-in-soapclient

Friday 3 May 2013

Download files from server using command line and PSCP in Windows

1)        Download pscp.exe
2)        Run >> CMD >> cd program files[location of pscp.exe]
3)        pscp -r username@HOSTIPADDRESS:/var/www/vhosts/abc.com/httpdocs/ C:\backupfiles\httpdocs\
4)        http://www.linuxquestions.org/questions/linux-newbie-8/scp-copy-file-from-remote-linux-server-onto-a-windows-machine-316263/

Wednesday 17 April 2013

Log Clearing Script Magento

<?php
$xml = simplexml_load_file('./app/etc/local.xml', NULL, LIBXML_NOCDATA);

$db['host'] = $xml->global->resources->default_setup->connection->host;
$db['name'] = $xml->global->resources->default_setup->connection->dbname;
$db['user'] = $xml->global->resources->default_setup->connection->username;
$db['pass'] = $xml->global->resources->default_setup->connection->password;
$db['pref'] = $xml->global->resources->db->table_prefix;

if($_GET['clean'] == 'log') clean_log_tables();
if($_GET['clean'] == 'var') clean_var_directory();

function clean_log_tables() {
 global $db;
 
 $tables = array(
  'dataflow_batch_export',
  'dataflow_batch_import',
  'log_customer',
  'log_quote',
  'log_summary',
  'log_summary_type',
  'log_url',
  'log_url_info',
  'log_visitor',
  'log_visitor_info',
  'log_visitor_online',
  'index_event',
  'report_event',
  'report_compared_product_index',
  'report_viewed_product_index',
  'catalog_compare_item',
  'catalogindex_aggregation',
  'catalogindex_aggregation_tag',
  'catalogindex_aggregation_to_tag'
 );
 
 mysql_connect($db['host'], $db['user'], $db['pass']) or die(mysql_error());
 mysql_select_db($db['name']) or die(mysql_error());
 
 foreach($tables as $v => $k) {
  @mysql_query('TRUNCATE `'.$db['pref'].$k.'`');
 }
}

function clean_var_directory() {
 $dirs = array(
  'downloader/.cache/*',
  'downloader/pearlib/cache/*',
  'downloader/pearlib/download/*',
  'var/cache/',
  'var/locks/',
  'var/log/',
  'var/report/',
  'var/session/',
  'var/tmp/'
 );
 
 foreach($dirs as $v => $k) {
  exec('rm -rf '.$k);
 }
}

Sunday 14 April 2013

Magento Module Creator

http://www.silksoftware.com/magento-module-creator/#.UWsLS0pnOho
http://www.techflirt.com/how-to-createn-custom-magento-module-step-by-step-tutorial/
https://github.com/shell/Magento-Module-Creator

Magento send emails using SMTP

In order to allow magento to use SMTP instead of the usual mail function, you need to take the below steps.
- Login to magento admin and go to. System->Configuration->Advanced->System->Mail Sending Settings
- Now here set the host value to your smtp host name like
mail.domain.com

- And then the default port is 25.
- Now you need to change magento file. Do not edit the core file as you will loose your change in an upgrade.
- So copy this file app/code/core/Mage/core/Model/Email/Template.php in to your local, by creating the same folder structure.
- Enable that module.
- Then in Template.php you will have to change the getMail() function as below.

public function getMail()
{
if (is_null($this->_mail)) {
/* changes begin */
$my_smtp_host = Mage::getStoreConfig('system/smtp/host');
$my_smtp_port = Mage::getStoreConfig('system/smtp/port');
$config = array(
'port' => $my_smtp_port,
'auth' => 'login',
'username' => 'email@domain.com',
'password' => 'yourpassword'
);
$transport = new Zend_Mail_Transport_Smtp($my_smtp_host, $config);
Zend_Mail::setDefaultTransport($transport);
/* Changes End */
$this->_mail = new Zend_Mail('utf-8');
}
return $this->_mail;
}

- After this clear your cache.
- Now magento will be able to send emails for you.

Magento Free extension to find the conflicts

http://wiki.webshopapps.com/the-faq/extension-conflicts

Friday 12 April 2013

Very helpful extension for development

http://www.mgt-commerce.com/magento-developer-toolbar.html

Thursday 11 April 2013

Magento Community Edition (CE) 1.8 and Enterprise Edition (EE) 1.13 Released

Highlights

Major overhaul of tax calculation formulas, correction of rounding errors, and additional assistance with configuration
Most indexing processes now run only to update products, categories, URL redirects, and so on that have changed—eliminating the need for manual full reindexing
Additional option of using Redis NoSQL for cache and session storage in multi-host deployments (recommended for new deployments)
Full page caching now invalidates only pages that are affected by product or category changes
Optimized cache adapters for single-server systems
Elimination of many types of database deadlocks

http://www.magentocommerce.com/knowledge-base/entry/ce-18-and-ee-113-documentation-home

Tuesday 9 April 2013

AddThis Sharing Magento Extension

http://www.magentocommerce.com/magento-connect/addthis-sharingtool-6043.html

Friday 5 April 2013

Disable Author pages in Wordpress

Open your theme’s functions.php and put this in:

/* Kill attachment, search, author, daily archive pages */
add_action('template_redirect', 'bwp_template_redirect');
function bwp_template_redirect()
{
 global $wp_query, $post;

 if (is_author() || is_attachment() || is_day() || is_search())
 {
  $wp_query->set_404();
 }

 if (is_feed())
 {
  $author  = get_query_var('author_name');
  $attachment = get_query_var('attachment');
  $attachment = (empty($attachment)) ? get_query_var('attachment_id') : $attachment;
  $day  = get_query_var('day');
  $search  = get_query_var('s');

  if (!empty($author) || !empty($attachment) || !empty($day) || !empty($search))
  {
   $wp_query->set_404();
   $wp_query->is_feed = false;
  }
 }
}

The snippet above will effectively disable attachment pages, search page, author pages and daily archive pages. Automatically generated feeds for those pages will also be disabled.

You can find more conditional tags at: http://codex.wordpress.org/Conditional_Tags

Source: http://betterwp.net/wordpress-tips/disable-some-wordpress-pages/

Wednesday 3 April 2013

Track your PF amount online

http://epfoservices.in/epfo/member_balance/member_balance_office_select.php

Tuesday 19 March 2013

Database table fields type using PHP

Script to list all the field data types in specified database and create a CSV file then download the CSV file.

<?php
set_time_limit(0);
getUniqueFieldTypes('HOSTNAME','DATABASE USERNAME','PASSWORD','DATABASENAME');

function getUniqueFieldTypes($host,$user,$pass,$name,$tables = '*')
{

    $link = mysql_connect($host,$user,$pass) or die('Could not connect');
    mysql_select_db($name,$link);

    //Get all of the tables
    if($tables == '*')
    {
        $tables = array();
        $result = mysql_query('SHOW TABLES');
        while($row = mysql_fetch_row($result))
        {
            $tables[] = $row[0];
        }
    }
    else
    {
        $tables = is_array($tables) ? $tables : explode(',',$tables);
    }
    $dataTypes = array();
    //Cycle through
    foreach($tables as $table)
    {
        $result = mysql_query('SHOW FIELDS FROM '.$table);
        $num_fields = mysql_num_fields($result);

        while($row = mysql_fetch_row($result))
        {
            $dataTypes[$row[1]] = $row[1];
        }
        //sleep(1);
    }
    asort($dataTypes);

    $fp = fopen('fields.csv', 'w+');
    foreach($dataTypes as $dataType) {
        $values = array($dataType);
        fputcsv($fp, $values);
    }
   fclose($fp);
   $file = 'fields.csv';

    if (file_exists($file)) {
        header('Content-Description: File Transfer');
        header('Content-Type: application/octet-stream');
        header('Content-Disposition: attachment; filename='.basename($file));
        header('Content-Transfer-Encoding: binary');
        header('Expires: 0');
        header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
        header('Pragma: public');
        header('Content-Length: ' . filesize($file));
        ob_clean();
        flush();
        readfile($file);
        exit;
    }

}
?>
<html>
    <head>
        <title>Create CSV with list of field data types</title>
    </head>
</html>

Below are the list data types supported by MYSQL:
VARCHAR
TINYINT
TEXT
DATE
SMALLINT
MEDIUMINT
INT
BIGINT
FLOAT
DOUBLE
DECIMAL
DATETIME
TIMESTAMP
TIME
YEAR
CHAR
TINYBLOB
TINYTEXT
BLOB
MEDIUMBLOB
MEDIUMTEXT
LONGBLOB
LONGTEXT
ENUM
SET
BOOL
BINARY
VARBINARY

Pages

Search This Blog