mcsg Posted February 18, 2021 Share Posted February 18, 2021 Our client would like to use a different number scheme for Invoice Numbers. Still numbers, but they do not want to start from 1. Is is possible to modify the starting Invoice number? Or perhaps a plugin/hook that allows this? Link to comment Share on other sites More sharing options...
Solution CoffeeCake Posted February 18, 2021 Solution Share Posted February 18, 2021 (edited) This is probably an incrementing ID, controlled by MySQL. If so, you can run the following operation on whatever the invoice table is: ALTER TABLE wherever_invoices_live AUTO_INCREMENT = 999999; Where 999999 is the number you'd like to start from. Backup everything first. Then back it up again. Just in case. Edited February 18, 2021 by Paul E. Maybe, just a guess. bfarber 1 Link to comment Share on other sites More sharing options...
mcsg Posted February 18, 2021 Author Share Posted February 18, 2021 Yes! Of course! Thanks @Paul E.! ALTER TABLE nexus_invoices AUTO_INCREMENT=1001; The most elegant and simple method. Thanks. Link to comment Share on other sites More sharing options...
Recommended Posts