I want to change Invoice increment id from new series with the prefix.

I have checked sequence_invoice table in the database. I have found 4 table:





I have found entries only in sales_invoice_2 table like 1,2,3,4 and soon. So I am confused to change invoice number.

Can anyone suggest me?

1 Answer 1


sales_invoice_0 is for default store view.

sales_invoice_1 is for 1st store view.

sales_invoice_2 is for 2nd store view.

sales_invoice_3 is for 3rd store view.

If you change your series with the prefix you can use this,

ALTER TABLE sequence_invoice_1 AUTO_INCREMENT = 700000011;

Magento default provides 9 digits for Id. if you want to change it with prefix then replace 700000011 with your new series Id. and execute it in the database.

This will help you more.

  • Can I add text as prefix with the series? Commented Apr 6, 2018 at 4:55
  • If I add text as prefix (ex: 'Inv') then what will be the length of series? Commented Apr 6, 2018 at 5:03
  • Yes you can use text as prefix. Please add your prefix value in sales_sequence_profile tabel. Commented Apr 6, 2018 at 5:04
  • @Vinodkumar Have you tried this solution.? Is this working for you.? Commented Apr 6, 2018 at 5:12
  • Thanks, It is working fine. I have accepted your answer. Commented Apr 6, 2018 at 5:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.