It is already known that the order number can not be modified with a custom format, because it is sequential in the database and is associated with several tables.
But, you could create an addon with a table with two fields in which the order_id and the custom_format_order_id appear and can be hooked to make it work whenever the order_id is required.
This would allow showing the customer an order number with a custom format. This would help to avoid knowing the number of orders that the store has or that the competition controls how many sales you have (making false orders).
Certainly possible to set up a mapping table. But how do you want to generate the custom order number? If it's based on something that can be automated, this is not a big deal. Take implementing it via a few hooks
When the order is placed (generate the custom value)
When it's looked up or retrieved (apply custom value into the order)
Probably have to modify search requests when order_id is specified in the detailed searches. (Look up in mapping table first and apply standard order_id)
Would you want the custom id on invoices? If so, that's additional work. If using the newer email editor, it's a lot more work than the old template style email templates.
If this is an MVE environment, might be a few more things that need to be addressed.
Feel free to click the link in my signature and provide me all of your requirements (above is a sampling) and I'll be happy to give you a fixed-price quote.
It is already known that the order number can not be modified with a custom format, because it is sequential in the database and is associated with several tables.
But, you could create an addon with a table with two fields in which the order_id and the custom_format_order_id appear and can be hooked to make it work whenever the order_id is required.
This would allow showing the customer an order number with a custom format. This would help to avoid knowing the number of orders that the store has or that the competition controls how many sales you have (making false orders).
Is it possible? Any proposal?
I have raised this issue some time ago here. But looks like was not taken seriously. Or didn't understand importance.
We can create such modification, but as we have many questions to discuss the final result, it better to contact our developers at manager@alt-team.com
We have worked with CS-Cart since 2010 and have lots of ready-to-use add-ons and modifications to offer you the best price of development service.