Gift Certificates and Coupons
Do know if anyone has done this. I'm about to and didn't want to reinvent the wheel.
In my mind, selling the gift certificates is easy. It's just another product. The hard part (semi hard part) is going to be keeping track of what is left on the gift certificate dollar wise.
I guess on checkout on the "thank you" page when you update the tables for the order you would need to update another Gift Cert table (either add or update) using the order ID code as the cerfiticate key.
Then you'd have to put a field on the check out form for a discount that evals the cert# to the cert table to see how much had be applied.
There seems to be many possabilities...I just want to make sure I'm thinking through all the scenerios.
PS. Same thing with coupons with the exception that there's no need to track the balance of the coupon; just that the coupon was valid and for what amount and what rule to apply.