Jump to content
  • Checkout
  • Login
  • Get in touch


The e-commerce.

Change order, invoice counter


Recommended Posts

I need to change the invoice and order number counter to a larger number. I recently moved an ecommerce site to oscommerce and the operator would like to have the invoice/order counter reflect the fact that he has been in operation for a few years. I see that the variable is (I think) oID. I have tried setting it to a larger number, but it has not been succesful. I am using osCommerce 2.2 MS2.


Any help will be greatly appreciated.

Bryan Broussard

Link to comment
Share on other sites

you can change the starting # all you have to do is go to your control panel and click on phymyadmin then select your data base from the dropdown box and then find orders from the list and click on browse. Next find the last order that was placed and click on the edit button. Find Orders_id under the Fields list (should be the first one listed) and then change the order # under Values to any # you want the next order to start at.


Hope this helps



Link to comment
Share on other sites

Probably the same as the above, maybe a bit easyer.


Use phpMyAdmin and execute the following query on your shop's database:

alter table orders auto_increment="insert_new_orderid_here"

"insert_new_orderid_here" must be a number higher than any existing ordernumber, the next order will be "insert_new_orderid_here+1"


Don't remember where I got it from, but it works. :)

Link to comment
Share on other sites


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

  • Create New...