The functionality doesn't exist in a standard cart, but it's certainly not difficult build new 'audience lists'. It's just a matter of adding new rows to the query_builder table in the database: the tricky bit is getting the select query right.
For example, if you want a new list that selects customers who have ordered something from the store, without time limits, you could use this query:
Code:
select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o WHERE c.customers_id = o.customers_id and o.orders_id > 0 GROUP BY c.customers_email_address order by c.customers_lastname, c.customers_firstname ASC
If you want a query to add that to the database with all the other fields, you could run this from Admin > Tools > Install SQL Patches:
Code:
INSERT INTO query_builder (`query_id`, `query_category`, `query_name`, `query_description`, `query_string`, `query_keys_list`) VALUES ('', 'email,newsletters', 'All customers who have purchased', 'All customers who have ever purchased anything, ignoring newsletter-subscription status.', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o WHERE c.customers_id = o.customers_id AND o.orders_id > 0 GROUP BY c.customers_email_address ORDER by c.customers_lastname, c.customers_firstname ASC', '');
Want one for customers who purchased product #103? here it is:
Code:
INSERT INTO query_builder (`query_id`, `query_category`, `query_name`, `query_description`, `query_string`, `query_keys_list`) VALUES ('', 'email,newsletters', 'All customers who have purchased product #103', 'All customers who have ever purchased product #103, ignoring newsletter-subscription status.', 'select c.customers_email_address, c.customers_lastname, c.customers_firstname from TABLE_CUSTOMERS c, TABLE_ORDERS o, TABLE_ORDERS_PRODUCTS op WHERE c.customers_id = o.customers_id AND o.customers_id = c.customers_id AND o.orders_id = op.orders_id AND op.products_id = 103 GROUP BY c.customers_email_address ORDER by c.customers_lastname, c.customers_firstname ASC', '');
The possibilities are only limited by your ability with sql queries
EDIT: by the way, the term 'active customer' in the drop-down box for the audience list means a customer who has purchased something...
Bookmarks