create DomU for Magento

Install Magento

Configure / customize Magento

Log in to Admin Panel
user: admin
pass: 123123

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

Magento Database structure

Download Magento Extension

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;


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 - PHP Documentation

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

sales_flat_order_item - order item

Links - Magento Design Terminologies - How do I set up Product Relations - Magento grouped products - Magento Page - My profile - download - Magento User Guide - sorting magento categories alphabetically