Jump to content
astecme

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

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

Share this post


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

Share this post


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

Share this post


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

Share this post


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

Share this post


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

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

×