Photo Seller – Order successfully placed but doesn't get saved in the database

[helen35]

Using WP Photo Seller Version 2.0.8 with paypal payment.

When we placed an order in paypal with test mode everything was fine and the order showed up in wordpress database but now we have received our first customer order and it didn’t appear. The order lines are saved in the database but with an order id of 0 and there is no entry for the order. The paypal payment went through successfully and we received confirmation of the order from paypal with the items purchased.

We only sell physical items so there is no download links.

[Peter]

Hi,

Can you please grab a fresh version of the plugin and check to see if that fixes your issue:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[helen35]

I have done this and tested but the same thing happened. Payment went through fine and redirected me back to the website but there was no order showing when I logged into the wordpress backend. Checked the database and the order item had been added but not the order.

[Peter]

Can you please do the following:

1) Enable logging for the photo seller. (go to Settings and scroll to bottom and select “yes” for “enable logging”)

2) Log into your paypal account and check the following settings:

– “Auto Return” (this should be enabled)

– “Payment Data Transfer” (this should be enabled)

– “Instant Payment Notification (IPN)” (this should be enabled).

– UTF-8 formatting enabled as per https://support.tipsandtricks-hq.com/forums/topic/some-characters-and-text-not-recognizable-in-the-notification-email

Photo seller side:

– In Payment Gateway Settings make sure you have entered your paypal email and also the correct PDT identity token.

3) Create a test gallery with price of $0.01 and provide a link to that gallery so I can try a test purchase.

[helen35]

What should the Notification URL be in paypal for the IPN?

[helen35]

I have created a test gallery at [http://snappets.co.uk/customer-area/] with the password ‘test’. Paypal test mode is not on and the logging is enabled. I think I have put right the settings, we presumed that because our initial test worked that everything was correct but we didn’t have IPN enabled.

[Peter]

but we didn’t have IPN enabled

I think this was your issue.

[helen35]

Did you try testing it?

Can I test it without actually making a purchase?

I’ve seen there’s paypal sandbox test accounts can I use these and would I set paypal to test mode in the plugin?

[Peter]

I tried a test purchase and I didn’t get the email

I did notice that your logs show that saving of the order to the DB failed.

Can you please do the following:

Go to the Photo Seller >> Settings >> Advanced Settings

Enable the “Display Download Links & Purchase Info On Thankyou Page” checkbox.

I have also sent you an email with a newer plugin version which has better debug info. Please deactivate and delete your current version and install the new one. (you won’t lose any settings or photos)

When you’ve done that let me know and I will make another test purchase.

[helen35]

Thanks for your help, we have not received an email, could you please send it again.

[Peter]

I sent the email to your registered address which a “hotmail” account. Did you check your inbox?

I have resent it.

[Peter]

I sent the email to your registered address which is a “hotmail” account. Did you check your inbox?

I have resent it.

[helen35]

Yes it is the hotmail account we are checking but still no email. Checked spam folder as well.

[Peter]

We updated the official version. Now you can get it by following this link:

https://support.tipsandtricks-hq.com/forums/topic/re-install-or-load-a-fresh-build-of-the-plugins

[helen35]

OK version 2.1.7 is now installed

[Author]

Posts