How is the E-commerce Website order number generated? At present, I do not feel good using the order ID. Starting from 1, it is too ugly. How does an order ID like Taobao come into being?

  mysql, question

How is the E-commerce Website order number generated? At present, I do not feel good using the order ID. Starting from 1, it is too ugly. How does an order ID like Taobao come into being?

I noticed that the subject mentioned:

Starting from 1, this is too ugly

This is absolutely not! Orders from e-commerce platforms must not show the rules to others, let alone increase in sequence. Because rivals may know your daily sales volume through the rule of order number, which is very dangerous.


My plan is:

Time plus random number

It is suggested to combine time, random number, merchant ID, member ID and self-increasing ID according to the actual situation and formulate according to its own operating characteristics.