Forum Replies Created
-
Posts
-
Hi Amin, Ivy, I’m having this problem as well–no product links appearing on the Return URL page. My Thank You page is here:
[http://weightlessbooks.com/thank-you/]
I have run two test orders today, and in both cases the links were in the email, but not on the Thank You page. I do have the shortcode
[wp_eStore_display_transaction_result]
on the page in WordPress, but it doesn’t appear when I visit the page after a sale–the place where it should be is just blank. There doesn’t seem to be any POST data getting sent with the URL. Auto Return is set to OFF in my paypal settings. “Use Automatic Post Payment Processing” and “Enable Transaction Result Display” are both checked on my Settings page. And ipn_handle_debug.log shows all SUCCESSes.
I guess I’m confused by the directions on this page:
WP eStore – Instant Digital Product Delivery on A Thank You Page
It says I should enable the PDT feature in my paypal profile, and it links me to some paypal instructions which tell me I should have Auto Return and Payment Data Transfer turned ON. But then above, if I’m reading it correctly, you’re saying Auto Return should be off?
Maybe this thread is outdated and I’m just confusing myself. If so, sorry to waste your time!
Ok, I just verified this with another test order. PayPal charged me correctly. The ipn_handle_debug log also shows the correct prices for both this new order and the one I mentioned above.
So (I think) it’s only the database eStore_sales_tbl, the Manage Customers page and the Stats page that show the wrong prices.
Excellent question. I will check on that and get back to you.
In the meantime, though, the problem appears to have happened again this week (just once, because only one person ordered more than one product at different prices). Here are the lines from the Manage Customers table for that order:
389 Doug Mayo-Wells email removed for privacy 383 0A5893338Y317383D 2010-10-09 0.99 — Edit / Details
388 Doug Mayo-Wells email removed for privacy 382 0A5893338Y317383D 2010-10-09 0.99 — Edit / Details
387 Doug Mayo-Wells email removed for privacy 384 0A5893338Y317383D 2010-10-09 0.99 — Edit / Details
386 Doug Mayo-Wells email removed for privacy 376 0A5893338Y317383D 2010-10-09 0.99 — Edit / Details
Products 382, 383 and 384 are all correctly priced at $0.99, but product 376 ought to be $4.99, not $0.99. So something is still going wrong.
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.
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.
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.
Another update: with my host’s help to flush the server cache, I got version 2.6.2 of the plugin working such that the “Requested File Could Not Be Found” error no longer occurs. For the moment, I’m satisfied with this as a solution.
An update: our hosts turned off “Safe Mode”, which caused that error line warning about safe mode to go away, but the other warnings (the “headers already sent” lines) are still there. A quick internet search suggests this could be caused by extra whitespace in a php file somewhere. I deleted a blank line from the end of download.php, which is the file the warnings were referencing, and re-uploaded it, but it didn’t change anything.
Warning: Cannot modify header information – headers already sent in […]/wp-content/plugins/wp-cart-for-digital-products/download.php on line 131
I’ve also tried reverting to older plugin versions, including 3.5.0, which is the version Ivy sent me on 5/31, and 2.6.2, which is the version I was running prior to these upgrades. Neither resulted in any change.
I chased them up right after I posted the above. They say they have not changed any settings since this problem occurred. I did, however, recently upgrade the plugin twice in quick succession, first using a version that Ivy emailed me, then another that you emailed me, both on May 31. Do you think it would help to revert to the version of the plugin I was using prior to that?
Our site suddenly began having this issue sometime between last Saturday and now. My symptoms are a little different: the encrypted url produces “Requested File Not Found”, but when I try to navigate to the actual URL in my browser I get a 500 server error. I had been using full URLs, but I changed one product to a relative URL. When I did that, the encrypted URL for that generated a bunch of warnings:
Warning: set_time_limit() [function.set-time-limit]: Cannot set time limit in safe mode in /home/lcrwnet/public_html.weightlessbooks/wp-content/plugins/wp-cart-for-digital-products/download.php on line 126
And I still couldn’t download the file.
It sort of looks from this like the cause of this is that some element of the php configuration on our server has changed unbeknownst to me. Can any of you wiser heads confirm or deny that theory or offer a different one?
Yes we are using the digital product variation, and yes….I think it only happens for products using the digital product variation.
Would it help if I pasted in here the data I put in the digital product variation field for one of the products that has produced this error? I guess it is somewhat sensitive info, so you’ll have to delete it again…
[admin deleted this section]
Hmm, I can already see here that one of the product URLs is lacking the “www”. Could that make a difference?
Hi Ivy and jorgfoto,
This same thing is happening on our site, [http://weightlessbooks.com]. It doesn’t happen with every customer–on some orders the email is delivered with the download link. I have already turned on debug and worked it out so the log file is actually written to, so I can provide some actual data. Here below is what was written to the log for an order wherein both we and the customer got both the payment confirmation from paypal and the download link email from wordpress, but the download link email just had a blank line where the download link should have been.
[admin deleted debug information]
As you can see, the log doesn’t show a download link either. Yet when I try to replicate this result by placing a test order for the same ebook, I get the download link just fine. This same thing has happened to this customer on two different ebooks and to several other customers as well–though I only managed to get the debug log working in time for this one, so this is all the data I have so far.
Any thoughts? Could it be that the Yahoo mailservers are stripping out the encrypted link?
