CN113762818A - Article information storage method and device, electronic equipment and storage medium - Google Patents

Article information storage method and device, electronic equipment and storage medium Download PDF

Info

Publication number
CN113762818A
CN113762818A CN202010544545.4A CN202010544545A CN113762818A CN 113762818 A CN113762818 A CN 113762818A CN 202010544545 A CN202010544545 A CN 202010544545A CN 113762818 A CN113762818 A CN 113762818A
Authority
CN
China
Prior art keywords
price
target
information
level
inventory
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.)
Pending
Application number
CN202010544545.4A
Other languages
Chinese (zh)
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.)
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information Technology Co Ltd
Original Assignee
Beijing Jingdong Century Trading Co Ltd
Beijing Wodong Tianjun Information 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 Beijing Jingdong Century Trading Co Ltd, Beijing Wodong Tianjun Information Technology Co Ltd filed Critical Beijing Jingdong Century Trading Co Ltd
Priority to CN202010544545.4A priority Critical patent/CN113762818A/en
Publication of CN113762818A publication Critical patent/CN113762818A/en
Pending legal-status Critical Current

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
    • 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
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/22Indexing; Data structures therefor; Storage structures
    • G06F16/2282Tablespace storage structures; Management thereof
    • 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/02Marketing; Price estimation or determination; Fundraising
    • G06Q30/0283Price estimation or determination
    • G06Q30/0284Time or distance, e.g. usage of parking meters or taximeters

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Theoretical Computer Science (AREA)
  • Development Economics (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • Economics (AREA)
  • Finance (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • General Business, Economics & Management (AREA)
  • Operations Research (AREA)
  • Tourism & Hospitality (AREA)
  • Quality & Reliability (AREA)
  • Human Resources & Organizations (AREA)
  • Software Systems (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • Game Theory and Decision Science (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The invention discloses a storage method and device of article information, electronic equipment and a storage medium, and relates to the technical field of computers. One embodiment of the method comprises: receiving an article identification and target article information of a target article; determining a target storage mode corresponding to the target object according to the target object information; if the target storage mode is time-period price level storage, inquiring a data storage file corresponding to the target item according to the target storage mode and the item identification; and storing the target article information into a data storage file corresponding to the target article. This embodiment can solve the problem that the price of an item in the stock system needs to be changed frequently for an item whose price has a time-dimensional change, the operation is frequent, and the load of data processing of the stock system is increased.

Description

Article information storage method and device, electronic equipment and storage medium
Technical Field
The present invention relates to the field of computer technologies, and in particular, to a method and an apparatus for storing article information, an electronic device, and a storage medium.
Background
Currently, in inventory systems, inventory information is typically stored for a fixed price for an individual item and for the overall inventory. In this manner, since each item is stored at a fixed price, the price of the item does not change.
In the process of implementing the invention, the inventor finds that at least the following problems exist in the prior art:
the storage mode of the item information in the inventory system is only suitable for some items with prices and not constantly changing inventory, and is not suitable for some items with time dimension change in price. For example, the price of the tickets for holidays such as scenic spots and the like can float with the price of the tickets at ordinary times, and the price of the goods can change along with the time, so that the price of the goods in the inventory system needs to be changed frequently, the goods information in the inventory system can meet the requirement of price change, the operation is frequent, and the data processing burden of the inventory system is increased.
Disclosure of Invention
In view of this, embodiments of the present invention provide a method, an apparatus, a system, and a storage medium for storing item information, which can solve the problems that for an item whose price has a time-dimension change, the price of the item in an inventory system needs to be changed frequently, the operation is frequent, and the load of data processing of the inventory system is increased.
To achieve the above object, according to an aspect of an embodiment of the present invention, there is provided a storage method of article information.
The article information storage method of the embodiment of the invention comprises the following steps: receiving an article identification and target article information of a target article; determining a target storage mode corresponding to the target item according to the target item information, wherein the storage mode comprises time-period price level storage, and the time-period price level storage corresponding item information comprises price information and stock information of a plurality of different time periods within a preset time length; if the target storage mode is the time-period price level storage, inquiring a data storage file corresponding to the target item according to the target storage mode and the item identification; and storing the target article information to a data storage file corresponding to the target article.
In one embodiment, if the target storage mode is time-interval price level storage, the target item information includes price information and stock quantity of the target item at different time intervals within a preset time length, and the data storage file includes a price stock level storage file and a time-interval price level storage file corresponding to the target item;
the storing the target article information to the data storage file corresponding to the target article includes:
determining the lowest price and total inventory information of the target object in a preset time according to the price information and the inventory of the target object in different time periods in the preset time;
storing the minimum price and the total stock information into the price stock level storage file;
and storing the price information and the stock quantity of the target object in different time periods within a preset time length to the time period price level storage file.
In yet another embodiment, the preset time period comprises at least two consecutive first-stage time periods, the first-stage time periods comprise a plurality of second-stage time periods, and the price information and the stock level of the target item at different time periods within the preset time period comprise the price information and the stock level of the target item at each second-stage time period; the time period price level storage files comprise a first time period price level storage file and a second time period price level storage file;
the step of storing the price information and the stock of the target object in different time periods within a preset time length to the time period price level storage file comprises the following steps:
for each first-stage time period, determining the lowest price and the total inventory information of the first-stage time period according to the price information and the inventory quantity of the target object in each second-stage time period, and storing the lowest price and the total inventory information of the first-stage time period into a first-stage time period price level storage file;
and storing the price information and the stock quantity of the target object in each second time period into the second-stage time period price level storage file.
In another embodiment, the determining a target storage mode corresponding to the target item according to the target item information includes:
judging whether the target article information comprises a time parameter or not;
if so, determining that the target storage mode corresponding to the target article is time-interval price level storage;
if not, determining that the target storage mode corresponding to the target item is sku (Stock Keeping Unit) price Stock level storage, wherein the sku price Stock level storage corresponding item information comprises fixed price and Stock information of the item.
In another embodiment, after the storing the target item information to the data storage file corresponding to the target item, the method further includes:
receiving an inquiry request sent by a display terminal, wherein the inquiry request comprises an item identifier of the target item and inquiry request information;
determining a target storage mode corresponding to the target object according to the query request information;
according to the target storage mode corresponding to the target object and the query request information, querying data corresponding to the query request from a data storage file corresponding to the object identifier;
and sending the data corresponding to the query request to the display terminal.
In another embodiment, after the storing the target item information to the data storage file corresponding to the target item, the method further includes:
receiving order information corresponding to the target object;
and updating the stock in the data storage file according to the order information.
To achieve the above object, according to another aspect of the present invention, there is provided an article information storage device.
An article information storage device according to the present invention includes: the receiving unit is used for receiving the object identification and the object information of the object; the determining unit is used for determining a target storage mode corresponding to the target item according to the target item information, wherein the storage mode comprises time-period price level storage, and the time-period price level storage corresponding item information comprises price information and stock information of a plurality of different time periods within a preset time length; the query unit is used for querying a data storage file corresponding to the target item according to the target storage mode and the item identifier if the target storage mode is the time-period price level storage; and the storage unit is used for storing the target article information to a data storage file corresponding to the target article.
In one embodiment, if the target storage mode is time-interval price level storage, the target item information includes price information and stock quantity of the target item at different time intervals within a preset time length, and the data storage file includes a price stock level storage file and a time-interval price level storage file corresponding to the target item;
the storage unit is specifically configured to:
determining the lowest price and total inventory information of the target object in a preset time according to the price information and the inventory of the target object in different time periods in the preset time;
storing the minimum price and the total stock information into the price stock level storage file;
and storing the price information and the stock quantity of the target object in different time periods within a preset time length to the time period price level storage file.
In yet another embodiment, the preset time period comprises at least two consecutive first-stage time periods, the first-stage time periods comprise a plurality of second-stage time periods, and the price information and the stock level of the target item at different time periods within the preset time period comprise the price information and the stock level of the target item at each second-stage time period; the time period price level storage files comprise a first time period price level storage file and a second time period price level storage file;
the storage unit is specifically configured to:
for each first-stage time period, determining the lowest price and the total inventory information of the first-stage time period according to the price information and the inventory quantity of the target object in each second-stage time period, and storing the lowest price and the total inventory information of the first-stage time period into a first-stage time period price level storage file;
and storing the price information and the stock quantity of the target object in each second time period into the second-stage time period price level storage file.
In another embodiment, the determining unit is specifically configured to:
judging whether the target article information comprises a time parameter or not;
if so, determining that the target storage mode corresponding to the target article is time-interval price level storage;
if not, determining that the target storage mode corresponding to the target item is sku price stock level storage, wherein the sku price stock level storage corresponding item information comprises fixed price and stock information of the item.
In another embodiment, the receiving unit is further configured to receive an inquiry request sent by a display terminal, where the inquiry request includes an item identifier of the target item and inquiry request information;
the determining unit is further configured to determine a target storage mode corresponding to the target item according to the query request information;
the query unit is further configured to query, according to a target storage mode corresponding to the target item and the query request information, data corresponding to the query request from a data storage file corresponding to the item identifier;
the device further comprises:
and the sending unit is used for sending the data corresponding to the query request to the display terminal.
In another embodiment, the receiving unit is further configured to receive order information corresponding to the target item;
the device further comprises:
and the updating unit is used for updating the stock in the data storage file according to the order information.
To achieve the above object, according to still another aspect of an embodiment of the present invention, there is provided an electronic apparatus.
An electronic device of an embodiment of the present invention includes: one or more processors; the storage device is used for storing one or more programs, and when the one or more programs are executed by the one or more processors, the one or more processors realize the storage method of the article information provided by the embodiment of the invention.
To achieve the above object, according to still another aspect of an embodiment of the present invention, there is provided a computer-readable medium.
A computer-readable medium of an embodiment of the present invention stores thereon a computer program, which, when executed by a processor, implements a storage method of article information provided by an embodiment of the present invention.
One embodiment of the above invention has the following advantages or benefits: in the embodiment of the invention, the storage mode comprises time period price level storage, and the article information corresponding to the time period price level storage can comprise price information and stock information of a plurality of different time periods within preset time length; after receiving the object identifier of the target object and the target object information, determining a target storage mode corresponding to the target object according to the target object information; for the target item stored in the target storage mode in the time period price level, target item information, that is, price information and stock of the target item in different time periods within a preset time period, may be stored in the data storage file corresponding to the target item. Therefore, when the target storage mode is time-interval price level storage, the price information of the target article in a plurality of different time intervals in the preset time interval can be stored, the requirement that the price information of the target article in the preset time interval can be changed in price is met, the article information does not need to be changed frequently, the operation is simple, and the burden of data processing is reduced.
Further effects of the above-mentioned non-conventional alternatives will be described below in connection with the embodiments.
Drawings
The drawings are included to provide a better understanding of the invention and are not to be construed as unduly limiting the invention. Wherein:
FIG. 1 is a schematic diagram of one configuration of an inventory system according to an embodiment of the invention;
fig. 2 is a schematic view of a main flow of a storage method of item information according to an embodiment of the present invention;
fig. 3 is a schematic view of still another main flow of a storage method of item information according to an embodiment of the present invention;
FIG. 4 is a block diagram of a sku level price and inventory table according to an embodiment of the invention;
FIG. 5 is a block diagram of a date level price and inventory table according to an embodiment of the present invention;
FIG. 6 is a block diagram of a time-level price and inventory table according to an embodiment of the invention;
FIG. 7 is a schematic diagram of a main flow of a method of pre-empting inventory according to an embodiment of the invention;
FIG. 8 is a schematic diagram of sku level prices and inventory in the inventory table, according to an embodiment of the invention;
FIG. 9 is a schematic diagram of sku level prices and pre-emption of inventory in the inventory tables, according to an embodiment of the invention;
FIG. 10 is a schematic diagram of sku level prices and inventory deductions in an inventory table, according to an embodiment of the present invention;
FIG. 11 is a schematic diagram of sku level pricing and stock recall in the stock table, in accordance with an embodiment of the present invention;
FIG. 12 is a schematic illustration of return data according to an embodiment of the invention;
fig. 13 is a schematic diagram of the main units of a storage apparatus of item information according to an embodiment of the present invention;
FIG. 14 is a diagram of yet another exemplary system architecture to which embodiments of the present invention may be applied;
FIG. 15 is a schematic block diagram of a computer system suitable for use in implementing embodiments of the present invention.
Detailed Description
Exemplary embodiments of the present invention are described below with reference to the accompanying drawings, in which various details of embodiments of the invention are included to assist understanding, and which are to be considered as merely exemplary. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.
It should be noted that the embodiments and features of the embodiments may be combined with each other without conflict.
Embodiments of the present invention provide an inventory system, in which item information of each item, for example, price information and inventory information of the item, may be stored. Specifically, the inventory system may include three modules, which are a data input module, a data storage module, and a data output module. The data input module is mainly used for providing interface service for the outside, writing operation of article information and data arrangement of the article information. The data storage module is mainly responsible for storing data, and can respectively store the article information in different data storage files according to different storage modes. The data output module provides data input interface service for the outside and mainly provides data reading operation.
Since price information of some items may fluctuate over time, the storage of item information in the embodiments of the present invention may be divided into different storage modes. In embodiments of the present invention, the storage modes may include sku price stock level storage and slot price level storage. The sku price stock level stores the price information of the items in the corresponding item information as a fixed price, and the change of the price along with time cannot be reflected. The time period price level stores the price information of a plurality of different time periods in the preset time length corresponding to the price information of the articles, and the change of the price along with the time can be reflected. The preset duration can be formed by connecting a plurality of different time periods, and the size of the preset duration can be set according to a specific scene, for example, the preset duration can be one week. According to the embodiment of the invention, the preset time length can be divided into a plurality of different time periods in the preset time length, and the preset time length can be divided according to the price change trend of the articles.
For different storage modes, different data storage files are established in the embodiment of the invention so as to store the article information of different storage modes. For sku price inventory level storage, only fixed price and inventory information for the item needs to be stored, so only one data storage file, namely a price inventory level storage file, such as sku level price and inventory tables, is typically required. For the period price level storage, price information and inventory information of a plurality of different time periods within a preset time period of an article need to be stored, so a price inventory level storage file and a time period price level storage file are usually needed, the price inventory level storage file is used for storing the total price and the total inventory information of the article, and the time period price level storage file is used for storing the price and the inventory information of the article corresponding to each time period. The overall price in embodiments of the invention may be the lowest price for the item.
In order to store the price information of the item with finer granularity, for the item whose storage mode is the time period price level, the time period in the preset time period may be divided into a plurality of levels. Specifically, the preset time period may include at least two consecutive first-stage time periods, and the first-stage time period may include a plurality of consecutive second-stage time periods. For example, taking the preset duration as one week, the first-stage time period may be divided into time periods according to days, and the second-stage time period may be divided into time periods according to hours, for example, one day is taken as one first-stage time period, that is, the preset duration may include 7 first-stage time periods, each first-stage time period corresponds to one day, and each first-stage time period is divided into time periods according to hours, that is, each first-stage time period may be divided into 24 second-stage time periods.
In the embodiment of the present invention, the preset time length is longer than a day, the first-level time period is a time period divided according to days, and the second-level time period is divided according to hours in each first-level time period as an example, the storage mode of the time-period price level storage may further be divided into date-price level storage and time-price level storage, the time-price level storage file may include a first-level time-period price level storage file and a second-level time-period price level storage file, the first-level time-period price level storage file may include a date-price and inventory table, and the second-level time-period price level storage file may include a time-price and inventory table. The date price level storage corresponding price information is a storage mode of the articles changing according to the first-level time period, and the time price level storage corresponding price information is a storage mode of the articles changing according to the second-level time period.
The embodiment of the present invention is described by taking the storage mode including sku price stock level storage, date price level storage and time price level storage as an example. For sku price inventory level storage, only fixed price and inventory information for the item needs to be stored, so only one data storage file, i.e., a price inventory level storage file, such as a sku level price and inventory table, is typically needed for storing the price information and inventory information for the item. For date price level storage, it is necessary to store the price and inventory information of the item corresponding to the first level time period, so a price inventory level storage file and a first level time period price level storage file are usually required, such as a sku level price and inventory table for storing the total price and total inventory information of the item and a date level price and inventory table for storing the price and inventory information of the item corresponding to the first level time period, where the total price may be the lowest price of the item. For time price level storage, it is necessary to store the price and inventory information of the second level time period of the item, so a price inventory level storage file, a first level time period price level storage file and a second level time period price level storage file are usually required, such as a sku level price and inventory table, a date level price and inventory table and a time level price and inventory table, the sku level price and inventory table is used to store the total price and total inventory information of the item, the date level price and inventory table is used to store the total price and total inventory information of the item corresponding to each first level time period, and the time level price and inventory table is used to store the price and inventory information of the item corresponding to each second level time period, wherein the total price may be the lowest price of the item in the corresponding time period.
Based on the above structure, a specific structure diagram of the inventory system may be as shown in fig. 1. In the structure shown in fig. 1, the data input module may receive information for performing writing operation on the article, such as writing of article information, stock pre-emption and recoiling, stock sorting, and so on; the data storage module is used for storing data storage files corresponding to the storage modes; the data output module provides external data input interface service, and can provide interfaces for various query information, such as price query and inventory query corresponding to each storage mode.
An embodiment of the present invention provides a method for storing item information, which may be performed by the inventory system shown in fig. 1, as shown in fig. 2, and includes the following steps.
S201: an item identification and target item information for a target item is received.
The target item information may include price information and inventory information of the target item, among others. The target item represents an item in which item information needs to be stored, the target item information is item information of the target item, and the item identifier of the target item includes an identifier that can uniquely identify the target item.
The inventory system may receive the item identification and the target item information for the target item as each item stores the item information. In the embodiment of the invention, the article information stored in each storage mode is different, so that the target article information in the received information is different.
S202: and determining a target storage mode corresponding to the target object according to the target object information.
In an embodiment of the present invention, the storage modes include sku price stock level storage and slot price level storage. The sku price stock level stores the corresponding item information, which may include the price and stock of the target item, and since the price is a fixed price of the target item, no time parameter is included in the item information. The time period price level storage corresponding item information comprises price information and inventory information of a plurality of different time periods in a preset time length so as to meet the requirement that the price information of the target item in the preset time length can change in price, and therefore the item information comprises time parameters. Therefore, according to whether the target item information includes the time parameter, the target storage mode corresponding to the target item can be determined. The concrete mode is as follows: judging whether the target article information comprises a time parameter or not; if so, determining that the target storage mode corresponding to the target article is time-interval price level storage; if not, determining that the target storage mode corresponding to the target item is sku price stock level storage.
S203: and if the target storage mode is time-period price level storage, inquiring a data storage file corresponding to the target item according to the target storage mode and the item identification.
As shown in fig. 1, different storage modes are usually corresponding to different data storage files, and after the target storage mode corresponding to the target item is determined, the data storage file corresponding to the target item can be searched from each data storage file according to the target storage mode and the item identifier in this step.
Specifically, the target storage mode is time-interval price level storage, and the target item information includes price information and inventory of the target item in different time intervals within a preset time length, so that a price inventory level storage file and a time-interval price level storage file are required when the item information is stored, and the price inventory level storage file and the time-interval price level storage file can be obtained through querying through item identifiers.
In the embodiment of the present invention, the preset duration may be divided into a plurality of levels of time periods, for example, the preset duration includes at least two consecutive first-level time periods, the first-level time period includes a plurality of second-level time periods, that is, the preset duration is divided into two levels of time periods, at this time, the time period price level storage file is also divided into two levels, that is, the first-level time period price level storage file and the second-level time period price level storage file. Therefore, when the price information and the stock quantity of the target item in different time periods within the preset time period include the price information and the stock quantity of the target item in each second-level time period, the time period price level storage file inquired in the step also includes the first-level time period price level storage file and the second-level time period price level storage file. When the price information and the stock of the target object in different time periods within the preset time length comprise the price information and the stock of the target object in each second-level time period, the time period price level storage file inquired in the step also comprises a first-level time period price level storage file.
S204: and storing the target article information into a data storage file corresponding to the target article.
After the data storage file corresponding to the target object is obtained, the information of the target object can be directly stored in the data storage file corresponding to the target object.
Specifically, when the target storage mode is time-interval price level storage, the target item information includes price information and inventory of the target item in different time intervals within a preset time length, and the data storage file includes a price inventory level storage file and a time-interval price level storage file corresponding to the target item. This step may be specifically executed as: determining the lowest price and total inventory information of the target object in the preset time according to the price information and the inventory of the target object in different time periods in the preset time; storing the lowest price and the total stock information into a price stock level storage file; and storing the price information and the stock of the target object in different time periods within a preset time period to a time period price level storage file.
When the target storage mode is time-interval price level storage, the time-interval price inventory level storage file is used for storing the total price and the total inventory information of the target object, and the time-interval price level storage file is used for storing specific price information and specific inventory information of different time intervals in preset time length. In the embodiment of the invention, the total price of the target item is expressed as the lowest price of the target item in the preset time, so that in the step, the lowest price and the total inventory information of the target item in the preset time can be determined according to the price information and the inventory quantity of the target item in different time periods in the preset time; then storing the minimum price and the total inventory information of the target object in a preset time length to a price inventory level storage file; and storing the price information and the stock of the target object in different time periods within a preset time period to a time period price level storage file.
In this embodiment of the present invention, the preset time duration may include at least two consecutive first-stage time periods, where the first-stage time period includes one or more consecutive second-stage time periods, that is, a time period in which the preset time duration is divided into two levels, and at this time, the time period price level storage file is also divided into two levels, that is, the first-stage time period price level storage file and the second-stage time period price level storage file. Therefore, when the price information of the target item in the preset time period at different time periods may include the price information of the target item in each second-level time period, the storing of the price information and the stock quantity of the target item in the preset time period at different time periods into the time period price level storage file may be specifically implemented as: for each first-stage time period, determining the lowest price and the total inventory information of the first-stage time period according to the price information and the inventory of the target object in each second-stage time period, and storing the lowest price and the total inventory information of the first-stage time period into a first-stage time period price-level storage file; and storing the price information and the stock quantity of the target object in each second time period into a second-stage time period price level storage file.
The price information and the stock quantity of the target item in different time periods within the preset time length can comprise the price information and the stock quantity of the target item in each second-level time period, and the price information and the stock quantity of the target item in each second-level time period need to be stored through a first-level time period price level storage file and a second-level time period price level storage file, wherein the first-level time period price level storage file stores the total price and the total stock information of the target item in each first-level time period, and the second-level time period price level storage file stores the specific price information and the specific stock quantity of the target item in each second-level time period. According to the embodiment of the invention, for each first-level time period, the total price is represented by the lowest price, so that the lowest price and the total inventory information of the first-level time period are determined according to the price information of the target object in different time periods within the preset time length, and the lowest price and the total inventory information of the first-level time period are stored into the corresponding first-level time price storage file.
In one implementation manner of the embodiment of the present invention, the inventory system may further provide a data query of the target item for the display terminal. The method specifically comprises the following steps: receiving an inquiry request sent by a display terminal, wherein the inquiry request comprises an article identifier of a target article and inquiry request information; determining a target storage mode corresponding to the target object according to the query request information; according to the target storage mode corresponding to the target object and the query request information, querying data corresponding to the query request from the data storage file corresponding to the object identifier; and sending the data corresponding to the query request to the display terminal.
When the display terminal or the like needs the data of the target item, it may send an inquiry request to the inventory system, where the inquiry request includes an item identifier of the target item and inquiry request information, for example, if the display terminal needs a price, the inquiry request information may include price-related information. Because different storage modes correspond to different data storage files, the target storage mode corresponding to the target object can be determined according to the query request information. The manner of determining the target storage mode corresponding to the target item according to the query request information in this step may be the same as the manner of determining the target storage mode corresponding to the target item according to the target item information in step S202. After the storage mode of the target object is determined, the data storage file corresponding to the object identifier can be inquired, the data corresponding to the inquiry request can be inquired, and the data corresponding to the inquiry request can be sent to the display terminal.
For example, the price required by the display terminal is different in prices of the target item at different times, so that after receiving the price query request, the inventory system can determine the time information corresponding to the query request, then query the price information of the target item, namely the price of the target item at the time corresponding to the price query request, from the data storage file corresponding to the item identifier according to the time information corresponding to the price query request, and then return the queried price information to the display terminal.
In the embodiment of the invention, the storage mode comprises time period price level storage, and the article information corresponding to the time period price level storage can comprise price information and stock information of a plurality of different time periods within preset time length; after receiving the object identifier of the target object and the target object information, determining a target storage mode corresponding to the target object according to the target object information; for the target item stored in the target storage mode in the time period price level, target item information, that is, price information and stock of the target item in different time periods within a preset time period, may be stored in the data storage file corresponding to the target item. Therefore, when the target storage mode is time-interval price level storage, the price information of the target article in a plurality of different time intervals in the preset time interval can be stored, the requirement that the price information of the target article in the preset time interval can be changed in price is met, the article information does not need to be changed frequently, the operation is simple, and the burden of data processing is reduced.
In conjunction with the structure of the inventory system shown in fig. 1 and the embodiment shown in fig. 2, the embodiment of the present invention explains the storage method of the item information by taking the storage modes including sku price inventory level storage, date price level storage, and time price level storage as examples. As shown in fig. 3, the method includes the following steps.
S301: an item identification and target item information for a target item is received.
As shown in fig. 1, the data entry of the data input module in the inventory system may receive the item identifier and the target item information of the target item by calling the inventory and price adding interface.
S302: and determining a target storage mode corresponding to the target object according to the target object information.
Wherein the storage modes include sku price stock level storage, date price level storage, and time price level storage. The price is fixed in the sku price stock level storage mode, so the target item information does not include time parameters, and only includes price and stock; the prices in the date price level storage mode are distinguished according to a first-level time period, namely, the target article information needs to comprise a time parameter of the first-level time period, namely a date parameter of a certain day in a certain month of a certain year, so that the target article information comprises the time parameter of the first-level time period, prices corresponding to all the time periods and inventory; the prices in the time price level storage mode are distinguished according to the second level time period, namely the target item information needs to include the time parameter of the second level time period, namely the time parameter of a certain time in a certain day in a certain month in a certain year, so that the target item information only includes the time parameter of the second level time period, the prices corresponding to the time periods and the stock quantity.
Based on the above, in this step, the target storage mode corresponding to the target item may be determined according to whether the time parameter is included in the target item information and which time parameter is included.
It should be noted that, if the parameters included in the target article information do not conform to the parameters included in the article information corresponding to the storage mode, it may be determined that the target article information is wrong, and the process is ended.
S303: and if the target storage mode is sku price stock level storage, inquiring sku level price and a stock table corresponding to the target item according to sku price stock level storage and the item identification.
For the sku price inventory level storage mode, the item information is stored in the sku level price and inventory tables. The sku level price and inventory tables typically include item identification, price and inventory. Specifically, the structure of the sku-level price and inventory table may be as shown in FIG. 4.
In fig. 4, skuLevelId represents the sku-level price and the primary key of the inventory table, waiid represents the identifier of the item to which the target item belongs, skulid represents the identifier of the target item, price represents the price of the target item, stock represents the inventory amount of the target item, and prestack represents the pre-occupied inventory amount of the target item. In an embodiment of the present invention, the item identifier may include a wartid and a waiid. Sku in the e-commerce field and system generally refers to the smallest unit of inventory that can be sold specifically for a particular item.
S304: and storing the item information of the target item into the sku level price and the stock table corresponding to the target item.
For example, taking the target article as red model a and B mobile phone as an example, that is, the article identifier of the target article is the identifier of red model a and B mobile phone, the article to which the target article belongs is the identifier of model a and B mobile phone, the price is 1000, the stock quantity of the target article is 30, the pre-occupied stock quantity of the target article is 5 as an example, and the result after storage is shown in fig. 4.
After this step is performed, the process may end.
S305: and if the target storage mode is date price level storage, inquiring the sku level price and stock list and the date level price and stock list corresponding to the target item according to the date price level storage and the item identification.
For the date price level storage mode, the item information is stored in the sku level price and inventory table and the date level price and inventory table. The sku level price and inventory table is used to store the target item including item identification, minimum price and total inventory. The date-level price and inventory table is used for storing specific prices and specific inventory levels corresponding to all first-level time periods within preset time of the target object. Specifically, the structure of the sku-level price and inventory table and the date-level price and inventory table may be as shown in FIG. 5.
In fig. 5, the sku-level price and skuleld in the inventory table represents the sku-level price and the main key of the inventory table, the waiid represents the identifier of the item to which the target item belongs, the skoid represents the identifier of the target item, the price represents the lowest price of the target item, the stock represents the total inventory amount of the target item, and the preStock represents the total pre-occupied inventory amount of the target item. The dateLevelId in the date-level price and inventory table represents a main key of the date-level price and inventory table, the skuLevelId represents a corresponding main key of a target article in the sku-level price and inventory table, the date represents specific time of a first-level time period, the waiid represents an identifier of an article to which the target article belongs, the skuId represents an identifier of the target article, the price represents a corresponding price of the target article in the first-level time period, the stock represents the stock of the target article in the first-level time period, and the prestack represents the pre-occupied stock of the target article in the first-level time period.
S306: and storing the item information of the target item into a sku-level price and stock list and a date-level price and stock list corresponding to the target item.
The minimum price and the total stock of the target item are calculated according to the information of the target item, then the minimum price and the total stock of the target item are stored in a sku-level price and stock table, and the specific price and the specific stock corresponding to each first-level time period in the preset duration are stored in a date-level price and stock table.
Taking red A-type and B-type mobile phones as examples of target articles, the article to which the target article belongs is the identifier of the A-type and B-type mobile phones, the price of the target article in 2019, 12, month and 1 day is 2000, the stock is 5, and the pre-occupied stock is 1, the price of the target article in 2019, 12, month and 2 days is 1000, the stock is 10, the pre-occupied stock is 2, and the price of the target article in 2019, 12, month and 3 days is 1500, the stock is 15, and the pre-occupied stock is 3. From the above, it can be calculated that the minimum price of the target item is 1000, the total stock of the target item is 30, and the pre-occupied stock quantity of the target item is 6, for example, and the result after storage is shown in fig. 5.
After this step is performed, the process may end.
S307: and if the target storage mode is time price level storage, inquiring sku level price and inventory table, date level price and inventory table and time level price and inventory table corresponding to the target item according to the time period price level storage and the item identification.
Wherein, for the time price level storage mode, the item information is stored in the sku level price and inventory table, the date level price and inventory table and the time level price and inventory table. The sku level price and inventory table is used to store the target item including the item identification, the minimum price and the total inventory. The date-level price and the stock list are used for storing the lowest price and the total stock corresponding to each first-level time period in the preset time length of the target object. The time-level price and inventory table is used for storing the price and the inventory corresponding to each second-level time period of the target object. Specifically, the structure of the sku-level price and inventory table, the date-level price and inventory table, and the time-level price and inventory table may be as shown in fig. 6.
In fig. 6, the sku-level price and skuleld in the inventory table represents the sku-level price and the main key of the inventory table, the waiid represents the identifier of the item to which the target item belongs, the skoid represents the identifier of the target item, the price represents the lowest price of the target item, the stock represents the total inventory amount of the target item, and the preStock represents the total pre-occupied inventory amount of the target item. The dateLevelId in the date-level price and inventory table represents a main key of the date-level price and inventory table, the skuLevelId represents a corresponding main key of a target article in the sku-level price and inventory table, the date represents specific time of a first-level time period, the waiid represents an identifier of an article to which the target article belongs, the skuId represents an identifier of the target article, the price represents the lowest price of the target article in the first-level time period, the stock represents the total inventory amount of the target article in the first-level time period, and the preStock represents the pre-occupied inventory amount of the target article in the first-level time period. timeLevelId in the time-level price and inventory table represents a time-level price and a primary key of the inventory table, dataLevelId represents a primary key corresponding to a target article in the date-level price and inventory table, date represents specific time of a second-level time period, waiid represents an identifier of an article to which the target article belongs, skuId represents an identifier of the target article, price represents a price corresponding to the target article in the second-level time period, stock represents an inventory amount corresponding to the target article in the second-level time period, and prestack represents a pre-occupied inventory amount corresponding to the target article in the second-level time period.
S308: and storing the item information of the target item into a sku-level price and inventory table, a date-level price and inventory table and a time-level price and inventory table corresponding to the target item.
According to the method, the minimum price and the total stock of the target object and the minimum price and the total stock corresponding to each first-stage time period are calculated according to the information of the target object, then the minimum price and the total stock of the target object are stored in a sku-level price and stock table, the minimum price and the total stock corresponding to each first-stage time period are stored in a date-level price and stock table, and the specific price and the specific stock corresponding to each second-stage time period in a preset duration are stored in a time-level price and stock table.
Taking a target object as a red A-type and B-type mobile phone; the object to which the target object belongs is an identifier of a mobile phone with the A type and the B brand; target item within 12 months and 3 days 2019: 8: price of 00 is 2000, stock is 2, pre-emption stock is 1, 9: the price of 00 is 2100, stock is 10, pre-occupied stock is 1, 10: the price of 00 is 1500, the stock is 2, the pre-occupied stock is 1; the price of the target object in 2019, 12 months and 2 days is 1000, the stock is 10, and the pre-occupied stock is 2; the price of the target item in 2019, 12 and 1 is 1500, the stock is 15 for example, and the pre-occupied stock is 1. From the above, it can be calculated that the minimum price of the target item is 1000, the total stock of the target item is 30, and the pre-occupied stock quantity of the target item is 6, for example, and the result after storage is shown in fig. 6.
After this step is performed, the process may end.
In the embodiment of the invention, when the target storage mode is time-interval price level storage, the price information of the target article in a plurality of different time intervals in the preset time length can be stored, so that the requirement that the price information of the target article in the preset time length can be changed in price is met, the article information does not need to be changed frequently, the operation is simple, and the burden of data processing is reduced.
After the inventory system stores the item information of the target item, the inventory system can also pre-occupy the inventory according to the order information of the item. A method of inventory preemption processing of items in an inventory system is described based on the embodiments shown in fig. 2 and 3, for example, to adjust inventory of a target object, as shown in fig. 7, which includes the following steps.
S701: order information of the target object is received.
The order information includes item identification and pre-emption inventory information for the target item. The pre-emptive inventory information may include different parameters depending on the storage mode of the target item.
The storage modes include sku price stock level storage, date price level storage, and time price level storage. For the storage mode of the sku price inventory level storage, the pre-emptive inventory information includes only the amount of pre-emptive inventory, and does not include the time parameter. For the storage mode of date price level storage, the pre-occupied inventory information not only includes the number of pre-occupied inventory, but also needs to include the time parameter of the pre-occupied inventory corresponding to the first level time period. For the storage mode of time price level storage, the pre-occupied inventory information not only includes the number of pre-occupied inventory, but also needs to include the time parameter of the pre-occupied inventory corresponding to the second level time period.
S702: and determining the storage mode of the target object according to the order information.
Since the pre-emption inventory information may include different parameters according to different storage modes of the target item, the storage mode of the target item may be determined according to the parameters included in the pre-emption inventory information.
S703: if the target storage mode is sku price stock level storage, judging whether the sku level price corresponding to the target item and the stock in the stock table meet the requirements or not according to the pre-occupied stock information, if so, executing a step S704; if not, the flow is ended.
If the target storage mode is sku price stock level storage, the sku level price and the stock table corresponding to the target item can be inquired according to the sku price stock level storage and the item identification. And then judging whether the current pre-occupation inventory requirement is met according to the sku level price, and the inventory and the pre-occupation inventory in the inventory table. If the sku level price and the pre-emptive inventory in the inventory table are greater than 0, it is indicated that the target item already has pre-emptive inventory. Therefore, the current amount of stock which can be preempted is the value obtained by subtracting the sku level price from the amount of stock in the sku level price and stock table and the amount of stock which can be preempted in the stock table, that is, the current amount of stock which can be preempted is the value of sku level price and stock-preStock in the stock table. In this step, the current pre-occupied inventory can be determined through the pre-occupied inventory information, taking the current pre-occupied inventory as 2 as an example, so that in this step, whether the sku-level price and the stock-prestack value in the inventory table are more than or equal to 2 can be judged, if yes, the sku-level price and the inventory in the inventory table corresponding to the target item meet the requirement of the current pre-occupied inventory is shown, and step S704 is executed; if not, the sku level price corresponding to the target item and the inventory in the inventory table cannot meet the requirement of pre-occupying the inventory at this time, namely the inventory is insufficient, and the process is ended.
S704: and updating the sku level price and the pre-occupied inventory in the inventory table according to the pre-occupied inventory information.
After the sku-level price and the stock in the stock table corresponding to the target item are judged to meet the requirement of the pre-occupied stock, the sku-level price and the pre-occupied stock in the stock table can be increased by the pre-occupied stock in the pre-occupied stock information, namely, the sku-level price and the pre-occupied stock in the stock table are updated.
For example, the target item is identified as 20001, and the reserved inventory amount in the reserved inventory information is 5. FIG. 8 is a schematic diagram of item information stored in the sku-level price and inventory tables for a target item. As can be seen from fig. 8, if the sku-level price and the stock in the stock table are 100, and the stock already reserved is 0, the stock that can be reserved this time is 100-0 to 100, and is equal to or greater than 5, so that it can be determined that the sku-level price and the stock in the stock table corresponding to the target item satisfy the demand, the sku-level price and the reserved stock in the stock table can be updated in this step, that is, the reserved stock is increased by 5, and the updated result is shown in fig. 9.
After the inventory pre-occupation is successful, the inventory system can record the order identification corresponding to the current inventory pre-occupation operation, and the order identification is used as the unique identification of the current inventory pre-occupation operation, so that the pre-occupation quantity and the target article information can be recorded.
S705: if the target storage mode is date price level storage, judging whether the date price of the target article and the inventory in the corresponding time period in the inventory table meet the requirements or not according to the pre-occupied inventory information, if so, executing a step S704; if not, the flow is ended.
If the target storage mode is date price level storage, the sku level price and inventory table and the date price and inventory table corresponding to the target item can be inquired according to the date price level storage and the item identification. Determining date-level prices and corresponding first-level time periods in the inventory list according to time parameters in the pre-occupied inventory information, further determining the inventory and the pre-occupied inventory corresponding to the first-level time period, and then judging whether the pre-occupied inventory requirement of the time is met according to the inventory and the pre-occupied inventory corresponding to the first-level time period. If the pre-occupied stock corresponding to the first-stage time period is more than 0, the pre-occupied stock is already existed in the first-stage time period. Therefore, the current preemptable inventory should be the value obtained by subtracting the preempted inventory corresponding to the first-stage time period from the inventory corresponding to the first-stage time period, that is, the current preemptable inventory is the value of stock-prestack corresponding to the first-stage time period. In this step, the current pre-occupied inventory can be determined through the pre-occupied inventory information, taking the current pre-occupied inventory as 2 as an example, so that in this step, whether the value of stock-prestack corresponding to the first-stage time period is greater than or equal to 2 can be determined, if yes, the date-level price of the target item and the inventory in the corresponding time period in the inventory table meet the requirement of the current pre-occupied inventory are indicated, and step S706 is executed; if not, the date-level price of the target object and the inventory quantity in the corresponding time period in the inventory table do not meet the current pre-occupation inventory requirement, namely the inventory is insufficient, and the process is ended.
S706: and updating the sku level price, the stock list, the date level price and the pre-occupied stock in the stock list according to the pre-occupied stock information.
After the date-level price of the target item and the inventory in the corresponding time period in the inventory table are judged to meet the requirements, the sku-level price and the pre-occupied inventory in the inventory table can be increased to pre-occupied inventory in the pre-occupied inventory information, and the date-level price and the pre-occupied inventory in the corresponding time period in the inventory table can be increased to pre-occupied inventory in the pre-occupied inventory information, namely the sku-level price and the inventory table, and the date-level price and the pre-occupied inventory in the inventory table.
After the inventory pre-occupation is successful, the inventory system can record the order identification corresponding to the current inventory pre-occupation operation, and the order identification is used as the unique identification of the current inventory pre-occupation operation, so that the pre-occupation quantity and the target article information can be recorded.
S707: if the target storage mode is time price level storage, judging whether the time price of the target object and the inventory in the corresponding time period in the inventory table meet the requirements or not according to the pre-occupied inventory information, if so, executing a step S704; if not, the flow is ended.
If the target storage mode is time price level storage, the sku level price and inventory table, the date level price and inventory table and the time level price and inventory table corresponding to the target item can be inquired according to the time price level storage and the item identification. And determining the time-level price and a corresponding second-level time period in the inventory list according to the time parameter in the pre-occupied inventory information, further determining the inventory and the pre-occupied inventory corresponding to the second-level time period, and then judging whether the pre-occupied inventory requirement of the time is met according to the inventory and the pre-occupied inventory corresponding to the second-level time period. If the pre-occupied inventory corresponding to the second-stage time period is greater than 0, the pre-occupied inventory in the second-stage time period is determined to exist, so that the pre-occupied inventory at this time is obtained by subtracting the value of the pre-occupied inventory corresponding to the second-stage time period from the inventory corresponding to the second-stage time period, namely the pre-occupied inventory at this time is the value of stock-preStock corresponding to the second-stage time period. In this step, the current pre-occupied inventory can be determined through the pre-occupied inventory information, taking the current pre-occupied inventory as 2 as an example, so that in this step, whether the value of stock-prestack corresponding to the second-stage time period is greater than or equal to 2 can be determined, if yes, the date-level price of the target item and the inventory in the corresponding time period in the inventory table meet the requirement of the current pre-occupied inventory are indicated, and step S708 is executed; if not, the date-level price of the target object and the inventory quantity in the corresponding time period in the inventory table do not meet the current pre-occupation inventory requirement, namely the inventory is insufficient, and the process is ended.
S708: and updating sku level price and inventory table, date level price and inventory table, time level price and the pre-occupied inventory in the inventory table according to the pre-occupied inventory information.
According to the time parameter in the pre-occupation inventory information, the date-level price of the pre-occupation inventory and the corresponding time period in the inventory table and the time-level price and the corresponding time period in the inventory table can be determined.
After the time-level price of the target object and the inventory in the corresponding time period in the inventory table are judged to meet the demand, the pre-occupied inventory in the sku-level price and the pre-occupied inventory in the inventory information can be increased, the pre-occupied inventory in the date-level price and the pre-occupied inventory in the corresponding time period in the inventory table can be increased, and the pre-occupied inventory in the time-level price and the pre-occupied inventory in the corresponding time period in the inventory table, namely the sku-level price and the inventory, the date-level price and the inventory, the time-level price and the pre-occupied inventory in the inventory table, can be increased.
After the inventory pre-occupation is successful, the inventory system can record the order identification corresponding to the current inventory pre-occupation operation, and the order identification is used as the unique identification of the current inventory pre-occupation operation, so that the pre-occupation quantity and the target article information can be recorded.
It should be noted that after the pre-occupied inventory is successful, if the order is successful, the inventory needs to be deducted, that is, the real deduction operation is performed on the pre-occupied inventory. Specifically, when the inventory is deducted, the order identifier of the preempted inventory can be used for inquiring the article identifier and the preempted inventory corresponding to the preempted inventory, namely the deduction amount is carried out at this time, and then the inventory is deducted. The specific operation is to reduce the corresponding inventory amount by the deduction decrement at this time and reduce the pre-occupied amount by the deduction decrement at this time. For example, for the result after the pre-emption inventory process shown in fig. 9, the result of the inventory deduction shown in fig. 10 can be obtained after the inventory deduction is performed. In the embodiment of the invention, after the pre-occupation of the inventory is successful, the inventory can be back flushed. The stock is reversed to the opposite operation of corresponding stock deduction, and the stock is reversed, namely the reserved stock needs to be reversed due to reasons such as payment failure and the like, and is released. Similar to the stock deduction, the order identification of the pre-occupied stock can be used for inquiring the item identification and the pre-occupied stock corresponding to the pre-occupied stock during the stock recoiling, namely the recoiling amount of the current time, and then the stock is recoiled. The specific operation is to reduce the back impulse in the pre-occupied quantity. For example, for the result after the pre-emption inventory process shown in fig. 9, the result shown in fig. 11 may be obtained after performing the inventory rollback.
In the embodiment of the invention, the inventory system can be regularly arranged. Stock timing consolidation is a timed task for the storage mode of date price level storage and time price level storage, and functions to automatically set the stock before the current time to an unavailable state. Since it is not meaningful to display the inventory before the current time in the sales scenario for the item, e.g., it is not possible today to reserve yesterday's movie tickets, embodiments of the present invention automatically set the inventory before the current time to an unavailable state by timing tasks.
The timing task of the stock timing arrangement can be divided into two types. One is to arrange the storage mode of daily price level storage, and the timing task can be arranged to arrange in the evening and early morning every day, and the inventory corresponding to the time period before the current date is set to be in an unavailable state. One is to arrange the storage mode of the time price level storage, and the timing task can be set to arrange at each integral point, and the inventory corresponding to the time period before the current time point is set to be in an unavailable state.
In the embodiment of the invention, various processing on the inventory can be realized through the process, so that the accuracy of the article information in the inventory system is realized.
It should be noted that, with the structure shown in fig. 1, the data output module in the inventory system provides a standardized output interface to the outside, so that the storage mode of the item corresponding to the query request can be determined according to the difference between parameters included in the received query request, and a result corresponding to the storage mode is returned. For example, if the query request only includes the item identifier but not the time parameter, the storage mode corresponding to the query request is sku price stock-level storage, so the returned parameter is the corresponding sku price and the data in the stock table; the query request comprises an item identifier and a time parameter of a first-level time period, and the corresponding storage mode of the query request is date price level storage, so that the returned parameters are data in a corresponding sku-level price and stock list and date price and stock list; and if the query request comprises the item identifier and the time parameter of the second-level time period, the storage mode corresponding to the query request is time price level storage, so the returned parameters are data in the corresponding sku-level price and inventory table, date-level price and inventory table and time-level price and inventory table.
The inventory system receives a query request to query the item information of the item, the query request can comprise an item identifier and a parameter representing a storage mode, and the inventory system can return data in a nested object mode after querying corresponding data. For example, the first level in the returned data is the data stored for the sku level price and inventory table, and the date level price and data in the inventory table are nested in the first level, i.e., the second level. If the date level price and inventory storage table includes multiple pieces of data, multiple second tiers are nested side-by-side within the first tier. The time-level prices are nested in the second layer and the data in the inventory storage table, i.e., the third layer. If the time-level prices and data in the inventory storage table include multiple pieces, multiple third tiers are nested side-by-side within the first tier. Fig. 12 is a schematic diagram of the return parameter.
In order to solve the problems in the prior art, an embodiment of the present invention provides an apparatus 1300 for storing article information, as shown in fig. 13, where the apparatus 1300 includes:
a receiving unit 1301, configured to receive an item identifier of a target item and target item information;
a determining unit 1302, configured to determine, according to the target item information, a target storage mode corresponding to the target item, where the storage mode includes time-period price level storage, and the time-period price level storage corresponds to item information, and the item information includes price information and stock information of multiple different time periods within a preset time length;
the query unit 1303 is configured to query, according to the target storage mode and the item identifier, a data storage file corresponding to the target item if the target storage mode is the time-interval price level storage;
a storage unit 1304, configured to store the target item information in a data storage file corresponding to the target item.
It should be understood that the manner of implementing the embodiment of the present invention is the same as the manner of implementing the embodiment shown in fig. 2, and the description thereof is omitted.
In an implementation manner of the embodiment of the present invention, if the target storage mode is time-interval price level storage, the target item information includes price information and stock of the target item at different time intervals within a preset time duration, and the data storage file includes a price stock level storage file and a time-interval price level storage file corresponding to the target item;
the storage unit 1304 is specifically configured to:
determining the lowest price and total inventory information of the target object in a preset time according to the price information and the inventory of the target object in different time periods in the preset time;
storing the minimum price and the total stock information into the price stock level storage file;
and storing the price information and the stock quantity of the target object in different time periods within a preset time length to the time period price level storage file.
In another implementation manner of the embodiment of the present invention, the preset time period includes at least two consecutive first-stage time periods, the first-stage time period includes a plurality of second-stage time periods, and the price information and the stock amount of the target item in different time periods within the preset time period include the price information and the stock amount of the target item in each of the second-stage time periods; the time period price level storage files comprise a first time period price level storage file and a second time period price level storage file;
the storage unit 1304 is specifically configured to:
for each first-stage time period, determining the lowest price and the total inventory information of the first-stage time period according to the price information and the inventory quantity of the target object in each second-stage time period, and storing the lowest price and the total inventory information of the first-stage time period into a first-stage time period price level storage file;
and storing the price information and the stock quantity of the target object in each second time period into the second-stage time period price level storage file.
In another implementation manner of the embodiment of the present invention, the determining unit 1302 is specifically configured to:
judging whether the target article information comprises a time parameter or not;
if so, determining that the target storage mode corresponding to the target article is time-interval price level storage;
if not, determining that the target storage mode corresponding to the target item is sku price stock level storage, wherein the sku price stock level storage corresponding item information comprises fixed price and stock information of the item.
In another implementation manner of the embodiment of the present invention, the receiving unit 1301 is further configured to receive an inquiry request sent by a display terminal, where the inquiry request includes an item identifier of the target item and inquiry request information;
the determining unit 1302 is further configured to determine, according to the query request information, a target storage mode corresponding to the target item;
the query unit 1303 is further configured to query, according to the target storage mode corresponding to the target item and the query request information, data corresponding to the query request from the data storage file corresponding to the item identifier;
the apparatus 1300 further comprises:
and the sending unit is used for sending the data corresponding to the query request to the display terminal.
In another implementation manner of the embodiment of the present invention, the receiving unit 1301 is further configured to receive order information corresponding to the target item;
the apparatus 1300 further comprises:
and the updating unit is used for updating the stock in the data storage file according to the order information.
It should be understood that the embodiment of the present invention is implemented in the same manner as the embodiment shown in fig. 2, 3 or 7, and is not repeated herein.
In the embodiment of the invention, when the target storage mode is time-interval price level storage, the price information of the target article in a plurality of different time intervals in the preset time length can be stored, so that the requirement that the price information of the target article in the preset time length can be changed in price is met, the article information does not need to be changed frequently, the operation is simple, and the burden of data processing is reduced.
The invention also provides an electronic device and a readable storage medium according to the embodiment of the invention.
The electronic device of the present invention includes: at least one processor; and a memory communicatively coupled to the at least one processor; wherein the memory stores instructions executable by the processor, and the instructions are executed by the at least one processor to cause the at least one processor to execute the article information storage method provided by the embodiment of the invention.
Fig. 14 shows an exemplary system architecture 1400 of a storage method of item information or a storage device of item information to which an embodiment of the present invention can be applied.
As shown in fig. 14, the system architecture 1400 may include terminal devices 1401, 1402, 1403, a network 1404, and a server 1405. The network 1404 serves to provide a medium for communication links between the terminal devices 1401, 1402, 1403 and the server 1405. The network 1404 may include various connection types, such as wired, wireless communication links, or fiber optic cables, among others.
A user may use terminal devices 1401, 1402, 1403 to interact with a server 1405 via a network 1404, to receive or send messages or the like. The terminal devices 1401, 1402, 1403 may have installed thereon various communication client applications, such as shopping-like applications, web browser applications, search-like applications, instant messaging tools, mailbox clients, social platform software, etc. (by way of example only).
The terminal devices 1401, 1402, 1403 may be various electronic devices having a display screen and supporting web browsing, including but not limited to smart phones, tablet computers, laptop portable computers, desktop computers, and the like.
The server 1405 may be a server providing various services, such as a backend management server (for example only) providing support for shopping websites browsed by users using the terminal devices 1401, 1402, 1403. The backend management server may analyze and perform other processing on the received data such as the product information query request, and feed back a processing result (for example, product information — just an example) to the terminal device.
It should be noted that the storage method of the item information provided by the embodiment of the present invention is generally executed by the server 1405, and accordingly, the storage device of the item information is generally disposed in the server 1405.
It should be understood that the number of terminal devices, networks, and servers in fig. 14 is merely illustrative. There may be any number of terminal devices, networks, and servers, as desired for implementation.
Referring now to FIG. 15, shown is a pictorial representation of a suitable configuration of computer system 1500 used to implement an embodiment of the present invention. The computer system illustrated in FIG. 15 is only an example and should not impose any limitations on the scope of use or functionality of embodiments of the invention.
As shown in fig. 15, the computer system 1500 includes a Central Processing Unit (CPU)1501 which can perform various appropriate actions and processes in accordance with a program stored in a Read Only Memory (ROM)1502 or a program loaded from a storage section 1508 into a Random Access Memory (RAM) 1503. In the RAM 1503, various programs and data necessary for the operation of the system 1500 are also stored. The CPU 1501, the ROM 1502, and the RAM 1503 are connected to each other by a bus 1504. An input/output (I/O) interface 1505 is also connected to bus 1504.
The following components are connected to the I/O interface 1505: an input portion 1506 including a keyboard, a mouse, and the like; an output portion 1507 including a display such as a Cathode Ray Tube (CRT), a Liquid Crystal Display (LCD), and the like, and a speaker; a storage portion 1508 including a hard disk and the like; and a communication section 1509 including a network interface card such as a LAN card, a modem, or the like. The communication section 1509 performs communication processing via a network such as the internet. A drive 1510 is also connected to the I/O interface 1505 as needed. A removable medium 1511 such as a magnetic disk, an optical disk, a magneto-optical disk, a semiconductor memory, or the like is mounted on the drive 1510 as necessary, so that a computer program read out therefrom is mounted into the storage section 1508 as necessary.
In particular, according to the embodiments of the present disclosure, the processes described above with reference to the flowcharts may be implemented as computer software programs. For example, embodiments of the present disclosure include a computer program product comprising a computer program embodied on a computer readable medium, the computer program comprising program code for performing the method illustrated in the flow chart. In such an embodiment, the computer program may be downloaded and installed from a network through the communication section 1509, and/or installed from the removable medium 1511. The computer program executes the above-described functions defined in the system of the present invention when executed by the Central Processing Unit (CPU) 1501.
It should be noted that the computer readable medium shown in the present invention can be a computer readable signal medium or a computer readable storage medium or any combination of the two. A computer readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromagnetic, infrared, or semiconductor system, apparatus, or device, or any combination of the foregoing. More specific examples of the computer readable storage medium may include, but are not limited to: an electrical connection having one or more wires, a portable computer diskette, a hard disk, a Random Access Memory (RAM), a read-only memory (ROM), an erasable programmable read-only memory (EPROM or flash memory), an optical fiber, a portable compact disc read-only memory (CD-ROM), an optical storage device, a magnetic storage device, or any suitable combination of the foregoing. In the present invention, a computer readable storage medium may be any tangible medium that can contain, or store a program for use by or in connection with an instruction execution system, apparatus, or device. In the present invention, however, a computer readable signal medium may include a propagated data signal with computer readable program code embodied therein, for example, in baseband or as part of a carrier wave. Such a propagated data signal may take many forms, including, but not limited to, electro-magnetic, optical, or any suitable combination thereof. A computer readable signal medium may also be any computer readable medium that is not a computer readable storage medium and that can communicate, propagate, or transport a program for use by or in connection with an instruction execution system, apparatus, or device. Program code embodied on a computer readable medium may be transmitted using any appropriate medium, including but not limited to: wireless, wire, fiber optic cable, RF, etc., or any suitable combination of the foregoing.
The flowchart and block diagrams in the figures illustrate the architecture, functionality, and operation of possible implementations of systems, methods and computer program products according to various embodiments of the present invention. In this regard, each block in the flowchart or block diagrams may represent a unit, segment, or portion of code, which comprises one or more executable instructions for implementing the specified logical function(s). It should also be noted that, in some alternative implementations, the functions noted in the block may occur out of the order noted in the figures. For example, two blocks shown in succession may, in fact, be executed substantially concurrently, or the blocks may sometimes be executed in the reverse order, depending upon the functionality involved. It will also be noted that each block of the block diagrams or flowchart illustration, and combinations of blocks in the block diagrams or flowchart illustration, can be implemented by special purpose hardware-based systems which perform the specified functions or acts, or combinations of special purpose hardware and computer instructions.
The units described in the embodiments of the present invention may be implemented by software or hardware. The described units may also be provided in a processor, and may be described as: a processor includes a receiving unit, a determining unit, a querying unit, and a storing unit. Where the names of these elements do not in some cases constitute a limitation of the element itself, for example, a receiving element may also be described as "an element of the function of the receiving element".
As another aspect, the present invention also provides a computer-readable medium that may be contained in the apparatus described in the above embodiments; or may be separate and not incorporated into the device. The computer-readable medium carries one or more programs which, when executed by a device, cause the device to perform the method for storing article information provided by the present invention.
The above-described embodiments should not be construed as limiting the scope of the invention. Those skilled in the art will appreciate that various modifications, combinations, sub-combinations, and substitutions can occur, depending on design requirements and other factors. Any modification, equivalent replacement, and improvement made within the spirit and principle of the present invention should be included in the protection scope of the present invention.

Claims (10)

1. A method for storing item information, comprising:
receiving an article identification and target article information of a target article;
determining a target storage mode corresponding to the target item according to the target item information, wherein the storage mode comprises time-period price level storage, and the time-period price level storage corresponding item information comprises price information and stock information of a plurality of different time periods within a preset time length;
if the target storage mode is the time-period price level storage, inquiring a data storage file corresponding to the target item according to the target storage mode and the item identification;
and storing the target article information to a data storage file corresponding to the target article.
2. The method according to claim 1, wherein if the target storage mode is time-interval price level storage, the target item information includes price information and stock quantity of the target item at different time intervals within a preset time length, and the data storage file includes a price stock level storage file and a time-interval price level storage file corresponding to the target item;
the storing the target article information to the data storage file corresponding to the target article includes:
determining the lowest price and total inventory information of the target object in a preset time according to the price information and the inventory of the target object in different time periods in the preset time;
storing the minimum price and the total stock information into the price stock level storage file;
and storing the price information and the stock quantity of the target object in different time periods within a preset time length to the time period price level storage file.
3. The method of claim 2, wherein the predetermined time period comprises at least two consecutive first-level time periods, the first-level time periods comprising a plurality of second-level time periods, and wherein the price information and the inventory amount of the target item at different time periods within the predetermined time period comprises the price information and the inventory amount of the target item at each of the second-level time periods; the time period price level storage files comprise a first time period price level storage file and a second time period price level storage file;
the step of storing the price information and the stock of the target object in different time periods within a preset time length to the time period price level storage file comprises the following steps:
for each first-stage time period, determining the lowest price and the total inventory information of the first-stage time period according to the price information and the inventory quantity of the target object in each second-stage time period, and storing the lowest price and the total inventory information of the first-stage time period into a first-stage time period price level storage file;
and storing the price information and the stock quantity of the target object in each second time period into the second-stage time period price level storage file.
4. The method according to claim 1, wherein the determining the target storage mode corresponding to the target item according to the target item information comprises:
judging whether the target article information comprises a time parameter or not;
if so, determining that the target storage mode corresponding to the target article is time-interval price level storage;
if not, determining that the target storage mode corresponding to the target item is sku price stock level storage, wherein the sku price stock level storage corresponding item information comprises fixed price and stock information of the item.
5. The method according to claim 1, further comprising, after storing the target item information in a data storage file corresponding to the target item:
receiving an inquiry request sent by a display terminal, wherein the inquiry request comprises an item identifier of the target item and inquiry request information;
determining a target storage mode corresponding to the target object according to the query request information;
according to the target storage mode corresponding to the target object and the query request information, querying data corresponding to the query request from a data storage file corresponding to the object identifier;
and sending the data corresponding to the query request to the display terminal.
6. The method according to claim 1, further comprising, after storing the target item information in a data storage file corresponding to the target item:
receiving order information corresponding to the target object;
and updating the stock in the data storage file according to the order information.
7. An article information storage device, comprising:
the receiving unit is used for receiving the object identification and the object information of the object;
the determining unit is used for determining a target storage mode corresponding to the target item according to the target item information, wherein the storage mode comprises time-period price level storage, and the time-period price level storage corresponding item information comprises price information and stock information of a plurality of different time periods within a preset time length;
the query unit is used for querying a data storage file corresponding to the target item according to the target storage mode and the item identifier if the target storage mode is the time-period price level storage;
and the storage unit is used for storing the target article information to a data storage file corresponding to the target article.
8. The apparatus according to claim 7, wherein if the target storage mode is time-interval price-level storage, the target item information includes price information and stock quantity of the target item in a plurality of different time intervals within a preset time length, and the data storage file includes a price-inventory-level storage file and a time-price-level storage file corresponding to the target item;
the storage unit is specifically configured to:
determining the lowest price of the target item in a preset time length according to the price information of the target item in different time periods in the preset time length;
storing the lowest price and the stock of the target object in a preset time length to a price stock level storage file;
and storing the price information of the target object in different time periods within a preset time length to the time price level storage file.
9. An electronic device, comprising:
one or more processors;
a storage device for storing one or more programs,
when executed by the one or more processors, cause the one or more processors to implement the method of any one of claims 1-6.
10. A computer-readable medium, on which a computer program is stored, which, when being executed by a processor, carries out the method according to any one of claims 1-6.
CN202010544545.4A 2020-06-15 2020-06-15 Article information storage method and device, electronic equipment and storage medium Pending CN113762818A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN202010544545.4A CN113762818A (en) 2020-06-15 2020-06-15 Article information storage method and device, electronic equipment and storage medium

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN202010544545.4A CN113762818A (en) 2020-06-15 2020-06-15 Article information storage method and device, electronic equipment and storage medium

Publications (1)

Publication Number Publication Date
CN113762818A true CN113762818A (en) 2021-12-07

Family

ID=78785352

Family Applications (1)

Application Number Title Priority Date Filing Date
CN202010544545.4A Pending CN113762818A (en) 2020-06-15 2020-06-15 Article information storage method and device, electronic equipment and storage medium

Country Status (1)

Country Link
CN (1) CN113762818A (en)

Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2280354A1 (en) * 1998-08-31 2000-02-29 Ncr Corporation System and method of altering transaction terms based upon current inventory levels
CN103530800A (en) * 2013-10-28 2014-01-22 宁夏天纵泓光余热发电技术有限公司 Logo terminal for fresh goods
CN103593787A (en) * 2013-10-25 2014-02-19 宁夏天纵泓光余热发电技术有限公司 Meat commodity sales system and method
CN108369710A (en) * 2016-01-07 2018-08-03 甲骨文国际公司 The promotion and price reduction scheduling of computerization
CN108805473A (en) * 2017-04-26 2018-11-13 上海橙亚商务咨询有限公司 Optimize the system and method for price fixing and stock control using advanced price/fulfilment date matcher
CN109948963A (en) * 2017-12-20 2019-06-28 北京京东尚科信息技术有限公司 Order placement service providing method and its system, computer system

Patent Citations (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CA2280354A1 (en) * 1998-08-31 2000-02-29 Ncr Corporation System and method of altering transaction terms based upon current inventory levels
CN103593787A (en) * 2013-10-25 2014-02-19 宁夏天纵泓光余热发电技术有限公司 Meat commodity sales system and method
CN103530800A (en) * 2013-10-28 2014-01-22 宁夏天纵泓光余热发电技术有限公司 Logo terminal for fresh goods
CN108369710A (en) * 2016-01-07 2018-08-03 甲骨文国际公司 The promotion and price reduction scheduling of computerization
CN108805473A (en) * 2017-04-26 2018-11-13 上海橙亚商务咨询有限公司 Optimize the system and method for price fixing and stock control using advanced price/fulfilment date matcher
CN109948963A (en) * 2017-12-20 2019-06-28 北京京东尚科信息技术有限公司 Order placement service providing method and its system, computer system

Similar Documents

Publication Publication Date Title
CN110826831A (en) Method and device for restocking a picking zone of a warehouse
CN112884405A (en) Inquiry system and scheduling method thereof
CN111461583B (en) Inventory checking method and device
CN111401684A (en) Task processing method and device
CN110858332B (en) Order production method and device
CN111753019A (en) Data partitioning method and device applied to data warehouse
CN111275450A (en) Method and system for processing associated preferential information after goods return
CN113112048A (en) Method and device for returning articles to warehouse
CN113762818A (en) Article information storage method and device, electronic equipment and storage medium
CN113762863B (en) Inventory management method and device
CN113762819A (en) Channel scheduling method and device
CN109902847B (en) Method and device for predicting amount of orders in branch warehouse
CN113822516A (en) Matching method and device for distribution and transportation side
CN113780914A (en) Inventory allocation method and device
CN113496386A (en) Method and device for combined charging
CN111695749A (en) Method and device for generating grouping tasks
CN113434754A (en) Method and device for determining recommended API (application program interface) service, electronic equipment and storage medium
CN110827047A (en) Dynamic pricing method and device
CN112785358A (en) Order fulfillment merchant access method and device
CN112015565A (en) Method and device for determining task downloading queue
CN112053106A (en) Method and device for managing delivery of articles
CN109978422A (en) Overstock article judgment method and device
CN110826948A (en) Warehouse product selection method and device
CN113344706A (en) Product quota control method, device, electronic equipment and computer readable medium
CN111291038B (en) Data query method and device

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