April 4, 2010 at 12:19 pm #1020derryckMember
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?
DerryckApril 4, 2010 at 10:34 pm #19389
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.
MikeMApril 5, 2010 at 1:12 am #19390
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:April 5, 2010 at 3:04 am #19391derryckMember
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.
DerryckApril 5, 2010 at 3:17 am #19392
Thanks. I have sent in a request for update plugins as you indicated.
MikeMApril 5, 2010 at 8:03 am #19393IvyMember
Hi Mike, I sent you an email with your update. Please let me know if you do not receive this email.
IvyApril 5, 2010 at 12:54 pm #19394
Thanks Ivy. I got it this morning.
MikeMApril 6, 2010 at 12:02 am #19395IvyMember
Hi Mike, Please let me know if this does not fix the issue. Remember to deactivate before you install the update.
IvyApril 6, 2010 at 1:45 am #19396
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.
MikeMApril 6, 2010 at 7:41 am #19397
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
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
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
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
Ok–I sent you that info via email just now. Thanks!August 28, 2010 at 2:31 pm #19402
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.
- You must be logged in to reply to this topic.