CN108416656B - High-availability inventory management method, server and high-availability inventory management system - Google Patents

High-availability inventory management method, server and high-availability inventory management system Download PDF

Info

Publication number
CN108416656B
CN108416656B CN201810202413.6A CN201810202413A CN108416656B CN 108416656 B CN108416656 B CN 108416656B CN 201810202413 A CN201810202413 A CN 201810202413A CN 108416656 B CN108416656 B CN 108416656B
Authority
CN
China
Prior art keywords
inventory
server
type
operation request
stock
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201810202413.6A
Other languages
Chinese (zh)
Other versions
CN108416656A (en
Inventor
朱杰
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shanghai Bilibili Technology Co Ltd
Original Assignee
Shanghai Bilibili Technology Co Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Shanghai Bilibili Technology Co Ltd filed Critical Shanghai Bilibili Technology Co Ltd
Priority to CN201810202413.6A priority Critical patent/CN108416656B/en
Publication of CN108416656A publication Critical patent/CN108416656A/en
Application granted granted Critical
Publication of CN108416656B publication Critical patent/CN108416656B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions
    • G06Q30/0601Electronic shopping [e-shopping]
    • G06Q30/0605Supply or demand aggregation
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • G06Q10/0875Itemisation or classification of parts, supplies or services, e.g. bill of materials

Landscapes

  • Business, Economics & Management (AREA)
  • Engineering & Computer Science (AREA)
  • Accounting & Taxation (AREA)
  • Finance (AREA)
  • Economics (AREA)
  • Marketing (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Physics & Mathematics (AREA)
  • General Business, Economics & Management (AREA)
  • General Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Human Resources & Organizations (AREA)
  • Operations Research (AREA)
  • Quality & Reliability (AREA)
  • Tourism & Hospitality (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention provides a high-availability inventory management method and a server, namely a high-availability inventory management system. The high availability inventory management method comprises the following steps: receiving an inventory operation request of a commodity; judging the inventory type corresponding to the inventory operation request; updating the stock of the stock type according to the stock operation request; and recording the inventory operation. By adopting the high-availability inventory management method provided by the invention, the inventory of the relevant inventory types of the commodities can be automatically updated based on the inventory operation request sent to the server by the user or the merchant, the problem of over-selling or under-selling can be effectively avoided, and the consistency of inventory data is ensured, so that a better shopping experience is provided for the user, and a more efficient inventory management method is provided for the merchant.

Description

High-availability inventory management method, server and high-availability inventory management system
Technical Field
The invention relates to the technical field of internet, in particular to a high-availability inventory management method, a server and a high-availability inventory management system.
Background
With the coming of the internet climax, online shopping has become the most popular new shopping mode. Through online shopping, a user can go home and can immediately become a capsule commodity by only lightly clicking a mouse or an intelligent terminal screen. The online shopping brings convenient shopping experience, rich commodity varieties and preferential purchase price to people, and therefore the online shopping becomes a choice of more and more users. However, with the expansion and development of e-commerce platforms, the online shopping experience becomes an important standard for measuring the goodness and badness of an e-commerce. However, in the online shopping process, in addition to the merchant service, the commodity quality and the logistics service, the inventory management of the e-commerce platform can also affect the online shopping experience of the user.
At present, the inventory type related to the inventory management system of the e-commerce platform is single, and the management mode mainly includes that a merchant displays available inventory of commodities through a commodity detail page, so that a user can know whether the current commodities can be purchased and the maximum quantity of the current commodities. For this reason, the inventory management system often causes problems, such as: 1) under the scene of high concurrency of killing second, due to the fact that ordering and inventory reduction are not in the same transaction, the problem of 'over-selling' and 'under-selling' of commodities is solved; 2) and the problem of inconsistent operation inventory data in the multi-service scene, such as inconsistent actual inventory in a warehouse and inconsistent inventory data browsed by a user. Based on the above problems, the purchasing experience of the user is often influenced, and the management of the merchant on the commodity inventory is also not facilitated.
Therefore, it is desirable to provide a more optimized high-availability inventory management method, server and high-availability inventory management system. The inventory of the commodities is subdivided, and the inventory quantity of the inventory type associated with the operation type is adjusted based on inventory operation requests of different operation types sent to the server by the user and/or the merchant through the user side. In addition, the phenomena of over-selling and under-selling of commodities and the problem that a plurality of clients simultaneously make inventory operation requests on the server can be effectively avoided, and therefore the problem that actual inventory of a warehouse is inconsistent with inventory data browsed by the users is solved.
Disclosure of Invention
In order to solve the technical defects, the invention provides a more optimized high-availability inventory management method, a server and a high-availability inventory management system. The inventory of the commodities is subdivided, and the inventory quantity of the inventory type associated with the operation type is adjusted based on inventory operation requests of different operation types sent to the server by the user and/or the merchant through the user side. In addition, the high-availability inventory management method, the server and the high-availability inventory management system further combine the setting of pessimistic locks and unique combined index fields, effectively avoid the problems of over-selling and under-selling of commodities, and simultaneously effectively avoid inventory operation requests of a plurality of user terminals on the server at the same time, thereby solving the problem that the actual inventory of a warehouse is inconsistent with the inventory data browsed by the users. The online shopping experience is more optimized for the user, and the inventory management experience is more efficient for the merchant.
The invention provides a high-availability inventory management method, which comprises the following steps:
receiving an inventory operation request of a commodity;
judging the inventory type corresponding to the inventory operation request;
updating the stock of the stock type according to the stock operation request;
and recording the inventory operation.
Preferably, the step of receiving an inventory operation request of a product further includes:
acquiring the total inventory of the commodities;
calling a pessimistic database lock to lock the total inventory;
removing repeated request contents containing the same index field through an interface for receiving the inventory operation request;
the index field includes: operation type, operation number, order number, commodity number and commodity type.
Preferably, the step of determining the inventory type corresponding to the inventory operation request further includes:
according to the operation type in the request content, identifying an inventory type associated with the operation type;
wherein the inventory types include: saleable inventory, frozen inventory, ex-warehouse inventory, physical inventory.
Preferably, the step of updating the stock quantity of the stock type according to the stock operation request further includes:
extracting the operation quantity in the inventory operation request;
and updating the stock of the stock type according to the operation quantity and in combination with the stock type.
Preferably, the high availability inventory management method further comprises:
reading the available inventory of the goods;
judging whether the available inventory is larger than a preset inventory or not;
and when the available inventory is less than or equal to the preset inventory, sending out early warning information.
Preferably, the step of recording the inventory operation further comprises:
and recording one or more of operation inventory type, operation time, operation quantity, order number, commodity number and commodity type of the inventory operation.
The invention provides a high-availability inventory management method, which is applied between a server and a user side, wherein the server and the user side execute the high-availability inventory management method.
The invention provides a server comprising a processor and a storage device, wherein the storage device stores a computer program, and the processor calls and executes the computer program to realize the high-availability inventory management method.
The invention provides a high-availability inventory management system, which comprises a server and a user side, wherein the server and the user side execute the high-availability inventory management method.
After the technical scheme is adopted, compared with the prior art, the method has the following beneficial effects:
1. subdividing commodity inventory, and adjusting inventory of inventory types related to operation types based on inventory operation requests of different operation types sent to a server by a user and/or a merchant through a user side;
2. the pessimistic lock and the unique combined index field are further combined, so that the problems of 'over-selling' and 'under-selling' of the commodities are effectively avoided;
3. inventory operation requests of a plurality of clients on the server at the same time can be effectively avoided;
4. the repeated sending of inventory operation requests by users or merchants can be effectively avoided;
5. the online shopping experience is more optimized for the user, and the inventory management experience is more efficient for the merchant.
Drawings
FIG. 1 is a flow chart of a method for high availability inventory management consistent with an embodiment of the present invention;
FIG. 2 is a flow chart of a method for high availability inventory management, consistent with an embodiment of the present invention.
Detailed Description
The advantages of the invention are further illustrated in the following description of specific embodiments in conjunction with the accompanying drawings.
Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The implementations described in the exemplary embodiments below are not intended to represent all implementations consistent with the present disclosure. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present disclosure, as detailed in the appended claims.
The terminology used in the present disclosure is for the purpose of describing particular embodiments only and is not intended to be limiting of the disclosure. As used in this disclosure and the appended claims, the singular forms "a," "an," and "the" are intended to include the plural forms as well, unless the context clearly indicates otherwise. It should also be understood that the term "and/or" as used herein refers to and encompasses any and all possible combinations of one or more of the associated listed items.
The application of the invention will be described in detail with respect to specific embodiments.
Example one
Referring to fig. 1, a flow chart of a high availability inventory management method according to an embodiment of the invention is shown. As shown in the figure, the high-availability inventory management method provided in this embodiment can automatically update the inventory of the relevant inventory types of the commodities based on the inventory operation request sent by the user to the server, and can effectively avoid the problem of over-selling or under-selling, thereby providing a more efficient inventory management method for the e-commerce merchants. Specifically, the method comprises the following steps:
when a user purchases goods on an e-commerce platform, the possible operations performed by the user on the server of the e-commerce platform include: submitting an order, paying a subscription, completing payment, canceling payment, etc. Whatever the operation described above, it may have an impact on the inventory of the e-commerce platform merchant. After the user sends the operation instruction to the server through the user side, the server can convert the operation instruction into an inventory operation request for receiving a pair of commodities.
In a preferred embodiment, after the server receives the inventory operation request sent by the user terminal, the server further automatically retrieves the total inventory of the product. Wherein the total inventory is the sum of the saleable inventory, the frozen inventory and the ex-warehouse inventory. And after the total inventory is obtained, the server calls a pessimistic database lock to lock the total inventory, and based on the locking state, the server does not respond when receiving inventory operation requests sent by any other users, until the server completes the response to the inventory operation request, the total inventory of the commodity can not release the locking state. Therefore, the problem of inconsistent inventory information caused by data loss, update and dirty reading due to the fact that a plurality of users request to operate the total inventory of the commodity at the same time under high concurrency can be effectively avoided. In addition, the interface in the server for receiving the inventory operation request can remove repeated request contents containing the same index field according to the preset united unique index field. Wherein the index field includes: operation type, operation quantity, order number, commodity type and other parameters. Therefore, the server can effectively ensure the idempotent of the interface, and the user side is prevented from sending repeated requests to the server based on a single order, so that the server deducts the inventory of the commodity for many times, and the inventory is disordered.
Based on the steps, the server reads the operation type of the inventory operation request sent by the user, and judges the inventory type associated with the inventory operation request. The operation type is judged by the server according to the operation content actually executed to the server by the user through the user side. For example, if the user submits an order for purchasing 10 items a to the server through the user terminal, the submitted order is the operation type of the inventory operation request. For another example, if the user completes the payment operation for purchasing 10 items of merchandise a at one time to the server, the completed payment operation is the operation type of the inventory operation request. The server can judge the inventory type associated with the operation type based on the operation type related to the received inventory operation request. The inventory types described in this embodiment may include: total inventory, saleable inventory, frozen inventory, ex inventory, and physical inventory. The sellable inventory is in particular sellable inventory. The frozen stock is the stock quantity from the time when the user submits the order to the server through the user terminal to the time when the payment is finished. For example, if a user submits an order for 10 items of merchandise a for an e-commerce item a, then 10 items of merchandise a are frozen stock of the item a before the user completes payment for the order. The physical inventory is the current actual inventory of the warehouse, and the physical inventory comprises genuine commodities and damaged commodities. Therefore, the server can judge the stock types associated with the operation types as saleable stock and frozen stock based on the operation types of the orders submitted by the users; the server can judge the inventory type associated with the operation type as frozen inventory and ex-warehouse inventory based on the operation type of the payment operation completed by the user. Therefore, the server can identify the inventory type associated with the operation type of the inventory operation request according to the operation type contained in the request content of the inventory operation request.
In addition, the server further responds to the inventory operation request by combining the inventory type obtained by the judgment of the server based on the operation quantity included in the inventory operation request sent by the client so as to update the inventory of the inventory type.
Specifically, in a preferred embodiment, if the inventory operation request sent from the user to the server through the user end is to submit an order for purchasing 10 commodities a, the server determines that the inventory types associated with the submitted order are saleable inventory and frozen inventory, and if the number of operations involved in the inventory operation request read by the server is 10, the server may automatically decrease the inventory of 10 commodities in the saleable inventory and increase the inventory of 10 commodities in the frozen inventory to complete the update of the saleable inventory and the frozen inventory, and the total inventory of the commodities a is not changed.
In a preferred embodiment, if the inventory operation request sent from the user to the server through the user terminal is an order for completing payment of 10 commodities a, the server determines that the inventory type associated with the payment completion is frozen inventory and ex-warehouse inventory, and reads that the number of operations involved in the inventory operation request is 10, then the server may automatically reduce the inventory of 10 commodities in the frozen inventory, and simultaneously increase the inventory of 10 commodities in the ex-warehouse inventory to complete the update of the inventory of the frozen inventory and the ex-warehouse inventory, and the total inventory of the commodities a is not changed.
In a preferred embodiment, if the inventory operation request sent from the user to the server through the user end is that payment of 10 commodities a is not completed within a preset time period and the order is automatically cancelled, the server determines that the inventory type associated with the operation type not completed by payment is the saleable inventory and the ex-warehouse inventory, and the server reads that the number of operations involved in the inventory operation request is 10, the server can automatically reduce the inventory of 10 commodities in the out-warehouse inventory and increase the inventory of 10 commodities in the saleable inventory to complete updating of the saleable inventory and the ex-warehouse inventory, and the total inventory of the commodities a is unchanged.
Preferably, the inventory management method provided by this embodiment further includes reading the available inventory of the product in real time, and comparing the available inventory obtained by reading with a preset inventory. When the server judges that the available stock is smaller than or equal to a preset stock, the server judges that the over-selling condition possibly occurs, the server refuses to respond to a stock operation request for submitting an order sent by a user, and simultaneously automatically sends out early warning information to the user and an e-commerce merchant, so that the over-selling problem of the commodities is effectively avoided.
When the server completes the automatic update of the inventory type corresponding to the inventory operation request according to the inventory operation request sent by the user through the user side, the server automatically further records the inventory operation executed for responding to the inventory operation request. In order to facilitate the e-commerce merchant to further refer to the inventory operation record, all information of the inventory operation request is recorded in the record, so that the e-commerce merchant can clearly know the inventory change condition and reason. Specifically, the record may include one or more of an operation inventory type, an operation time, an operation quantity, an order number, a commodity number, and a commodity type of the inventory operation request. It can be understood that the contents and items recorded in the operation records can be further increased or decreased according to the actual needs of the e-commerce merchants.
Example two
Fig. 2 is a flow chart of a method for managing high availability inventory, in accordance with an embodiment of the present invention. As shown in the figure, the high-availability inventory management method provided in this embodiment can automatically update the inventory of the relevant inventory types of the commodities based on the inventory operation request sent by the e-commerce merchant to the server, thereby providing a more efficient inventory management method for the e-commerce merchant. Specifically, the method comprises the following steps:
when the e-commerce merchant sells goods, the possible operations performed on the server of the e-commerce platform by the user end include: purchasing and warehousing, returning and warehousing, confirming and delivering goods, canceling delivery goods, checking loss and delivery, checking excess and warehousing and the like. Whatever the above operation, the stock of the goods sold by the merchant is affected. After the merchant sends the operation instruction to the server through the user side, the server can convert the operation instruction into an inventory operation request of a pair of commodities.
In a preferred embodiment, after the server receives the inventory operation request sent by the e-commerce merchant through the user terminal, the further server automatically retrieves the total inventory of the commodity. Wherein the total inventory is the sum of the saleable inventory, the frozen inventory and the ex-warehouse inventory information. After the total inventory is obtained, the server calls a pessimistic database lock to lock the total inventory, and based on the locking state, the server does not respond when receiving inventory operation requests sent by any other users, until the server completes the response of the inventory operation requests sent by the merchant, the total inventory of the commodity can not be unlocked. Therefore, the problem that inventory information is inconsistent due to data loss, updating and dirty reading caused by the fact that the merchant and the user simultaneously request to operate the total inventory of the commodity can be effectively avoided. After the total inventory of the commodity is locked, the interface in the server for receiving the inventory operation request can remove repeated request contents containing the same index field according to the preset united unique index field. Wherein the index field includes: operation type, operation quantity, order number, commodity type and other parameters. Therefore, the server can effectively guarantee the idempotent of the interface, and the phenomenon that the E-commerce merchant sends repeated requests to the server through the user side is avoided, so that the server adjusts the inventory of commodities for many times, and the inventory is disordered.
Based on the above steps, further, the server reads the operation type of the inventory operation request sent by the merchant, and judges the inventory type corresponding to the inventory operation request. The operation type is judged by the server according to the operation content actually executed to the server by the user through the user side. For example, the merchant sends an operation confirming that 10 items a are sent out to the server through the user terminal, and then confirms that the sending is the operation type of the operation request. For another example, if the merchant cancels the shipping operation of 10 items of the article a from the server, the cancellation of shipping is the operation type of the operation request. Further, the inventory types in this embodiment include: total inventory, saleable inventory, frozen inventory, ex inventory, and physical inventory. The sellable inventory is specifically sellable inventory. The frozen stock is the stock quantity from the time when the user submits the order to the server through the user terminal to the time when the payment is finished. For example, the merchant sends a shipment confirmation for 10 items of merchandise a to the server through the client, and the inventory operation request for confirming the shipment affects the current actual inventory of the warehouse, so the server identifies the inventory type associated with the confirmation shipment operation type as the actual inventory. Therefore, the server can identify the inventory type corresponding to the request operation according to the operation type contained in the request content in the inventory operation request.
After the server identifies the inventory type corresponding to the inventory request operation, the server can respond to the inventory operation request sent by the merchant through the user terminal and update the inventory of the corresponding inventory type based on the operation quantity contained in the inventory operation request.
In a preferred embodiment, after the merchant sends an inventory operation request for confirming shipment to the server through the user terminal, the server identifies the inventory type associated with the confirmed shipment as physical inventory based on the operation type for confirming shipment, and further, in combination with the operation quantity involved in the inventory operation request, for example, 10 items a, the server automatically responds to the inventory operation request sent by the merchant, and deducts the inventory quantity of the 10 items in the physical inventory to complete the update of the inventory quantity of the item a.
In a preferred embodiment, after the merchant sends an inventory operation request for canceling shipment to the server through the user terminal, the server identifies the inventory type associated with canceling shipment as physical inventory and available inventory based on the operation type for canceling shipment, and further combines the operation quantity involved in the inventory operation request, for example, 10 items a, then the server automatically responds to the inventory operation request sent by the merchant, and simultaneously increases the inventory amounts of the 10 items in the available inventory and the physical inventory to complete the update of the inventory amount of the item a.
In a preferred embodiment, after the merchant sends an inventory operation request for inventory shortage to the server through the user side, the server identifies the inventory types associated with inventory shortage to be saleable inventory, physical inventory and ex-warehouse inventory based on the operation types of inventory shortage, further combines the operation number related to the inventory operation request, for example, 10 commodities a, and then the server automatically responds to the inventory operation request sent by the merchant, reduces the inventory of 10 commodities for saleable inventory, reduces the inventory of 10 commodities for physical inventory, and increases the inventory of 10 commodities in the out-warehouse inventory at the same time, so as to complete the update of the inventory of the commodity a.
In a preferred embodiment, after the merchant sends an inventory operation request of a purchase warehouse to the server through the user terminal, the server identifies the inventory type associated with the purchase warehouse as a saleable inventory and an entity inventory based on the operation type of the purchase warehouse, and further combines the operation quantity related in the inventory operation request, for example, 10 commodities a, the server automatically responds to the inventory operation request sent by the merchant, and increases the inventory quantity of the 10 commodities in the saleable inventory and the entity inventory at the same time, so as to complete the update of the inventory quantity of the commodity a. Further, when the server responds to the inventory operation request, the server may further determine the type of the commodity related to the inventory operation request for purchasing and warehousing, and the commodity type may specifically include a good and a defective product. When the server judges that the commodity type is a genuine commodity, the 10-piece inventory in the saleable inventory and the physical inventory is increased simultaneously. When the server judges that the commodity types are the genuine commodity and the defective commodity, only the stock quantity of the genuine commodity in the saleable stock and the physical stock is increased simultaneously.
In a preferred embodiment, after the merchant sends an inventory operation request of a returned warehouse to the server through the user terminal, the server identifies the inventory types associated with the returned warehouse as warehouse-out inventory, saleable inventory and physical inventory based on the operation type of the returned warehouse, and further combines the operation quantity related to the inventory operation request, for example, 10 commodities a, the server automatically responds to the inventory operation request sent by the merchant, reduces the 10 inventory in the warehouse-out inventory, and increases the 10 inventory in the saleable inventory and the physical inventory at the same time, so as to complete the update of the inventory of the commodity a. Further, when the server responds to the inventory operation request, the server may further determine the type of the goods related to the inventory operation request of the returned and warehoused goods, and the type of the goods may specifically include genuine goods and defective goods. When the server judges that the commodity type is a genuine commodity, the 10-piece inventory in the saleable inventory and the physical inventory is increased simultaneously. When the server judges that the commodity types are the genuine commodity and the defective commodity, only the stock quantity of the genuine commodity in the saleable stock and the physical stock is increased simultaneously.
In a preferred embodiment, after the merchant sends an inventory operation request of the inventory filling warehouse to the server through the user side, the server identifies the inventory type associated with the inventory filling warehouse as the saleable inventory and the physical inventory based on the operation type of the inventory filling warehouse, and further combines the operation quantity related to the inventory operation request, for example, 10 commodities a, the server automatically responds to the inventory operation request sent by the merchant, and simultaneously increases the 10 stocks in the saleable inventory and the physical inventory to complete the inventory quantity update of the commodities a. Further, when the server responds to the inventory operation request, the server may further determine the type of the goods related to the inventory operation request of the returned and warehoused goods, and the type of the goods may specifically include genuine goods and defective goods. When the server judges that the commodity type is a genuine commodity, the 10-piece inventory in the saleable inventory and the physical inventory is increased simultaneously. When the server judges that the commodity types are the genuine commodity and the defective commodity, only the stock quantity of the genuine commodity in the saleable stock and the physical stock is increased simultaneously.
And after the server completes the automatic updating of the inventory type corresponding to the inventory operation request according to the inventory operation request sent by the merchant through the user side, the server automatically further records the inventory operation executed for responding to the inventory operation request. In order to facilitate the e-commerce merchant to further refer to the inventory operation record, all information of the inventory operation request is recorded in the record, so that the e-commerce merchant can clearly know the inventory change condition and reason. Specifically, the record may include one or more of an operation inventory type, an operation time, an operation quantity, an order number, a commodity number, and a commodity type of the inventory operation request. It can be understood that the contents and items recorded in the operation records can be further increased or decreased according to the actual needs of the e-commerce merchants.
In summary, when the high-availability inventory management method, the server and the high-availability inventory management system provided by the invention are used for managing the inventory of the goods, the inventory type of the goods can be subdivided. And adjusting the inventory quantity of the inventory type associated with the operation type based on inventory operation requests of different operation types sent by the user and/or the merchant to the server through the user side. In addition, the pessimistic lock and the unique combined index field can be further combined, the problems of over-selling and under-selling of commodities are effectively avoided, and meanwhile, inventory operation requests of a plurality of user sides on the server can be effectively avoided, so that the problem that actual inventory of a warehouse is inconsistent with inventory data browsed by the users is solved. Therefore, the high-availability inventory management method, the server and the high-availability inventory management system provided by the invention provide a more optimized online shopping experience for users, and also provide a more efficient inventory management experience for merchants.
It should be noted that the embodiments of the present invention have been described in terms of preferred embodiments, and not by way of limitation, and that those skilled in the art can make modifications and variations of the embodiments described above without departing from the spirit of the invention.

Claims (8)

1. A method for managing highly available inventory, comprising the steps of:
receiving an inventory operation request of a commodity;
judging the inventory type corresponding to the inventory operation request;
updating the stock of the stock type according to the stock operation request;
recording the inventory operation;
wherein, in the step of judging the inventory type corresponding to the inventory operation request, the method further comprises the following steps:
identifying an inventory type associated with the operation type according to the operation type contained in the request content in the inventory operation request; wherein the operation types include: submitting an order, completing payment, canceling payment, purchasing and warehousing, returning and warehousing, confirming and shipping, canceling shipping, checking loss and leaving warehouse and checking excess and warehousing, wherein the inventory types comprise: available inventory, frozen inventory, ex-warehouse inventory, and physical inventory;
specifically, the step of identifying the inventory type associated with the operation type further includes:
identifying the inventory type associated with the submitted order as saleable inventory and frozen inventory;
identifying inventory types associated with completing payment as frozen inventory and ex-warehouse inventory;
identifying the inventory type associated with the unpaid as saleable inventory and ex-warehouse inventory;
identifying an inventory type associated with the confirmed shipment as physical inventory;
identifying inventory types associated with the cancellation of the shipment as physical inventory and saleable inventory;
identifying inventory types associated with disqualified ex inventory as saleable inventory, physical inventory and ex inventory;
identifying the inventory types associated with the procurement warehousing as saleable inventory and physical inventory;
identifying the inventory types associated with returned inventory as ex-warehouse inventory, saleable inventory and physical inventory;
identifying the inventory types associated with the inventory of inventory overbooking as saleable inventory and physical inventory.
2. The high availability inventory management method of claim 1,
the step of receiving an inventory operation request of a product further includes:
acquiring the total inventory of the commodities;
calling a pessimistic database lock to lock the total inventory;
removing repeated request contents containing the same index field through an interface for receiving the inventory operation request;
the index field includes: operation type, operation number, order number, commodity number and commodity type.
3. The high availability inventory management method of claim 1,
in the step of updating the stock quantity of the stock type according to the stock operation request, the method further includes:
extracting the operation quantity in the inventory operation request;
and updating the stock of the stock type according to the operation quantity and in combination with the stock type.
4. The high availability inventory management method of claim 1,
the high availability inventory management method further comprises:
reading the available inventory of the goods;
judging whether the available inventory is larger than a preset inventory or not;
and when the available inventory is less than or equal to the preset inventory, sending out early warning information.
5. The high availability inventory management method of claim 1,
in the step of recording the inventory operation, the method further comprises:
and recording one or more of operation inventory type, operation time, operation quantity, order number, commodity number and commodity type of the inventory operation.
6. A high availability inventory management method, characterized in that the high availability inventory management method is applied between a server and a user side, the server and the user side perform the high availability inventory management method according to any one of claims 1-5.
7. A server comprising a processor and a storage device, the storage device storing a computer program, wherein the processor implements the high availability inventory management method of any one of claims 1-5 when the computer program is invoked and executed.
8. A high availability inventory management system, characterized in that the high availability inventory management system comprises a server and a client, the server and the client perform the high availability inventory management method according to any one of claims 1-5.
CN201810202413.6A 2018-03-12 2018-03-12 High-availability inventory management method, server and high-availability inventory management system Active CN108416656B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201810202413.6A CN108416656B (en) 2018-03-12 2018-03-12 High-availability inventory management method, server and high-availability inventory management system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201810202413.6A CN108416656B (en) 2018-03-12 2018-03-12 High-availability inventory management method, server and high-availability inventory management system

Publications (2)

Publication Number Publication Date
CN108416656A CN108416656A (en) 2018-08-17
CN108416656B true CN108416656B (en) 2021-07-13

Family

ID=63131277

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201810202413.6A Active CN108416656B (en) 2018-03-12 2018-03-12 High-availability inventory management method, server and high-availability inventory management system

Country Status (1)

Country Link
CN (1) CN108416656B (en)

Families Citing this family (7)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110659517A (en) * 2019-08-30 2020-01-07 深圳壹账通智能科技有限公司 Data verification method and device, computer equipment and storage medium
CN110738340B (en) * 2019-09-06 2022-04-19 口碑(上海)信息技术有限公司 Reserved product inventory management method and device
CN112785214B (en) * 2019-11-07 2024-06-18 北京沃东天骏信息技术有限公司 Inventory optimizing method, device and storage medium
CN113762865A (en) * 2021-01-06 2021-12-07 北京京东乾石科技有限公司 Inventory information processing method and device
CN113610417A (en) * 2021-08-13 2021-11-05 北京沃东天骏信息技术有限公司 Data processing method, device, computer system and storage medium
CN114331667B (en) * 2021-12-02 2023-02-10 上海金仕达软件科技有限公司 Method and system for preventing precious metal of bank from being over-bought and over-sold
CN117333104A (en) * 2023-09-27 2024-01-02 上海百胜软件股份有限公司 Inventory synchronization method and device, electronic equipment and storage medium

Family Cites Families (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103455334A (en) * 2013-09-10 2013-12-18 天津点点科技发展有限公司 Invoicing system based on PHP-MySQL technology
CN105096065B (en) * 2014-04-16 2019-08-20 阿里巴巴集团控股有限公司 A kind of inventory reduces method and apparatus
CN106203894A (en) * 2015-04-30 2016-12-07 阿里巴巴集团控股有限公司 The processing method of the inventory information of merchandise items and system
CN106599018A (en) * 2016-10-20 2017-04-26 乐视控股(北京)有限公司 Inventory operation method and system
CN107767104A (en) * 2017-11-10 2018-03-06 小草数语(北京)科技有限公司 Commodity inventory control information system, method and e-commerce platform

Also Published As

Publication number Publication date
CN108416656A (en) 2018-08-17

Similar Documents

Publication Publication Date Title
CN108416656B (en) High-availability inventory management method, server and high-availability inventory management system
TWI668653B (en) Commodity object information processing method and system
US7181418B1 (en) Internet customer service method and system
US6397226B1 (en) System and method for inventory control based on inventory aging
US20120173308A1 (en) Optimizing package delivery using social networks
US20110264555A1 (en) Method and system for providing feature to temporarily hold one-of-a-kind merchandise in an online shopping cart
US20010005833A1 (en) Product distribution system and method for providing information to customer in context of such system
US20130151381A1 (en) Multiple-retailer internet sales system and method
CN105279682B (en) Method and device for processing transaction information of commodity object
WO2012047240A1 (en) Method and system for excess inventory management
US20120011023A1 (en) Computer systems manufacturing method and apparatus
KR101640568B1 (en) Method Of Mediating Rental Service For Goods And System Thereof
JP2002041842A (en) Electronic mediation service and price determination for selling/buying article
CN110322276A (en) Rebating data processing method, device, computer equipment and storage medium
KR101094619B1 (en) Shopping mall apparatus and method that blogger participates
US20050065864A1 (en) Loan management system loan management apparatus and loan management method corresponding to security evaluation
CN112308681B (en) Inventory processing method and device, electronic equipment and storage medium
CN114170010A (en) Matching transaction method and device, electronic equipment and storage medium
US20100191618A1 (en) Centralized database supported electronic catalog and order system for merchandise distribution
CN111860890A (en) Sales management method and equipment
JP7339687B2 (en) Product delivery method, system and recording medium based on space station
CN112215544B (en) Method for secondary commodity transaction, mobile terminal and computer storage medium
CN109559068B (en) Network transaction method, network transaction platform and storage equipment thereof
JP7339688B2 (en) Space station-based product resale method, system and recording medium
JP2001312658A (en) Commodity circulation system, and method for providing information to customer in the system

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant