CN109299952B - System and method for realizing correlated retrieval of multiple commodity codes - Google Patents

System and method for realizing correlated retrieval of multiple commodity codes Download PDF

Info

Publication number
CN109299952B
CN109299952B CN201810485534.6A CN201810485534A CN109299952B CN 109299952 B CN109299952 B CN 109299952B CN 201810485534 A CN201810485534 A CN 201810485534A CN 109299952 B CN109299952 B CN 109299952B
Authority
CN
China
Prior art keywords
code
commodity
service platform
codes
inquiry
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
CN201810485534.6A
Other languages
Chinese (zh)
Other versions
CN109299952A (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.)
Zhejiang Jiaguwen Chaojima Technology Co ltd
Original Assignee
Zhejiang Jiaguwen Chaojima 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 Zhejiang Jiaguwen Chaojima Technology Co ltd filed Critical Zhejiang Jiaguwen Chaojima Technology Co ltd
Publication of CN109299952A publication Critical patent/CN109299952A/en
Application granted granted Critical
Publication of CN109299952B publication Critical patent/CN109299952B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00Network architectures or network communication protocols for network security
    • H04L63/08Network architectures or network communication protocols for network security for authentication of entities
    • H04L63/0876Network architectures or network communication protocols for network security for authentication of entities based on the identity of the terminal or configuration, e.g. MAC address, hardware or software configuration or device fingerprint
    • 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/018Certifying business or products
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K19/00Record carriers for use with machines and with at least a part designed to carry digital markings
    • G06K19/06Record carriers for use with machines and with at least a part designed to carry digital markings characterised by the kind of the digital marking, e.g. shape, nature, code
    • HELECTRICITY
    • H04ELECTRIC COMMUNICATION TECHNIQUE
    • H04LTRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L63/00Network architectures or network communication protocols for network security
    • H04L63/10Network architectures or network communication protocols for network security for controlling access to devices or network resources
    • H04L63/102Entity profiles

Landscapes

  • Engineering & Computer Science (AREA)
  • Business, Economics & Management (AREA)
  • Computing Systems (AREA)
  • Computer Hardware Design (AREA)
  • Signal Processing (AREA)
  • Computer Networks & Wireless Communication (AREA)
  • General Engineering & Computer Science (AREA)
  • Computer Security & Cryptography (AREA)
  • Physics & Mathematics (AREA)
  • Theoretical Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Accounting & Taxation (AREA)
  • General Business, Economics & Management (AREA)
  • Development Economics (AREA)
  • Strategic Management (AREA)
  • Entrepreneurship & Innovation (AREA)
  • Marketing (AREA)
  • Finance (AREA)
  • Economics (AREA)
  • Power Engineering (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)
  • Storage Device Security (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)

Abstract

The invention relates to a method for realizing the inter-correlation calling of various commodity codes, which comprises a unique internal code, a plurality of external codes, a code service platform and an inquiry terminal, and comprises the following steps: s1, storing an inner code, an outer code and an association corresponding relation of the inner code and the outer code in a server of a code service platform; s2, after the inquiry terminal provides any inquiry outer code marked on the commodity for the code service platform, the code service platform calls a non-inquiry outer code associated with the inquiry outer code through the inner code, and feeds commodity information associated with the inquiry outer code and/or the non-inquiry outer code back to the inquiry terminal. The invention allows consumers to acquire various commodity information only by inquiring one commodity identification code, avoids the condition that the contained information cannot be inquired due to the damage and the invalidation of the commodity identification code, realizes the storage and the quick calling of massive commodity identification codes, not only can realize one object and one code, but also can quickly inquire and feed back the information contained in the commodity identification code.

Description

System and method for realizing correlated retrieval of multiple commodity codes
Technical Field
The invention relates to the technical field of Internet and Internet of things, in particular to a method for realizing correlation of multiple commodity identification codes.
Background
In recent years, the code assigning technology is widely applied in various directions of commodity production, logistics, sales, inventory management, anti-counterfeiting traceability and the like.
For example, one or more of a plurality of identification codes such as a traceability code, an anti-counterfeiting code, a logistics code, a marketing code and the like are generally identified on the current commercial goods. By identifying the logistics codes on the commodities, logistics information can be given to the products, and the article transportation route can be tracked; by marking the anti-counterfeiting code on the commodity, anti-counterfeiting information can be given to the product, and authenticity is confirmed to avoid counterfeiting; by marking the marketing code on the commodity, information such as marketing activities and the like can be added on the product, and the user viscosity is increased; by identifying the traceability codes on the commodities, the whole process information of the products from production to sale can be added on the products, and the user trust degree is increased.
In summary, different codes have different functions, and the types of codes required to be identified by commodities with different attributes are different. For example, for goods such as food, medicine, cosmetics, etc., it is particularly important to use anti-counterfeit codes to help consumers to distinguish true from false. Meanwhile, the flow direction of the commodities is effectively managed and controlled by adopting the logistics codes, so that the products of specific models or batch numbers can be conveniently recalled when the products have quality problems. In addition, for agricultural products or fresh food, it is necessary for manufacturers and consumers of products in this field to help consumers to further master the source information of the products, such as production regions, processing flows, etc., through the source tracing code.
At present, in the field of product anti-counterfeiting tracing, it is a common situation that the same commodity needs to be marked with a plurality of identification codes so as to provide a plurality of different information for consumers. Not only do these codes differ in the information contained and fed back, but their form, manner of query, and platform of query used may vary. For consumers, the ideal situation is that various information such as traceability, anti-counterfeiting, logistics, marketing and the like can be inquired through any one code on the commodity identification, and when one or more codes are invalid due to damage and loss, the information contained in the damage identification code can still be inquired through other commodity identification codes. However, since the code system, query platform, and service provider of each code may not be the same, the above-mentioned complaints of consumers are difficult to achieve.
In addition, with the continuous establishment and improvement of the commodity quality supervision department and the supervision system, many industries and enterprises face the problem that although the commodity management system is established by the commodity identification code, the existing commodity identification code management system cannot meet new requirements or new standards proposed by government and industry supervision departments. The new and old commodity identification code management systems cannot be compatible, the information of commodities which are produced and sold cannot be traced back due to the operation of the new system, and meanwhile, the production and operation cost is increased due to the operation of the old system.
In particular, the enterprise itself often needs to adopt a new product identification code in order to improve related services and product quality, for example, the anti-counterfeiting function is realized, and meanwhile, the anti-counterfeiting performance is further improved and the channel conflict is prevented by adding a logistics code. In this case, the packaging cost is increased by the cancellation of the overprint label and the stock label, and the process of establishing a new product identification code registration inquiry system is complicated.
In another situation, along with the improvement of logistics management standards of various industries and the occurrence of the accurate monitoring requirement of various industries on each node in the production and circulation processes of commodities, it is also necessary to realize the record control of the association, combination or nesting relation of a plurality of commodities through commodity codes.
For example, some industries or merchants expect to accurately record specific association correspondence between each sold commodity and other commodities collocated for sale or bundled for sale, and related information of inventory, flow direction and the like of the commodities; some industries or merchants desire to record the equipment used by each item during the production process; some industries or businesses desire to record the nesting relationship of individual articles of each smallest packaging unit with their entire box of packaged articles, or even an entire stack of articles.
Disclosure of Invention
In order to overcome the defects in the prior art, the invention discloses a method for realizing the correlation of various commodity identification codes.
The invention is realized by the following technical scheme:
a method for realizing the inter-correlation retrieval of a plurality of commodity codes comprises a unique inner code, a plurality of outer codes, a code service platform and an inquiry terminal of a single commodity of each minimum packaging unit, and is characterized by comprising the following steps:
s1, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform;
s2, after the inquiry terminal provides any one inquiry outer code marked on the commodity for the code service platform, the code service platform calls a non-inquiry outer code associated with the inquiry outer code through the inner code, and feeds back part or all of commodity information associated with the inquiry outer code and/or the non-inquiry outer code to the inquiry terminal.
Further, the server includes a database server and an Elasticsearch server, in step S1, the internal code and the external code are stored in the database server of the code service platform, and the association correspondence between the internal code and the external code is stored in the Elasticsearch server of the code service platform.
Further, step S1 specifically includes the following steps:
s1-1, respectively assigning the inner code and the outer code to the single commodity of each minimum packaging unit;
s1-2, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform.
Further, step S2 specifically includes the following steps:
s2-1, the code service platform receives the query outer code provided by the query terminal;
s2-1, in the code service platform, obtaining an outer code global serial number and an inner code global serial number corresponding to the query outer code;
s2-3, in the code service platform, obtaining an outer code sublist and an inner code sublist according to the outer code global serial number and the inner code global serial number;
s2-4, in the code service platform, acquiring corresponding commodity information according to the outer code sublist and the inner code sublist;
s2-5, feeding back part or all of the commodity information in the code service platform to the inquiry terminal.
Further, the inner code is an infinitely growing inner code.
Furthermore, the number of the outer codes is at least two, the outer codes comprise at least one inquiry outer code and at least one non-inquiry outer code, and the code systems adopted by the at least two outer codes are different from each other.
Further, the storage model data of the correlation corresponding relation between the internal code and the external code is stored in a sub-base sub-table of the mysql database.
Further, in step S2, part or all of the commodity information is packaged into JSON format and then fed back to the query terminal.
Further, the outer code comprises one or more of an anti-counterfeiting code, a logistics code, a marketing code, a traceability code, a pesticide code and a 0ID code.
Further, the outer code is one or more of a character string, a one-dimensional code, a two-dimensional code and a multi-dimensional code.
Compared with the prior art, the invention has the advantages that:
1. the invention allows a consumer to obtain various commodity information including the tracing information, the anti-counterfeiting information, the marketing information and the like only by inquiring one commodity identification code, thereby avoiding the condition that the consumer adopts various codes and utilizes various platforms to inquire and verify for many times and improving the user experience of the consumer;
2. in the invention, under the condition that one or more commodity identification codes are damaged, the information contained in the damaged commodity identification codes can be inquired through the good commodity identification codes, so that the condition that the contained information cannot be inquired due to damage and invalidation of the commodity identification codes is avoided;
3. the invention allows the commodity production enterprises to add new commodity identification codes, change the types or forms of the commodity identification codes and change the functions realized by the existing commodity identification codes or the carried information at any time according to the requirements of the supervision department or the actual needs of the enterprises, thereby improving the flexibility of assigning codes to the commodity identification codes and saving the production cost;
4. the invention can realize the storage and the quick retrieval of mass commodity identification codes, not only can realize one-object-one-code, and can assign codes to the commodities in the smallest packing unit of each single commodity, but also can quickly inquire and feed back the information contained in the commodity identification codes. Because the data storage capacity is large and the calling speed is high, the invention can allow different enterprises, even different industries to use the same open commodity identification code management query platform while improving the user experience of consumers, thereby not only allowing various production enterprises to directly apply for issuing of the commodity identification code and personalized service customization to the open platform, but also allowing enterprises without corresponding development capacity, code assigning and code management capacity to customize and purchase service to the open commodity identification code management query platform as required.
Drawings
FIG. 1: the embodiment of the invention provides a schematic diagram of the relationship between an inner code and an outer code;
FIG. 2: the overall step schematic diagram of the method for realizing the correlated calling of the multiple commodity codes in the embodiment of the invention is shown;
FIG. 3: the commodity label schematic diagram of the embodiment of the invention;
FIG. 4: the embodiment of the invention provides a specific step schematic diagram of a method for realizing the correlated calling of a plurality of commodity codes.
Detailed Description
The embodiment of the invention provides a method for realizing the inter-association calling of various commodity codes, which comprises an inner code, an outer code, a code service platform and an inquiry terminal of each single commodity with the smallest packaging unit. As shown in fig. 1, the single commodity of each minimum packaging unit provided by the embodiment of the present invention has a unique number of the inner codes, the number of the outer codes is several, each of the outer codes contains different commodity information, and each of the outer codes is associated with a unique inner code. An inner code, which is an infinitely growing inner code, may be mapped and associated with a plurality of outer codes having different code systems.
The outer code is marked on the commodity or the outer package and comprises any one or more of an anti-counterfeiting code, a marketing code, a logistics code, a traceability code, a pesticide code and a 0ID code. The anti-counterfeiting code is used for bearing anti-counterfeiting information and confirming authenticity to avoid counterfeiting; the marketing code is used for bearing and recording product marketing activity information; the logistics code is used for bearing logistics information and tracking an article conveying route; the source tracing code is used for bearing production and processing information of a product; the pesticide code is a code woven according to pesticide code rules formulated by the ministry of agriculture, and comprises a fixed prefix of the front 11 bits and a random code of the rear 21 bits, and is used for managing agricultural products; the 0ID coding structure is a tree structure, different layers are separated by using the 'er', and the number of layers is not limited. When identifying the object, the identifier is a character string formed by sequentially combining nodes on all paths from the root of the tree to the leaf. The international root node is divided into three branches of ISO, ISO-ITU union (join-ISO-ITU-T) and ITU-T, wherein each country member is responsible for the management and registration of the 0ID inside the country under the ISO and ISO-ITU union node.
The external code can be a code which can be manually identified and checked by a consumer, or a code which needs to be read by a code reading device such as a smart phone, a POS machine, a bar code gun and the like. Specifically, the outer code may be a number, or an alphabet, or a character string formed by combining a number and an alphabet, or may be a one-dimensional code, a two-dimensional code, or a multi-dimensional code.
The internal code is only exposed to the interior of the code service platform and is not marked on the commodity. The inner code is not only unique, but can be infinitely increased, and the inner codes of the individual commodities of each minimum packaging unit are different from each other.
As shown in fig. 2, the embodiment of the present invention realizes the inter-association calling of multiple commodity codes by the following steps:
s1, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform;
s2, after the inquiry terminal provides any one inquiry outer code marked on the commodity for the code service platform, the code service platform calls a non-inquiry outer code associated with the inquiry outer code through the inner code, and feeds back part or all of commodity information associated with the inquiry outer code and/or the non-inquiry outer code to the inquiry terminal.
The query terminal in step S2 may be a mobile phone, a computer, a handheld POS, or other devices, and the consumer or the market monitoring department may submit the query external code to the code service platform in a manner of scanning a code by WeChat, or logging in a mobile phone APP or a computer web page. In step S2, some or all of the commodity information may be packaged into JSON format and then fed back to the query terminal.
In step S2, the consumer or the market regulatory agency provides any one of the external codes to the code service platform for commodity information inquiry (i.e., provides the inquiry external code) by scanning or manual input through the inquiry terminal. The code service platform calls a unique internal code corresponding to the query external code through the query external code provided by a consumer or a market regulatory department, calls other external codes related to the internal code through the internal code (namely calling a non-query external code), and feeds back part or all of commodity information related to the query external code and/or the non-query external code to the query terminal.
In one embodiment of the present invention, the server includes a database server and an Elasticsearch server, and in step S1, the internal code and the external code are stored in the database server of the code service platform, and the association relationship between the internal code and the external code is stored in the Elasticsearch server of the code service platform.
For example, as shown in fig. 3, a merchant identifies an anti-counterfeit code 2 in the form of a digital character string, a logistics code 3 in the form of a barcode, and a traceability code 4 in the form of a two-dimensional code on a commodity label 1, where the anti-counterfeit code 2 is used for a consumer to inquire and verify the authenticity of a product, the logistics code 3 is used for a dealer at each step to register and upload product circulation information, so that the consumer can obtain node information at each step in the product circulation process by scanning the logistics code 3, and the traceability code 4 records relevant information of commodities such as a commodity manufacturer, a batch, a production date, an inspection result, and the like. In the prior art, the anti-counterfeiting code 2, the logistics code 3 and the traceability code 4 need to be scanned respectively to sequentially obtain corresponding authenticity information, circulation information and commodity identity information. The code system, the required scanning or input mode and the adopted query platform adopted by the anti-counterfeiting code 2, the logistics code 3 and the tracing code 4 may be different, and consumers need to obtain all relevant information by respectively querying.
According to the method for realizing the correlated calling of the multiple commodity codes, provided by the embodiment of the invention, firstly, three external codes comprising an anti-counterfeiting code 2, a logistics code 3 and a traceability code 4 are correlated with an internal code stored in a server of the code service platform respectively, and the correlation corresponding relation between all the external codes and the internal code is recorded. The internal code and the external code are stored in a database server of the code service platform, and the correlation corresponding relation of the internal code and the external code is stored in an Elasticissearch server of the code service platform.
Therefore, a consumer or a market supervision department can obtain the inner code corresponding to the inquiry outer code by only adopting the inquiry terminal to provide the anti-counterfeiting code 2 (namely, providing the inquiry outer code) for the code service platform, and obtain the commodity information contained in the logistics code 3 and the tracing code 4 (namely, the non-inquiry outer code) corresponding to the commodity according to the inner code. The code service platform can set specific inquiry authority according to actual needs, so that part or all of commodity information is fed back to consumers or market monitoring departments.
Therefore, according to the embodiment of the invention, a consumer can obtain various commodity information including the tracing information, the anti-counterfeiting information, the marketing information and the like by only inquiring one commodity identification code, so that the user experience of the consumer is improved. In addition, in the case that one or more of the commodity identification codes are damaged, the information contained in the damaged commodity identification code can be inquired through the intact commodity identification code. Finally, under the condition that a merchant needs to add a new code system or a commodity identification code containing new information, the newly added external code and the original internal code are correlated with each other only in the server of the code service platform, and the original information can be inquired through the new external code or the added information can be inquired through the original external code.
As shown in fig. 4, in one embodiment of the present invention, the steps S1 and S2 respectively specifically include the following steps:
s1-1, respectively assigning the inner code and the outer code to the single commodity of each minimum packaging unit;
s1-2, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform;
s2-1, the code service platform receives the query outer code provided by the query terminal;
s2-1, in the code service platform, obtaining an outer code global serial number and an inner code global serial number corresponding to the query outer code;
s2-3, in the code service platform, obtaining an outer code sublist and an inner code sublist according to the outer code global serial number and the inner code global serial number;
s2-4, in the code service platform, acquiring corresponding commodity information according to the outer code sublist and the inner code sublist;
s2-5, feeding back part or all of the commodity information in the code service platform to the inquiry terminal.
In some embodiments of the present invention, the association relationship between the internal code and the external code is stored by an Elasticsearch association index model, and the storage model data of the association relationship between the internal code and the external code is stored in a sub-library sub-table of the mysql database. The main keys of the outer code and the inner code are realized in a mode of generating a uniform serial number through cache, and the uniform serial number is a self-increment sequence. The increase of the data volume of the outer code and the inner code realizes the horizontal expansion of the data volume through the strategy of database division and table division, and realizes the table to be inquired by the corresponding outer code table and the inner code table and the corresponding library name through the route addressing mode of the uniform serial number of the self-increasing sequence. The expansion of the data amount stored in the database does not influence the searching speed of the external code and the internal code, and the background can be expanded to hundreds of servers to process PB-level code data, so that the user experience is further improved. If the information of the codes is not complete, after the information of the corresponding table corresponding to the mysql database table is obtained through the Elasticissearch associated index model, the information of other codes is inquired, and then the information is uniformly fed back to the outside.
Through an elastic search associated index model and a storage mode of establishing and sub-base sub-tables, the embodiment of the invention can realize the storage and retrieval of massive internal codes and external codes, not only can realize one object and one code, but also can quickly inquire and feed back the information contained in the external codes. Because the data storage capacity is large and the calling speed is high, the invention can allow different enterprises, even different industries to use the same open commodity identification code management query platform while improving the user experience of consumers, thereby not only allowing various production enterprises to directly apply for issuing of the commodity identification code and personalized service customization to the open platform, but also allowing enterprises without corresponding development capacity, code assigning and code management capacity to customize and purchase service to the open commodity identification code management query platform as required.
It is obvious that the above embodiments are only a part of the embodiments of the present invention, and not all of them. Based on the embodiments of the present invention, those skilled in the art should also include various changes, modifications, substitutions and improvements without creative efforts to the embodiments.

Claims (9)

1. A method for realizing the correlated retrieval of a plurality of commodity codes comprises a unique inner code, a plurality of outer codes, a code service platform and a query terminal which are possessed by a single commodity of each minimum packaging unit, and is characterized in that each outer code contains different commodity information, each outer code is correlated with the unique inner code, the unique inner code is an infinitely-increased inner code which is exposed only inside the code service platform and can be mutually mapped and correlated with the plurality of outer codes with different code systems, a main key of each outer code and the inner code is realized by a mode of generating a uniform serial number through caching, the uniform serial number is a self-increasing sequence, the increase of the data quantity of the outer codes and the inner codes realizes the horizontal expansion of the data quantity through the strategy of sub-base sub-tables, and the table and the corresponding library name which are required to be queried by the corresponding outer code table and inner code table are realized through the routing addressing mode of the uniform serial number of the self-increasing sequence, which comprises the following steps:
s1, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform;
s2, after the inquiry terminal provides any one inquiry outer code marked on the commodity for the code service platform, the code service platform calls a non-inquiry outer code associated with the inquiry outer code through the inner code, and feeds back part or all of commodity information associated with the inquiry outer code and/or the non-inquiry outer code to the inquiry terminal.
2. The method for realizing retrieval of correlation among multiple commodity codes according to claim 1, wherein the server comprises a database server and an elastic search server, in step S1, the internal code and the external code are stored in the database server of the code service platform, and the correlation correspondence between the internal code and the external code is stored in the elastic search server of the code service platform.
3. The method for realizing the inter-related retrieval of a plurality of commodity codes according to claim 1, wherein the step S1 specifically comprises the steps of:
s1-1, respectively assigning the inner code and the outer code to the single commodity of each minimum packaging unit;
s1-2, storing the internal code, the external code and the correlation corresponding relation of the internal code and the external code in a server of the code service platform.
4. The method for realizing the inter-related retrieval of a plurality of commodity codes according to claim 1, wherein the step S2 specifically comprises the steps of:
s2-1, the code service platform receives the query outer code provided by the query terminal;
s2-1, in the code service platform, obtaining an outer code global serial number and an inner code global serial number corresponding to the query outer code;
s2-3, in the code service platform, obtaining an outer code sublist and an inner code sublist according to the outer code global serial number and the inner code global serial number;
s2-4, in the code service platform, acquiring corresponding commodity information according to the outer code sublist and the inner code sublist;
s2-5, feeding back part or all of the commodity information in the code service platform to the inquiry terminal.
5. The method for realizing the correlated retrieval of the plurality of commodity codes according to claim 1, wherein: the number of the outer codes is at least two, the outer codes comprise at least one inquiry outer code and at least one non-inquiry outer code, and the code systems adopted by the at least two outer codes are different from each other.
6. The method for realizing the correlated retrieval of the plurality of commodity codes according to claim 1, wherein: and the storage model data of the correlation corresponding relation between the internal code and the external code is stored in a sub-library and sub-table of the mysql database.
7. The method for realizing the correlated retrieval of the plurality of commodity codes according to claim 1, wherein: in step S2, part or all of the commodity information is packaged into JSON format and then fed back to the query terminal.
8. The method for realizing correlated retrieval of multiple commodity codes according to any one of claims 1 to 7, wherein: the external code comprises one or more of an anti-counterfeiting code, a logistics code, a marketing code, a traceability code, a pesticide code and an OID code.
9. The method for realizing correlated retrieval of multiple commodity codes according to any one of claims 1 to 7, wherein: the outer code is one or more of a character string, a one-dimensional code, a two-dimensional code and a multi-dimensional code.
CN201810485534.6A 2018-03-30 2018-05-18 System and method for realizing correlated retrieval of multiple commodity codes Active CN109299952B (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
CN2018102968246 2018-03-30
CN201810296824 2018-03-30

Publications (2)

Publication Number Publication Date
CN109299952A CN109299952A (en) 2019-02-01
CN109299952B true CN109299952B (en) 2021-10-29

Family

ID=65167731

Family Applications (3)

Application Number Title Priority Date Filing Date
CN201810485262.XA Pending CN109299951A (en) 2018-03-30 2018-05-18 A kind of realization more than one piece commodity are mutually related method
CN201810485534.6A Active CN109299952B (en) 2018-03-30 2018-05-18 System and method for realizing correlated retrieval of multiple commodity codes
CN201810485264.9A Active CN109302376B (en) 2018-03-30 2018-05-18 Account code generation method, account authorization method and account code fetching method

Family Applications Before (1)

Application Number Title Priority Date Filing Date
CN201810485262.XA Pending CN109299951A (en) 2018-03-30 2018-05-18 A kind of realization more than one piece commodity are mutually related method

Family Applications After (1)

Application Number Title Priority Date Filing Date
CN201810485264.9A Active CN109302376B (en) 2018-03-30 2018-05-18 Account code generation method, account authorization method and account code fetching method

Country Status (1)

Country Link
CN (3) CN109299951A (en)

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110490654B (en) * 2019-08-19 2022-05-20 广州凯晟信息科技有限公司 Film shrinking and code assigning method and device, terminal and computer storage medium
CN110992070B (en) * 2019-12-26 2024-03-01 上海中商网络股份有限公司 Commodity tracing code association method and device
CN115034346B (en) * 2022-06-01 2023-04-07 浙江省标准化研究院(金砖国家标准化(浙江)研究中心、浙江省物品编码中心) Unique product code assigning method and device based on GS1 codes and storage medium

Family Cites Families (18)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20110016052A1 (en) * 2009-07-16 2011-01-20 Scragg Ernest M Event Tracking and Velocity Fraud Rules for Financial Transactions
CN102013072A (en) * 2010-11-29 2011-04-13 吴东杰 Over two-group associated data-based commodity anti-counterfeiting method
DE102011114248A1 (en) * 2011-04-15 2012-10-18 Oliver C. Mehler Procedure for handling product information
CN102664933B (en) * 2012-04-06 2015-03-18 中国联合网络通信集团有限公司 User authorization method, application terminal, open platform and system
US9978062B2 (en) * 2013-05-15 2018-05-22 Visa International Service Association Mobile tokenization hub
CN104036397A (en) * 2014-05-26 2014-09-10 北京五洲全景信息技术有限公司 Internet of Things anti-counterfeiting and tracing scheme based on NFC and combination of two-dimensional code and password
US9363254B2 (en) * 2014-06-04 2016-06-07 Sonos, Inc. Cloud queue access control
CN104104673B (en) * 2014-06-30 2017-05-24 福建爱特点信息科技有限公司 Method for realizing security payment through third party unified dynamic authorization code
CN104091258A (en) * 2014-07-23 2014-10-08 湖南中财化学建材有限公司 Dicode anti-counterfeiting anti-channel conflict method for tubular products
US20160125396A1 (en) * 2014-10-29 2016-05-05 Google Inc. Confirming physical possession of plastic nfc cards with a mobile digital wallet application
CN105989491A (en) * 2015-02-17 2016-10-05 孙宏铭 Dynamic authorization code generation method, device, payment transaction method and system
CN105023136A (en) * 2015-08-14 2015-11-04 深圳正品创想科技有限公司 Two-dimensional code operating method and apparatus of commodity
CN105956867A (en) * 2016-05-23 2016-09-21 无锡市鸿太阳印刷有限公司 Anti-fake method by associating color codes of commodity and anti-fake system of anti-fake method
CN106897341A (en) * 2016-07-08 2017-06-27 阿里巴巴集团控股有限公司 2 D code information querying method, server, client and system
CN106846013A (en) * 2017-01-24 2017-06-13 浙江甲骨文超级码科技股份有限公司 A kind of false proof identity management system and method for tracing to the source
CN106934439A (en) * 2017-03-03 2017-07-07 信码互通(北京)科技有限公司 The bottle code and the correlating method and bottle cap of case code realized based on concealed code
CN107146060A (en) * 2017-05-26 2017-09-08 现代城市数据科技(深圳)有限公司 The method for building up and its system of a kind of respiratory sensation relation of Quick Response Code and commodity
CN107506817B (en) * 2017-07-13 2023-06-27 拍拍看(海南)人工智能有限公司 Commodity virtual coding method and system based on personality patterns

Also Published As

Publication number Publication date
CN109302376A (en) 2019-02-01
CN109299951A (en) 2019-02-01
CN109299952A (en) 2019-02-01
CN109302376B (en) 2021-05-28

Similar Documents

Publication Publication Date Title
CN109299952B (en) System and method for realizing correlated retrieval of multiple commodity codes
KR20050103919A (en) Product and parts management system, data processing system, serial number management method, computer program product, and computer-readable medium
WO2021128588A1 (en) Tracing method and system for item circulation system
US20220171951A1 (en) Product labels, trust identifier systems containing the same, and methods of use thereof
CN111445264A (en) Food supply chain traceability system based on block chain and implementation method
CN109034849B (en) Agricultural product information traceability verification method and system based on block chain
Jakkhupan et al. An RFID-based traceability system: A case study of rice supply chain
US20220230134A1 (en) Centralized printing application for provenance of assets
CN106657342B (en) Agricultural product source tracing method, mobile terminal and server
US20050038710A1 (en) Method and system for item tracking
CN104657866A (en) Method, device and system for inquiring business object information based on product encoded information
CN106570674A (en) Supply chain information query method and device
CN104504487A (en) Method and system for tracing service object information between platforms
CN111080310A (en) Product tracking management system based on two-dimensional code
US20170004442A1 (en) System and method for inventory and supply chain management
CN106127426A (en) A kind of the Internet shopping platform kinds of goods management method and system
CN114219509A (en) Production tracing system and method for wireless communication module
CN112085302A (en) Cigarette quality tracing system, method, storage medium and electronic terminal
CN105760911A (en) Method and device for applying associated identification codes
CN105427111A (en) Product management system and method
Hassan et al. Review of auto-ID technology use in warehouse management
WO2020223905A1 (en) Method for tracking product history
CN113919848A (en) Furniture traceability system based on two-dimensional code
CN112418885A (en) Label generation method, product tracing method and related device
CN110570206A (en) commodity tracing 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
GR01 Patent grant
GR01 Patent grant