Author Topic: invoice numbers  (Read 1000 times)

3LM

  • Beginner
  • *
  • Posts: 2
invoice numbers
« on: January 19, 2011, 02:36:20 am »
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

  • Advanced
  • Jr. Member
  • *****
  • Posts: 245
    • vm-expert.com
Re: invoice numbers
« Reply #1 on: January 19, 2011, 08:35:03 am »
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
Virtuemart Professional Support at http://www.vm-expert.com

Visit the large Virtuemart Group on Joomla.org: http://people.joomla.org/groups/viewgroup/30-Virtuemart.html