I made a promo code function, the member in the purchase of a certain item, how to give this coupon code to the member

I got a promo code generation function in the mall backstage, how do I go to specify this coupon code when adding a product, (note: A number of different coupon code, the same denomination), and then the member in the front desk to buy this product, how to release the coupon code, this I think half a day did not understand

Reply to discussion (solution)

Is it a coupon code or a coupon?
Since is the coupon code why need to issue? (Refer to Amazon mode) or I understand the mistake

When adding a product, randomly generate several coupon codes (several can be self-determined), and stored in the database, and the product to correspond well
At the front desk to give a button or something, the user click on the product ID to find a coupon code to the user
The coupon code must have the Status field, identify this coupon code is not received, has been picked, not used, has been used .... It depends on your own logic.

My coupon code and coupon here is a

Isn't there a promo code table?
Bind the membership ID on it.

I'm sorry, but I haven't been here recently.

