Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Change first order number from 1 to 1000


Dabitz

Recommended Posts

Posted

I am installing a fresh copy since I installed a few contributions (Paypal IPN and QT Pro 4.2), I guess I will start all orders from zero (I was up to 500) and with a fresh database so I get no conflicts. Is there a way to change the first order so when someones makes the first purchase the order number is 1000 instead of 1?

 

I hope you can help me out.

 

Dave

Posted
I am installing a fresh copy since I installed a few contributions (Paypal IPN and QT Pro 4.2), I guess I will start all orders from zero (I was up to 500) and with a fresh database so I get no conflicts. Is there a way to change the first order so when someones makes the first purchase the order number is 1000 instead of 1?

 

I hope you can help me out.

 

Dave

http://www.oscommerce.info/kb/osCommerce/G...s_and_Tricks/31

Posted
I ran that query but it says table not found.... :-(

 

 

 

it's actually

 

alter table orders auto_increment = 1000;

 

 

the table is called orders now. just tried it and verified it works.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...