Price comparison query method and system based on multiple suppliers

Abstract

The present invention discloses a price comparison query method and system based on multiple suppliers. The method comprises: step S1: accessing the price query interface API corresponding to each supplier according to the definition mode of each supplier's price query interface API; step S2: querying the price of each supplier according to the query interface API, and merging the product strategy with the product price information returned by each supplier's query interface API, pricing the product strategy according to the pricing configuration table, and generating a pricing result; step S3: writing the pricing result back to a cache database; step S4: querying and returning the corresponding pricing data from the cache database according to the user's query request. The present invention not only improves the comparison efficiency and the real-time performance of obtaining advantageous prices, but also helps to enhance user satisfaction and loyalty.

Description

Technical Field

[0001] The present invention belongs to the technical field of information search, and in particular relates to a price comparison query method and system based on multiple suppliers. Background Art

[0002] In the multi-supplier price comparison application scenario, in order to reduce the dependence on a single or certain suppliers, ensure that the system can output prices stably and can show customers prices that are relatively advantageous in the market; at the same time, in order to meet the needs of customers to enjoy promotional member prices and point accumulation when they are bound to members of common hotel group suppliers in the market, it is necessary to be able to connect to more suppliers and obtain different types of relatively advantageous prices from different suppliers.

[0003] A common approach is to purchase products from major suppliers in the market, and then analyze historical sales data to determine which products have relatively good advantages from which suppliers, so as to configure and sell them in a targeted manner. When selling to the outside, the main products are the advantageous suppliers and products obtained through manual comparison and analysis.

[0004] However, when analyzing product price advantages based on historical data, it often takes a lot of time and effort to compare prices and make choices, and it is difficult to achieve accurate analysis, resulting in a certain degree of misjudgment. More importantly, the real-time performance is relatively poor. After product prices change, it is difficult to immediately compare and obtain the latest and most advantageous prices, which prevents users from enjoying more advantageous prices when booking products, resulting in poor user experience and difficulty in reducing dissatisfaction. Summary of the invention

[0005] In view of the shortcomings of the prior art, the present invention adopts a method of integrating after real-time comparison of advantages and disadvantages based on multi-supplier price query. Control query can be performed on products of different suppliers, different brands, different cities and other characteristics. After each supplier returns the product price information, the same products are first merged, and then the price level, supplier service quality, etc. are compared according to the configured conditions to select the advantageous price to display to the user. The query results will be cached in the cache database to improve the performance of users' repeated queries.

[0006] 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 price comparison query method based on multiple suppliers, comprising: step S1: accessing the price query interface API corresponding to each supplier according to the definition method of the price query interface API of each supplier; Step S2: querying the prices of each supplier according to the query interface API, and merging the product strategy with the product price information returned by the query interface API of each supplier, pricing the product strategy according to the pricing configuration table, and generating a pricing result; Step S3: writing the pricing result back to the cache database; Step S4: According to the user's query request, query and return the corresponding pricing data from the cache database.

[0007] Another aspect of the present invention provides a price comparison query system based on multiple suppliers, including: a supplier access module, used to access the price query interface API corresponding to each supplier according to the definition method of the price query interface API of each supplier; A pricing result generation module, used to query the prices of each supplier according to the query interface API, merge the product strategy with the product price information returned by the query interface API of each supplier, price the product strategy according to the pricing configuration table, and generate a pricing result; A result cache module, used for writing the pricing result back to a cache database; The query result feedback module is used to query and return corresponding pricing data from the cache database according to the user's query request.

[0008] Compared with the prior art, the present invention has at least the following advantages: through the integration method of the present invention, users can easily query and compare prices of multiple suppliers, and can quickly obtain the best price according to the user's own characteristics. The present invention not only improves the comparison efficiency and the real-time performance of obtaining advantageous prices, but also helps to enhance user satisfaction and loyalty. BRIEF DESCRIPTION OF THE DRAWINGS

[0009] 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.

[0010] Figure 1 It is a flowchart of a method based on multi-supplier price comparison provided by a typical implementation case of the present invention; Figure 2 It is the product code combined with the product code provided by a typical implementation case of the present invention; Figure 3 It is a code for obtaining the selling price according to the configuration rules provided in a typical implementation case of the present invention. DETAILED DESCRIPTION

[0011] 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.

[0012] One aspect of the present invention provides a price comparison query method based on multiple suppliers, comprising: Step S1: access the price inquiry interface API corresponding to each supplier according to the definition of each supplier's price inquiry interface API; Step S2: querying the prices of each supplier according to the query interface API, and merging the product strategy with the product price information returned by the query interface API of each supplier, pricing the product strategy according to the pricing configuration table, and generating a pricing result; Step S3: writing the pricing result back to the cache database; Step S4: According to the user's query request, query and return the corresponding pricing data from the cache database.

[0013] In one embodiment, the step S2 also includes: constructing a pricing configuration table, wherein the pricing configuration table includes at least the following fields: customer name, supplier type, hotel ID, hotel recommendation level, city type, priority, star rating, brand, pricing type, and added value.

[0014] In one embodiment, the step S2 uses a concurrent query method to query the prices of each supplier, specifically including: using multi-threaded parallel querying of the prices of each supplier, and using Task asynchronous execution technology to put the query operations of N suppliers into the thread pool for asynchronous query, and setting the asynchronous waiting time, and only obtaining the supplier prices returned within the specified time; setting the time limit for each user to query the price of each supplier according to the configuration information to ensure the response time of the user operation.

[0015] In one embodiment, before step S1, the method further includes: defining a set of standard price inquiry interface definitions, wherein the request parameters of the price difference interface include: supplier hotel code, check-in and check-out dates, and member information; and the return parameters of the price inquiry interface include hotel room information, hotel product information, inventory, and price.

[0016] In one embodiment, step S2 also includes, after concurrently querying the prices of all suppliers, merging the same room types and the same policies, specifically: merging the same room type name, the same breakfast score and the cancellation rule, and only outputting the quotation for one room type and one policy; comparing the settlement prices of the same policies to find out the products with settlement price advantages; and pricing the products with settlement price advantages and outputting them to the user.

[0017] Another aspect of the present invention provides a price comparison query system based on multiple suppliers, including: a supplier access module, used to access the price query interface API corresponding to each supplier according to the definition method of the price query interface API of each supplier; A pricing result generation module, used to query the prices of each supplier according to the query interface API, merge the product strategy with the product price information returned by each supplier query interface API, price the product strategy according to the pricing configuration table, and generate a pricing result; A result cache module, used for writing the pricing result back to a cache database; The query result feedback module is used to query and return corresponding pricing data from the cache database according to the user's query request.

[0018] In one embodiment, the system also includes a configuration table building module for building a pricing configuration table, wherein the pricing configuration table includes at least the following fields: customer name, supplier type, hotel id, hotel recommendation level, city type, priority, star rating, brand, pricing type, and added value.

[0019] In one embodiment, the pricing result generation module uses a concurrent query method to query the prices of each supplier, specifically including: using multi-threaded parallel query of each supplier's price, and using Task asynchronous execution technology to put the query operations of N suppliers into the thread pool for asynchronous query, and set the asynchronous waiting time, and only obtain the supplier prices returned within the specified time; set the time limit for each user to query the price of each supplier according to the configuration information to ensure the response time of the user's operation.

[0020] In one embodiment, it also includes a standard price difference interface definition module, which is used to define a set of standard price inquiry interface definitions. The request parameters of the price difference interface include: supplier hotel code, check-in and check-out dates, and member information; the return parameters of the price inquiry interface include hotel room information, hotel product information, inventory, and price.

[0021] In one embodiment, the pricing result generation module also includes merging the same room types and the same policies after concurrently querying the prices of all suppliers, specifically: merging the same room type name, the same breakfast score and cancellation rules, and only outputting the quotation for one room type and one policy; comparing the settlement prices of the same policies to find out the products with settlement price advantages; and pricing the products with settlement price advantages and outputting them to the user.

[0022] Figure 1 It is the main flow chart of the technical solution of the present invention. Figure 1 As shown, the method based on multi-supplier price comparison proposed by the present invention includes the following steps: (1) Create a new pricing configuration table. The configuration table should contain at least the following fields: customer name, supplier type, hotel ID, hotel recommendation level, city type, priority, star rating, brand, pricing type, and added value.

[0023] (2) Define a set of standard price inquiry interface definitions. The request parameters include: supplier hotel code, check-in and check-out dates, and membership information. The return parameters include hotel room information, hotel product information, inventory, price, etc.

[0024] (3) Every time a new supplier is connected, the access to the supplier's price inquiry interface is implemented according to the above interface definition.

[0025] (4) Cache the supplier's room types and products each time you query to reduce QPS calls and improve interface performance.

[0026] (5) After querying all suppliers’ prices concurrently, merge the rooms with the same room types and policies, where: ① Merging principle: The same room type name, same breakfast score and cancellation rules are merged, and only one room type and one policy quotation is output.

[0027] ② Compare the settlement prices of products with the same policy and find out the products with settlement price advantages.

[0028] ③ For products with settlement price advantage, the selling price is determined and output to users.

[0029] Among them, the code implementation of some core functions involved is as follows: (1) Product merger, such as Figure 2 As shown, the core functions of the code are explained: ① Group products according to the number of breakfast portions to make breakfast information unique; ② Find the product with the lowest settlement price in each breakfast group; ③ Use the lowest settlement price product to calculate the selling price according to the pricing rules; ④ Member price and negotiated price products are obtained separately; ⑤ Integrate regular price products, member price products, and negotiated price products and output them together.

[0030] (2) Obtain the selling price according to the configuration rules, such as Figure 3 As shown, the core functions of the code are explained: ① Some customers set their prices based on the selling prices of designated self-operated hotels. If they are such companies, the selling prices of Sike's self-operated hotels will be returned; ② Huazhu Group’s hotels are priced according to the specified pricing logic; ③ The pricing of other hotels will first be based on the refined pricing logic. If there is no match, then the pricing will be based on the batch pricing rules.

[0031] See again Figure 1 The specific implementation process is described as follows: (1) The user initiates a price inquiry request; (2) Determine whether the user has a price cache. If yes, return directly. If not, continue with the following process; (3) Concurrently query the prices of various suppliers; (4) Cache the prices of each supplier so that they can be reused when other users query them; (5) Combine and price the room types and policies returned by all suppliers; (6) Cache the merged room types, policies, etc. for the user's next query; (7) Return the query results.

[0032] The present invention will match the hotel relationships of all suppliers, and then merge the product price information returned by the suppliers according to the breakfast information, and after the merger, the price will be determined mainly based on the configuration rules.

[0033] The implementation process of concurrently querying the prices of each supplier is as follows: (1) Use multi-threaded parallel query of supplier prices, use Task asynchronous execution technology, put the query operations of N suppliers into the thread pool for asynchronous query, and set the asynchronous waiting time to only obtain the supplier prices returned within the specified time; (2) According to the configuration, set a time limit for each customer to check prices at each supplier to ensure the response time of user operations.

[0034] Among them, pricing methods include: (1) Self-purchased hotels directly set prices according to the set prices; (2) Detailed pricing: pricing is based on the configuration of the designated customer and hotel combined with the price returned by the supplier; (3) Bulk pricing: pricing based on hotel star rating, brand / unit, recommendation level, and city; The above three scenarios for setting selling prices are divided into the following processing scenarios: (1) Sequential pricing: Some hotels set prices based on the priority of suppliers in categories A, B, and C; (2) Low-price pricing: pricing is based on the settlement price provided by the supplier; (3) Market price: pricing is based on the selling price provided by the supplier.

[0035] Through the integration method of the present invention, users can easily query and compare prices of multiple suppliers, and quickly obtain the best price according to their own characteristics. This not only improves the comparison efficiency, but also improves the real-time nature of obtaining advantageous prices, and also helps to enhance customer satisfaction and loyalty.

[0036] 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 price comparison query method based on multiple suppliers, characterized in that: include: Step S1: access the price inquiry interface API corresponding to each supplier according to the definition of each supplier's price inquiry interface API; Step S2: querying the prices of each supplier according to the query interface API, and merging the product strategy with the product price information returned by the query interface API of each supplier, pricing the product strategy according to the pricing configuration table, and generating a pricing result; Step S3: writing the pricing result back to the cache database; Step S4: According to the user's query request, query and return the corresponding pricing data from the cache database.

2. The price comparison query method based on multiple suppliers according to claim 1, characterized in that: Before step S2, the method further includes: constructing a pricing configuration table, wherein the pricing configuration table includes at least the following fields: customer name, supplier type, hotel ID, hotel recommendation level, city type, priority, star rating, brand, pricing type, and added value.

3. The price comparison query method based on multiple suppliers according to claim 2 is characterized in that: In step S2, the prices of various suppliers are queried in a concurrent query manner, specifically including: using multi-threaded parallel querying of the prices of various suppliers, and using Task asynchronous execution technology to put the query operations of N suppliers into a thread pool for asynchronous query, and setting the asynchronous waiting time, and only obtaining the supplier prices returned within the specified time; setting the time limit for each user to query the price of each supplier according to the configuration information to ensure the response time of the user operation.

4. The price comparison query method based on multiple suppliers according to claim 1 is characterized in that: Before step S1, the process also includes: defining a set of standard price inquiry interface definitions, wherein the request parameters of the price difference interface include: supplier hotel code, check-in and check-out dates, and member information; and the return parameters of the price inquiry interface include hotel room information, hotel product information, inventory, and price.

5. The price comparison query method based on multiple suppliers according to claim 3 is characterized in that: The step S2 also includes, after concurrently querying the prices of all suppliers, merging the same room types and the same policies, specifically: merging the same room type name, the same breakfast score and the cancellation rule, and only outputting the quotation of one room type and one policy; comparing the settlement prices of the same policy to find out the products with settlement price advantages; and pricing the products with settlement price advantages and outputting them to the user.

6. A price comparison query system based on multiple suppliers, characterized in that: include: The supplier access module is used to access the price inquiry interface API corresponding to each supplier according to the definition method of each supplier's price inquiry interface API; A pricing result generation module, used to query the prices of each supplier according to the query interface API, merge the product strategy with the product price information returned by each supplier query interface API, price the product strategy according to the pricing configuration table, and generate a pricing result; A result cache module, used for writing the pricing result back to a cache database; The query result feedback module is used to query and return corresponding pricing data from the cache database according to the user's query request.

7. The price comparison query system based on multiple suppliers according to claim 6 is characterized in that: It also includes a configuration table building module for building a pricing configuration table, wherein the pricing configuration table includes at least the following fields: customer name, supplier type, hotel ID, hotel recommendation level, city type, priority, star rating, brand, pricing type, and added value.

8. The price comparison query system based on multiple suppliers according to claim 7 is characterized in that: The pricing result generation module uses a concurrent query method to query the prices of each supplier, specifically including: using multi-threaded parallel query of each supplier's price, and using Task asynchronous execution technology to put the query operations of N suppliers into the thread pool for asynchronous query, and set the asynchronous waiting time, and only obtain the supplier prices returned within the specified time; set the time limit for each user to query the price of each supplier according to the configuration information to ensure the response time of the user operation.

9. The price comparison query system based on multiple suppliers according to claim 6, characterized in that: It also includes a standard price difference interface definition module, which is used to define a set of standard price inquiry interface definitions. The request parameters of the price difference interface include: supplier hotel code, check-in and check-out dates, and member information; the return parameters of the price inquiry interface include hotel room information, hotel product information, inventory, and price.

10. The price comparison query method based on multiple suppliers according to claim 8, characterized in that: The pricing result generation module also includes merging the same room types and the same policies after concurrently querying the prices of all suppliers, specifically: merging the same room type name, the same breakfast score and the cancellation rule, and only outputting the quotation for one room type and one policy; comparing the settlement prices of the same policies to find out the products with settlement price advantages; and pricing the products with settlement price advantages and outputting them to the user.

Images