[ic] In Stock Notification
Tue, 2 Jan 2001 12:28:04 -0800
Why not create a mv script that runs periodically via cron(1) that
scans the "notify_me" table looking for outstanding notifications
then for each item they are interested in, check the products/
inventory tables to see if there's a quantity > zero? This would
eliminate the dependence on the admin ui upload function and
would work no matter how the quantity info was updated.
I have some sample code that does something similar, if you're
On Jan 2, 2:49pm, Doug Alcorn wrote:
} Subject: Re: [ic] In Stock Notification
} "Thomas McAlees" <firstname.lastname@example.org> writes:
} > I've been working with the Construct demo and see that the In Stock
} > Notification successfully sends a confirmation email to someone
} > requesting the notification. Is there any code to actually do the
} > notification when the inventory is re-stocked?
} No. In fact, there isn't even any code to store the user's
} information for future reference. All it does is send the email then
} forget about you. I have written one implementation of this. It
} relies on a new table called "notify_me". When you upload a new
} inventory table through the admin ui, it sends out any notifications
} as necessary. It's not a perfect solution because of the dependance
} on the upload function to trigger the notifications. However, the
} real question is "how do you plan to keep the inventory levels in IC
} I'm not sure I actually have the code anymore. I need to take a look
} around and see if I can come up with a patch against a clean
} 'construct' demo.
} (__) Doug Alcorn (mailto:email@example.com http://www.lathi.net)
} oo / PGP 02B3 1E26 BCF2 9AAF 93F1 61D7 450C B264 3E63 D543
} |_/ If you're a capitalist and you have the best goods and they're
} free, you don't have to proselytize, you just have to wait.
} Interchange-users mailing list
}-- End of excerpt from Doug Alcorn