Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Sandbox? This invoice has already been paid.


newosguy

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?

Link to comment
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

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
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.

Link to comment
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?

Link to comment
Share on other sites

  • 2 weeks later...

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 -

Link to comment
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 -

Link to comment
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.

Link to comment
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 -

Link to comment
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.).

Link to comment
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 -

Link to comment
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.

Link to comment
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 -

Link to comment
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.

Link to comment
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
Link to comment
Share on other sites

  • 4 weeks later...

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.

Link to comment
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

Support Links:

For Hire: Contact me for anything you need help with for your shop: upgrading, hosting, repairs, code written, etc.

Get the latest versions of my addons

Recommended SEO Addons

Link to comment
Share on other sites

  • 2 months later...

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.

Link to comment
Share on other sites

  • 4 months later...

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.

Link to comment
Share on other sites

  • 7 months later...

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!

Link to comment
Share on other sites

  • 1 year later...

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:

Link to comment
Share on other sites

  • 4 months later...

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.

Thanks for Looking

 

Ludo

Link to comment
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

Link to comment
Share on other sites

  • 1 year later...

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 by Pinball
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...