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