Trial order method and system based on multiple suppliers
By adopting a multi-vendor-based trial order method in the hotel booking system, asynchronously querying the advantageous prices and sorting orders, the problem of high order failure rate in the existing system is solved, and customer experience and corporate income are improved.
Patent Information
- Application Number
- CN202411790057.6
- Authority / Receiving Office
- CN · China
- Patent Type
- Applications(China)
- Current Assignee / Owner
- Filing Date
- 2024-12-06
- Publication Date
- 2025-04-08
- Estimated Expiration
- Not applicable · inactive patent
AI Technical Summary
When placing an order, the existing hotel reservation system fails to create a supplier order due to instability of the supplier system, insufficient inventory or price changes when placing an order, which affects customer experience and corporate income.
Using a multi-supplier trial order method, after obtaining customer orders, asynchronously querying the advantageous prices of all suppliers, and creating supplier orders in sequence according to price range until success.
This greatly reduces the failure rate of creating supplier orders, improves user experience and corporate revenue, and ensures that customers can book hotels successfully, even if some suppliers are priced higher or have no inventory.
Smart Images
Figure CN119784465A_ABST
Abstract
Description
Technical Field
[0001] The invention belongs to the field of hotel reservation, and in particular relates to a trial order method and system based on multiple suppliers. Background Art
[0002] The price and inventory of each supplier are displayed to the client. After the customer selects a supplier's price, he or she immediately places an order with the supplier. The success or failure is determined only by the supplier's system and inventory price data. The common processing method is to only connect to suppliers with good system stability, stable prices, and sufficient inventory, but even so, it is difficult to guarantee the success rate. There is a certain percentage of failure rate, which leads to damage to both customer experience and corporate revenue.
[0003] Due to the stability and timeliness of each supplier's price interface, it is impossible to display the prices of all hotels on the market to users when they query prices. Even if they are displayed to users, when the user selects a supplier's price to place an order, the supplier may be out of stock, the price has changed, or the system has an abnormality, resulting in failure to create the supplier order, resulting in a poor user experience and loss of part of the company's profits. Summary of the invention
[0004] In view of the shortcomings of the prior art, the present invention proposes a method and system for trial orders based on multiple suppliers. The method adopts a method based on trial orders combined with multiple suppliers. After the customer places an order, the supplier order is not created immediately. The advantageous prices of all suppliers are asynchronously queried, and the advantageous prices are sorted according to the magnitude. Orders are created with suppliers in order from the largest magnitude to the smallest magnitude until the order is created successfully. This will greatly reduce the failure rate of order creation.
[0005] In order to achieve the aforementioned object of the invention, the present invention adopts the following scheme: One aspect of the present invention provides a trial order method based on multiple suppliers, comprising: S1: Obtain a customer order from the database that requires creating a supplier order, and perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, hotel room type, and original price; S2: Concurrently query the hotel's prices on all suppliers; S3: based on the price returned by each supplier for the hotel room type and the original price in the customer order, filter out a price that is lower than the original price in the customer order; wherein the original price is the price displayed by the hotel to the customer when the user places the order; S4: creating orders to suppliers in sequence according to the order of the advantageous prices; wherein the advantageous prices may be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, invoice type, and main supplier fields; S5: If the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is created successfully. If the booking fails, the next best price is found according to the advantage margin and then supplier orders are created one by one until all advantageous prices are tried out. If all advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
[0006] In one of the embodiments, idempotency control is performed on the obtained customer orders, further comprising: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with the supplier in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
[0007] In one of the embodiments, the distributed lock is implemented using Redis, and the key of Redis consists of a fixed character and an order number.
[0008] In one of the embodiments, orders are created to suppliers in sequence according to the order of advantageous prices, further comprising: based on the hotel price returned by each supplier, searching for hotels with the same room type and the same service as the customer order created by the user and with a price lower than the original price of the customer order created by the user; based on the hotel price returned by each supplier, screening out hotels with higher room types and better services than the customer order created by the user and with a price lower than the original price in the customer order; and creating orders to suppliers in sequence according to the order of advantageous prices that satisfy the above two conditions.
[0009] One of the embodiments further includes: when creating a supplier order, determining whether the user applies to cancel the customer order.
[0010] Another aspect of the present invention provides a multi-supplier based trial order system, comprising: An order control module is used to obtain a customer order from a database that requires creating a supplier order, and to perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, a hotel room type, and an original price; The first query module is used to concurrently query the prices of the hotel on all suppliers; The first screening module is used to screen out advantageous prices that are lower than the original prices in the customer's order based on the prices returned by each supplier for the hotel room type and the original prices in the customer's order; wherein the original prices are the prices displayed by the hotel to the customer when the user places an order; The first order creation module is used to create orders with suppliers in sequence according to the order of advantageous prices; wherein the advantageous prices can be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, the invoice type, and the main supplier field; if the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is successfully created; if the booking fails, the next best price is found according to the order of the advantage margin and then the supplier orders are created one by one until all the advantageous prices are tried out; if all the advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
[0011] In one of the embodiments, idempotency control is performed on the obtained customer orders, further comprising: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with the supplier in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
[0012] In one of the embodiments, the distributed lock is implemented using Redis, and the key of Redis consists of a fixed character and an order number.
[0013] In one embodiment, the first order creation module further includes: The second query module is used to query the original price of the customer order created by the user for the same room type and the same service according to the hotel price returned by each supplier, and the price is lower than the original price of the customer order created by the user; The second screening module is used to screen out the hotel prices returned by each supplier, which have higher room types and better services than the customer order created by the user, and whose prices are lower than the original prices in the customer order; The second order creation module is used to create orders to suppliers in order of advantageous prices that meet the above two conditions.
[0014] One of the embodiments further includes: a judgment module, which is used to judge whether the user applies to cancel the customer order when creating a supplier order.
[0015] Compared with the prior art, the present invention has at least the following advantages: (1) By obtaining the customer orders that need to create supplier orders in the database and performing idempotence control, it is possible to prevent multiple supplier orders from being created and failing, thereby greatly reducing the proportion of user order failures. Even if some suppliers have increased their prices or are out of stock, it is possible to allow users to successfully create orders to a certain extent, directly increasing the company's profits. (2) In addition, by creating supplier orders and querying the advantageous prices of all suppliers, it is possible to maximize the advantageous prices to a certain extent, increase the gross profit margin of the order, and also increase the company's profits to a certain extent. BRIEF DESCRIPTION OF THE DRAWINGS
[0016] In order to more clearly illustrate the technical solutions in the embodiments of the present invention, the drawings required for use in the embodiments or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are only some embodiments recorded in the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.
[0017] Figure 1 It is a flowchart of a trial order based on multiple suppliers provided in a typical implementation case of the present invention. DETAILED DESCRIPTION
[0018] In order to make the purpose, technical scheme and advantages of the present invention clearer, the specific embodiments of the present invention are described in detail below in conjunction with the accompanying drawings. Examples of these preferred embodiments are illustrated in the accompanying drawings. The embodiments of the present invention shown in the accompanying drawings and described according to the accompanying drawings are merely exemplary, and the present invention is not limited to these embodiments.
[0019] One aspect of the present invention provides a trial order method based on multiple suppliers, comprising: S1: Obtain a customer order from the database that requires creating a supplier order, and perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, hotel room type, and original price; S2: Concurrently query the hotel's prices on all suppliers; S3: based on the price returned by each supplier for the hotel room type and the original price in the customer order, filter out a price that is lower than the original price in the customer order; wherein the original price is the price displayed by the hotel to the customer when the user places the order; S4: creating orders to suppliers in sequence according to the order of the advantageous prices; wherein the advantageous prices may be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, invoice type, and main supplier fields; S5: If the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is created successfully. If the booking fails, the next best price is found according to the advantage margin and then supplier orders are created one by one until all advantageous prices are tried out. If all advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
[0020] In one embodiment, idempotency control is performed on the obtained customer orders, further comprising: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with the supplier in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
[0021] In one embodiment, the distributed lock is implemented using Redis, and the key of Redis consists of a fixed character and an order number.
[0022] In one embodiment, wherein, orders are created with suppliers in sequence according to the advantageous price sorting order, further comprising: based on the hotel price returned by each supplier, searching for the same room type and the same service as the customer order created by the user, and the price being lower than the original price in the customer order created by the user; based on the hotel price returned by each supplier, screening out the room types that are higher in class and have better services than the customer order created by the user, and the price being lower than the original price in the customer order; and creating orders with suppliers in sequence according to the advantageous price sorting order that meets the above two conditions.
[0023] In one embodiment, it further includes: when creating a supplier order, determining whether the user applies to cancel the customer order.
[0024] Another aspect of the present invention provides a multi-supplier based trial order system, comprising: An order control module is used to obtain a customer order from a database that requires creating a supplier order, and to perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, a hotel room type, and an original price; The first query module is used to concurrently query the prices of the hotel on all suppliers; The first screening module is used to screen out advantageous prices that are lower than the original prices in the customer's order based on the prices returned by each supplier for the hotel room type and the original prices in the customer's order; wherein the original prices are the prices displayed by the hotel to the customer when the user places an order; The first order creation module is used to create orders with suppliers in sequence according to the order of advantageous prices; wherein the advantageous prices can be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, the invoice type, and the main supplier field; if the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is successfully created; if the booking fails, the next best price is found according to the order of the advantage margin and then the supplier orders are created one by one until all the advantageous prices are tried out; if all the advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
[0025] In one embodiment, idempotency control is performed on the obtained customer orders, further comprising: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with the supplier in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
[0026] In one embodiment, the distributed lock is implemented using Redis, and the key of Redis consists of a fixed character and an order number.
[0027] In one embodiment, the first order creation module further includes: The second query module is used to query the original price of the customer order created by the user for the same room type and the same service according to the hotel price returned by each supplier, and the price is lower than the original price of the customer order created by the user; The second screening module is used to screen out the hotel prices returned by each supplier, which have higher room types and better services than the customer order created by the user, and whose prices are lower than the original prices in the customer order; The second order creation module is used to create orders to suppliers in order of advantageous prices that meet the above two conditions.
[0028] In one embodiment, it further includes: a judgment module, which is used to judge whether the user applies to cancel the customer order when creating a supplier order.
[0029] Figure 1 The following is a flowchart of a trial order based on multiple suppliers. The specific steps are as follows: S1: Obtain a customer order from the database that requires creating a supplier order, and perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, hotel room type, and original price; S2: Concurrently query the hotel's prices on all suppliers; S3: based on the price returned by each supplier for the hotel room type and the original price in the customer order, filter out a price that is lower than the original price in the customer order; wherein the original price is the price displayed by the hotel to the customer when the user places the order; S4: Create orders to suppliers in sequence according to the order of advantage prices; wherein, the advantage prices can be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, invoice type, and main supplier fields; the sorting algorithm used here is a quick sorting algorithm, which is suitable for sorting more data, so it can withstand sorting and comparison in larger data.
[0030] S5: If the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is created successfully. If the booking fails, the next best price is found according to the advantage margin and then supplier orders are created one by one until all advantageous prices are tried out. If all advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
[0031] It should be understood that although this specification is described according to implementation methods, not every implementation method contains only one independent technical solution. This narrative method of the specification is only for the sake of clarity. Those skilled in the art should regard the specification as a whole. The technical solutions of each embodiment can also be appropriately combined to form other implementation methods that can be understood by those skilled in the art.
Claims
1. A trial order method based on multiple suppliers, characterized in that: The following steps are involved: S1: Obtain a customer order from the database that requires creating a supplier order, and perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, hotel room type, and original price; S2: Concurrently query the hotel's prices on all suppliers; S3: based on the price returned by each supplier for the hotel room type and the original price in the customer order, filter out a price that is lower than the original price in the customer order; wherein the original price is the price displayed by the hotel to the customer when the user places the order; S4: creating orders to suppliers in sequence according to the order of the advantageous prices; wherein the advantageous prices may be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, invoice type, and main supplier fields; S5: If the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is created successfully. If the booking fails, the next best price is found according to the advantage margin and then supplier orders are created one by one until all advantageous prices are tried out. If all advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
2. The method for trial order based on multiple suppliers according to claim 1, characterized in that: Performing idempotency control on the obtained customer orders further includes: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with suppliers in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
3. The method for trial order based on multiple suppliers according to claim 2, characterized in that: in, The distributed lock is implemented using Redis, and the Redis key consists of a fixed string of characters and the order number.
4. The method for trial order based on multiple suppliers according to claim 1, characterized in that: in, Creating orders with suppliers in sequence according to the order of advantageous prices further includes: searching for hotels with the same room type and services as the customer order created by the user and with a price lower than the original price of the customer order created by the user according to the hotel price returned by each supplier; screening out hotels with higher room types and better services than the customer order created by the user and with a price lower than the original price in the customer order according to the hotel price returned by each supplier; and creating orders with suppliers in sequence according to the order of advantageous prices that meet the above two conditions.
5. The method for trial order based on multiple suppliers according to claim 1, characterized in that: When creating a supplier order, determine whether the user applies to cancel the customer order.
6. A trial order system based on multiple suppliers, characterized in that: include: An order control module is used to obtain a customer order from a database that requires creating a supplier order, and to perform idempotence control on the obtained customer order, wherein the customer order includes a hotel name, a hotel room type, and an original price; The first query module is used to concurrently query the prices of the hotel on all suppliers; The first screening module is used to screen out advantageous prices that are lower than the original prices in the customer's order based on the prices returned by each supplier for the hotel room type and the original prices in the customer's order; wherein the original prices are the prices displayed by the hotel to the customer when the user places an order; The first order creation module is used to create orders with suppliers in sequence according to the order of advantageous prices; wherein the advantageous prices can be sorted according to at least one of the supplier settlement price, whether it is a member price, whether it is a group hotel, the invoice type, and the main supplier field; if the current advantageous price is successfully booked with the supplier, it is deemed that the supplier order is successfully created; if the booking fails, the next best price is found according to the order of the advantage margin and then the supplier orders are created one by one until all the advantageous prices are tried out; if all the advantageous prices fail, it is deemed that the supplier order creation for the customer order has failed.
7. The multi-supplier trial order system according to claim 6, characterized in that: Performing idempotency control on the obtained customer orders further includes: obtaining orders for which supplier orders have not been successfully created and have not been attempted to be created with suppliers in the last N minutes, where N is greater than or equal to 1; and performing idempotency control through distributed locks during the process of attempting to create supplier orders.
8. The multi-supplier trial order system according to claim 7, characterized in that: in, The distributed lock is implemented using Redis, and the Redis key consists of a fixed string of characters and the order number.
9. The multi-supplier based trial order system according to claim 6, characterized in that: The first order creation module further includes: The second query module is used to query the original price of the customer order created by the user for the same room type and the same service according to the hotel price returned by each supplier, and the price is lower than the original price of the customer order created by the user; The second screening module is used to screen out the hotel prices returned by each supplier, which have higher room types and better services compared with the customer order created by the user, and the prices are lower than the original prices in the customer order; The second order creation module is used to create orders to suppliers in order of advantageous prices that meet the above two conditions.
10. The multi-supplier based trial order system according to claim 6, characterized in that: The system further includes: a judgment module, which is used to judge whether the user applies to cancel the customer order when creating a supplier order.