Order information and status flow

Order information

1. Key fields

The efficiency of order flow depends on the data flow of the information system combined with the commodity flow of the warehouse and express, so there are several key fields to pay attention to and understand in advance.

Where the order flows into the OMS (Order management System), that's where the order comes from. Different sources of order sales channels are different, and some flow is also different, such as orders shipped by a third party, the system needs to pass information according to the open platform, for delivery, logistics and other control is different from self-operated orders.

Different types of orders are processed differently in the OMS system. Some may be cross-node or reverse process. For example, the return order is a process from the user to the merchant. It is more complicated than the forward order, because it needs to obtain the information generated in the forward order flow process and then calculate and process according to the rules.

Warehouse, that is, where the orders should be sent to for operation processing, what standard processes are required for circulation in the warehouse, different warehouses may belong to different branches, and what are the differences in cost accounting? Although we do not pay attention to these information in the early stage of OMS, we must ensure the accuracy of these information. And for some merchants in A warehouse out of stock, may arrange B warehouse delivery that order transfer, not through the way of warehouse transfer, so the order to record the final delivery warehouse.

Payment status, this field is related to payment, different payment methods need to connect to different interfaces, whether the return of the status is timely, and so on. Payment status and order status can be combined into a single field.

Order status, that is, the status of the order on different operational nodes, some information is presented to the user and some is viewed internally. A detailed introduction will follow.

2. Order information

When the order is generated, it simply says that the order information includes basic order information and order product information, and also includes a lot of subsidiary information, such as payment details, associated users, and gift card details used

(1) Basic order information

Order information is the main order table information, I will be divided into order number, order user information, order basic information, payment information, receiving information and logistics information several small parts.

1) Order number: listed separately, we may have questions, here to explain.

Although the order number is only a document number, what kind of format of the number needs to be designed, because some companies order number is year month date + serial number or random number, so there is no problem in the design, because as long as the uniqueness is guaranteed. However, for some companies in order to avoid data leakage (such as friends by order number analysis of daily order volume) some processing in the document number format.

In addition, the order number is a very important field in the flow process. Therefore, if a good OMS system can distribute the flow according to the order number, the operator can also determine the order type or warehouse information based on the order number. Attachment: Amazon China order number format: C01-2442712-9062228; Jd order number: 106697775485; Taobao order number: 786699393282068525

The generation of order numbers needs to be supported by a component. First, it must be able to meet the requirements of the growth of order volume and user concurrency. Secondly, with the growth of data volume, the order table should be split horizontally or vertically for database and table classification, and the data should be distributed storage (if you are interested, please see the Practice of Database and Table Classification of Dianping Order System). We have started the practice of sub-library sub-table project, but for various reasons, the promotion is not smooth, and finally only the single number generator and some service components are online, it is a pity.

2) Basic Information:

Including the main information in addition to the order number such as source, classification, status, ownership, warehouse, etc., because the order table is the largest amount of data in the future, so the design of each field needs to consider its real meaning and whether it can meet the future expansion.

With the passage of time and the rapid change and growth of the business, there are many possibilities in the future that will force you to add fields or define the original fields twice, so that this table must be constantly escaped during the development process, which greatly increases the complexity of the code. Personal is more inclined to predefined a few reserved fields, the pros and cons of everyone in the design to measure it.

3) Payment information:

Payment is mainly for coupons, gift cards, points and discounts used at the order level. When the front-end order enters the settlement page, it will be calculated and recorded according to relevant information. At the same time, it generally follows: order amount - coupon - gift card - points = amount payable; Order amount = order amount + freight amount; Order amount = actual selling price * Quantity of goods sold.