Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Changing the invoice number


cayugadan

Recommended Posts

Posted

Does anyone know how I can change the next order number? It starts out with order #1. That does not look good. We'd prefer to start, for example, with #20001.

 

We already have had a number of orders.

 

If it's just going into phpmyAdmin, that's no problem, but I've tried to find that field and so far been unsuccesful, so if you can include which table/field I'd appreciate it

Posted

No, actually it's updated, because the Knowledge Base has been given over to MS3 which hasn't been released yet. Sorry about that - the corresponding table in MS2 is just 'orders'

 

Vger

Posted

Thanks for pointing me there. :thumbsup: I figured out that the field needed to be changed to orders.

 

For those who don't understand the SQL syntax the command should be

 

alter table orders auto_increment = 26100

 

(if you were to increment by 26100)

Archived

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

×
×
  • Create New...