Delete all Orders

2 08 2010

Magento version 1.4.1.1
In Database,

SET FOREIGN_KEY_CHECKS = 1;
DELETE FROM sales_flat_order;
DELETE FROM sales_flat_quote;
DELETE FROM eav_entity_store;

Advertisements




Problems With Magento Installation

1 08 2010

Problem 1. Installing MCrypt on Mac
Mac OS X comes with pre-installed PHP which needs to be switched on and most likely updated to the latest version of PHP which is simple enough however installing MCrypt is a major pain. After spending 2 hours on this, I think the best thing to do is to use MAMP instead. Comes with Apache, PHP and MySQL.. SWEET!!!

Problem 2. Can’t log into admin
So Magento is installed on the localhost and now I can’t log into admin..

There are lots of workaround like changing the Varien.php file if you google this however they didn’t work for me so..

Please uninstall and make sure you reinstall Magento on http://127.0.0.1 instead of http://localhost/





How to edit email templates

1 08 2010

1. Create new template in System -> Transactional Emails -> [Add New Template]
2. Select [Template] to edit
3. [Template Name]: Unique name to identify template
4. [Template Subject]: The subject of the email

Variables for Subject:
Customer Name: {{var customer.name}}
Order No.: {{var order.increment_id}}
Store Name: {{var store.getFrontendName()}}
Shipping No.: {{var shipment.increment_id}}

5. [Template Content]: Easier to grab existing template to modify in (app/locale/en_US/template/email)
6. [Save]

7. Change Customer Email in System->Customer Configuration
8. Change Orders/Shipping Email in System->Sales Emails