CN109472534B - Commodity name association method and system - Google Patents

Commodity name association method and system Download PDF

Info

Publication number
CN109472534B
CN109472534B CN201811374544.9A CN201811374544A CN109472534B CN 109472534 B CN109472534 B CN 109472534B CN 201811374544 A CN201811374544 A CN 201811374544A CN 109472534 B CN109472534 B CN 109472534B
Authority
CN
China
Prior art keywords
commodity
commodities
information
goods
association
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Active
Application number
CN201811374544.9A
Other languages
Chinese (zh)
Other versions
CN109472534A (en
Inventor
申智强
陈健
陶诗豪
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Shenzhen Forwor Technology Co ltd
Original Assignee
Shenzhen Forwor 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 Shenzhen Forwor Technology Co ltd filed Critical Shenzhen Forwor Technology Co ltd
Priority to CN201811374544.9A priority Critical patent/CN109472534B/en
Publication of CN109472534A publication Critical patent/CN109472534A/en
Application granted granted Critical
Publication of CN109472534B publication Critical patent/CN109472534B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

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

Landscapes

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

Abstract

The invention discloses a commodity name correlation method and a system, firstly, matching commodities to be warehoused in a commodity database, judging whether the commodities exist in the commodity database, if so, directly completing warehousing, otherwise, judging whether the commodity database contains a commodity specification combination which can be correlated with the commodities to be warehoused, if so, correlating the commodity information with the relevant commodity specification combination, creating correlation attributes of the commodities combined with the relevant commodity specification to store the correlation relationship, and completing warehousing of the commodities, wherein the correlation attributes are added in the commodity attribute information and recording whether the commodities are correlated with the commodities associated with the commodity attributes; and if the judgment result is negative, the commodity is put on the shelf to be associated, and warehousing is finished. The invention establishes commodity association for commodities with different names of different merchants in the process of stocking and warehousing, and subsequent stocking of upstream and downstream can automatically manage inventory after successful association.

Description

Commodity name association method and system
Technical Field
The invention belongs to the technical field of commodity information association and linkage, and particularly relates to a commodity name association method and system.
Background
The first is unified management, and all circulating commodities are kept consistent, such as a commodity management system of a large-scale merchant super and chain brands; the second is a commodity management system of a merchant platform, the commodities in the system cannot be associated on the system, a merchant needs to separately enter the commodities, then the commodity information is input into the store and sold, the commodities to be bought and the commodities to be sold are not linked in the system, and the selling and the stocking are separated. In the automatic replenishment process, names and calling of a certain commodity in a supplier, a merchant and a distributor may be different, when the names and calling of the same commodity are different, automatic replenishment is difficult to realize, the existing e-commerce cannot effectively establish contact, the process is complicated, and unified management is difficult to form for the commodities with the same commodity but different names.
When commodities with different names are circulated, commodities on the upstream and downstream cannot be linked, inventory cannot be managed conveniently, and initialization and subsequent inventory management of commodity inventory often need to be performed manually, by table import and the like, so that the workload is heavy, and the labor input is costly.
Disclosure of Invention
The invention aims to: the commodity name association method and system are provided for solving the problems that in a commodity management system of an e-commerce platform at present, commodity attributes such as names of the same commodity to be purchased and the commodity to be sold are different but no association is established, so that commodities of the same type with different names cannot be associated and linked, stock cannot be managed conveniently, manual management is needed, the repeated workload is large, and a large amount of manpower is consumed.
The technical scheme adopted by the invention is as follows:
a commodity name association method comprises the following steps:
step 1, submitting commodity information to be warehoused, performing commodity attribute matching on a commodity to be warehoused in a commodity database, judging whether the commodity exists in the commodity database, and if not, performing the next step, and if so, directly completing warehousing of the commodity;
step 2, judging whether the commodity database contains a commodity specification combination which can be associated with the commodities to be warehoused, if so, entering step 3, and if not, entering step 4;
step 3, associating the commodity information with the relevant commodity specification combination, creating the association attribute of the commodity combined with the relevant commodity specification to store the association relationship, and finishing warehousing of the commodity, wherein the association attribute is added in the commodity attribute information and records whether the associated commodity and the commodity attribute of the associated commodity are related or not;
and 4, carrying out shelving association on the commodity to finish warehousing.
Further, the commodity attributes in step 1 include a merchant number, a commodity specification, a commodity number, and basic attributes thereof.
Further, in the step 2, the commodity number attribute of the warehoused commodity is selected to judge whether the commodity database contains a commodity specification combination which can be associated with the submitted commodity information.
Further, the commodity information submitted in step 1 is commodity combination information, and the commodity combination information = specification combination of warehoused commodities + specification combination of incoming commodities.
Further, the commodity shelving association in the step 4 is a one-key shelving association, and the specific steps are as follows:
1) selecting information sources of one-key shelving commodities, entering a commodity list of the information sources, and selecting commodities to be shelved;
2) submitting a goods on-shelf request to generate key information of the goods on-shelf, wherein the key information of the goods on-shelf comprises the unique specification of the goods, the basic attribute of the goods and the one-key goods on-shelf state
3) Automatically rendering key information of the goods on the shelf, and modifying the rendered goods information to finish editing the information of the newly added goods;
4) judging a one-key shelving state according to the key information of the shelving commodity, and performing the next step when the one-key shelving state is true, and not performing the next step when the one-key shelving state is false;
5) performing MD5 verification according to the commodity key information in the step 2) and the newly added commodity information in the step 3) to judge whether the specification of the newly added commodity information is modified, and if so, only newly adding commodities without associating commodities; and if not, associating the commodities and storing the shelving association information.
Further, the step 3) comprises the following steps:
step 3.1: matching the basic commodity attributes of the commodities on the shelves with the commodity editing unit according to the shelving requests of the commodities to be shelved to finish automatic rendering;
step 3.2: and the user changes the commodity editing unit based on the rendered commodity editing unit to finish editing the information of the newly added commodity.
Further, the step 5) comprises the following steps:
step 5.1: generating an initial MD5 check value from the key information of the upper commodity in the step 2);
step 5.2: generating a target MD5 check value from commodity key information corresponding to the newly added commodity information, judging whether the target MD5 check value is matched with the initial MD5 check value, if so, successfully checking, and skipping to the step 5.4 if the specification of the newly added commodity information is not modified; if not, the verification fails, the specification of the newly added commodity information is modified, and the step 5.3 is skipped;
step 5.3: commodities are not related, and only commodities are newly added;
step 5.4: and associating the commodities and storing the shelving association information.
A commodity name correlation system comprises a commodity module, a correlation judgment module, a correlation warehousing module and an on-shelf correlation warehousing module, wherein:
a commodity module: selecting goods to be warehoused, performing goods attribute matching on the goods to be warehoused in a goods database, judging whether the goods exist in the goods database, directly transmitting goods information to a goods database of a goods module for warehousing if the judgment result is yes, and transmitting the goods information to be warehoused to an association judgment module if the judgment result is not;
an association judgment module: judging whether a commodity database contains a commodity specification combination which can be associated with commodities to be warehoused or not according to the information of the commodities to be warehoused, if so, transmitting the information of the commodities to be warehoused to an associated warehousing module, and if not, transmitting the information of the commodities to be warehoused to an overhead associated warehousing module;
and a correlation storage module: associating the information of the commodities to be warehoused with the relevant commodity specification combination, creating the association attributes of the commodities to be warehoused and the relevant commodity specification combination to store the association relationship, and completing the association warehousing, wherein the association attributes record whether the associated commodities and the commodity attributes of the associated commodities are related or not;
a shelving association warehousing module: and carrying out shelving association on the commodity to be warehoused to finish warehousing.
Further, the commodity module comprises a merchant number table, a commodity specification table, a commodity number table and a basic attribute table thereof.
Further, the shelving association storage module comprises:
a commodity supply unit: the commodity information providing system is used for providing information sources of commodities to be shelved for a user to select the commodities to be shelved in the commodity list;
a racking unit: the commodity editing unit is used for providing a button and an interface for putting commodities on shelves, submitting a one-key putting request and transmitting generated key information of the commodities on shelves to the commodity editing unit, wherein the key information of the commodities on shelves comprises the unique specification of the commodities, the basic attribute of the commodities and the one-key putting state of the commodities;
a product editing unit: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for finishing rendering after receiving key information of goods on shelves transmitted by a shelving unit and finishing editing information of newly added goods according to goods information modified by a user;
a key racking state determination module: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for displaying a commodity on the display unit, and the display unit is used for displaying the commodity on the display unit;
an association unit: when the one-key shelving state is true, performing MD5 verification according to the key information of the shelving commodities and the newly added commodity information, judging whether the specification of the newly added commodity information is modified, if so, not associating the commodities, and only adding the commodities; and if not, associating the commodities and storing the shelving association information.
In summary, due to the adoption of the technical scheme, the invention has the beneficial effects that:
1. the method and the system perform association judgment on the goods in the goods database, establish goods association for goods with different names of different merchants in the process of goods entering and warehousing, automatically manage inventory for subsequent goods entering at upstream and downstream after successful association, and keep the goods after the association attribute is established, so that the goods association is not influenced because the goods name needs to be modified for sale, and the problems that the same goods in the goods management system of the current e-commerce platform are not associated with different names of the goods for sale, so that the goods at upstream and downstream cannot be associated and linked when the goods with different names circulate, the inventory cannot be managed conveniently, the manual management of the goods with different names has large workload and large manpower consumption are solved;
2. in the invention, the commodity number attribute is selected to judge whether the commodity database contains a commodity specification combination which can be associated with the submitted commodity information, namely whether the commodity specification combination is associated is judged according to the commodity numbers of the two commodities, and the commodity specification combination can be associated with the merchant to which the commodity belongs through the commodity numbers, so that the association between the merchant and the merchant is further realized, and the commodity management of stocking and selling is more convenient.
Drawings
In order to more clearly illustrate the technical solutions of the embodiments of the present invention, the drawings needed to be used in the embodiments will be briefly described below, it should be understood that the following drawings only illustrate some embodiments of the present invention and therefore should not be considered as limiting the scope, and for those skilled in the art, other related drawings can be obtained according to the drawings without inventive efforts.
FIG. 1 is an overall flow chart of the method of the present invention;
FIG. 2 is a flow chart of a one-key shelving correlation method in the method of the present invention;
FIG. 3 is a diagram of an operation interface of a one-key shelving system in the method of the present invention;
FIG. 4 is a diagram of an operation interface of the one-key shelving system in the method of the present invention.
Detailed Description
In order to make the objects, technical solutions and advantages of the present invention more apparent, the present invention is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the detailed description and specific examples, while indicating the preferred embodiment of the invention, are intended for purposes of illustration only and are not intended to limit the scope of the invention. The components of embodiments of the present invention generally described and illustrated in the figures herein may be arranged and designed in a wide variety of different configurations.
Thus, the following detailed description of the embodiments of the present invention, presented in the figures, is not intended to limit the scope of the invention, as claimed, but is merely representative of selected embodiments of the invention. All other embodiments, which can be derived by a person skilled in the art from the embodiments of the present invention without making any creative effort, shall fall within the protection scope of the present invention.
It is noted that relational terms such as "first" and "second," and the like, may be used solely to distinguish one entity or action from another entity or action without necessarily requiring or implying any actual such relationship or order between such entities or actions. Also, the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising an … …" does not exclude the presence of other identical elements in a process, method, article, or apparatus that comprises the element.
A commodity name association method is shown in figure 1, and the general flow chart of the method comprises the following steps:
step 1, submitting commodity information to be warehoused, performing commodity attribute matching on a commodity to be warehoused in a commodity database, judging whether the commodity exists in the commodity database, if not, performing the next step, and if so, directly completing warehousing of the commodity and correspondingly modifying the commodity inventory in the corresponding database;
step 2, judging whether the commodity database contains a commodity specification combination which can be associated with the commodities to be warehoused, if so, entering step 3, and if not, entering step 4;
step 3, associating the commodity information with the relevant commodity specification combination, creating the association attribute of the commodity combined with the relevant commodity specification to store the association relationship, and finishing warehousing of the commodity, wherein the association attribute is added in the commodity attribute information and records whether the associated commodity and the commodity attribute of the associated commodity are related or not;
and 4, carrying out shelving association on the commodity to finish warehousing.
Establishing the association refers to the commodity management of the existing commodities (the commodities already on shelves) and the order of the incoming commodity, and no shelving is needed (only the association is not needed). If the judgment result in the step 2 is negative, the step of performing shelving association on the commodity refers to adding the commodity (the association is completed while shelving).
Preferably, the commodity attributes in step 1 include a merchant number, a commodity specification, a commodity number and basic attributes thereof.
Preferably, in the step 2, the commodity number attribute of the warehoused commodity is selected to judge whether the commodity database contains a commodity specification combination which can be associated with the submitted commodity information.
Preferably, the commodity information submitted in step 2 is commodity combination information, and the commodity combination information = specification combination of warehoused commodities + specification combination of incoming commodities.
Preferably, the commodity shelving association in the step 4 is a one-key shelving association, and the specific steps are as follows:
1) selecting information sources (suppliers/distributors) of one-key shelving commodities, entering a commodity list of the suppliers/distributors, and selecting commodities to be shelved;
2) submitting a goods on-shelf request to generate key information of the goods on-shelf, wherein the key information of the goods on-shelf comprises the unique specification of the goods, the basic attribute of the goods and a one-key goods on-shelf state;
3) automatically rendering key information of the goods on the shelf, modifying the rendered goods information to finish editing newly added goods information, wherein the goods information = complete goods attribute information + goods number of goods information source;
4) judging a one-key shelving state according to the key information of the shelving commodity, and performing the next step when the one-key shelving state is true, and not performing the next step when the one-key shelving state is false;
5) performing MD5 verification according to the commodity key information in the step 2) and the newly added commodity information in the step 3) to judge whether the specification of the newly added commodity information is modified, and if so, only newly adding commodities without associating commodities; and if not, associating the commodities and storing the shelving association information.
Preferably, the step 3) comprises the following steps:
step 3.1: matching the basic commodity attributes of the commodities on the shelves with the commodity editing unit according to the shelving requests of the commodities to be shelved to finish automatic rendering;
step 3.2: and the user changes the commodity editing unit based on the rendered commodity editing unit to finish editing the information of the newly added commodity.
Preferably, the step 5) comprises the following steps:
step 5.1: generating an initial MD5 check value from the key information of the upper commodity in the step 2);
step 5.2: generating a target MD5 check value from commodity key information corresponding to the newly added commodity information, judging whether the target MD5 check value is matched with the initial MD5 check value, if so, successfully checking, and skipping to the step 5.4 if the specification of the newly added commodity information is not modified; if not, the verification fails, the specification of the newly added commodity information is modified, and the step 5.3 is skipped;
step 5.3: commodities are not related, and only commodities are newly added;
step 5.4: and associating the commodities and storing the shelving association information.
In the method, the specifications of commodities are various, and each combination is a related minimum unit when the commodities are put in a warehouse. For example: the same commodity of the merchant is the children's garment T XUE, the color is red and blue, the size is 140cm and 150cm, the commodity specification combination which can be put in storage comprises 4 kinds, namely red, 140cm, [ blue, 140cm, [ red, 150cm ], blue and 150 cm. When the user performs warehousing and stocking operation, the specification combination and the quantity of the stocking commodities need to be selected, and after the related warehousing is finished, commodities with various specification combinations can exist in one stocking order list.
The basic attributes of the commodity comprise: name, category, unit, shelving status, remarks, inventory management status, price information, barcode information, etc. of the item.
Valid ranges of association relations are exemplified by:
if the following two commodities "Children's garment t XUE 1" and "t XUE 2" are associated by warehousing with the specification combination yellow, 150cm "and coffee, M":
merchant's child T XUE 1 (specifications: yellow, blue, 150cm, 160 cm) for Merchant A and T XUE 2 (coffee, sky blue, M, L) for Merchant B.
When merchant B changes the name of "t XUE 2" to "Children's garment t XUE 2", the association is not changed.
When the merchant B adds one specification (male, female) to "t XUE 2", and the specification combination fails due to the addition of the specification, the commodity association also fails. The original specification combination 'coffee color and M' can not exist, and becomes 'coffee color, M and male' or 'coffee color, M and female'.
When the operator carries out a stock order, the method judges whether the commodity in the stock order exists in the commodity list of the operator, if so, the commodity is related with the upstream and the downstream, and the commodity is directly put in storage; if not, there are two cases: firstly, the commodity does not exist, the quick commodity shelving association can be completed through the function of one-key shelving at the moment, secondly, the commodity with different name specifications actually exists, association is not formed, and at the moment, the commodity in the incoming order is associated with the commodity in the commodity list. The two commodities after the association relationship is established can not be released because of the change of the commodity name.
A commodity name correlation system comprises a commodity module, a correlation judgment module, a correlation warehousing module and an on-shelf correlation warehousing module, wherein:
a commodity module: selecting goods to be warehoused, performing goods attribute matching on the goods to be warehoused in a goods database, judging whether the goods exist in the goods database, directly transmitting goods information to a goods database of a goods module for warehousing if the judgment result is yes, and transmitting the goods information to be warehoused to an association judgment module if the judgment result is not;
an association judgment module: judging whether a commodity database contains a commodity specification combination which can be associated with commodities to be warehoused or not according to the information of the commodities to be warehoused, if so, transmitting the information of the commodities to be warehoused to an associated warehousing module, and if not, transmitting the information of the commodities to be warehoused to an overhead associated warehousing module;
and a correlation storage module: associating the information of the commodities to be warehoused with the relevant commodity specification combination, creating the association attributes of the commodities to be warehoused and the relevant commodity specification combination to store the association relationship, and completing the association warehousing, wherein the association attributes record whether the associated commodities and the commodity attributes of the associated commodities are related or not;
a shelving association warehousing module: and carrying out shelving association on the commodity to be warehoused to finish warehousing.
Preferably, the commodity module includes a merchant number table, a commodity specification table, a commodity number table and a basic attribute table thereof.
Preferably, the shelving associating and warehousing module includes:
a commodity supply unit: the commodity information providing system is used for providing information sources of commodities to be shelved for a user to select the commodities to be shelved in the commodity list;
a racking unit: the commodity editing unit is used for providing a button and an interface for putting commodities on shelves, submitting a one-key putting request and transmitting generated key information of the commodities on shelves to the commodity editing unit, wherein the key information of the commodities on shelves comprises the unique specification of the commodities, the basic attribute of the commodities and the one-key putting state of the commodities;
a product editing unit: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for finishing rendering after receiving key information of goods on shelves transmitted by a shelving unit and finishing editing information of newly added goods according to goods information modified by a user;
a key racking state determination module: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for displaying a commodity on the display unit, and the display unit is used for displaying the commodity on the display unit;
an association unit: when the one-key shelving state is true, performing MD5 verification according to the key information of the shelving commodities and the newly added commodity information, judging whether the specification of the newly added commodity information is modified, if so, not associating the commodities, and only adding the commodities; and if not, associating the commodities and storing the shelving association information.
The system is implemented at interfaces associated with the system entity and the commodity entity.
The entity is a technical noun in an object-oriented programming method, mainly comprises attributes and an interface, and realizes the depiction and management of merchant information through the attributes and the interface.
The attributes associated in the commodity entity include:
1) merchant number
2) One-key racking state
3) Other basic attributes: name, specification, category, unit, on-off shelf status, notes, inventory management status, price information, barcode information, and the like.
In the one-key shelf-on-shelf correlation function, the interface related to the commodity entity comprises:
1) obtaining a one-key racking status
2) And adding or modifying a commodity interface.
The method comprises the following steps when using the one-key shelving correlation operation:
if the merchandise information source of the merchandise supply unit is the supplier, the operation steps are as follows: selecting a supplier with commodities, entering a commodity list corresponding to the supplier, selecting the commodities, clicking one-key shelving as shown in figure 3, and entering a commodity newly-added editing page as shown in figure 4, wherein key information of the shelved commodities is generated after clicking one-key shelving, and the key information comprises the unique specification of the commodities and the basic attributes of the commodities; sending the key information of the goods on the shelf to a goods editing unit, and automatically rendering the key information of the goods on the shelf by the goods editing unit; if the new commodity information needs to be changed, editing corresponding new commodity information; judging a one-key shelving state according to the key information of the shelving commodity, completing one-key shelving when the one-key shelving state is true, and performing the operation of the next module; when the one-key shelving state is yes, the newly added commodity information is edited, MD5 verification is carried out, MD5 verification is carried out according to the commodity key information and the newly added commodity information when the one-key shelving is performed, whether the specification of the newly added commodity information is modified or not is judged, if so, the newly added commodity is not related, and only the newly added commodity is associated; if not, the commodities are associated and the shelving associated information is saved (bidirectional saving: commodities from one-key shelving source and current modified/newly added commodities). Determining whether the unique specification of the commodity is not changed by checking whether the specifications of the commodity before and after editing are matched or not, and then associating; if the merchandise information source of the merchandise supply unit is the distributor, the operation steps are similar to those of the supplier, and are not described herein again. Fig. 3 and 4 are diagrams of an operation interface of the one-key shelving system in the method of the invention.
The commodity name association method can be combined with the system to carry out commodity name association and shelving and warehousing, and the corresponding steps in the method correspond to the functions of all modules in the system.
The above description is only for the purpose of illustrating the preferred embodiments of the present invention and is not to be construed as limiting the invention, and any modifications, equivalents and improvements made within the spirit and principle of the present invention are intended to be included within the scope of the present invention.

Claims (7)

1. A commodity name association method is characterized in that: the method comprises the following steps:
step 1, submitting commodity information to be warehoused, performing commodity attribute matching on a commodity to be warehoused in a commodity database, judging whether the commodity exists in the commodity database, and if not, performing the next step, and if so, directly completing warehousing of the commodity;
step 2, judging whether the commodity database contains a commodity specification combination which can be associated with the commodities to be warehoused, if so, entering step 3, and if not, entering step 4;
step 3, associating the commodity information with the relevant commodity specification combination, creating the association attribute of the commodity combined with the relevant commodity specification to store the association relationship, and finishing warehousing of the commodity, wherein the association attribute is added in the commodity attribute information and records whether the associated commodity and the commodity attribute of the associated commodity are related or not;
step 4, putting the commodity on a shelf for association, and finishing warehousing;
the commodity shelving association in the step 4 is a one-key shelving association, and the specific steps are as follows:
1) selecting information sources of one-key shelving commodities, entering a commodity list of the information sources, and selecting commodities to be shelved;
2) submitting a goods on-shelf request to generate key information of the goods on-shelf, wherein the key information of the goods on-shelf comprises the unique specification of the goods, the basic attribute of the goods and the one-key goods on-shelf state
3) Automatically rendering key information of the goods on the shelf, and modifying the rendered goods information to finish editing the information of the newly added goods;
4) judging a one-key shelving state according to the key information of the shelving commodity, and performing the next step when the one-key shelving state is true, and not performing the next step when the one-key shelving state is false;
5) performing MD5 verification according to the commodity key information in the step 2) and the newly added commodity information in the step 3) to judge whether the specification of the newly added commodity information is modified, and if so, only newly adding commodities without associating commodities; if not, correlating the commodities and storing the shelving correlation information;
the step 5) comprises the following steps:
step 5.1: generating an initial MD5 check value from the key information of the upper commodity in the step 2);
step 5.2: generating a target MD5 check value from commodity key information corresponding to the newly added commodity information, judging whether the target MD5 check value is matched with the initial MD5 check value, if so, successfully checking, and skipping to the step 5.4 if the specification of the newly added commodity information is not modified; if not, the verification fails, the specification of the newly added commodity information is modified, and the step 5.3 is skipped;
step 5.3: commodities are not related, and only commodities are newly added;
step 5.4: and associating the commodities and storing the shelving association information.
2. The commodity name associating method according to claim 1, wherein: the commodity attributes in the step 1 include a merchant number, a commodity specification, a commodity number and basic attributes thereof.
3. The commodity name associating method according to claim 1, wherein: and 2, selecting the commodity number attribute for the warehoused commodities to judge whether the commodity database contains a commodity specification combination which can be associated with the submitted commodity information.
4. The commodity name associating method according to claim 1, wherein: the commodity information submitted in the step 1 is commodity combination information, and the commodity combination information = specification combination of warehousing commodities + specification combination of incoming commodities.
5. The commodity name associating method according to claim 1, wherein: the step 3) comprises the following steps:
step 3.1: matching the basic commodity attributes of the commodities on the shelves with the commodity editing unit according to the shelving requests of the commodities to be shelved to finish automatic rendering;
step 3.2: and the user changes the commodity editing unit based on the rendered commodity editing unit to finish editing the information of the newly added commodity.
6. A commodity name association system characterized by: the system comprises a commodity module, an association judgment module, an association warehousing module and an on-shelf association warehousing module, wherein:
a commodity module: selecting goods to be warehoused, performing goods attribute matching on the goods to be warehoused in a goods database, judging whether the goods exist in the goods database, directly transmitting goods information to a goods database of a goods module for warehousing if the judgment result is yes, and transmitting the goods information to be warehoused to an association judgment module if the judgment result is not;
an association judgment module: judging whether a commodity database contains a commodity specification combination which can be associated with commodities to be warehoused or not according to the information of the commodities to be warehoused, if so, transmitting the information of the commodities to be warehoused to an associated warehousing module, and if not, transmitting the information of the commodities to be warehoused to an overhead associated warehousing module;
and a correlation storage module: associating the information of the commodities to be warehoused with the relevant commodity specification combination, creating the association attributes of the commodities to be warehoused and the relevant commodity specification combination to store the association relationship, and completing the association warehousing, wherein the association attributes record whether the associated commodities and the commodity attributes of the associated commodities are related or not;
a shelving association warehousing module: putting the commodity to be warehoused on a shelf for correlation, and completing warehousing;
the racking associated warehousing module comprises:
a commodity supply unit: the commodity information providing system is used for providing information sources of commodities to be shelved for a user to select the commodities to be shelved in the commodity list;
a racking unit: the commodity editing unit is used for providing a button and an interface for putting commodities on shelves, submitting a one-key putting request and transmitting generated key information of the commodities on shelves to the commodity editing unit, wherein the key information of the commodities on shelves comprises the unique specification of the commodities, the basic attribute of the commodities and the one-key putting state of the commodities;
a product editing unit: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for finishing rendering after receiving key information of goods on shelves transmitted by a shelving unit and finishing editing information of newly added goods according to goods information modified by a user;
a key racking state determination module: the system comprises a display unit, a display unit and a display unit, wherein the display unit is used for displaying a commodity on the display unit, and the display unit is used for displaying the commodity on the display unit;
an association unit: when the one-key shelving state is true, performing MD5 verification according to the key information of the shelving commodities and the newly added commodity information, judging whether the specification of the newly added commodity information is modified, if so, not associating the commodities, and only adding the commodities; and if not, associating the commodities and storing the shelving association information.
7. The commodity name association system according to claim 6, wherein: the commodity module comprises a merchant number table, a commodity specification table, a commodity number table and a basic attribute table thereof.
CN201811374544.9A 2018-11-15 2018-11-15 Commodity name association method and system Active CN109472534B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201811374544.9A CN109472534B (en) 2018-11-15 2018-11-15 Commodity name association method and system

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201811374544.9A CN109472534B (en) 2018-11-15 2018-11-15 Commodity name association method and system

Publications (2)

Publication Number Publication Date
CN109472534A CN109472534A (en) 2019-03-15
CN109472534B true CN109472534B (en) 2021-07-27

Family

ID=65672766

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201811374544.9A Active CN109472534B (en) 2018-11-15 2018-11-15 Commodity name association method and system

Country Status (1)

Country Link
CN (1) CN109472534B (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN109977369A (en) * 2019-03-18 2019-07-05 南通中实纺织交易市场有限公司 A kind of commodity management system and method
US20210304275A1 (en) * 2020-03-31 2021-09-30 Coupang Corp. Computer-implemented systems and methods for electronicaly determining a real-time product registration
CN114528343A (en) * 2020-10-23 2022-05-24 花瓣云科技有限公司 Commodity data management method and device and server

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105809393A (en) * 2016-03-01 2016-07-27 成都市泰象网络科技有限公司 System and method for automatically synchronizing e-commerce platform with company's inventory
CN107274270A (en) * 2017-06-20 2017-10-20 浪潮软件股份有限公司 Terminal commodity adding system and method based on shopping mall and cloud commodity library

Family Cites Families (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103425658B (en) * 2012-05-15 2017-06-09 阿里巴巴集团控股有限公司 The storage of merchandise news, searching method and mobile terminal and server
US20160217522A1 (en) * 2014-03-07 2016-07-28 Rare Mile Technologies, Inc. Review based navigation and product discovery platform and method of using same
CN108614811B (en) * 2016-12-09 2021-11-05 腾讯科技(深圳)有限公司 Data analysis method and device
CN106779963A (en) * 2016-12-29 2017-05-31 江西博瑞彤芸科技有限公司 The merchandise news method to set up of associated articles

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105809393A (en) * 2016-03-01 2016-07-27 成都市泰象网络科技有限公司 System and method for automatically synchronizing e-commerce platform with company's inventory
CN107274270A (en) * 2017-06-20 2017-10-20 浪潮软件股份有限公司 Terminal commodity adding system and method based on shopping mall and cloud commodity library

Also Published As

Publication number Publication date
CN109472534A (en) 2019-03-15

Similar Documents

Publication Publication Date Title
CN109544289B (en) Method and system for realizing online wholesale
CN109472534B (en) Commodity name association method and system
US6873967B1 (en) Electronic shopping assistant and method of use
CN106951516B (en) Decoration selection intelligent sorting method based on big data
CN107957867B (en) Electric power retail market model modeling method and system
CN105631722A (en) Service information push method, service information push system and terminal
CN111144970B (en) Order splitting method and device, electronic equipment and readable medium
US7979324B2 (en) Virtual catalog
CN110033350B (en) Textile fabric mobile internet transaction platform
US20130268416A1 (en) Sample identification and distribution system
CN109544069A (en) One kind on-line off-line fusion type commodity replenishing method Internet-based and system
CN114581186A (en) Commodity information display method and device, computer equipment and readable storage medium
CN106296240B (en) Business object accessory information processing method and device
TW201533670A (en) Merchandise/service sales and distribution method and computer readable storage medium having the same
CN112529666A (en) Commodity recommendation method, commodity recommendation system, computer equipment and storage medium
CN112348445A (en) Material record and material order processing method and system in ERP system
CN110335417B (en) Application system and method of electronic water ticket
CN109389451B (en) Method and system for determining recommendation information
CN114372451A (en) Data processing method, device, equipment, computer storage medium and program product
JP2002304537A (en) Merchandise ordering system
CN112288507B (en) Method and device for determining display information
CN110727832A (en) Method for making product information database
KR20080040663A (en) Product optional daily on/off line integration stock manager system
CN111915405A (en) Order management method and system
CN112241897A (en) Method for assisting dealers in popularizing marketing by combining intelligent mobile logistics with intelligent putting-through recommendation

Legal Events

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