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


1 Answer 1


You need to check 2 tables for that.
1 sales_sequence_meta
2 sales_sequence_profile enter image description here

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;

  • I think the solution requires CCC-yy to be dynamic in terms of current year. This would not be a dynamic solution. Commented Jul 28, 2019 at 0:18
  • I need CCC is static letter and YY needs to current year that is dynamic
    – Priya
    Commented Jul 29, 2019 at 4:00

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.