Magento

Log in to Admin Panel
http://192.168.1.88/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

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

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
http://www.sonassi.com/knowledge-base/magento-kb/important-magento-security-update-zend-platform-vulnerability/

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

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

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

Do you like this page? Then support it. Please click the AD below and visit the sponsor. Thank you!


client = pub-6933618646234008
slot = 3731759448
width = 728
height = 90