Seiya Posted January 1, 2011 Share Posted January 1, 2011 (edited) Happy new year folks, I'm about to write a php script which will use the dailycronjob hook to email customers who have placed an order but not paid and eventually cancel their order and deactivate their account if they dont respond. The basic logic is below and I would really appreciate any advice on whether Im missing anything out. I would need to add a field to the tblcustomers table or create a new table to record whether the customer had been sent the offer email and then If order is older than 8 hours AND status of invoice = "unpaid" AND emailed_offer == false then Email customer with special offer and step by step instructions on how to pay emailed_offer = true log in system activity log EndIf If order is older than 48 hours AND status of invoice = "unpaid" AND emailed_offer == true then Cancel order Close customer account log in system activity log EndIf Thanks for any help Edited January 1, 2011 by Seiya 0 Quote Link to comment Share on other sites More sharing options...
othellotech Posted January 1, 2011 Share Posted January 1, 2011 >add a field to the tblcustomers add your own table rather than change one of the standard tables >Close customer account you dont want to *close* an account if they have (or will veer have) any other products - perhaps make it *inactive* would be better ? 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.