Trying to Implement Gift Certificate

[journalinabox]

Our company (www.journalinabox.com) sells online, but we also travel around to fairs and festivals to sell. We sell a downloadable home study, so when we are out at a show, I usually just process each order and promise to email them a link to the product within a week, but this is very time consuming. Plus, we are looking at going in to this Christmas buying season and we’d like to offer printed Gift Certificates. My original thought was that I would print a Home Study Voucher or Gift Certificate with an estore Coupon Code on it and set each individual Voucher or Certificate with an individual coupon code that could only be redeemed once for the full value of that product. Then, each person can go on their own time and download the product. I have the coupon code settings set to 100% with the condition that the item # is the item on the gift certificate and a redemption limit of 1. The problem is that when I test this, it doesn’t work. When I enter the coupon code, it says it was successfully entered, then I click Check Out with PayPal and it has me fill in all the info, but when I am done and hit enter, instead of taking me to the “Thank you for your Purchase page” that I have set up, it kicks back to our website home page. I get an email saying that a sale was made and on the selling end I get an email that I placed an order, but I am not getting the email with the download link. And, the coupon code remains at 0 used, instead of setting to 1 used. I’m a bit lost. I enabled the logs and in the eStore_post_payment_log I see the following: [10/06/2011 12:07 AM] – SUCCESS :WP Affiliate Platform Plugin is not installed. This makes no sense to me, because I am not sure why this would have anything to do with the WP Affiliate program.

Any help would be greatly appreciated! Thanks!

[admin]

This does look like a database column out of sync type issue. Usually this happens when you update the plugin without following the update instruction. This can also happen if you change database related code in the plugin without properly changing the table structure.

Please do the following to fix this:

1. Deactivate and delete the currently installed version of the plugin(s).

2. Download a fresh build of the plugin(s) from here:

https://support.tipsandtricks-hq.com/update-request

3. Update the plugin following the appropriate update instruction for the plugin in question:

https://support.tipsandtricks-hq.com/plugin-installation-and-upgrade-instructions

Once you do the above perform a test sale with the debug option enabled so we can see what is going on with your system. This post will help you with the debug option:

https://support.tipsandtricks-hq.com/forums/topic/how-and-when-to-enable-debug-and-what-does-it-do

[journalinabox]

I deactivated, deleted, downloaded the update, installed the update, reactivated, tried to complete the purchase and had exactly the same results. eStore_post_payment_log for this morning: [10/06/2011 3:18 PM] – SUCCESS :WP Affiliate Platform Plugin is not installed.

[admin]

You don’t have anything in the following file?

– ipn_handle_debug.log

[journalinabox]

No. That file is completely blank.

[admin]

That means the plugin is not even getting the payment notification. Follow this checklist to address this first:

https://support.tipsandtricks-hq.com/forums/topic/what-to-do-if-the-debug-file-is-empty

[journalinabox]

Okay. I didn’t know I was supposed to have IPN settings turned on at PayPal. I have that on now. But, the IPN is blocked when I try to send it from the sandbox. Where should I start looking?

[journalinabox]

Scratch that. The IPN is not blocked in sandbox. It worked fine there. Here is what shows up now in the debug file:

[10/08/2011 5:40 AM] – SUCCESS :Paypal Class Initiated by 173.0.82.126

[10/08/2011 5:40 AM] – SUCCESS :Post string : [redacted]

[10/08/2011 5:40 AM] – SUCCESS :Connection to http://www.paypal.com successfuly completed.

[10/08/2011 5:40 AM] – FAILURE :IPN validation failed.

[10/08/2011 5:40 AM] – SUCCESS :Paypal class finished.

This all showed up, (saying IPN validation failed even though on the PayPal sandbox end it gave me a green check saying it went through) after I did the sandbox test. After I attempt to make a purchase with the gift certificate (coupon code) and then look at this log nothing new shows up for that attempted purchase.

[journalinabox]

Oh, ARGH!!! We’ve been having this whole discussion about PayPal. That is not the issue at all! It was a problem with my Manual Checkout settings. I wasn’t aware of this feature. I assumed (and then kept assuming by virtue of the posts here) that this was actually being processed through PayPal! Nope. It’s a $0 purchase, so it is through the Manual Checkout feature. All is well.

Thanks.

[Author]

Posts