I would like to create a database that is associated with the users of my website. The database will be filled with a fixed coupon code that only paid plan members can use on the store. Each paid plan members have his own code and this code works only 3 time a month.
this code will be displayed in the user account with the value 000000 if the member is just a regular member and with the value of the field user coupon if the member is a paid plan customer.
Can somebody help me ?