eStore – Wrong Product Price Detected causing IPN product validation failed

[susanmarshallva]

I created new discounted products and was using the Old Price field under Additional Product Details so the product would show it’s discounted on my website. Now I’m having an intermittent problem with some orders (both with Stripe and PayPal). The payments go through every time, but what happens with each payment method is different.

When this happens the orders do not show up in the Order Manager, I get no email notification of the sale and I end up getting contacted by unhappy customers that want to know where their order is.

With the Stripe payments, I do not get an order email notification and the order is not recorded in either the ipn handle debug file or the eStore post payment debug file.

With PayPal payments, the order shows up in the ipn handle debug file only with the FAILURE notice and no order email notification.

Here is what shows up in the ipn handle debug file for the paypal orders where the FAILURE occurs:

[12/08/2019 3:57 PM] – SUCCESS :Checking if PayPal IPN response is valid

[12/08/2019 3:57 PM] – SUCCESS :Connecting to: https://www.paypal.com/cgi-bin/webscr

[12/08/2019 3:57 PM] – SUCCESS :IPN successfully verified.

[12/08/2019 3:57 PM] – SUCCESS :Creating product Information to send.

[12/08/2019 3:57 PM] – SUCCESS :Transaction Type: Shopping Cart

[12/08/2019 3:57 PM] – SUCCESS :Number of Cart Items: 4

[12/08/2019 3:57 PM] – SUCCESS :Item Number: 14

[12/08/2019 3:57 PM] – SUCCESS :Item Name: Genuine Ogallala Bay Rum Bath Soap/Shampoo Bar (Trails End)

[12/08/2019 3:57 PM] – SUCCESS :Item Quantity: 2

[12/08/2019 3:57 PM] – SUCCESS :Item Price: 10.70

[12/08/2019 3:57 PM] – SUCCESS :Item Shipping:

[12/08/2019 3:57 PM] – SUCCESS :Item Currency: USD

[12/08/2019 3:57 PM] – SUCCESS :Price paid: 10.70, True price: 13.4

[12/08/2019 3:57 PM] – FAILURE :Wrong Product Price Detected! Actual Product Price : 13.4 Amount Paid: 10.70

[12/08/2019 3:57 PM] – FAILURE :IPN product validation failed.

[12/08/2019 3:57 PM] – SUCCESS :Paypal class finished.

[admin]

The old price field option has no impact on this post payment verification process. This would be a case of someone paying $10.70 when in estore’s product database it shows the actual price to be $13.4.

Is this for a subscription product by any chance?

Do you have any caching which maybe showing a different price than what is configured in the database.

If you edit the product ID 14, what is the price that you have set for it? If it is $13.4 then do you know why someone paid $10.70 for it?

[susanmarshallva]

It is not a subscription.

I do have a caching plugin, SG Optimizer. Also using WP Performance Score Booster but not sure if that has caching or not.

The regular product price is 6.70 but I’m using a product variation and the variation the customer selected has a price change of -1.35. This brings the price down to 5.35. The quantity order was 2 which brings the total for that item to 10.70. (I hope that made sense)

[wzp]

I do have a caching plugin, SG Optimizer.

The only two caching plugins that we “officially” support are WP Super Cache and W3 Total Cache:

• WP Super Cache:

  https://support.tipsandtricks-hq.com/forums/topic/using-the-plugins-together-with-wp-super-cache-plugin

• W3 Total Cache:

  https://support.tipsandtricks-hq.com/forums/topic/using-the-plugins-with-w3-total-cache-plugin

 

For any other caching plugin, you must determine if it can be configured in a manner similar to the two supported plugins.

The regular product price is 6.70 but I’m using a product variation and the variation the customer selected has a price change of -1.35. This brings the price down to 5.35.

***** NEGATIVE PRICE VARIATIONS ARE NOT SUPPORTED *****

The post payment price verification will fail if you use negative variance:

https://support.tipsandtricks-hq.com/forums/topic/negative-variation-price-fails-to-send-email-or-show-order

[susanmarshallva]

Thank you very much for your reply. I suspect that negative pricing is causing my issue. I will remove this and see if it solves my problem before switching the caching plugin. If it doesn’t then I swap out the caching plugin for one of the super cache.

[Author]

Posts