When testing new features locally on your development machine, it is advisable to change the customers’ email addresses. You can use the following script for this purpose: Warning: Never execute these statements on a production system!
|
1 2 3 4 |
update sales_flat_quote set customer_email = (concat(substring(md5(rand()) from 1 for 20), '@example.com')); update sales_flat_order set customer_email = (concat(substring(md5(rand()) from 1 for 20), '@example.com')); update sales_flat_quote_address set email = (concat(substring(md5(rand()) from 1 for 20), '@example.com')); update customer_entity set email = (concat(substring(md5(rand()) from 1 for 20), '@example.com')); |
Now open an…