Jump to content

change order ID


sickshot
 Share

Recommended Posts

so i have old prestashop based shop which is running from 2015 and is on ps 1.4

 

some time ago i had to restore 3 month old backup and now my payment gateway is not accepting payments as new orders are sent with old IDs which in payment gateway database are already been registered so all payments get rejected...

before restore order ID was on 4616 and now it is on order ID 3821, so i need to make prestashop to continue orders from 4017 and up to make gateway accept payments...

so i need to skip about 600 orders to make payments work again ....

any ideas on how i can do this?

Edited by sickshot (see edit history)

Share this post


Link to post
Share on other sites

i tried ALTER TABLE ps_orders AUTO_INCREMENT=4620;

but got error 

#1146 - Table 'kenarish_kensop.ps_orders' doesn't exist

so its in ps147_orders and ids itself are in id_order

i dont know how this works...if you know what is the exact command? its presta version 1.4

Edited by sickshot (see edit history)

Share this post


Link to post
Share on other sites

35 minutes ago, sickshot said:

i tried ALTER TABLE ps_orders AUTO_INCREMENT=4620;

but got error 

#1146 - Table 'kenarish_kensop.ps_orders' doesn't exist

so its in ps147_orders and ids itself are in id_order

i dont know how this works...if you know what is the exact command? its presta version 1.4

And you are using prefix "ps_"?

Share this post


Link to post
Share on other sites

  • 5 weeks later...
On 3/31/2021 at 10:47 PM, musicmaster said:

You are contradicting yourself. Previously you said that you used "ps147_" as refix.

Oh yes my fault. Im managing several websites so i messed this up.

 

Anyway i fixed this issue 

  • Like 1

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
 Share

×
×
  • Create New...

Important Information

Cookies ensure the smooth running of our services. Using these, you accept the use of cookies. Learn More