Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Another paypal problem - Paypal says the invoice has already been paid...


astecme

Recommended Posts

I have for some time been getting reports (intermittently) that Paypal tell my customer(s) that the invoice has already been paid and then that there is a problem with the merchant account.

 

I have recently upgraded so it may be that historically ( years ago) that the order number has been used before. Is there a way to change the base order no so that it starts at say 30000?

 

Thanks

 

Allan

Link to comment
Share on other sites

I hope I have this right, but heres what I did ages ago.

 

Go to your shop and complete an order. Once all fully completed go to your database an find the orders table and the order you jsut placed. Change the order number on that order to what ever you want the order numbers to be.

 

The next order placed should follow on from the one you just created.

 

You could also try running this on your database, but please backup first.

 

alter table orders auto_increment = 30000;

 

That has not been tested.

REMEMBER BACKUP, BACKUP AND BACKUP

Link to comment
Share on other sites

LOL,

tried that and got this.....

 

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

Your purchase couldn't be completed
 
There's a problem with the merchant's PayPal account. Please try again later.
Site Feedback sm_333_oo.gif

PayPal. Safer. Simpler. Smarter.

For more information, see our Privacy Policy, User Agreement and Key Payment and Service Information.

Copyright © 1999-2016 PayPal. All rights reserved.

 

Second time lucky so we will see...

 

Many Thanks

Edited by astecme
Link to comment
Share on other sites

@@astecme You need to complete the order with a different module. If you enable the COD or Check/Money Order module and complete it, then next order with paypal should work. Be sure to un-install the module if you had to install it.

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


ALTER TABLE `orders`

AUTO_INCREMENT = 30001 ;

:blink:
osCommerce based shop owner with minimal design and focused on background works. When the less is more.
Email managment with tracking pixel, package managment for shipping, stock management, warehouse managment with bar code reader, parcel shops management on 3000 pickup points without local store.

Link to comment
Share on other sites

OK so it would appear that Paypal has a Looooooong memory and that it remembered order nos from years ago. Altering the base order no as above appears to have fixed this problem.

 

I would suggest that the docs be updated to sy that if you have had a prior installation then you need to set the base order no. It would even be a great idea to include it in the installation process.

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