Tips and Tricks HQ Support

Support site for Tips and Tricks HQ premium products

  • Home
  • Contact Us
  • Documentation
  • Forum Home
    • Forum
    • Forum Search
    • Forum Login
    • Forum Registration

How to refund a sale

by

Tips and Tricks HQ Support Portal › Forums › WP eStore Forum › How to refund a sale

Tagged: Affiliate Commission, commission reversal, refund

  • This topic has 22 replies, 8 voices, and was last updated 11 years, 6 months ago by msdt.
Viewing 15 posts - 1 through 15 (of 23 total)
1 2 →
  • Author
    Posts
  • April 4, 2010 at 12:19 pm #1020
    derryck
    Member

    Hi all,

    Recently purchased the affiliate program plugin and eStore. Have been testing the plugins and both work well. However I can find a method to refund the sales, crediting paypal and retracting the affiliate commission. The changelog says that this functionality is possible. So how is it done?

    Derryck

    April 4, 2010 at 10:34 pm #19389
    MikeM
    Member

    I am wondering this myself. I checked off Use Automatic Customer Record Removal in the settings and then did a test refund from PayPal. It did remove that customer sale, but when going to Stats, it still shows the same amount of sales and money earned. It didn’t deduct the refunded sale from the stats or from the total sales amount, which I would have assumed it would do.

    Thanks.

    MikeM

    April 5, 2010 at 1:12 am #19390
    amin007
    Participant

    You simply issue a refund from your PayPal account (PayPal transactions can be refunded for up to 60 days).

    When you issue a refund PayPal will send a notification to WP eStore and the plugin will take care of the rest (e.g. reversing the commission).

    @MikeM, You just need an updated version of the plugin where I have done some work around fixing the stats. This URL should explain how you can get an udpate:

    https://support.tipsandtricks-hq.com/forums/topic/how-and-when-do-you-get-an-update

    April 5, 2010 at 3:04 am #19391
    derryck
    Member

    Thanks very much for your prompt response. Was this information in the documentation some where? I looked for quite a while and could not find anything on refunds apart from the comment in the changelog. If there is something in the doco, perhaps a link here will help someone in the future.

    Derryck

    April 5, 2010 at 3:17 am #19392
    MikeM
    Member

    Thanks. I have sent in a request for update plugins as you indicated.

    MikeM

    April 5, 2010 at 8:03 am #19393
    Ivy
    Member

    Hi Mike, I sent you an email with your update. Please let me know if you do not receive this email.

    Cheers,

    Ivy

    April 5, 2010 at 12:54 pm #19394
    MikeM
    Member

    Thanks Ivy. I got it this morning.

    MikeM

    April 6, 2010 at 12:02 am #19395
    Ivy
    Member

    Hi Mike, Please let me know if this does not fix the issue. Remember to deactivate before you install the update. =)

    Cheers,

    Ivy

    April 6, 2010 at 1:45 am #19396
    MikeM
    Member

    OK, in testing a sale and a refund of a product set at 0.01 cents. With the new version, in the stats it still shows number of item sales which includes the refunded purchase. So I made 7 sales and refunded 1, it still shows 7 instead of 6.

    It does show the refund and did deduct the 0.01 cents from the total sales amount, so that is correct. And in the itemized sales stats, it still shows the sale, even though it was refunded.

    So I don’t know if this is how you set it up to work or not, but it seems to me it should deduct the total number of sales by however many refunds were issued to reflect the true sales.

    Thanks.

    MikeM

    April 6, 2010 at 7:41 am #19397
    amin007
    Participant

    The stats should work correctly after the update.. I will have to take a look at your system… will send you an email.

    August 27, 2010 at 6:23 pm #19398
    Michael DeLuca
    Participant

    Hi Ivy, Amin,

    I just upgraded to eStore version 4.0.8 and I think I am experiencing the same problem as these people above. I ran three test transactions today, then refunded all three of them through paypal. The stats page for today shows the following:

    Total Number of Products : 71

    Total Number of Coupons : 1

    Number of Item Sales : 3

    Total Sales Amount : 12.97 USD

    Number of Refunds : 1

    Total Refund Amount : -2.99 USD

    Net Sales Amount : 9.98 USD

    It only seems to have registered one out of the three refunds.

    August 27, 2010 at 6:41 pm #19399
    Michael DeLuca
    Participant

    A related issue: I notice, looking through the sales table in the database, that there’s a discrepancy every time an order is refunded for which PayPal has been set up to charge state-based sales tax. For example, if somebody in the same state as us (we’re in MA) orders a $6.00 ebook, our PayPal acct automatically charges them 6.25% state sales tax, for a total of $6.38. Then, when we refund that order, the refund quantity that shows up in the sales table is $6.38 rather than $6.00. Which means that the Stats page is going to show a net loss on that transaction of $0.38, though in reality we actually did get that 38 cents from the customer–it just happened after the plugin sent the order off.

    Sorry! I realize this is probably going to be a pain to fix.

    August 28, 2010 at 1:39 am #19400
    amin007
    Participant

    Don’t run the stat for one day as the time period when the day rolls over is based on server time and not your PC time. Always take a bigger sample for example (last 3 days or this month) and you will get more accurate result.

    It uses the Gross amount that PayPal sends. When you received the payment you would have received $6.38 from the customer (including tax) so the stat should have recorded $6.38 given that’s the amount PayPal sent in the payment notification. Can you run a test under debug and then forward me the IPN values so I can see what data PayPal is sending when used with state based tax?

    August 28, 2010 at 1:36 pm #19401
    Michael DeLuca
    Participant

    Ok–I sent you that info via email just now. Thanks!

    August 28, 2010 at 2:31 pm #19402
    Michael DeLuca
    Participant

    About the way refunds are recorded:

    I’ve looked through the whole database sales table, so I know that some refunds are not being taken into account. I also notice that when a refund does get recorded, there is no product ID associated with it, which means there’s no way to directly connect a refund with the associated sale. For example, here’s a test purchase I made yesterday and the refund, as the data is represented in the sales table:

    cust_email date time item_id sale_price

    michaeljdeluca@gmail 2010-08-27 15:21:51 54 2.99

    michaeljdeluca@gmail 2010-08-27 15:28:45 -2.99

    It would be a huge help to us if the refund info could include the product ID or some other way to tell what sale it belongs to. We’re selling ebooks for a number of different small press publishers, and we need to calculate quarterly royalty totals based on how many of each product we sold for how much in a specified period. I wrote a royalty report script that does this, but as of now there is no way to account for refunds.

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 23 total)
1 2 →
  • You must be logged in to reply to this topic.
Log In

Forum Related

  • Forum Home
  • Forum Search
  • Forum Registration
  • Forum Login

Support Related Forms

  • Contact Us
  • Customer Support
  • Request a Plugin Update
  • Request Fresh Download Links

Useful Links

  • Plugin Upgrade Instructions
  • WP eStore Documentation
  • WP eMember Documentation
  • WP Affiliate Platform Documentation
  • Tips and Tricks HQ Home Page
  • Our Projects

Quick Setup Video Tutorials

  • WP eStore Video Tutorial
  • WP eMember Video Tutorial
  • WP Affiliate Platform Video Tutorial
  • Lightbox Ultimate Video Tutorial

Our Other Plugins

  • WP Express Checkout
  • Stripe Payments Plugin
  • Simple Shopping Cart Plugin
  • Simple Download Monitor

Copyright © 2025 | Tips and Tricks HQ