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 10 years, 11 months ago by msdt.
-
AuthorPosts
-
April 4, 2010 at 12:19 pm #1020derryckMember
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 #19389MikeMMemberI 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 #19390amin007ParticipantYou 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 #19391derryckMemberThanks 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 #19392MikeMMemberThanks. I have sent in a request for update plugins as you indicated.
MikeM
April 5, 2010 at 8:03 am #19393IvyMemberHi 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 #19394MikeMMemberThanks Ivy. I got it this morning.
MikeM
April 6, 2010 at 12:02 am #19395IvyMemberHi 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 #19396MikeMMemberOK, 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 #19397amin007ParticipantThe 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 #19398Michael DeLucaParticipantHi 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 #19399Michael DeLucaParticipantA 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 #19400amin007ParticipantDon’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 #19401Michael DeLucaParticipantOk–I sent you that info via email just now. Thanks!
August 28, 2010 at 2:31 pm #19402Michael DeLucaParticipantAbout 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.
-
AuthorPosts
- You must be logged in to reply to this topic.