Magento XML explanation

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


http://alanstorm.com/magento_dispatch_admin_cms_default_routers

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

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

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' )

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

Sales Order Grid Customization

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