We are going to add prefix word using the database operation.

– Login to Database & Check table ‘sales_sequence_meta’

In the above SC “meta_id” is:  ‘ 2 ‘  And after run the below query :

UPDATE ‘sales_sequence_profile’ SET ‘prefix’ = ‘HAZ’ WHERE ‘meta_id’ = 2;

That’s it!! Now when you will going to place an order, You will get the next increment Id Like ‘HAZ21050001′ by ‘HAZ’ prefix word.

Thank you.