Add ability to change starting numbers of invoices

The current "invoice number generation" is very special but also simple. If you choose "Infinite" invoice numbers you can make an offset if you change the last invoice number directly in the database to "1000". I think this should work for your needs. Try this in a test system.

Changing invoice_id and invoice_number in the database does not help. It might work for the next order, but not for second order. I thing having option to change start number of counting is mush have functionality.

I think the handling of invoice numbers is the core feature of this module. I am thinking of an improvement of this. Security and stability are the most important features. But a good way for customizing including a preset like you want to have is also very interesting.
Because the module is already in usage we need an upgrade path if we change the logic.

I change the issue title to "Add ability to change starting numbers of invoices" and mark it as feature request.

Title change.

I agree that making the invoice number generation more flexible would be great.

For a quick fix I think the following should work:

UPDATE commerce_invoice SET invoice_id = 1000, invoice_number = '1000' WHERE invoice_id = 1;
ALTER TABLE commerce_invoice AUTO_INCREMENT = 1001;

where invoice with 1 is a dummy invoice you've created, assuming you're starting with an empty table.

That way the first real invoice will get invoice_id 1001 and invoice_number "1001".

This feature is also discussed here: #1728106: Discuss the strategy for future invoice number handling: stability, flexibility and interface

Found the solution for the first question

Closing all Drupal 7 issues as this project will only be supported for Drupal 8