Forum Replies Created
-
Posts
-
OK, I think I may see the problem on my side here.
I activated Stop Spammer Registrations and it seems to be blocking emails sent by eStore. I added my emails and IPs to the whitelist and it appears to fix it in staging. I will have to wait and see for my production site when someone actually buys something.
Further checking, for those that run into this, showed the following:
– JQuery was included properly, but I had Minify turned on inside W3TC AND
– Comment and line break removal was also turned on
Turning off those last two options (remove comments and line breaks) fixed it. Apparently, the line breaks and comments are necessary to keep things running smoothly here.
Hi Ruhil,
Thanks for looking into it. It’s probably my caching settings with W3TC. It worked before with WooThemes, so it’s probably not the theme itself. I’ll check it out.
Hi Ivy & Ruhil,
I submitted site access to you and got the email back to upgrade. I’m now on 4.5.9 and the problem still exists. It’s not forcing users to check “I accept” before going to PayPal. Can you please take a deeper look?
I’m also running W3 Total Cache, but I’ve made sure the JS relating to eStore’s jQuery isn’t Minified, and that’s not helping either. I’ve done the correct setup for the cache on eStore, as the store is working, just the T&C aren’t required.
The shopping cart pops up after clicking on the first item with “You must accept the T&C!” in red, but the checkbox isn’t checked.
Whoops! I take that back, the theme DOES use jQuery…
wp-content/themes/inspire/includes/js/jquery-142.js?ver=1.4.1
So, how do I set noconflict mode?
@wzp: This was originally configured correctly before two upgrades ago. That’s when it stopped working. The checkbox is checked, the Terms URL is filled in and valid.
@amin: How do I put jQuery in “non-conflict” mode? There is a plugin on the site that includes some jQuery JS. The theme doesn’t use jQuery.
Thanks for the update. I’ve installed it, but is there any way you can send me a query to fix all the bad data in the database? This bug essentially means my sales reports for the trailing months are all junk right now.
Here’s more sale data from that estore_sales_tbl in case you’re not convinced:
Customer 1 2010-09-05 17:46:08 4 21.99
Customer 2 2010-09-06 10:42:13 5 21.99
Customer 2 2010-09-06 10:42:13 4 21.99
Customer 3 2010-09-06 15:37:11 2 19.99
Customer 3 2010-09-06 15:37:11 5 19.99
Customer 3 2010-09-06 15:37:11 8 19.99
Customer 4 2010-09-07 16:53:08 2 25.00
Customer 4 2010-09-07 16:53:08 7 25.00
Notice that in every multi-module sale, no matter the product IDs (which are always different when a customer buys a set of items), the amounts are always the same. It just *happens* to work when there’s only one item in the basket.
Actually, the problem is much more severe than I originally described, based on what I just saw in that table, comparing it with actual sales data:
So, here I have one customer who bought 4 items from me on 9/1/10:
Email Sale Date Time Prod ID Amount NOTES (mine)
customer@customer.com 2010-09-01 14:48:13 1 19.99 <—- Should be $10.99!
customer@customer.com 2010-09-01 14:48:13 3 19.99 <—- Should be $39.99!
customer@customer.com 2010-09-01 14:48:13 5 19.99 <—- Should be $5.00
customer@customer.com 2010-09-01 14:48:13 8 19.99 <—- This is Correct (only one)
Those sales figures are just plain wrong! My prices for the individual items are different than those prices. The PayPal email has the correct data:
Product Title 1
Item #: 1
$10.99 USD 1 $10.99 USD
Product Title 2
Item #: 3
$39.99 USD 1 $39.99 USD
Product Title 3
Item #: 5
$5.00 USD 1 $5.00 USD
Product Title 4
Item #: 8
$19.99 USD 1 $19.99 USD
And now I suddenly see the source of the 19.99 for the 39.99 product! Product ID 3 was purchased once, but erroneously recorded in the database as $19.99, not $39.99. Looks like there’s some bug in the tracking of the data, where only the last price of the list of items purchased is inserted into the database.
I see this with every multi-item purchase made this month. And in previous months.
HELP!
Hi amin,
Nope, this is on a live site. And it clearly counted, otherwise I wouldn’t see it in the stats. The math doesn’t lie.
The only reason I was able to notice it was the fact that it was a product that rarely sells. 39.99/2 = 19.98, so assuming the .01 is a rounding issue or something, it makes sense that the sale was counted (2) but the actual revenue was not ($39.99 instead of $79.98).
Can you try simulating this in your sandbox to see? Or would you prefer to login and verify in my site?
+1 for this plugin. It eats Super Cache for breakfast. Installing it, disabling Super Cache and using the same opcode as before gave a 20% decrease in page load speeds. (-1 second per page, on average). Works with eStore, no problem so far.
