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?


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.

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

Your Answer

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

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