Order information and status flow

4) Receiving information:

The order user and the consignee may be different, in order to better improve the user experience, some orders can be booked delivery time, so this part of the information can be listed separately or with ancillary information for protection.

5) Logistics information:

Here, it is necessary to record the express company and logistics order number, and make associated calls with the logistics details.

(2) Order information

This table is the detailed commodity information of the transaction, which naturally includes the basic information of the commodity, and also includes the price and preferential information of the commodity at the time of the transaction, and should also include information about the activities of the commodity in the transaction process.

The commodity information table is the order table, the amount of data is several times or ten times the order table, and some preferential amounts for the order level need to be shared according to the commodity. Since the invoice is based on the product information, pay attention to the tail difference when apportioning the amount; At the same time, when the order is returned or replaced, the amount should be re-amortized according to the goods.

For the reamortization of the return and exchange of goods, it is for the user has enjoyed the order level or product promotion activities, when the return or exchange of goods due to changes in the goods, so that the order level or exchange of goods can no longer enjoy its promotional offers, the need to recalculate the discount amount of the process.

(3) Billing information

(4) Payment details

For payment, it was briefly talked about when the order was generated, and it is emphasized here that the payment details are for various payment methods. As mentioned before, the information involving money can not be sloppy, must be recorded clearly, there must be a transaction serial number (our company or a third party), the process of state change is the payment log.

This part will then enter the financial system for reconciliation of accounts receivable, and it needs to be inspected when a refund occurs. How to design and develop the payment system is not verbose, the official word is to ensure the accuracy and timely data and compensation measures after the occurrence of anomalies; Improve the response time as much as possible at checkout, even 1ms can greatly improve the user experience.

For payment, it is generally carried out according to the parent order, and if the subsequent order is removed, the relevant payment information needs to be associated through the parent order number.

(5) Logistics details

(6) Order attachment form

This part is designed according to the actual business situation, such as the use of gift cards in the order payment process, then you need to record the relationship between the gift card and the order number, and record how much money is used, how much balance is, what time is deducted, these need to be associated with the gift card system to ensure that the amount of the gift under the name of the user is tracked.

Similarly, points payment needs to record how many points are worth how much money when using points payment, how many points are used for this order, and how much point balance the user has.

Again, information related to money should not be sloppy; For other information that needs to be recorded, if it is not convenient or can not be recorded in the order request form or the product list, you can use the additional form. However, be aware that the more subsidiary tables, the code may be complicated, but it may be easier for moving the database to the table.

At this point, even if the decomposition of order information is completed, orders will generally go through dismantling, that is, an order will be divided into different sub-orders, and subsequent orders are carried out according to sub-orders. The following is a review from the perspective of status.

Order status

The status of the order, I have divided it into three parts:

User related status, that is, the user can view the tracked order status changes in my order;

The state of the warehouse/merchant refers to the state generated during the operation of the warehouse or merchant after the order is assigned to it;

Logistics status, that is, after the warehouse/merchant delivery, the relevant status of the parcel delivery to the user sign for receipt.

Below, according to the new to the user sign this complete process to say my understanding.

New: that is, the new order generated after the user selects the product and submits it. Before the order is generated, the inventory judgment of the goods, the preferential activities of the goods, the preferential activities of the orders, and the payment method and billing information selected by the users are generated according to the delivery address selected by the users. For the detailed process, we can refer to the "E-commerce background - Order Generation".

Payment: The user pays the submitted order, then it is necessary to record the details of the payment, after the payment is completed, the order status becomes paid, at this time the order needs to go through several processes from delivery.