VirtueMart Forum

VirtueMart 2 + 3 + 4 => General Questions => Topic started by: Peter Skotte on March 21, 2014, 21:01:29 PM

Title: Re-number invoice number sequence
Post by: Peter Skotte on March 21, 2014, 21:01:29 PM
I have searched these forums high and low, and google etc. but haven't found any solution to my "problem"
There are tons of hits for renumber/customize "order number" but nothing for "invoice number".

I have the order number plugin installed and that works fine. I can change the starting range for order numbers etc. by changing the mysql table at auto increment, but not for the invoice number, which is the one that shows in the customer email and in the shop system.
Once I installed the plugin, orders started at 00001, but I need them to start at 5783 (last order of the old shop orders)

Any hints on getting that working?

Thanks

Peter
Title: Re: Re-number invoice number sequence
Post by: reinhold on March 21, 2014, 21:43:42 PM
See the 2nd question and answer of my FAQ: http://www.open-tools.net/documentation/ordernumber-plugin-for-virtuemart/22-virtuemart-2-extensions/41-vm2-ordernumber-plugin-faq.html

The only difference for invoice numbers is that the number_type column in the database is 1 for invoice numbers (and 0 for order numbers).

Reinhold