[ic] In Stock Notification

[Bill Randle]

Doug,

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
interested.

	-Bill

On Jan 2,  2:49pm, Doug Alcorn wrote:
} Subject: Re: [ic] In Stock Notification
} "Thomas McAlees" <tmcalees@discgolfcentral.com> 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
} accurate?"
}
} 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:doug@lathi.net 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
} Interchange-users@lists.akopia.com
} http://lists.akopia.com/mailman/listinfo/interchange-users
}-- End of excerpt from Doug Alcorn