Magento

create DomU for Magento
http://www.panticz.de/Xen_domU_Magento

Install Magento
http://www.panticz.de/install_magento

Configure / customize Magento
http://www.panticz.de/Magento-configuration

Log in to Admin Panel
http://www.example.com/magento/index.php/admin/
user: admin
pass: 123123

Templates
./app/design/frontend/default/default/template/catalog/product/view.phtml - product details

Magento Database structure
http://www.magereverse.com/

Download Magento Extension
http://freegento.com/ddl-magento-extension.php

Reindex data from command line or as cronjob
php -f /var/www/shell/indexer.php reindexall

View Magento encryption key
grep key ./app/etc/local.xml | cut -d"[" -f 3 | cut -d"]" -f 1

Update Magento package on commandline
./pear mage-setup
./pear update-channels
./pear upgrade --force magento-community/RicoNeitzel_VertNav

backup Magento
# backup filesystem (without product images)
tar -cjf magento.ftp.back.$(date -I).tar.bz2 --exclude=/var/www/magento/media/catalog/product/i/m/* /var/www/magento/
# backup database
mysqldump --password=magento --user=magento magento | bzip2 --best > magento.db.back.$(date -I).sql.bz2

change category order to alphabetic
sed -i "s|setOrder('position', 'ASC')|setOrder('name', 'ASC')|g" ./app/code/core/Mage/Catalog/Model/Resource/Eav/Mysql4/Category.php

reset admin password
echo "UPDATE admin_user SET password=MD5('123123') WHERE username='admin'" | mysql -u root -pterceS magento

Magento logs
tail -f /var/www/var/log/exception.log /var/www/var/log/system.log

Clear logs
TRUNCATE log_url;
TRUNCATE log_url_info;
TRUNCATE log_visitor;
TRUNCATE log_visitor_info;
TRUNCATE dataflow_batch_import;
TRUNCATE dataflow_batch_export;
TRUNCATE index_event;
TRUNCATE report_event;

Security
https://www.magereport.com/
http://www.sonassi.com/knowledge-base/magento-kb/important-magento-security-update-zend-platform-vulnerability/

Disable SSL support
1) Admin > System / Configuration > Web
2) Open the Secure settings.
3) Set Use Secure URLs in Frontend to No
4) Use Secure URLs in Admin to No
5) Clear the Cache from the admin

Documentation
http://docs.magentocommerce.com/ - PHP Documentation

Clear Magento cache from command line
rm -r /var/www/var/cache/*

Table
sales_flat_order_item - order item

Security check
https://www.magereport.com/scan/

Fix reindex error "General error: 1005 Can't create table `magento`.`catalog_category_flat_store_1`"
ALTER TABLE catalog_category_entity ENGINE=INNODB;
ALTER TABLE core_store ENGINE=INNODB;

Logrotate

# cat /etc/logrotate.d/magento
/var/www/html/var/log/*.log {
    daily
    missingok
    rotate 31
    size 100M
    compress
#    delaycompress
    notifempty
#	create 640 root adm
}

List applied patches
grep -F '|' /tmp/www.muenzen-ritter.de/app/etc/applied.patches.list|cut -f 2,1 -d'|'

Add Google reCAPTCHA to Magento
https://meetanshi.com/blog/add-google-recaptcha-to-magento/
https://developers.google.com/recaptcha/docs/display

Links
http://www.magentocommerce.com/design_guide/articles/magento-design-terminologies4 - Magento Design Terminologies
http://www.magentocommerce.com/knowledge-base/entry/how-do-i-set-up-product-relations - How do I set up Product Relations
http://www.vodahost.com/vodatalk/magento/39401-magento-grouped-products.html - Magento grouped products
http://www.magentocommerce.com/ - Magento Page
http://www.magentocommerce.com/boards/member/93863 - My profile
http://www.magentocommerce.com/download/noregister - download
http://www.mikesmullin.com/development/automatically-sorting-magento-catalog-categories-alphabetically-via-mysql/
http://www.magentocommerce.com/support/magento-user-guide-book - Magento User Guide
http://www.mikesmullin.com/development/automatically-sorting-magento-catalog-categories-alphabetically-via-mysql/ - sorting magento categories alphabetically