B2B Commerce provides the option to customize the prefix and format of the auto-generated Order and Customer numbers. The default settings for Order Number and Customer Number Prefix are set to "WEB" and the respective number formats are both set to "000000".
You must use the "000000" format. These zeroes are the format mask, number of zeroes to match the number of digits, not starting numbers. If you want to start at a certain number, you have to update the seqordernumber table, where the seqordernumber is an identity field.
In the scenario where a user wants the Order Number to start with the company name abbreviation and start the iterative numbering sequence with a specific number, for example "INSFT500000", the Order Number Prefix should be set to "INSFT" and the Order Number Format should be set to "500000".
Customizing the settings
- Go to Admin Console > Websites.
- Click the Details finger tab.
- Under the Format and Prefix Configuration make the necessary changes to the following fields:
- Order Number Prefix - The prefix that will be added to all order numbers. Default value: Z.
- Order Number Format - Order numbers will be formatted according to the number of zeroes entered in this setting. Default value: 000000.
- Customer Number Prefix - The prefix that will be added to all automatically generated customer numbers. Default value: C.
- Customer Number Format - Automatically generated customer numbers will be formatted using the number of zeroes entered in this setting. Default value: 000000.