invoice numbers

[3LM]

VirtueMart 1.1.5

is there a way we can start the invoice numbers at a high number vrs astarting at 1, i have a customer reques that the numbers start in the 100000 range to give the impression that they have done lots of sales.

nick

[zorkhh]

I guess you mean the order_id. You can do this only through mysql. This is an auto-increment id-field in the database. The easiest way is to use something like phpMyAdmin and set the autoincrement value of the table #__vm_orders to the required value. The next order will be created with the higher id.

Another way is to insert a new record into the table with a given order_id:

Insert into #__vm_orders (order_id) VALUES (1000000)

That also sets the autoincrement to a higher value. You will have to delete this record manually afterwards:

delete from #__vm_orders where order_id=1000000

Thomas