> The user buys and actually pays for the certificate like it was any > item in the store? Would I set it up as an item for sale like that?
Generally yes. You can create a function to generate them automatically if you want, but you'd have to ensure that it is only done if you're using some online gateway and can validate the payment before sending them the code. If the store is low-volume, manually generating codes usually works fine. > Then, what's the best process for the certificate receiver to redeem > their cert.? Use their email and a generated certificate code as info > they'd put in a form during the checkout process? I personally just use the code, since it's a 20-digit random code that's going to be pretty secure on its own. You don't want to use the email since many people purchase them to give as gifts and the person using the code may not know the email of the person that bought it originally. > Then keep a running > total on how much they have left on the cert? Yup. So in your table, I'd suggest keeping both the original amount as well as the current balance. You should also add information to your orders table to show the certificate code used so you can track it back to the purchaser. --- Mary Jo ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Create robust enterprise, web RIAs. Upgrade & integrate Adobe Coldfusion MX7 with Flex 2 http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265390 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
