[ic] Looking for a way to send a follow-up e-mail 7days after shipment

[mail]

On Wed, 2007-04-18 at 15:49 -0700, Eric Chamberlain wrote:
> I'm trying to figure out how to send a follow-up e-mail to customers a
> week or so after their order ships.  The text should be customized based
> on what items were in their order.  
> 
> Can anyone point me in the right direction?
> 
> --
> Eric Chamberlain
> 
> 
> 
> 
> _______________________________________________
> interchange-users mailing list
> interchange-users at icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users

Here is an idea...

maybe set up a cron for it?
as IC run a cron each day like the following
00 9 * * * /usr/local/interchange/bin/interchange
--runjobs=catalogname=jobs > /dev/null

then make a directory etc/jobs put a file in it like
etc/jobs/send-follow-up-email

Make a new field in your transactions table like "followupsent" then You
can put some IC code in that file to look up any orders that have been
shipped 7 days ago AND not marked as "followupsent" then have it send a
followup email, then mark the transaction "followupsent" field as true?

rick