Sandbox? This invoice has already been paid.

[newosguy]

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?

[Jack_mcs]

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

[satish]

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

[newosguy]

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?

[jhande]

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.

[jhande]

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?

[satish]

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

[jhande]

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!

[Guest]

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.).

[jhande]

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.

[satish]

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

[jhande]

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

 

 

 

;)

[Kmberly]

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.

[Kmberly]

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 August 1, 2008 by Kmberly

[GwilliamP]

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 [email protected]

I created a test user and buyer

[email protected] (business)

[email protected] (buyer)

 

I created a shop user account [email protected] 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 [email protected] in the PayPal IPN Payment Module. I changed it to the sandbox business address [email protected] 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.

[Jack_mcs]

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

[K_Casault]

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 [email protected]

I created a test user and buyer

[email protected] (business)

[email protected] (buyer)

 

I created a shop user account [email protected] 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 [email protected] in the PayPal IPN Payment Module. I changed it to the sandbox business address [email protected] 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.

[tomato]

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://www.oscommerce.com/forums/index.php?sho...p;#entry1243857

 

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

[aarsenca]

After AGES I found that I had been using my master sandbox email address [email protected] in the PayPal IPN Payment Module. I changed it to the sandbox business address [email protected] 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!

[dustinsuarez]

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:

[ludowhite]

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://www.oscommerce.com/forums/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.

[ludowhite]

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

[Pinball]

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 [email protected]

I created a test user and buyer

[email protected] (business)

[email protected] (buyer)

 

I created a shop user account [email protected] 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 [email protected] in the PayPal IPN Payment Module. I changed it to the sandbox business address [email protected] 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 May 3, 2012 by Pinball