+ Reply to Thread
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: "Coupon Code" Plugin Improvement

  1. #1

    Lightbulb "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,

  2. #2
    Master
    Join Date
    Apr 2012
    Location
    Germany
    Posts
    421
    Hello Alexandre Ono,

    There are several possibilities to realize this.
    The easiest would be to modify something the Coupon Plugin, because the database table for this is partly already available.
    It would have "only" some modification and to be created a table in the admin panel.

    Another option would be to insert it into the transactions table. Admin panel -> Common -> Transactions.
    In my opinion this would be a better option. However it requires for this some modifications in the Flynax Classified script.

    Let me know which possibility you want to use and i try to help them.

    Best regards
    Steffen
    Last edited by Steffen Buschkemper; June 3, 2013 at 09:59 PM.

  3. #3
    Hi Steffen,
    Thanks for your attention.
    I don't know exactly the best solution for this implementation. I don't have experience with programming, but I will appreciate if you help me in this work.
    Best regards,
    Alexandre

  4. #4
    Master
    Join Date
    Apr 2012
    Location
    Germany
    Posts
    421
    Hallo Alexandre,

    I will test this and post a solution here.
    But I need a few more details.
    What kind of payment gateways do you use?
    It must be also made modifications there.

    Best regards
    Steffen

  5. #5
    Hello Steffen,
    Now I'm using PayPal, but in the near future I intend to use a Brazilian payment gateway (I have to do some customization for that).
    Once again, thank you for your help!
    Best regards,
    Alexandre

  6. #6
    Master
    Join Date
    Apr 2012
    Location
    Germany
    Posts
    421

    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 files2change.zip.
    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.

    Now you can see coupon code including discount in the transactions table. See picture...

    newtransaction.jpg

    transaction.png

    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
    Last edited by Steffen Buschkemper; June 5, 2013 at 04:08 AM.

  7. #7
    Hi Steffen!!!
    Thaks a lot!! Outstanding work!! Congratulation!

  8. #8
    Master
    Join Date
    Apr 2012
    Location
    Germany
    Posts
    421
    No problem.
    You're welcome!

    It was a good idea from you.
    This is also useful. Now we know - who has used what code.
    Last edited by Steffen Buschkemper; June 5, 2013 at 04:38 AM.

  9. #9
    Great Steffen! Thanks a lot, I'll install tonight and good idea from the beginning!

    //Morgan
    Free Advertising at Fyndklippet.se


  10. #10
    Junior Member
    Join Date
    Oct 2013
    Posts
    4
    I need a help. I'm using pagseguro plugin and I tried many things to get used coupon code with that gateway. Any idea how to link transaction with used coupon code?

    Thanks
    Fabio

+ Reply to Thread