Jump to content
Sign in to follow this  
newosguy

Sandbox? This invoice has already been paid.

Recommended Posts

When using sandbox to test I get this at the final screen

 

 

"This invoice has already been paid. For more information, please contact the merchant.

 

Return to Merchant "

 

 

Does that mean the "fake" transaction and the PayPal module worked?

 

 

but no money ever actually moves anywhere right?

Share this post


Link to post
Share on other sites

It means it sees the order as duplicate. There are a couple of fixes for it. They are included in the paypal IPN osCommerce_PayPal_IPN_v2.3.3 contribution.

 

Jack

Share this post


Link to post
Share on other sites

use reset order id contribution.

This will move Yoor order id by a 100 or so and that will clear the chance of a tested order ID being reused.

 

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites
use reset order id contribution.

This will move Yoor order id by a 100 or so and that will clear the chance of a tested order ID being reused.

 

 

Satish

 

 

could not find "reset order id contribution" where is it?

Share this post


Link to post
Share on other sites

I finally got around to test my PayPal Website Standards using the Sandbox.

 

I received the same message as Jon above after clicking to pay for the order.

 

Also when I returned to my osC Admin Panel > Customers > Orders I received this message -

Fatal error: Call to undefined function tep_hide_session_id() in /home/handesho/public_html/catalog/admin/orders.php on line 350

Order ID: [ box ]

 

It also did not redirect me back to my site. I had to click a link to return and then I returned to an empty shopping cart instead of checkout_success.php

 

I am using PayPal IPN v.2.3.3

 

Is this just a bug when using the Sandbox or am I looking at a serious problem?

 

If serious problem, can someone help me fix it please as this will be my only payment processing? :(

 

I too was unable to find the "reset order id" contribution.


- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Share this post


Link to post
Share on other sites

I am wondering...

 

I'm on a shared server with a shared SSL, don't know if that makes a difference with anything.

 

Also I noticed in Admin Panel > Configuration > Sessions I have these settings -

Session Directory = /tmp

Force Cookies Use = False

Check SSL Session ID = True

Check User Agent = False

Check IP Address = False

Prevent Spider Sessions = True

Recreate Sessions = True

 

They used to be False at one time... :huh:

Could my problem be caused by the above settings?


- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Share this post


Link to post
Share on other sites

How to reset order id:

 

Place a test order thru COD(need to enable in case its discable).

 

Then thru PhpMyAdmin modify(increase by X) that order ID(last test order).

 

This way You have reset order id so future orders will be higher order number.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

Thank you Satish ;)

 

I was wondering why I would have to follow the directions that came with the installation of the mod to add a letter to my order ID's. That was discussing having multiple shops which I don't.

 

Thanks again!


- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Share this post


Link to post
Share on other sites

In your PayPal account, go to "Profile" - > "Payment Receiving Preferences". In there you will have the option:

Block accidental payments:

You may prevent accidental payments by blocking duplicate invoice IDs

Yes, block multiple payments per invoice ID

No, allow multiple payments per invoice ID

 

Select "No".

 

PayPal will now allow all orders to be paid, even if the order ID has already been paid previously. A potential problem is if customers pay an invoice twice by mistake (e.g. refreshing browser, hitting button twice etc.).

Share this post


Link to post
Share on other sites
You may prevent accidental payments by blocking duplicate invoice IDs

Yes, block multiple payments per invoice ID

No, allow multiple payments per invoice ID

 

Select "No".

 

Thanks ellie,

 

I seen that in the directions but didn't want to use that option for fear of opening a can of worms.


- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Share this post


Link to post
Share on other sites
Thanks ellie,

 

I seen that in the directions but didn't want to use that option for fear of opening a can of worms.

 

 

Some of Your clients may end up paying more then once.

 

So for a temporary fix this is ok but not a long term solution.

 

Satish


Ask/Skype for Free osCommerce value addon/SEO suggestion tips for your site.

 

Check My About US For who am I and what My company does.

Share this post


Link to post
Share on other sites

I went with adding a letter to the invoice ID as specified in the IPN help folder.

 

 

 

;)


- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Share this post


Link to post
Share on other sites

I have the same problem.... I did exactly what the help file said to in replacing lines/etc... that didn't work. So temporarily, I allowed multiple payments per invoice ID... still had the same problem. I am stuck as stuck can be. I cannot have this shop if I cannot be sure that my IPN and Super Download Shop contribs work! I'm at my rope's end here. Please someone shed some light :(.

 

I have the PayPal IPN 2.3.4.5 and newest release of OSC.

Share this post


Link to post
Share on other sites
I have the same problem.... I did exactly what the help file said to in replacing lines/etc... that didn't work. So temporarily, I allowed multiple payments per invoice ID... still had the same problem. I am stuck as stuck can be. I cannot have this shop if I cannot be sure that my IPN and Super Download Shop contribs work! I'm at my rope's end here. Please someone shed some light :(.

 

I have the PayPal IPN 2.3.4.5 and newest release of OSC.

 

After all the fixes I tried to implement... all I had to do was put the sandbox email in the ipn module (the one that looks like seller_4254rwe2_site@gmail or whatever).

 

NEVERMIND: made another test order and back to the same problem........

 

In the previous order that DID go through, it shows this:

Invoice ID: K --- shouldn't that be K plus a number?

 

 

...Okay, cool. Now my 'confirm order' button does nothing upon clicking. I've made previous shops with oscommerce and have a fair amount of php skills, but this shop is just KILLING me.

Edited by Kmberly

Share this post


Link to post
Share on other sites

I don't know if this helps but I just found out why I was getting this error.

 

PayPal Sandbox

I created a test account test@mydomain.com

I created a test user and buyer

test_1219854010_biz@mydomain.com (business)

test_1219854112_per@mydomain.com (buyer)

 

I created a shop user account test_1219854112_per@mydomain.com and purchased a test item. All went well up to paying at the PayPal Sandbox where I got the already paid error.

 

After AGES I found that I had been using my master sandbox email address test@mydomain.com in the PayPal IPN Payment Module. I changed it to the sandbox business address test_1219854010_biz@mydomain.com and everything now works.

 

For some reason PayPal Sandbox was accepting the master account instead of rejecting it for IPN transactions.

 

It may not cure everyone's problems but it worked for me.

Share this post


Link to post
Share on other sites

As a quick fix, you can enable the Check/Money Order module and place an order. Then the paypal module should work since the order number will have changed.

 

Jack

Share this post


Link to post
Share on other sites

OMG Paul. It worked. I can't tell you how many hours I've been banging my head on this. Thank Youuuuuuuuuuuuuuuuuuuuuuu.

 

Kim

 

 

I don't know if this helps but I just found out why I was getting this error.

 

PayPal Sandbox

I created a test account test@mydomain.com

I created a test user and buyer

test_1219854010_biz@mydomain.com (business)

test_1219854112_per@mydomain.com (buyer)

 

I created a shop user account test_1219854112_per@mydomain.com and purchased a test item. All went well up to paying at the PayPal Sandbox where I got the already paid error.

 

After AGES I found that I had been using my master sandbox email address test@mydomain.com in the PayPal IPN Payment Module. I changed it to the sandbox business address test_1219854010_biz@mydomain.com and everything now works.

 

For some reason PayPal Sandbox was accepting the master account instead of rejecting it for IPN transactions.

 

It may not cure everyone's problems but it worked for me.

Share this post


Link to post
Share on other sites

Thank you very much. This worked fine for me too. I am happy that the solution worked out to be so simple...

 

For anyone else who meets the same problem:

 

- I use OsCommerce v2.2 RC2

- PayPal Website Payments Standard (includes\modules\payment\paypal_standard.php )

 

I tried billhatcher's solution from following thread:

http://forums.oscommerce.com/index.php?sho...p;#entry1243857

 

Maybe this worked for someone else but for me it did not resolve the issue.

Share this post


Link to post
Share on other sites

After AGES I found that I had been using my master sandbox email address test@mydomain.com in the PayPal IPN Payment Module. I changed it to the sandbox business address test_1219854010_biz@mydomain.com and everything now works.

That worked for me too. What is amazing is how the error message has nothing to do with the solution <_<

 

Thanks!

Share this post


Link to post
Share on other sites

Paul thank you very much!! it worked for me too.

 

Now the only thing is that it does not return automatically to my website, I'm going to start browsing for a solution to this.

 

Thank you again, I was going around this for hours, you saved me a headache. :thumbsup:

Share this post


Link to post
Share on other sites

Thank you very much. This worked fine for me too. I am happy that the solution worked out to be so simple...

 

For anyone else who meets the same problem:

 

- I use OsCommerce v2.2 RC2

- PayPal Website Payments Standard (includes\modules\payment\paypal_standard.php )

 

I tried billhatcher's solution from following thread:

http://forums.oscommerce.com/index.php?sho...p;#entry1243857

 

Maybe this worked for someone else but for me it did not resolve the issue.

 

 

Just come across your post.

Could you explain the last part of Bill Hatchers' solution, where he changes /ext/modules/payment/paypal/ipn.php I am just not sure on this.


Thanks for Looking

 

Ludo

Share this post


Link to post
Share on other sites

How to reset order id:

 

Place a test order thru COD(need to enable in case its discable).

 

Then thru PhpMyAdmin modify(increase by X) that order ID(last test order).

 

This way You have reset order id so future orders will be higher order number.

 

Satish

Hi Satish

Could you just explain how to mahe the change in PHPmyadmin.

Thanks in anticipation.

Hope you are enjoying the cricket!! Good luck


Thanks for Looking

 

Ludo

Share this post


Link to post
Share on other sites

I don't know if this helps but I just found out why I was getting this error.

 

PayPal Sandbox

I created a test account test@mydomain.com

I created a test user and buyer

test_1219854010_biz@mydomain.com (business)

test_1219854112_per@mydomain.com (buyer)

 

I created a shop user account test_1219854112_per@mydomain.com and purchased a test item. All went well up to paying at the PayPal Sandbox where I got the already paid error.

 

After AGES I found that I had been using my master sandbox email address test@mydomain.com in the PayPal IPN Payment Module. I changed it to the sandbox business address test_1219854010_biz@mydomain.com and everything now works.

 

For some reason PayPal Sandbox was accepting the master account instead of rejecting it for IPN transactions.

 

It may not cure everyone's problems but it worked for me.

 

This also works in localhost test setups - I too was getting the "Invoice Already Paid" bit with PayPal Sandbox and I hadn't changed the setting in admin/modules/PayPalxxx to my sandbox business 'email' address. Must remember to change back when going live!! This would be a good edit to the PayPal module that the Sandbox/Testing switch changes the PayPal email to the Sandbox/Testing one and back to the real one when in Real (money!) mode.

 

Thanks for the tip!

Edited by Pinball

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×