Magento 2 : Change Order # Formatting for M2 Orders

Question

I am trying to implement feature that Orders placed on M2 should start with a ' 3 ' instead of a ' 2 '

This will help me with easily identifying new orders while we move test orders to production and for post live tracking.

What would be the most convenient method to do so programmatically, following by best practice ?

any thoughts would be greatly appriciated.
– devhs
Apr 8, 2021 at 5:27 — devhs, Apr 8, 2021 at 5:27

Rakesh Varma · Accepted Answer · 2021-04-08 04:37:21Z

1

You can change it from the table sales_sequence_profile by changing value of prefix column for the particular meta_id

You will find order meta_id from sales_sequence_meta this table based on your store view.

answered Apr 8, 2021 at 4:37

Rakesh Varma

2,22610 silver badges19 bronze badges

Thanks for the answer, i have opened & checked tables. This is it ? Everything else would be managed automatically by magento if i change prefix for a store's meta id ?
– devhs
Apr 8, 2021 at 4:42
Also i would like to ask if it can be done programmatically ?
– devhs
Apr 8, 2021 at 4:42
yes after changing value in table it will work. I don't know about the code. till now I have done with the db only
– Rakesh Varma
Apr 8, 2021 at 4:51
ok rakesh thanks for the answer, i have to perform this programmatically, so i need to check that.
– devhs
Apr 8, 2021 at 5:04
once you get the solution using programmatically post it in your question so it will helpful for other as well
– Rakesh Varma
Apr 8, 2021 at 10:48

Add a comment |

Shoaib Munir · Accepted Answer · 2021-04-08 04:43:31Z

0

This should work

answered Apr 8, 2021 at 4:43

Shoaib Munir

9,43410 gold badges50 silver badges107 bronze badges

Thanks for the answer, That's it ? Everything else would be managed automatically by magento ? For credit memo, invoice, shipment ?
– devhs
Apr 8, 2021 at 4:45
Also would like to ask if it will work for multiple stores ?
– devhs
Apr 8, 2021 at 4:45
For multiple stores you will find multiple sequences like _1, _2 etc
– Shoaib Munir
Apr 8, 2021 at 4:55
For invoice shipment, credit memo you have other tables like this. sequence_creditmemo_0, sequence_creditmemo_1, sequence_invoice_0, sequence_invoice_1 etc
– Shoaib Munir
Apr 8, 2021 at 4:56
ok so i need to change there in those table also ?
– devhs
Apr 8, 2021 at 5:04

| Show 4 more comments

LitExtension Magento Migration · Accepted Answer · 2021-04-09 02:54:02Z

0

answered Apr 9, 2021 at 2:54

1,3501 gold badge5 silver badges10 bronze badges

Add a comment |

3 Answers 3