I have multiple stores where I want each one of them to have a different order number's prefix. Is there anyway to realize that?
Edit: I'm trying to avoid using raw queries, any other (safer) way ?
Magento Stack Exchange is a question and answer site for users of the Magento e-Commerce platform. It only takes a minute to sign up.Sign up to join this community
You can manage it like below:
Magento 2 database contains a table name 'sales_sequence_profile' which has prefix column and every row contains a meta_id which relates with table 'sales_sequence_meta'.
Table 'sales_sequence_meta' sequence table names according to stores and type(order, invoice, shipment, creditmemo, rma).
Basically this is just for understanding. You need to update the table 'sales_sequence_profile' and related sequence tables.