Home
Forum
Extensions
Developer Portal
VirtueMart Forum
VirtueMart & Joomla! - The Future of eCommerce
Home
Help
Search
Login
Register
Please
login
or
register
.
1 Hour
1 Day
1 Week
1 Month
Forever
Looking for documentation? Take a look on our
wiki
VirtueMart Forum
»
VirtueMart 1.1.x [ Old version - no longer supported ]
»
Questions VM 1.1 ( the only active board for the old version)
(Moderators:
aravot
,
jolmeda
,
PRO
) »
invoice numbers
« previous
next »
Print
Pages: [
1
]
Go Down
Author
Topic: invoice numbers (Read 1091 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
Logged
zorkhh
Advanced
Jr. Member
Posts: 245
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
Logged
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
Print
Pages: [
1
]
Go Up
« previous
next »
VirtueMart Forum
»
VirtueMart 1.1.x [ Old version - no longer supported ]
»
Questions VM 1.1 ( the only active board for the old version)
(Moderators:
aravot
,
jolmeda
,
PRO
) »
invoice numbers
We use cookies, just to track visits to our website, we store no personal details.
OK
Learn more