What I would like to achieve is to have the invoice number defined as so:


Where YYYY represents the current year, MM the current month and DDD the number that increments for each invoice.

The issue is that I don't know how to automatically reset the three digits at the beginning of each month.


1st invoice of March: 202003001

2nd invoice of March: 202003002

3rd invoice of March: 202003003

1st invoice of April: 202004001
  • you refer this link :- github.com/mage2pro/sales-sequence – Mohit Patel Mar 24 at 18:35
  • @MohitPatel hi, unfortunately this plugin doesn't seem to achieve what I want. I can already modify the prefix as I wish and change the length of digits. What I want is to reset the auto_increment at the beginning of each month. – Dim13i Mar 25 at 9:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.