"Coupon Code" Plugin Improvement
I would like to suggest some improvement in “Coupon Code” Plugin. I would like to visualize Who, When, How and How Much coupons are used. Something like that:
User / coupon code / plan / Discount / date
User A / 123456 / Silver / 10% / 05-02-2013
User B / 456125 / Gold / 20% / 10-05-2013
Thanks,
3 Attachment(s)
Coupon Code and Discount in Transactions table
Hallo Alexandre Ono and all who need this feature,
I have decided to insert this feature in the transactions table.
It makes more sense as a separate table.
This feature will show you used coupon code inclusive the discount of a transaction.
The discount is shown in brackets as A or P.
P = discount in percent
A = discount amount
Please note this feature will only work with installed coupon plugin!
Now here comes the solution.
Part 1
Login into the Admin Panel and go to Common -> Database
Paste the follow SQL query
Code:
Only registered members can view the code.
and press the button "Go".
Part 2
NOTICE: Please back up all files before change!
Download and extract the Attachment 536.
The folder structure in the zip file is the same as @ your ftp root.
You must only replace the files in the folders via ftp in their folder in the root directory.
Thats all. :rolleyes:
Now you can see coupon code including discount in the transactions table. See picture...
Attachment 533
Attachment 534
INFO! I modified only paypal and 2co payment gateway for this feature.
Every who wants this feature also for other paymant gateways report it here in this thread and i will help you.
Best regards
Steffen