My users have a e-wallet, it can be credited via payment gateway and the transactions can be done through, that money can be credited and debited.
But I am stuck at a issue, I wanted to add some promotional money into the wallet but I also want that the money shall expire automatically after a fixed period of time.
So I have a field called user wallet and each user has his own wallet field which is numeric in value. The transactions are stored in a different database which is pulled up and shown in the wallet transaction history page.
Now as a company I want to add $10 as a promotional offer into the users wallet and also wanted to expire in 2 days so how can I achieve that ? because till now I had been simply using the workflow, if the user places in order then simply deduct the amount from that wallet field.