Over-sale processing method, system and device for web shopping mall, and medium

Abstract

The invention discloses an oversell processing method, system and device for a web shopping mall, and a medium. The method comprises the following steps: storing inventory information of commodities in the web shopping mall; performing alarm processing based on real-time monitoring on the commodities in the Web shopping mall according to the inventory information; commodity inventory locking processing is carried out according to the order placing condition of the user for the commodities in the Web shopping mall; commodity purchase limitation processing is carried out according to the order placing condition of the user for the commodities in the Web shopping mall; according to the method, the algorithm and the component can be comprehensively applied, the overselling problem of the Web shopping mall system is effectively solved, the system performance, stability and reliability are improved, the user experience and satisfaction degree are improved, the defects in the prior art are overcome, and the method has high application value and popularization prospects.

Description

Technical Field

[0001] The present invention relates to the field of computer technology, and in particular to a method, system, device and medium for processing overselling in a web mall. Background Art

[0002] At present, with the rapid development of computer technology and Internet technology, overselling problem is a common and serious challenge in the Web shopping mall system, as follows: (1) When a user places an order to purchase a product, there may be a synchronization delay in the inventory information of the Web mall system, which may result in a product being sold out but still available for order. Furthermore, the current front-end cache mechanism may cause the inventory quantity on the user side to be inconsistent with the actual inventory, resulting in overselling. (2) When there is a high concurrency of flash sales or special offers, traditional solutions may not be able to effectively handle the situation where a large number of users are rushing to buy the same product at the same time, which may easily lead to overselling; (3) Traditional database transaction processing mechanisms may have loopholes and cannot fully guarantee the atomicity of order submission and inventory deduction, thus leading to overselling; (iv) Network delays and asynchronous requests may result in users failing to obtain the latest inventory information in a timely manner when placing an order, thus leading to overselling; In summary, the traditional operation management solutions in the Web mall system have many shortcomings in dealing with overselling problems. Overselling may also lead to order errors, inventory confusion and customer dissatisfaction; therefore, a more reliable and efficient solution is needed to ensure the normal operation of the Web mall. Summary of the invention

[0003] The object of the present invention is to provide a method, system, device and medium for overselling processing in a web mall, thereby solving all or one of the above problems existing in the prior art.

[0004] In order to solve the above technical problems, the specific technical solutions of the present invention are as follows: In one aspect, the present invention provides a method for handling overselling in a web mall, comprising the following steps: Inventory management initialization: Store the inventory information of the products in the Web mall; To conduct inventory monitoring: Performing alarm processing based on real-time monitoring on the commodities in the Web mall according to the inventory information; Transaction lock control: Locking the inventory of goods according to the order of the goods in the web mall by the user; To purchase current limit: Commodity purchase restrictions are implemented based on the user's ordering of commodities in the Web mall.

[0005] As an improved solution, the storage of inventory information of commodities in the Web mall includes: A MySQL database is used to store the product information, order information and inventory information of the products in the Web mall.

[0006] As an improved solution, the storage of inventory information of commodities in the Web mall further includes: Redis or Memcached is used to cache the product information and inventory information of the products in the Web mall.

[0007] As an improved solution, the delisting of the commodities in the Web mall based on real-time monitoring according to the inventory information includes: Setting an inventory threshold for products in the Web mall; In response to the inventory information of the commodities in the Web mall being lower than the inventory threshold, an alarm notification process is performed.

[0008] As an improved solution, the commodity inventory locking process is performed according to the order situation of the user for the commodities in the Web mall, including: In response to a first user placing an order for a first product in the Web mall, before generating order information for the first product, ordering authority for the first product for users other than the first user is disabled.

[0009] As an improved solution, the commodity purchase restriction processing according to the user's order situation for commodities in the Web mall includes: In response to a first user placing an order for a first product in the Web mall, limiting the purchase quantity of the first product by the first user within a first time period.

[0010] As an improved solution, the product inventory locking process according to the user's order for the products in the Web mall further includes: Redis distributed lock is used to implement the commodity inventory locking process.

[0011] On the other hand, the present invention also provides an overselling processing system for a web mall, comprising: The inventory management initialization module is used to store the inventory information of the products in the Web mall; The inventory monitoring module is used to: perform alarm processing based on real-time monitoring of the commodities in the Web mall according to the inventory information; The transaction lock control module is used to: lock the inventory of commodities according to the order of the commodities in the Web mall by the user; The purchase flow limiting module is used to: perform commodity purchase restriction processing according to the user's order situation for commodities in the Web mall.

[0012] On the other hand, the present invention further provides a computer-readable storage medium, on which a computer program is stored, and when the computer program is executed by a processor, the steps of the overselling processing method of the web mall are implemented.

[0013] On the other hand, the present invention further provides a computer device, comprising a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other via the communication bus; wherein: The memory is used to store computer programs; The processor is used to execute the steps of the overselling processing method of the web mall by running the program stored in the memory.

[0014] The beneficial effects of the technical solution of the present invention are: The overselling processing method of the web mall described in the present invention can realize the comprehensive application of algorithms and components, effectively solve the overselling problem of the web mall system, improve system performance, stability and reliability, enhance user experience and satisfaction, make up for the defects of the prior art, and have high application value and promotion prospects.

[0015] The oversold processing system of the web mall described in the present invention can realize the comprehensive application of algorithms and components through the mutual cooperation of the inventory management initialization module, the inventory monitoring module, the transaction locking control module and the purchase current limiting module, effectively solve the oversold problem of the web mall system, improve the system performance, stability and reliability, enhance the user experience and satisfaction, make up for the defects of the existing technology, and have high application value and promotion prospects.

[0016] The computer-readable storage medium of the present invention can guide the inventory management initialization module, the inventory monitoring module, the transaction lock control module and the purchase current limiting module to cooperate, thereby realizing the oversold processing method of the web mall of the present invention, and the computer-readable storage medium of the present invention also effectively improves the operability of the oversold processing method of the web mall.

[0017] The computer device of the present invention can store and execute the computer-readable storage medium, thereby realizing the overselling processing method of the web mall of the present invention. BRIEF DESCRIPTION OF THE DRAWINGS

[0018] In order to more clearly illustrate the specific implementation methods of the present invention or the technical solutions in the prior art, the drawings required for use in the specific implementation methods or the description of the prior art will be briefly introduced below. Obviously, the drawings described below are some implementation methods of the present invention. For ordinary technicians in this field, other drawings can be obtained based on these drawings without paying creative work.

[0019] Figure 1 It is a flowchart of the overselling processing method of the web mall described in Example 1 of the present invention; Figure 2 It is a detailed flow chart of the overselling processing method of the web mall described in Example 1 of the present invention; Figure 3 It is a schematic diagram of the architecture of the overselling processing system of the web mall according to the second embodiment of the present invention; Figure 4 is a schematic diagram of the structure of the computer device described in Example 4 of the present invention; The symbols in the accompanying drawings are explained as follows: 1501, processor; 1502, communication interface; 1503, memory; 1504, communication bus. DETAILED DESCRIPTION

[0020] The preferred embodiments of the present invention are described in detail below in conjunction with the accompanying drawings so that the advantages and features of the present invention can be more easily understood by those skilled in the art, thereby making a clearer and more definite definition of the protection scope of the present invention.

[0021] In the description of the present invention, it should be noted that the embodiments described in the present invention are only part of the embodiments of the present invention, rather than all of the embodiments; based on the embodiments in the present invention, all other embodiments obtained by ordinary technicians in the field without making creative work are within the scope of protection of the present invention.

[0022] The terms "first", "second", etc. in the specification and claims of this article and the above-mentioned drawings are used to distinguish similar objects, and are not necessarily used to describe a specific order or sequence. It should be understood that the data used in this way can be interchanged where appropriate, so that the embodiments of this article described here can be implemented in an order other than those illustrated or described here. In addition, the terms "including" and "having" and any variations thereof are intended to cover non-exclusive inclusions, for example, a process, method, device, product or equipment that includes a series of steps or units is not necessarily limited to those steps or units clearly listed, but may include other steps or units that are not clearly listed or inherent to these processes, methods, products or equipment. Example 1

[0023] This embodiment provides a method for handling overselling in a web mall. Figure 1 and Figure 2 As shown, the following steps are included: S100, Inventory Management Initialization: In this step, a reliable inventory management system is established to store and manage the inventory information of the products in the Web mall to ensure the consistency and reliability of the data; In one implementation, a Mysql database is used to store product information, order information, and inventory information. It should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention. In one implementation, a cache system such as Redis or Memcached is used to cache product information and inventory information, thereby improving the performance and response speed of inventory management. It should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0024] S200, inventory monitoring: In this step, an inventory monitoring system is established to monitor the inventory of goods in the Web mall in real time to facilitate timely handling of emergencies; In one implementation, a stock threshold is set for each commodity. When the stock of a commodity is lower than the preset stock threshold, an alarm is sent to notify the management terminal or management personnel to handle it in time. It should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention. In one implementation, a monitoring and alarm system is used to monitor the operating status and inventory status of the Web mall system and complete alarm notification operations in emergency situations. It should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0025] S300, transaction lock control: In this step, the product inventory is locked according to the user's order situation, thereby preventing the inventory quantity from being inconsistent with the quantity displayed on the user end; In one implementation, in response to a user placing an order, the inventory of the corresponding product is locked before the order is generated, and after the locking, other users are prohibited from placing orders / purchasing the corresponding product and inventory at the same time; it should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention; In one implementation, a Redis distributed lock is used to implement the transaction locking mechanism, thereby ensuring that the inventory can be correctly locked when multiple nodes operate simultaneously. It should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0026] S400, purchase flow limit: In this step, product purchase operations are restricted based on the user's order situation to prevent overselling caused by frequent orders; In one implementation, a flow control mechanism is set up, and in response to a user placing an order, this mechanism is used to limit the number of goods purchased by the user within a certain time period or a short period of time, thereby preventing malicious users from causing overselling problems by placing orders frequently; it should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention. Example 2

[0027] This embodiment is based on the same inventive concept as the method for handling oversold items in a web mall described in Embodiment 1, and provides a system for handling oversold items in a web mall, such as Figure 3 As shown, including: The inventory management initialization module is used to establish a reliable inventory management system to store and manage the inventory information of the products in the Web mall to ensure the consistency and reliability of the data; In one implementation, the inventory management initialization module uses a MySQL database to store product information, order information, and inventory information; it should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention; In one implementation, the inventory management initialization module uses a cache system such as Redis or Memcached to cache product information and inventory information, thereby improving the performance and response speed of inventory management; it should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0028] The inventory monitoring module is used to establish an inventory monitoring system to monitor the inventory of goods in the Web mall in real time to facilitate timely handling of emergencies; In one implementation, the inventory monitoring module sets an inventory threshold for each commodity inventory. When the inventory of a commodity is lower than the preset inventory threshold, an alarm is sent to notify the management terminal or management personnel to handle it in time. It should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention. In one implementation, the inventory monitoring module uses a monitoring and alarm system to monitor the operating status and inventory status of the Web mall system and complete alarm notification operations in emergency situations; it should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0029] The transaction lock control module is used to lock the commodity inventory according to the user's order situation, thereby preventing the inventory quantity from being inconsistent with the quantity displayed on the user end; In one implementation, the transaction lock control module responds to a user placing an order and locks the inventory of the corresponding product before the order is generated. After locking, other users are prohibited from placing orders / purchasing the corresponding product and inventory at the same time. It should be noted that the examples here are only for explaining the present invention and cannot limit the protection scope of the present invention. In one implementation, the transaction lock control module uses a Redis distributed lock to implement the above-mentioned transaction lock mechanism, thereby ensuring that the inventory can be correctly locked when multiple nodes operate simultaneously; it should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention.

[0030] The purchase flow limiting module is used to limit the purchase of goods according to the user's order situation to prevent overselling caused by frequent orders; In one implementation, the purchase current limiting module sets a current limiting control mechanism, and in response to a user's order, uses this mechanism to limit the number of goods purchased by the user within a certain time period or a short period of time, thereby preventing malicious users from causing overselling problems by placing orders frequently; it should be noted that the examples here are only for explaining the present invention and cannot limit the scope of protection of the present invention. Example 3

[0031] This embodiment provides a computer-readable storage medium, including: The storage medium is used to store computer software instructions used to implement the oversold processing method for the web mall described in the above-mentioned embodiment 1, which includes a program for executing the above-mentioned program set for the oversold processing method for the web mall; specifically, the executable program can be built into the oversold processing system for the web mall described in the embodiment 2, so that the oversold processing system for the web mall can implement the oversold processing method for the web mall described in the embodiment 1 by executing the built-in executable program.

[0032] In addition, the computer-readable storage medium of this embodiment may adopt any combination of one or more computer-readable storage media, wherein the computer-readable storage medium includes electrical, optical, electromagnetic, infrared or semiconductor systems, devices or components, or any combination thereof. Example 4

[0033] This embodiment provides an electronic device, such as Figure 4As shown, the electronic device may include: a processor 1501 , a communication interface 1502 , a memory 1503 and a communication bus 1504 , wherein the processor 1501 , the communication interface 1502 , and the memory 1503 communicate with each other via the communication bus 1504 .

[0034] Memory 1503, used for storing computer programs; The processor 1501 is used to implement the steps of the overselling processing method of the web mall described in the above embodiment 1 when executing the computer program stored in the memory 1503.

[0035] As an embodiment of the present invention, the communication bus mentioned in the above terminal can be a Peripheral Component Interconnect (PCI) bus or an Extended Industry Standard Architecture (EISA) bus. The communication bus can be divided into an address bus, a data bus, a control bus, etc. For ease of representation, Figure 4 Only one thick line is used in the diagram, but this does not mean that there is only one bus or only one type of bus.

[0036] As an implementation mode of the present invention, the communication interface is used for communication between the above-mentioned terminal and other devices.

[0037] As an embodiment of the present invention, the memory may include a random access memory (RAM) or a non-volatile memory, such as at least one disk memory. Optionally, the memory may also be at least one storage device located away from the aforementioned processor.

[0038] As an embodiment of the present invention, the above-mentioned processor can be a general-purpose processor, including a central processing unit (CPU), a network processor (NP), etc.; it can also be a digital signal processor (DSP), an application specific integrated circuit (ASIC), a field programmable gate array (FPGA) or other programmable logic devices, discrete gates or transistor logic devices, discrete hardware components.

[0039] Different from the prior art, the present application provides a method, system, device and medium for overselling processing in a web mall, which can effectively solve the overselling problem of the web mall system through the comprehensive application of algorithms and components, improve system performance, stability and reliability, enhance user experience and satisfaction, make up for the defects of the prior art, and have high application value and promotion prospects.

[0040] It should be understood that in the various embodiments of this document, the size of the serial numbers of the above-mentioned processes does not mean the order of execution. The execution order of each process should be determined by its function and internal logic, and should not constitute any limitation on the implementation process of the embodiments of this document.

[0041] It should also be understood that in the embodiments of this article, the term "and / or" is only a description of the association relationship of the associated objects, indicating that three relationships may exist. For example, A and / or B can represent: A exists alone, A and B exist at the same time, and B exists alone. In addition, the character " / " in this article generally indicates that the associated objects before and after are in an "or" relationship.

[0042] Those of ordinary skill in the art will appreciate that the units and algorithm steps of each example described in conjunction with the embodiments disclosed herein can be implemented in electronic hardware, computer software, or a combination of the two. In order to clearly illustrate the interchangeability of hardware and software, the composition and steps of each example have been generally described in terms of function in the above description. Whether these functions are performed in hardware or software depends on the specific application and design constraints of the technical solution. Professional and technical personnel can use different methods to implement the described functions for each specific application, but such implementation should not be considered to be beyond the scope of this article.

[0043] Those skilled in the art can clearly understand that, for the convenience and brevity of description, the specific working processes of the systems, devices and units described above can refer to the corresponding processes in the aforementioned method embodiments and will not be repeated here.

[0044] In the several embodiments provided herein, it should be understood that the disclosed systems, devices and methods can be implemented in other ways. For example, the device embodiments described above are only schematic, for example, the division of the units is only a logical function division, and there may be other division methods in actual implementation, such as multiple units or components can be combined or integrated into another system, or some features can be ignored or not executed. In addition, the mutual coupling or direct coupling or communication connection shown or discussed can be an indirect coupling or communication connection through some interfaces, devices or units, or can be electrical, mechanical or other forms of connection.

[0045] The units described as separate components may or may not be physically separated, and the components shown as units may or may not be physical units, that is, they may be located in one place or distributed on multiple network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the embodiments of this article.

[0046] In addition, each functional unit in each embodiment of this invention may be integrated into one processing unit, or each unit may exist physically separately, or two or more units may be integrated into one unit. The above integrated unit may be implemented in the form of hardware or in the form of software functional unit.

[0047] If the integrated unit is implemented in the form of a software functional unit and sold or used as an independent product, it can be stored in a computer-readable storage medium. Based on this understanding, the technical solution of this article is essentially or the part that contributes to the prior art, or all or part of the technical solution can be embodied in the form of a software product, and the computer software product is stored in a storage medium, including a number of instructions to enable a computer device (which can be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the method described in each embodiment of this article. The aforementioned storage medium includes: U disk, mobile hard disk, read-only memory (ROM, Read-Only Memory), random access memory (RAM, Random Access Memory), disk or optical disk and other media that can store program codes.

[0048] The above descriptions are merely embodiments of the present invention and are not intended to limit the patent scope of the present invention. Any equivalent structure or equivalent process transformation made using the contents of the present invention specification and drawings, or directly or indirectly applied in other related technical fields, are also included in the patent protection scope of the present invention.

Claims

1. A method for handling overselling in a web mall, characterized in that: The following steps are involved: Inventory management initialization: Store the inventory information of the products in the Web mall; To conduct inventory monitoring: Performing alarm processing based on real-time monitoring on the commodities in the Web mall according to the inventory information; Transaction lock control: Locking the inventory of goods according to the order of the goods in the web mall by the user; To purchase current limit: Commodity purchase restrictions are implemented based on the user's ordering of commodities in the Web mall.

2. The overselling processing method of the web mall according to claim 1, characterized in that: The storing of inventory information of commodities in the Web mall includes: A MySQL database is used to store the product information, order information and inventory information of the products in the Web mall.

3. The overselling processing method of the web mall according to claim 1, characterized in that: The storing of inventory information of commodities in the Web mall further includes: Redis or Memcached is used to cache the product information and inventory information of the products in the Web mall.

4. The overselling processing method of the web mall according to claim 1 is characterized by: The removing of the commodities in the Web mall from shelves based on the real-time monitoring according to the inventory information includes: Setting an inventory threshold for products in the Web mall; In response to the inventory information of the commodities in the Web mall being lower than the inventory threshold, an alarm notification process is performed.

5. The overselling processing method of the web mall according to claim 1 is characterized by: The product inventory locking process according to the user's order for the products in the Web mall includes: In response to a first user placing an order for a first product in the Web mall, before generating order information for the first product, ordering authority for the first product for users other than the first user is disabled.

6. The overselling processing method of a web mall according to claim 1, characterized in that: The commodity purchase restriction processing according to the order situation of the user for the commodities in the Web mall includes: In response to a first user placing an order for a first product in the Web mall, limiting the purchase quantity of the first product by the first user within a first time period.

7. The overselling processing method of a web mall according to claim 5, characterized in that: The product inventory locking process according to the user's order for the product in the Web mall also includes: Redis distributed lock is used to implement the commodity inventory locking process.

8. A web mall overselling processing system, characterized in that: include: The inventory management initialization module is used to store the inventory information of the products in the Web mall; An inventory monitoring module, used to: perform alarm processing based on real-time monitoring of the commodities in the Web mall according to the inventory information; The transaction lock control module is used to: lock the inventory of commodities according to the order of the commodities in the Web mall by the user; The purchase flow limiting module is used to: perform commodity purchase restriction processing according to the user's order situation for commodities in the Web mall.

9. A computer-readable storage medium, characterized in that: The computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the steps of the overselling processing method of the web mall described in any one of claims 1 to 7 are implemented.

10. A computer device, characterized in that: It includes a processor, a communication interface, a memory and a communication bus, wherein the processor, the communication interface and the memory communicate with each other through the communication bus; wherein: The memory is used to store computer programs; The processor is used to execute the steps of the overselling processing method of the web mall according to any one of claims 1 to 7 by running the program stored in the memory.

Images