How to add custom value prefix in order and invoice number

Question

I like to add prefix in order and invoice number and next number should be in current year and last 4 digit is Increment number, this are all without extension.

Example: 0001 to CCC-yy0001

Answer 1

You need to check 2 tables for that.
1 sales_sequence_meta
2 sales_sequence_profile

for sequence_order_1 has meta_id is 6.
use below sql query
UPDATE sales_sequence_profile SET prefix = 'CCC-yy' WHERE meta_id = 6;