Phoenix is amazing to modify

[burt]

Over in this thread, Steve mentioned the possibility of viewing a single customers Queue.

It took us a long time the other day to find a customer when he cancelled an order so we didn't send all the emails that were set up to be sent

I thought of a few ways to view a single customers queue, my first idea was to have it as part of the admin/customers.php page - a new "view" which showed that customers Queue. I started coding this to soon realise that I was duplicating a lot of code. Pointless to do so, so I move back to the admin/outgoing.php page to change the SQL to show only a selected customer;

From this:

Code: Select all

SELECT * FROM outgoing ORDER BY send_at

This shows all the scheduled emails.

To something like this:

Code: Select all

SELECT * FROM outgoing WHERE customer_id = 456 ORDER BY send_at

This shows the scheduled emails of Customer ID 456 only.

Pretty simple. I hardcoded it to get the concept working.

You all know my methods by now, and that is to try not to change core. Now I had the concept code working, I reverted my changes back to standard Phoenix. And now to find a way to do this without changing core code.

By utilising our Hooking system, I got this in place (WITH NO CORE CODE CHANGES);

A new button on admin/customers.php, looking like this;

queue_c.jpg

When clicked loads the standard admin/outgoing.php page with only that particular customers scheduled emails;

queue_o.jpg

You might also notice that on this page, in the bottom left is a "Reset" button (which only shows when looking at a particular customers list of Scheduled emails. This Reset button links back to admin/outgoing.php (which therefore shows the full list of Scheduled Emails).

We are the ONLY cart to have this amazing level of flexibility.

[14Steve14]

I know I have some weird ideas at times, but its good to see that a problem is so easy to rectify and make life easier for us store owners.

If you are not using this system then you should be. The emails do get a response. We are getting more feedback from customers on the service we offer after the order has been delivered. We are getting more product reviews, and more Trustpilot reviews. Even the recover carts used in combination with the existing recover carts mod is getting us results. The emails can be tailored to your specific business which is great and can include images. We set up a cron job and everything happens automatically once a day so nothing to stress over and no additional labour time to get emails sent. I cant thank Gary enough for this system.