CN1309372A - Apparatus and method for commodity dispensing delivery service using standard commodity information over computer communication network - Google Patents

Apparatus and method for commodity dispensing delivery service using standard commodity information over computer communication network Download PDF

Info

Publication number
CN1309372A
CN1309372A CN 00134043 CN00134043A CN1309372A CN 1309372 A CN1309372 A CN 1309372A CN 00134043 CN00134043 CN 00134043 CN 00134043 A CN00134043 A CN 00134043A CN 1309372 A CN1309372 A CN 1309372A
Authority
CN
China
Prior art keywords
mentioned
commodity
information
order
ordering
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN 00134043
Other languages
Chinese (zh)
Inventor
李东波
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
LEE TONG PA
Original Assignee
LEE TONG PA
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
Priority claimed from KR1020000006692A external-priority patent/KR20000024412A/en
Priority claimed from KR1020000007388A external-priority patent/KR20000024494A/en
Application filed by LEE TONG PA filed Critical LEE TONG PA
Publication of CN1309372A publication Critical patent/CN1309372A/en
Pending legal-status Critical Current

Links

Images

Landscapes

  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The present invention provides a device and a method for article delivery service with standard article information, a plurality of electronic commerce traders, manufacturers, and supplies having mutually different article code system are converted into a standardized article code system to structure a standard article information database. Traders transmit correlative order information of customs to a network sever of articles manager through the internet, the network sever sends shipping and delivery instructions to the suppliers or a distribution center according to the ordered articles. The network sever examines ordered articles in stock and automatically informs whether or not the articles can be ordered according various databases each time articles are ordered. Therefore, a plurality of electronic commerce traders minimize logistics expense of articles storage and stock management, and storage of trading articles, stock, and ordering are not restrained by trading variety of different suppliers.

Description

Utilize the commodity distribution service unit and the method for standard merchandise information by computer communication network
The present invention relates to utilize the commodity distribution service of computer communication network, more particularly, relate to a kind of commodity distribution service unit and method of utilizing standard merchandise information by computer communication network, according to multiple businessman classification, the e-commerce transaction commodity standardization that will have different mutually codeword value systems, and constructs database, can be according to this standardized merchandising database, unified management is carried out in stock, order and the dispensing of the commodity of the user being ordered by the e-commerce transaction merchant.
In recent years, along with the peripheral techniques that is used for Internet traffic, promptly the develop rapidly of computer system, software, communication line etc. can just become generally by the Internet shopping way of internet purchases commodity in family.
Corresponding with this user's demand, in the information of the multiple product that production firm is provided on the Internet, and the agency orders and the Internet shopping operator of sale etc. also increases greatly.
But for the commodity of most of the Internet shopping operator transaction, because the different codeword value system of utilization provides service, not only the service item of merchandise news is different mutually, and also is not very clear for the information of same services project.
And because the scope of the commodity of each the Internet shopping operator transaction is different mutually, the consumer can feel a lot of difficulties when search provides the Internet shopping operator of information to the commodity of oneself wanting to buy.
On the other hand, in present stage, shopping operator in the Internet can not conclude the business to all products.Even and specific the Internet shopping operator all products of wanting to conclude the business, thus to the not low logistics cost of the commodity custody that is used to order processing, stock and order management of these transaction commodity, also become can not a conclude the business reason of many commodity of the Internet shopping operator.
Its result, most the Internet shopping operator is limited in merchandising in the very limited scope, and concerning each marketer, keeping, the stock of its transaction commodity and to order management all different, therefore with respect to investment cost, the efficiency of operation of the Internet shopping operator is not high.
The object of the present invention is to provide and a kind ofly utilize the commodity distribution service unit and the method for standard merchandise information, to solve the above-mentioned problem that exists by computer communication network.According to multiple businessman classification, the e-commerce transaction commodity standardization that will have different mutually codeword value systems, and constructs database, can be according to this standardized merchandising database, unified management is carried out in stock, order and the dispensing of the commodity of the user being ordered by a plurality of e-commerce transaction merchants.
To achieve these goals, according to embodiments of the invention, the commodity distribution service unit that it utilizes standard merchandise information comprises: the Internet; Memory storage, according to the standardized codeword value system of having prepared, a plurality of e-commerce transaction merchants that will have different mutually codeword value systems, the basic data of the commodity that commodity manufacturer and goods providers etc. provide is transformed to the standard merchandise sign indicating number, standard merchandise information with structure, the purchase order information of the above-mentioned commodity that provide from above-mentioned a plurality of e-commerce transaction merchants, the payment information of order goods, the inventory information of the above-mentioned commodity that provide from above-mentioned commodity manufacturer, the above-mentioned commodity that provide from above-mentioned goods providers go out library information, stored as each database; The webserver, has subroutine, this subroutine is used to respond the above-mentioned a plurality of e-commerce transaction merchants' that receive by the Internet request, retrieval is in the standard merchandise information of the above-mentioned standard merchandise information database of above-mentioned memory device stores, the standard merchandise information of retrieval is offered above-mentioned requestor with the form corresponding to requestor's request form, to be stored in the purchase order information database of above-mentioned memory storage by the request of ordering that above-mentioned the Internet receives from above-mentioned a plurality of e-commerce transaction merchants, classify and add up, according to above-mentioned inventory information database and outbound information database, the outbound and the dispensing order of the commodity of the request of ordering that will come from above-mentioned a plurality of e-commerce transaction merchants offer above-mentioned goods providers or logistics center.
To achieve these goals, according to embodiments of the invention, it utilizes standard merchandise information to carry out the commodity distribution service method, this method is including the Internet, the memory storage that is used for canned data, by above-mentioned the Internet the commodity that client orders are utilized standard merchandise information in the environment of the webserver formation with subroutine of user's dispensing, carry out the commodity distribution service, may further comprise the steps: according to the standardized codeword value system of having prepared, a plurality of e-commerce transaction merchants that will have different mutually codeword value systems, the basic data of the commodity that commodity manufacturer and goods providers etc. provide is transformed to the standard merchandise sign indicating number, is stored in the step of above-mentioned memory storage as the standard merchandise information database; The purchase order information of the above-mentioned commodity that above-mentioned a plurality of e-commerce transaction merchants are provided, the payment information of order goods are as the step of each database storing at above-mentioned memory storage; The inventory information of the above-mentioned commodity that will provide from above-mentioned commodity manufacturer is as the step of database storing at above-mentioned memory storage; The above-mentioned commodity that will provide from above-mentioned goods providers go out library information, minimum size of order information, safety stock information as the step of each database storing at above-mentioned memory storage; Respond above-mentioned a plurality of e-commerce transaction merchants' request, retrieve the step of above-mentioned standard merchandise information database; The standard merchandise information of retrieval is sent to above-mentioned e-commerce transaction merchant's step with the form corresponding to requestor's request form; Receive the step of above-mentioned a plurality of e-commerce transaction merchants' purchase order information; The step that above-mentioned purchase order information is classified and added up; According to above-mentioned standard information, inventory information and outbound information database, the outbound of the commodity of the request of ordering that will come from above-mentioned a plurality of e-commerce transaction merchants and the step that the dispensing order offers above-mentioned goods providers or logistics center.
Here, above-mentioned standardized codeword value system comprises at least: the project of businessman's sign indicating number, item property sign indicating number, codeword value, individual event sign indicating number, content sign indicating number, status code and taxonomic hierarchies sign indicating number.What above-mentioned a plurality of e-commerce transaction merchants' the request of ordering comprised commodity that the user orders orders id information, Order Quantity information, merchandise news, individual event information, membership information and distribution information.
In addition, the retrieval of above-mentioned standard merchandise information database is to retrieve with in the following retrieval any, promptly uses the basic retrieval of retrieving at least more than one project of above-mentioned standardized codeword value system according to above-mentioned requestor's request configuration sequence; Retrieve at least two expansion retrievals of above-mentioned standardized codeword value system simultaneously to begin a project; And retrieve simultaneously in the general inquiry retrieval of the individual event sign indicating number project of above-mentioned standardized codeword value system and other project any retrieve.
On the other hand, providing of the standard merchandise information of above-mentioned retrieval is request form according to above-mentioned e-commerce transaction merchant, gives above-mentioned requestor's mode to be kept at recording medium; The mode of downloading according to requestor's download request; Mode with E-mail conveyance; The electronic data interchange mode; In the file transfer protocol (FTP) mode any carried out.
Above-mentioned commodity distribution method also comprises: according to the standard merchandise information of the above-mentioned commodity of ordering, in the step of the inventory status of the above-mentioned commodity of above-mentioned inventory information database retrieval; The step that the safety stock information of the tank farm stock of above-mentioned retrieval and the above-mentioned commodity of ordering is compared; According to the result of above-mentioned comparison, above-mentioned order order is offered the step of above-mentioned goods providers.
When the order scheduled volume of the above-mentioned commodity of ordering surpasses the minimum size of order of the above-mentioned commodity of ordering, above-mentioned order order is offered above-mentioned goods providers.Above-mentioned order scheduled volume is that the safety stock information from the above-mentioned commodity of ordering deducts present tank farm stock, and calculates from the size of order that the value of carrying out this subtraction deducts the above-mentioned commodity of ordering.
In addition, above-mentioned outbound and dispensing commands steps also comprise: if reception is from above-mentioned order e-commerce transaction merchant's the request of ordering, then at the above-mentioned commodity of ordering of above-mentioned standard merchandise information data library searching, check that whether the above-mentioned commodity of ordering are the steps at the commodity of logistics center's transaction; If the commodity of concluding the business in logistics center are ordered the step that offers above-mentioned logistics center with the above-mentioned outbound of the above-mentioned commodity of ordering with providing and delivering; If not commodity, the above-mentioned outbound and the dispensing order of the above-mentioned commodity of ordering offered the step of above-mentioned goods providers in logistics center's transaction.
According to commodity distribution service unit and the method for utilizing standard merchandise information by computer communication network of the present invention, the information conversion of commodity that will have a plurality of e-commerce transaction merchants, manufacturer and supplier's transaction of mutually different codeword value systems is a standardization codeword value system, structure standard merchandise information database.Therefore, each e-commerce transaction merchant can provide the information of multiple commodity to the consumer, and as long as the consumer is e-commerce transaction merchant of retrieval, can the information of the commodity of all e-commerce transactions etc. be come into plain view.
Have again, if a plurality of e-commerce transaction merchants will receive commodity, client and the payment information ordered from client by the Internet and transmit to merchandise control person's the webserver, the then above-mentioned webserver is indicated the outbound of commodity and the order of dispensing to supplier or logistics center according to the commodity of ordering.The above-mentioned webserver according to the various databases of memory storage, is checked the tank farm stock of above-mentioned order goods when each commodity are ordered, indicate whether automatically to carry out the order of these commodity.Therefore, above-mentioned a plurality of e-commerce transaction merchants can make the keeping of commodity and the logistics cost of stock control minimize, and keeping, stock and the order management of transaction commodity can not be subjected to the restriction of trade variety because of businessman's difference.
By following explanation, can make purpose of the present invention and feature and advantage become clear to preferred embodiment of the present invention.
Fig. 1 is the structural representation of database that computer communication network utilizes the commodity distribution service unit of standard merchandise information that passes through of a preferred embodiment of the present invention.
Fig. 2 is the structural representation that computer communication network utilizes the commodity distribution service unit of standard merchandise information that passes through of a preferred embodiment of the present invention.
Fig. 3 is the process flow diagram that carries out commodity distribution by standard merchandise information database shown in Figure 1 and commodity distribution service unit shown in Figure 2.
Fig. 4 is the process flow diagram that computer communication network utilizes the commodity distribution method of servicing of standard merchandise information that passes through of a preferred embodiment of the present invention.
Fig. 5 is the process flow diagram that the method for the standard Business Information of constructing standard merchandise information database shown in Figure 1 is described.
Fig. 6 is the process flow diagram that the method for the standard merchandise information of constructing standard merchandise information database shown in Figure 1 is described.
Fig. 7 is the process flow diagram that the method for the standard individual event information of constructing standard merchandise information database shown in Figure 1 is described.
Fig. 8 is the process flow diagram that the method for the standard attribute information of constructing standard merchandise information database shown in Figure 1 is described.
Fig. 9 is the process flow diagram of explanation with the method for commodity distribution method of servicing search criteria merchandise news shown in Figure 4.
Figure 10 is that explanation will send the process flow diagram of the method for businessman with the standard merchandise information of commodity distribution method of servicing retrieval shown in Figure 4 to.
Figure 11 illustrates the outbound of the commodity of ordering with commodity distribution method of servicing shown in Figure 4 and the process flow diagram of allocator.
Figure 12 is the order flow chart of steps of explanation with commodity distribution method of servicing shown in Figure 4.
Following 1 to Figure 12 commodity distribution service unit and the method that computer communication network utilizes standard merchandise information of passing through that specifies one embodiment of the present of invention with reference to the accompanying drawings.
Fig. 1 is according to a preferred embodiment of the present invention, utilizes the structural drawing of database of the commodity distribution service unit of standard merchandise information by computer communication network.
With reference to Fig. 1, it is commodity distribution service provider that the information of e-commerce transaction commodity is carried out standardized standardization businessman, prepare standard merchandise sign indicating number system in advance, this standard merchandise sign indicating number system is used for the information of the commodity that carry out e-commerce transaction by the Internet is carried out standardization.At this moment, by above-mentioned commodity distribution service provider carry out normalized codeword value system as following table 1 to shown in the table 7, have the project of businessman's sign indicating number, item property sign indicating number, property value sign indicating number, codeword value, individual event sign indicating number, content (contents) sign indicating number, status code and taxonomic hierarchies sign indicating number.
To shown in the table 7, the project of above-mentioned businessman sign indicating number, item property sign indicating number, property value sign indicating number, codeword value, individual event sign indicating number, content sign indicating number, status code and taxonomic hierarchies sign indicating number has the subitem of ID sign indicating number, entry name sign indicating number, item code and recording status sign indicating number at least as table 1.
Here, above-mentioned codeword value represents to take down notes the kind of commodity such as utensil, clothes class, leather and fur products, the characteristic of above-mentioned each commodity of individual event representation.For example, as suppose that commodity shown in the above-mentioned codeword value are clothes classes of identical manufacturer, then the color of this clothes class, size, pattern etc. as the individual event sign indicating number of above-mentioned clothes class by typing.In addition, attribute code is represented the attribute of each commodity, is clothes classes if suppose commodity shown in the above-mentioned codeword value, then the dress material of this clothes class as attribute code by typing.
Table 1 businessman sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-VEND ?1 ?VENDID ID NUMBER ?22
?2 ?DBSTS State VARchar2 ?15
?3 ?CODE Merchant number VARchar2 ?80
?4 ?NAME Trading company VARchar2 ?160
?5 ?OWNNAME Representative's name VARchar2 ?160
?6 ?BGNDATE Establishing time VARchar2 ?8
?7 Legal person's accession designation number VARchar2 ?80
?8 Industry situation VARchar2 ?160
?9 Industry is planted VARchar2 ?160
?10 The administration tax bureau VARchar2 ?80
?11 Email VARchar2 ?510
?12 Telephone number VARchar2 ?40
?13 Fax number VARchar2 ?40
?14 The residence VARchar2 ?510
?15 Businessman's scope VARchar2 ?80
?16 Range of countries VARchar2 ?40
?17 Territorial scope VARchar2 ?40
?18 Stock control is distinguished VARchar2 ?80
Table 2-1 attribute code
Table name SEQ Column name Content Type LEN Remarks
EC-PRPSET ?1 ?PRPSETID ?NUMBER ?22
?2 ?DBSTS ?VARchar2 ?15
?3 ?NAME Attribute-name ?VARchar2 ?80
?4 ?DSCR ?DESCRIPTION ?VARchar2 ?510
Table 2-2 attribute code
Table name SEQ Column name Content Type LEN Remarks
EC-PRPSETVAL ?1 ?PRPSETVALID Property value ID ?NUMBER ?22
?2 ?DBSTS The RECORD state ?VARchar2 ?15
?3 ?VAL Property value ?VARchar2 ?80
?4 ?DSCR DESCRIPTION ?VARchar2 ?510
?5 ?PRPSETID Property ID ?NUMBER ?22
Table 3 codeword value
Table name SEQ Column name Content Type LEN Remarks
EC-PRD ?1 ?PRDID Commodity ID ?NUMBER ?22
?2 ?DBSTS The RECORD state ?VARchar2 ?15
?3 ?NAME Trade name ?VARchar2 ?160
?4 ?DSCR DESCRIPTION ?VARchar2 ?510
?5 ?PARTNUM Codeword value ?VARchar2 ?80
?6 ?MFR Manufacturer ?VARchar2 ?80
?7 ?BGNDATE Be suitable for the date ?DATE ?7
?8 ?PRDTYPE Commodity are distinguished ?VARchar2 ?160 Books class, stationery class etc.
9 ?TAXCSCODE ?VARchar2 ?40
10 ?TAXIND ?VARchar2 ?40
11 ?TAXPRDCODE ?VARchar2 ?80
12 ?TTTLPASSIND ?VARchar2 ?40
13 ?UOM Stock control unit ?VARchar2 ?40 Individual, box etc.
Table 4 individual event sign indicating number
Table name SEQ Column name Content Type ?LEN Remarks
EC-PRDITM ?1 ?PRDITMID Individual event ID ?NUMBER ?22
?2 ?DBSIS The RECORD state ?VARchar2 ?15
?3 ?SKU The individual event sign indicating number ?VARchar2 ?80 ?Stock ?Kepping ?Unit
?4 ?PRDITMNAME The individual event name ?VARchar2 ?160
?5 ?DSCR DESCRIPTION ?VARchar2 ?510
?6 ?MFR Manufacturer ?VARchar2 ?80
?7 ?PRDITMDLVRT ?YPE ?VARchar2 ?160
?8 ?KEY ?VARchar2 ?160
?9 ?PRDPRSTID ?NUMBER ?22
Table 5 content sign indicating number
Table name SEQ Column name Content Type ?LEN Remarks
EC-CTNT ?1 ?CTNTID Content ID ?NUMBER ?22
?2 ?DBSTS RECORDID ?VARchar2 ?15A,D
?3 ?NAME The content name ?VARchar2 ?80
?4 ?DSCR DESCRIPTION ?VARchar2 ?510
?5 ?FRMT FORMAT ?VARchar2 ?160
?6 ?PVDR The provider ?VARchar2 ?80
?7 ?SEMTYPE ?VARchar2 ?40
?8 ?FILENAME ?VARchar2 ?160
?9 ?FILESIZE ?NUMBER ?22
?10 ?URL ?VARchar2 ?2000
Table 6 status code
Table name SEQ Column name Content Type LEN Remarks
EC-STS ?1 ?STSID State ID NUMBER ?22
?2 ?DBSTS The RECORD state VARchar2 ?15
?3 ?VALUE State value VARchar2 ?160
?4 ?BGNDATE Start Date DATE ?7
?5 ?ENDDATE Close Date DATE ?7
?6 ?RSN REASON VARchar2 ?160
Table 7 taxonomic hierarchies sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-SECT ?I ?SECTID Taxonomic hierarchies ID NUMBER ?22
?2 ?DBSTS The RECORD state VARchar2 ?15
?3 ?NAME The taxonomic hierarchies name VARchar2 ?80
?4 ?LBL Mark VARchar2 ?80
?5 ?DSCR DESCRIPTION VARchar2 ?510
?6 ?SECTPRSTID NUMBER ?22
If prepared above-mentioned standard merchandise sign indicating number system, above-mentioned commodity distribution service provider from a plurality of e-commerce transaction merchants (110,120,130) that directly carry out e-commerce transaction by above-mentioned the Internet, a plurality of commodity manufacturers (610,620,630) that make commodity, and provide a plurality of goods providers (510,520,530) there of the commodity of the commodity of manufacturing or sale to receive basic data about these commodity to each businessman or consumer.
Then, above-mentioned commodity distribution service provider is according to above-mentioned standard merchandise sign indicating number system, will from above-mentioned e-commerce transaction merchant (110,120,130), commodity manufacturer (610,620,630), and the basic data of the commodity that receive of goods providers (510,520,530) be transformed to standard merchandise sign indicating number system, structure standard merchandise information database.
At this moment, above-mentioned commodity distribution service provider when the standard merchandise information database that structure is made of standard single datum storehouse (410), standard merchant database (418), standard attribute database (412), criteria classification database (420), standardized product database (414), content data base (422) and slip condition database (424), according to following table 8 to other codeword value system is connected with at least one like that shown in the table 21.Therefore, in each project of standard merchandise sign indicating number system,, promptly all information of these commodity can be extracted and retrieve as long as specify a project.
Table 8 attribute+property value sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-PRPSET- PRPSETVALLST ?1 ?PRPSETID Property ID ?NUMBER ?22
?2 ?PRPSETVALID Property value ID ?NUMBER ?22
?3 ?SEQNUMBER A series of numbers ?NUMBER ?22
?4 ?DBSTS State ?VARchar2 ?15
Table 9 commodity+individual event sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-PRD- PRDITMLST ?1 ?PRDID Commodity ID NUMBER ?22
?2 ?PRDITMID Individual event ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 10 commodity+attribute code
Table name SEQ Column name Content Type LEN Remarks
EC-PRD- PRPSETLST ?1 ?PRDID Commodity ID NUMBER ?22
?2 ?PRPSETID Property ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 11 commodity+status code
Table name SEQ Hurdle day name Content Type LEN Remarks
EC-PRD-STSLST ?1 ?PRDID Commodity ID NUMBER ?22
?2 ?STSID Property ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 12 commodity+content sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-PRD- CTNLST ?1 ?PRDID Commodity ID NUMBER ?22
?2 ?CTNTID Content ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 13 individual event+attribute code
Table name SEQ Column name Content Type LEN Remarks
EC-PRDITM- PRPSETVALLST ?1 ?PRDITMID Individual event ID NUMBER ?22
?2 ?PRPSETVALID Property value ID NUMBER ?22
?3 ?SEONUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 14 individual event+status code
Table name SEQ Column name Content Type LEN Remarks
EC-PRDITM- STSLST ?1 ?PRDITMID Individual event ID NUMBER ?22
?2 ?STSID State ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 15 individual event+businessman's sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-PRDITM- VENDLST ?1 ?PRDITMID Individual event ID NUMBER ?22
?2 ?VENDID Thing dealer ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 16 individual event+content sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-PRDITM- CTNTLST ?1 ?PRDITMID Individual event ID NUMBER ?22
?2 ?CTNTID Content ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 17 content+attribute code
Table name SEQ Column name Content Type LEN Remarks
EC-CTNT- REFSETVALLST ?1 ?CTNTID Content ID NUMBER ?22
?2 ?REFSBTVALID Property value ID NUMBER ?22
?3 ?SEONUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 18 content+status code
Table name SEQ Column name Content Type LEN Remarks
EC-CTNT- STSL8T ?1 ?CTNTID Content ID NUMBER ?22
?2 ?REFSETVALID State NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 19 taxonomic hierarchies+codeword value
Table name SEO Column name Content Type LEN Remarks
EC-SECT- PRDLST ?1 ?SECTID Taxonomic hierarchies ID NUMBER ?22
?2 ?PRDID Commodity ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 20 taxonomic hierarchies+taxonomic hierarchies sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-SECT- SECTLST ?1 ?SECTID Taxonomic hierarchies ID NUMBER ?22
?2 ?SNDSECTID Taxonomic hierarchies ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Table 21 taxonomic hierarchies+content sign indicating number
Table name SEQ Column name Content Type LEN Remarks
EC-SECT- CTNTLST ?1 ?SECNTID Taxonomic hierarchies ID NUMBER ?22
?2 ?CTNTID Content ID NUMBER ?22
?3 ?SEQNUMBER A series of numbers NUMBER ?22
?4 ?DBSTS The RECORD state VARchar2 ?15
Then, above-mentioned commodity distribution service provider provides the standard merchandise information database by the such businessman of e-commerce transaction merchant that to the businessman of the above-mentioned standard merchandise information database of needs, particularly runs the Internet shopping, finishes the standardization of e-commerce transaction with the information of commodity etc.
On the other hand, above-mentioned commodity distribution service provider is except having above-mentioned standard merchandise information database, also has e-commerce transaction merchant (110,120,130), goods providers (510,520,530), and the purchase order information (428) of each commodity of providing of commodity manufacturer (610,620,630), goes out the database that library information (430), minimum size of order information (432), purchasing order information (434), inventory information (436) and safety stock information (438) constitute.
In addition, above-mentioned e-commerce transaction merchant (110,120,130) has merchandise news, membership information, individual event information and the purchase order information database (140,150,160,170) of the commodity of oneself concluding the business.Above-mentioned commodity manufacturers (610,620,630) have into library information, inventory information, reach purchase order information database (640,650,660).Above-mentioned goods providers (510,520,530) has purchase order information, merchandise news, Business Information and distribution information database (540,550,560,570).
Fig. 2 is according to a preferred embodiment of the present invention, utilizes the structure of the commodity distribution service unit of standard merchandise information by computer communication network.Fig. 3 reaches the synoptic diagram that is carried out the commodity distribution flow process by commodity distribution service unit shown in Figure 2 by standard merchandise information database shown in Figure 1.
With reference to Fig. 2 and Fig. 3, e-commerce transaction merchant (100) adds above-mentioned commodity distribution service provider as the member, registers in above-mentioned member information database (416).Then, above-mentioned e-commerce transaction merchant (100) asks the information of the commodity that oneself will conclude the business to above-mentioned commodity distribution service provider (300), and the electronic directory that provides is provided, and it is provided to general client by the Internet shopping operator.
When above-mentioned general client input during to the ordering of particular commodity, above-mentioned e-commerce transaction merchant (100) above-mentioned merchandise news of retrieval and member information database (140,150), membership information that will be relevant with the client who has ordered commodity and the purchase order information that relevant merchandise news constitutes with the commodity of ordering transmit by the Internet (200) above-mentioned webserver (webserver) (300) to the operation of above-mentioned commodity distribution service provider.At this moment, above-mentioned purchase order information constitutes by ordering id information, Order Quantity information, merchandise news, individual event information, membership information and distribution information etc.
On the other hand, before the above-mentioned webserver (300) provides, offer clearing merchants (800) earlier, be used for above-mentioned general client's paying ability is approved from above-mentioned general client's purchase order information.Then, if produce the clearing approval information that above-mentioned general client's commodity are ordered from above-mentioned clearing merchant (800), then above-mentioned e-commerce transaction merchant (100) offers above-mentioned purchase order information the webserver (300) of above-mentioned commodity distribution service provider.
Then, the above-mentioned webserver (300) will be recorded in the above-mentioned purchase order information database (428) of above-mentioned memory storage (400) from the purchase order information that above-mentioned e-commerce transaction merchant (100) receives, respond above-mentioned e-commerce transaction merchant's (100) purchase order information, in the retrieval storage devices (400) with transaction commodity relevant various database of information.
According to this result for retrieval, the above-mentioned webserver (300) transmits the outbound and the dispensing order of ordered commodity to goods providers (500) or logistics center (600).Here, in the above-mentioned memory storage (400), as shown in Figure 1, have standard individual event information, standard attribute information, standardized product information, membership information, standard Business Information, criteria classification information, content information, status information, link information, purchase order information, go out library information, minimum size of order information, purchasing order information, inventory information and safety stock information database (410,412,414,416,418,420,422,424,426,428,430,432,434,436,438).
On the other hand, if above-mentioned e-commerce transaction merchant (100) has produced the goods order request, what the above-mentioned webserver (300) was retrieved above-mentioned memory storage (400) goes out library information, purchasing order information and inventory information database (430,434,436), and the On-hand Balance of order goods is checked.Then, behind the above-mentioned webserver (300) the above-mentioned safety stock information database of retrieval (438), consider the On-hand Balance of above-mentioned inspection, the order order of above-mentioned client's order goods is provided to above-mentioned goods providers (500).
At this moment, the above-mentioned webserver (300) retrieval above-mentioned minimum size of order information database (432) when the order scheduled volume of above-mentioned order goods surpasses the minimum size of order of above-mentioned order goods, provides above-mentioned order order.And by present tank farm stock being deducted the safety stock of above-mentioned order goods, carried out in the value of subtraction at this, deduct the quantity ordered of above-mentioned order goods, calculate above-mentioned order scheduled volume.
Below with reference to Fig. 4 to Figure 12, describe the method for commodity being carried out delivery service in detail according to above-mentioned standard merchandise information database by computer communication network.
Fig. 4 is according to a preferred embodiment of the present invention, is used to illustrate the process flow diagram that utilizes the commodity distribution method of servicing of merchandise news by computer communication network.
With reference to Fig. 4, normalized codeword value system (step S100) is prepared by above-mentioned commodity distribution service provider.Then, above-mentioned commodity distribution service provider receives the basic data (step S102) of each commodity from e-commerce transaction merchant (100), commodity manufacturer (610,620,630) and the goods providers theres such as (500) with different mutually codeword value systems.
Above-mentioned commodity distribution service provider utilizes the codeword value system of preparing at step S100, the basic data of the extensive stock that will provide from e-commerce transaction merchant (100), commodity manufacturer (610,620,630) and goods providers (500) etc. is transformed to the standard merchandise sign indicating number, constitute standard merchandise information database shown in Figure 1, be stored in above-mentioned memory storage (400) (step S104).In addition, above-mentioned commodity distribution service provider also construct above-mentioned extensive stock purchase order information, inventory information, go out library information, minimum size of order information and safety stock database of information (428,436,430,432,438), be stored in above-mentioned memory storage (400).
Then, the e-commerce transaction merchant who adds by above-mentioned the Internet (200) and the webserver (300) if with the member have pair particular commodity merchandise news, be the request (step S105) of electronic directory, the webserver (300) the retrieval above-mentioned standard merchandise information database (step S108) of above-mentioned commodity distribution service provider.Be provided for above-mentioned e-commerce transaction merchant (step S110) in the merchandise news of step S108 retrieval with the form of electronic directory.
Then, if receive from above-mentioned general client by above-mentioned e-commerce transaction merchant (110,120,130) and to order (step S112), the then above-mentioned webserver (300) carries out the outbound and the dispensing (S114) of the commodity that above-mentioned general client orders to above-mentioned goods providers (500) or logistics center (600) order.
The specific implementation method in each stage of above-mentioned commodity distribution service is as described below.
Fig. 5 is the process flow diagram of method that is used to illustrate the standard Business Information of structural map 1 described standard merchandise information database.
With reference to Fig. 5, above-mentioned commodity distribution service provider is from e-commerce transaction merchant (EC merchant) (110,120,130), goods providers (510,520,530), commodity manufacturer (610,620,630) merchant number as shown in table 1 is collected in the there, trading company, representative's name, set up the date, legal person's accession designation number, industry situation, industry is planted, the administration tax bureau, Email (E-MAIL), telephone number, fax number, the residence, businessman's scope, range of countries, the Business Information (step S200) that territorial scope and stock control are distinguished is registered (step S202) with it in merchant database.
Then, above-mentioned commodity distribution service provider classifies, processes and verify the Business Information of registering in above-mentioned merchant database, removes or revise inappropriate information (step S204,206,208,210).The file maintenance that checking is finished is in above-mentioned standard merchant database (418) back (step S212), operative norm businessman registration procedure, Business Information is arranged by kind/businessman's classification, be recorded in defined businessman project (step S214, S216, S218, S220) in the above-mentioned table 1.
Then, above-mentioned commodity distribution service provider is after the Business Information of record is given the standard Merchant ID, be stored in above-mentioned standard merchant database (418), this standard merchant database (418) is pressed shown in the table 15, be connected (step S222,224,226) with standard single datum storehouse (410).At this moment, above-mentioned standard merchant database (418) is kept at above-mentioned link information database (426) with the link information of standard single datum storehouse (410) join dependency.
Fig. 6 is the process flow diagram of building method that is used to illustrate the standard merchandise information of formation standard merchandise information database shown in Figure 1.
With reference to Fig. 6, above-mentioned commodity distribution service provider collects trade name as shown in table 3, codeword value, manufacturer from e-commerce transaction merchant (EC merchant) (110,120,130), goods providers (510,520,530), commodity manufacturer (610,620,630) there, is suitable for the date, commodity are distinguished and the product information of stock control unit etc., it is registered in product database (step S300,302).
Then, above-mentioned commodity distribution service provider verifies the product information of registering in the said goods database, removes or revise inappropriate information (step S304,306,308,310).The file maintenance (step S312) behind the said goods database that checking is finished, operative norm product registration procedure, add up and arrange by product category, the commodity item that defines in above-mentioned table 3 is write down (step S314, S316, S318, S320).
Then, above-mentioned commodity distribution service provider is stored in (step S322,324) in the said goods database (414) after the product information of record is given standardized product ID.
Fig. 7 is the process flow diagram of building method that is used to illustrate the standard individual event information of formation standard merchandise information database shown in Figure 1.
With reference to Fig. 7, individual event information such as individual event name as shown in table 4, individual event sign indicating number, manufacturer are collected from e-commerce transaction merchant (EC merchant) (110,120,130), goods providers (510,520,530), commodity manufacturer (610,620,630) there by above-mentioned commodity distribution service provider, and it is registered (step S400,402) in the single datum storehouse.
Then, above-mentioned commodity distribution service provider verifies the individual event information of registering in above-mentioned single datum storehouse, removes or revise inappropriate information (step S404,406,408,410).The file maintenance that checking is finished is behind above-mentioned single datum storehouse (step S412), operative norm individual event registration procedure, add up and arrange by the individual event classification, the individual event project that defines in above-mentioned table 4 is write down (step S414, S416, S418, S420).
Then, above-mentioned commodity distribution service provider is connected (step S422) with the individual event information of record with above-mentioned standard attribute, standardized product, standard businessman, criteria classification and content data base (412,414,418,420,422), after giving standard individual event ID, be stored in (step S424,426) in the above-mentioned standard single datum storehouse (410).According to shown in the table 15 individual event information is connected (step S426,428) with Business Information.Link information between above-mentioned standard single datum storehouse (410) and above-mentioned standard attribute, standardized product, standard businessman, criteria classification and content data base (412,414,418,420,422) is kept at above-mentioned link information database (426).
Fig. 8 is the process flow diagram of building method that is used to illustrate the standard attribute information of formation standard merchandise information database shown in Figure 1.
With reference to Fig. 8, the attribute information relevant with attributes commodity as shown in table 2 collected from e-commerce transaction merchant (EC merchant) (110,120,130), goods providers (510,520,530), commodity manufacturer (610,620,630) there by above-mentioned commodity distribution service provider, it registered in attribute database (step S500,502).
Then, above-mentioned commodity distribution service provider verifies the attribute information of registering in above-mentioned attribute database, removes or revise inappropriate material (step S504,506,508,510).The file maintenance (step S512) behind above-mentioned attribute database that checking is finished, operative norm attribute registration procedure, add up and arrange by the attribute/attribute-value classification, defined attribute project in above-mentioned table 2-1,2-2 is write down (step S514,516,518,520).
Then, the checking of above-mentioned commodity distribution service provider is recorded in the attribute information of attribute database, give the standard attribute ID and standard attribute value ID of attribute information after, be stored in the above-mentioned standard attribute database (412) shown in Figure 1 (step S522,524,526).
Fig. 9 is the process flow diagram that is used to illustrate with the method for commodity distribution method of servicing search criteria merchandise news shown in Figure 4.
With reference to Fig. 9, the retrieval of standard merchandise information is in the following cases, promptly by the Internet (200), after above-mentioned e-commerce transaction merchant (100) adds as the member, carries out when receiving the request of the electronic directory that required merchandise news is arranged.If above-mentioned e-commerce transaction merchant's (100) member authentication finishes (step S700 to S704), the search method of above-mentioned standard merchandise information database selected (step S706), the then above-mentioned webserver (300) is retrieved above-mentioned standard merchandise information database according to the search condition that above-mentioned e-commerce transaction merchant (100) selects.
Be the above-mentioned webserver (130) with retrieve substantially, enlarge retrieval, and general inquiry any in retrieving retrieve above-mentioned standard merchandise information database.
If above-mentioned e-commerce transaction merchant selects basic retrieval (step S708), the above-mentioned webserver (300) is according to the condition of above-mentioned e-commerce transaction merchant input, the above-mentioned standard merchandise information database of sequential search according to macrotaxonomy, middle classification, subclassification, product, individual event etc. provides the electronic directory with the desired merchandise news of above-mentioned e-commerce transaction merchant (step S710 is to step S720) to above-mentioned e-commerce transaction merchant.
If above-mentioned e-commerce transaction merchant selects to enlarge retrieval (step S722), the above-mentioned webserver (300) is according at least 2 above-mentioned standard merchandise sign indicating number systems of above-mentioned e-commerce transaction merchant input, retrieve above-mentioned standard merchandise information database, provide the electronic directory that is retrieved (step S722 is to step S730) with merchandise news to above-mentioned e-commerce transaction merchant.
On the other hand, if above-mentioned e-commerce transaction merchant selects general inquiry retrieval (step S732), the above-mentioned webserver (300) provides the electronic directory with the desired merchandise news of above-mentioned e-commerce transaction merchant (step S732 is to step S742) according to businessman, supplier, taxonomic hierarchies, other sequential query individual event content of Attribute class to above-mentioned e-commerce transaction merchant.
Then, if in order to transmit the standard merchandise information of above-mentioned e-commerce transaction commodity inspection rope, request is inserted the shopping frame with the standard merchandise information that retrieves and is downloaded, and the then above-mentioned webserver (300) transmits the above-mentioned standard merchandise information that retrieves (step S744 is to step S748) by above-mentioned the Internet (200) to above-mentioned e-commerce transaction merchant.
Figure 10 is explanation transmits the standard merchandise information of retrieval to the e-commerce transaction merchant with the commodity distribution method of servicing shown in Figure 4 process flow diagram of method.
With reference to Figure 10, if by the Internet (200), above-mentioned e-commerce transaction merchant's member authentication finishes, search method is selected, the retrieval to above-mentioned standard merchandise information database that above-mentioned e-commerce transaction merchant requires finishes (step S800 is to step S806), the then above-mentioned webserver (300) provides the standard merchandise information (step S808) of above-mentioned retrieval according to the transmission condition that above-mentioned e-commerce transaction merchant selects to above-mentioned e-commerce transaction merchant.
Promptly, if above-mentioned e-commerce transaction is consulted and request the standard merchandise information stores asked above-mentioned retrieval at CD, then the webserver (300) is accepted this request, as step S810 to shown in the step S820, with the standard merchandise information of the above-mentioned retrieval of disc making, offer above-mentioned e-commerce transaction merchant.
If the standard merchandise information that obtains above-mentioned retrieval with the form of Email of asking is consulted and request in above-mentioned e-commerce transaction, to shown in the step S836, the standard merchandise information of above-mentioned retrieval is offered above-mentioned e-commerce transaction merchant with the form of Email as step S826.
If the standard merchandise information that receives above-mentioned retrieval with electronic data interchange mode or file transfer protocol (FTP) mode of asking is consulted and request in above-mentioned e-commerce transaction, then as step S838 to shown in the step S854, the standard merchandise information of above-mentioned retrieval is offered above-mentioned e-commerce transaction merchant with electronic data form or document form.
On the other hand, to shown in the step S824, when the standard merchandise information of above-mentioned retrieval is directly downloaded, then offer above-mentioned e-commerce transaction merchant as step S822 by process shown in Figure 9.
Figure 11 illustrates the outbound of the commodity of ordering with commodity distribution method of servicing shown in Figure 4 and the process flow diagram of allocator; Figure 12 is explanation with the order goods process flow diagram of step of commodity distribution method of servicing shown in Figure 4.
With reference to Figure 11 and Figure 12, the above-mentioned webserver (300) receives the purchase order information (step S900) of commodity from above-mentioned e-commerce transaction merchant (100).At this moment, above-mentioned purchase order information constitutes by ordering id information, Order Quantity information, merchandise news, individual event information, membership information and distribution information etc.
Then, after the above-mentioned webserver (300) is stored in the purchase order information database (428) of above-mentioned memory storage (400) with above-mentioned purchase order information, above-mentioned purchase order information is classified and added up (step S902).
The above-mentioned webserver (300) is retrieved the said goods information database (414) of above-mentioned memory storage (400) according to from the merchandise news in above-mentioned e-commerce transaction merchant's (100) the above-mentioned purchase order information.Its result checks whether the above-mentioned commodity of ordering are the commodity (step S903) of concluding the business in above-mentioned logistics center (600).
If the above-mentioned commodity of ordering are the commodity in above-mentioned logistics center (600) transaction, the above-mentioned webserver (300) is according to the purchase order information that receives from above-mentioned e-commerce transaction merchant (100), purchase order information at the commodity of above-mentioned logistics center (600) transaction is added up back (step S904), assign the outbound and the dispensing order (step S906) of institute's order goods to above-mentioned logistics center (600).
Then, above-mentioned logistics center (600) response is from the outbound and the dispensing order of the above-mentioned webserver (300), indication forwarding agent (900) the dispensing above-mentioned commodity of ordering (step S908).Forwarding agent (900) responds the dispensing order of above-mentioned logistics center (600), output distribution plan book (step S910), give above-mentioned general client with the above-mentioned commodity distribution of ordering, client receives the commodity of ordering (step S912,914) by above-mentioned e-commerce transaction merchant (100).
In contrast, if retrieve the result of the said goods information database (414) of above-mentioned memory storage (400), the commodity of ordering at step S900 and step S902 are not the commodity in above-mentioned logistics center (600) transaction, the above-mentioned webserver (300) is according to the ordering information that receives from above-mentioned e-commerce transaction merchant (100), the goods order information of above-mentioned goods providers (500) transaction is added up back (step S916), assigning the outbound and the dispensing order (step 8918) of institute's order goods to above-mentioned goods providers (500).
Then, above-mentioned goods providers (500) response is from the outbound and the dispensing order of the above-mentioned webserver (300), output distribution plan book (step S920), indication forwarding agent (900) the dispensing above-mentioned commodity of ordering (step S922).
Then, forwarding agent (900) responds the dispensing order of above-mentioned goods providers (500), gives above-mentioned general client with the above-mentioned commodity distribution of ordering, and client receives the commodity of ordering (step S924, S926) by above-mentioned e-commerce transaction merchant (100).
Then, with reference to Figure 12, if above-mentioned e-commerce transaction merchant (100) has produced the request of ordering of commodity, the above-mentioned webserver (300) is retrieved the On-hand Balance that library information, purchasing order information, inventory information and safety stock information database (430,434,436,438) are checked order goods that of above-mentioned memory storage (400), and calculates the order scheduled volume (step S1000, S1002, S1004) of the above-mentioned commodity of ordering.
At this moment, the safety stock of the above-mentioned order goods of above-mentioned safety stock information database (438) retrieval is deducted the present tank farm stock of the above-mentioned order goods of above-mentioned inventory information database (436) retrieval, this value of carrying out subtraction is deducted the quantity ordered of the above-mentioned order goods of above-mentioned purchasing order information database (434) retrieval, calculate above-mentioned order scheduled volume.
The above-mentioned webserver (300) is retrieved the minimum size of order information database (432) of above-mentioned memory storage (400), extract the minimum size of order information of above-mentioned order goods, check whether the order scheduled volume in step S1004 computing surpasses above-mentioned minimum size of order (step S1006).
If the order scheduled volume of above-mentioned order goods does not surpass the minimum size of order of above-mentioned order goods, the above-mentioned webserver (300) returns step S1004.
If when the order scheduled volume of above-mentioned order goods surpassed the minimum size of order of above-mentioned order goods, the above-mentioned webserver (300) was stored in the purchasing order information of the above-mentioned commodity of ordering in the above-mentioned purchasing order information database (434) (step S1008).
Then, if the order management release (step S1010) of above-mentioned institute order goods, the order goods that the above-mentioned webserver (300) will need to order goods merges, calculate and also to revise the merging size of order (step S1012) that is used to order goods, carry out the authentication processing (step S1014) of the order of order goods etc. then
If the above-mentioned webserver (300) finishes the order of this commodity of ordering, back (step S1016) such as above-mentioned goods providers (500) output delivery prospectus, tax calculated descriptions will receive the commodity of above-mentioned order order to above-mentioned logistics center (600) delivery (step S1018).
In sum, according to commodity distribution service unit and the method for utilizing the standard merchandise information database by computer communication network of the present invention, the information conversion of commodity that will have a plurality of e-commerce transaction merchants, manufacturer and supplier's transaction of mutually different codeword value systems is a standardization codeword value system, structure standard merchandise information database.
Therefore, each e-commerce transaction merchant can provide the information of the commodity that oneself can not conclude the business in advance to the consumer, and as long as the consumer is e-commerce transaction merchant of retrieval, can the information of the commodity of all e-commerce transactions etc. be come into plain view.
In addition, if a plurality of e-commerce transaction merchants will receive commodity, client and the payment information ordered from client by the Internet and transmit to merchandise control person's the webserver, the then above-mentioned webserver is according to the commodity of ordering, and indication supplier or logistics center carry out the outbound of commodity and the order of dispensing.The above-mentioned webserver according to the various databases of memory storage, is checked the tank farm stock of above-mentioned order goods when each commodity are ordered, indicate whether automatically to carry out the order of these commodity.
Therefore, above-mentioned a plurality of e-commerce transaction merchants can make the keeping of commodity and the logistics cost of stock control minimize, and keeping, stock and the order management of transaction commodity can not be subjected to the restriction of trade variety because of businessman's difference.
More than, according to embodiment the present invention is had been described in detail, but the present invention is not limited to embodiment, as long as have the personnel of the common knowledge of the technical field of the invention, can not deviate under the situation of design of the present invention and spirit, and the present invention is revised or changes.

Claims (19)

1, a kind of commodity distribution service unit that utilizes standard merchandise information is characterized in that, comprising:
Memory storage, according to the standardized codeword value system of having prepared, a plurality of e-commerce transaction merchants that will have different mutually codeword value systems, the basic data of the commodity that commodity manufacturer and goods providers etc. provide is transformed to the standard merchandise sign indicating number, standard merchandise information with structure, the purchase order information of the above-mentioned commodity that provide from above-mentioned a plurality of e-commerce transaction merchants, the payment information of order goods, the inventory information of the above-mentioned commodity that provide from above-mentioned commodity manufacturer, the above-mentioned commodity that provide from above-mentioned goods providers go out library information, stored as each database;
The webserver, has subroutine, this subroutine is used to respond the above-mentioned a plurality of e-commerce transaction merchants' that receive by the Internet request, retrieval is in the standard merchandise information of the above-mentioned standard merchandise information database of above-mentioned memory device stores, the standard merchandise information of retrieval is offered above-mentioned requestor with the form corresponding to requestor's request form, to be stored in the purchase order information database of above-mentioned memory storage by the request of ordering that above-mentioned the Internet receives from above-mentioned a plurality of e-commerce transaction merchants, classify and add up, according to above-mentioned inventory information database and outbound information database, the outbound and the dispensing order of the commodity of the request of ordering that will come from above-mentioned a plurality of e-commerce transaction merchants offer above-mentioned goods providers or logistics center.
2, the commodity distribution service unit that utilizes standard merchandise information according to claim 1, it is characterized in that above-mentioned standardized codeword value system comprises at least: the project of businessman's sign indicating number, item property sign indicating number, codeword value, individual event sign indicating number, content sign indicating number, status code and taxonomic hierarchies sign indicating number.
3, the commodity distribution service unit that utilizes standard merchandise information according to claim 2, it is characterized in that the retrieval of above-mentioned standard merchandise information database is to retrieve with in the following retrieval any: promptly use the basic retrieval of retrieving at least more than one project of above-mentioned standardized codeword value system according to above-mentioned requestor's request configuration sequence; Retrieve at least two expansion retrievals of above-mentioned standardized codeword value system simultaneously to begin a project; And retrieve simultaneously in the general inquiry retrieval of the individual event sign indicating number project of above-mentioned standardized codeword value system and other project any retrieve.
4, the commodity distribution service unit that utilizes standard merchandise information according to claim 1, it is characterized in that, providing of the standard merchandise information of above-mentioned retrieval is request form according to above-mentioned requestor, gives above-mentioned requestor's mode to be kept at recording medium; The mode of downloading according to requestor's download request; Mode with E-mail conveyance; The electronic data interchange mode; In the file transfer protocol (FTP) mode any carried out.
5, the commodity distribution service unit that utilizes standard merchandise information according to claim 1, it is characterized in that what above-mentioned a plurality of e-commerce transaction merchants' the request of ordering comprised commodity that the user orders orders id information, Order Quantity information, merchandise news, individual event information, membership information and distribution information.
6, the commodity distribution service unit that utilizes standard merchandise information according to claim 5, it is characterized in that, if the above-mentioned webserver receives the request of ordering from above-mentioned a plurality of e-commerce transaction merchants, then retrieve above-mentioned information of goods information data storehouse, be under the situation of commodity of logistics center transaction at the above-mentioned commodity of ordering, provide above-mentioned outbound and dispensing order to above-mentioned logistics center; Be under the situation of commodity of goods providers transaction at the above-mentioned commodity of ordering, provide above-mentioned outbound and dispensing order to above-mentioned goods providers.
7, the commodity distribution service unit that utilizes standard merchandise information according to claim 1 is characterized in that, above-mentioned memory storage also comprises each minimum size of order database and safety stock database of the commodity of above-mentioned e-commerce transaction merchant transaction.
8, the commodity distribution service unit that utilizes standard merchandise information according to claim 7, it is characterized in that, the above-mentioned webserver is according to the standard merchandise individual event information of the above-mentioned commodity of ordering, present inventory status at above-mentioned these commodity of inventory information database retrieval, the present tank farm stock and the above-mentioned safety stock of retrieval are compared, and will order goods for ordering according to comparative result offers above-mentioned goods providers.
9, the commodity distribution service unit that utilizes standard merchandise information according to claim 8, it is characterized in that, when the order scheduled volume of the above-mentioned commodity of ordering surpasses the minimum size of order of the above-mentioned commodity of ordering, above-mentioned order order is offered above-mentioned goods providers.
10, the commodity distribution service unit that utilizes standard merchandise information according to claim 9, it is characterized in that, above-mentioned order scheduled volume is that the safety stock from the above-mentioned commodity of ordering deducts present tank farm stock, and calculates from the size of order that the value of having carried out this subtraction deducts the above-mentioned commodity of ordering.
11, a kind of standard merchandise information of utilizing is carried out the commodity distribution service method, comprise: the Internet, be used for the memory storage of canned data, the commodity client ordered by above-mentioned the Internet are to the webserver with subroutine of user's dispensing, it is characterized in that, may further comprise the steps:
According to the standardized codeword value system of having prepared, the basic data that will have the commodity that a plurality of e-commerce transaction merchants, commodity manufacturer and the goods providers etc. of mutually different codeword value systems provide is transformed to the standard merchandise sign indicating number, is stored in the step of above-mentioned memory storage as the standard merchandise information database;
The purchase order information of the above-mentioned commodity that above-mentioned a plurality of e-commerce transaction merchants are provided, the payment information of order goods are as the step of each database storing at above-mentioned memory storage;
The inventory information of the above-mentioned commodity that will provide from above-mentioned commodity manufacturer is as the step of database storing at above-mentioned memory storage;
The above-mentioned commodity that will provide from above-mentioned goods providers go out library information, minimum size of order information, safety stock information as the step of each database storing at above-mentioned memory storage;
Respond above-mentioned a plurality of e-commerce transaction merchants' request, retrieve the step of above-mentioned standard merchandise information database;
The standard merchandise information of retrieval is sent to above-mentioned e-commerce transaction merchant's step with the form corresponding to requestor's request form;
Receive the step of above-mentioned a plurality of e-commerce transaction merchants' purchase order information;
The step that above-mentioned purchase order information is classified and added up; And,
According to above-mentioned standard information, inventory information and outbound information database, the outbound of the commodity of the request of ordering that will come from above-mentioned a plurality of e-commerce transaction merchants and the step that the dispensing order offers above-mentioned goods providers or logistics center.
12, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11, it is characterized in that above-mentioned standardized codeword value system comprises at least: the project of businessman's sign indicating number, item property sign indicating number, codeword value, individual event sign indicating number, content sign indicating number, status code and taxonomic hierarchies sign indicating number.
13, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11, it is characterized in that, the retrieval of above-mentioned standard merchandise information database is to retrieve with in the following retrieval any, promptly uses the basic retrieval of retrieving at least more than one project of above-mentioned standardized codeword value system according to above-mentioned requestor's request configuration sequence; Retrieve the expansion retrieval of the project more than at least two of above-mentioned standardized codeword value system simultaneously; And retrieve simultaneously in the general inquiry retrieval of the individual event sign indicating number project of above-mentioned standardized codeword value system and other project any retrieve.
14, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11, it is characterized in that, providing of the standard merchandise information of above-mentioned retrieval is request form according to above-mentioned e-commerce transaction merchant, gives above-mentioned requestor's mode to be kept at recording medium; The mode of downloading according to above-mentioned e-commerce transaction merchant's download request; Mode with E-mail conveyance; The electronic data interchange mode; In the file transfer protocol (FTP) mode any carried out.
15, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11, it is characterized in that what above-mentioned a plurality of e-commerce transaction merchants' the request of ordering comprised commodity that the user orders orders id information, Order Quantity information, merchandise news, individual event information, membership information and distribution information.
16, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11 is characterized in that, also comprises:
According to the standard merchandise information of the above-mentioned commodity of ordering, in the step of the inventory status of the above-mentioned commodity of above-mentioned inventory information database retrieval;
The step that the safety stock information of the tank farm stock of above-mentioned retrieval and the above-mentioned commodity of ordering is compared; And,
According to the result of above-mentioned comparison, above-mentioned order order is offered the step of above-mentioned goods providers.
17, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 16, it is characterized in that, when the order scheduled volume of the above-mentioned commodity of ordering surpasses the minimum size of order of the above-mentioned commodity of ordering, above-mentioned order order is offered above-mentioned goods providers.
18, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 17, it is characterized in that, above-mentioned order scheduled volume is that the safety stock information from the above-mentioned commodity of ordering deducts present tank farm stock, and calculates from the size of order that the value of carrying out this subtraction deducts the above-mentioned commodity of ordering.
19, the commodity distribution method of servicing that utilizes standard merchandise information according to claim 11 is characterized in that, above-mentioned outbound and dispensing commands steps also comprise:
If receive the request of ordering,, checks that whether the above-mentioned commodity of ordering are the steps of the commodity of concluding the business in logistics center then at the above-mentioned commodity of ordering of above-mentioned standard merchandise information data library searching from above-mentioned order e-commerce transaction merchant;
If the commodity of concluding the business in logistics center are ordered the step that offers above-mentioned logistics center with the above-mentioned outbound of the above-mentioned commodity of ordering with providing and delivering;
If not commodity, the above-mentioned outbound and the dispensing order of the above-mentioned commodity of ordering offered the step of above-mentioned goods providers in logistics center's transaction.
CN 00134043 2000-02-12 2000-12-08 Apparatus and method for commodity dispensing delivery service using standard commodity information over computer communication network Pending CN1309372A (en)

Applications Claiming Priority (4)

Application Number Priority Date Filing Date Title
KR1020000006692A KR20000024412A (en) 2000-02-12 2000-02-12 Method for building database of goods information standardized, method and apparatus for searching standardized goods information
KR20006692 2000-02-12
KR20007388 2000-02-16
KR1020000007388A KR20000024494A (en) 2000-02-16 2000-02-16 Service apparatus and method for delivering goods with internet network

Publications (1)

Publication Number Publication Date
CN1309372A true CN1309372A (en) 2001-08-22

Family

ID=26637071

Family Applications (1)

Application Number Title Priority Date Filing Date
CN 00134043 Pending CN1309372A (en) 2000-02-12 2000-12-08 Apparatus and method for commodity dispensing delivery service using standard commodity information over computer communication network

Country Status (2)

Country Link
JP (1) JP2001222652A (en)
CN (1) CN1309372A (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1319007C (en) * 2002-08-06 2007-05-30 株式会社日立制作所 Inventory control system and method, and charging method
CN100388206C (en) * 2003-06-06 2008-05-14 法国无线电话公司 Method with management of an opaque user identifier for checking complete delivery of a service using a set of servers
CN103679478A (en) * 2013-12-17 2014-03-26 南京联创科技集团股份有限公司 Method and system for generating home delivery set of fresh food supermarket
CN101615277B (en) * 2008-06-26 2016-12-14 阿里巴巴集团控股有限公司 A kind of method and apparatus of statistical data
CN109816284A (en) * 2017-11-22 2019-05-28 上海德启信息科技有限公司 A kind of Warehouse Management System
CN110633939A (en) * 2016-06-09 2019-12-31 藤泽和则 Commodity shipment management method and storage medium
CN111639137A (en) * 2020-06-02 2020-09-08 广东金砖天网信息科技有限公司 Multi-platform commodity data synchronization method and system
CN113902376A (en) * 2021-10-21 2022-01-07 广州前后科技有限公司 Cloud computing-based lost commodity processing system and method

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
MXPA04003844A (en) * 2001-09-26 2005-02-17 Seokyu Park Principal guaranteeing game system, gaming method using the same on internet and storage media for the same.

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN1319007C (en) * 2002-08-06 2007-05-30 株式会社日立制作所 Inventory control system and method, and charging method
CN100388206C (en) * 2003-06-06 2008-05-14 法国无线电话公司 Method with management of an opaque user identifier for checking complete delivery of a service using a set of servers
CN101615277B (en) * 2008-06-26 2016-12-14 阿里巴巴集团控股有限公司 A kind of method and apparatus of statistical data
CN103679478A (en) * 2013-12-17 2014-03-26 南京联创科技集团股份有限公司 Method and system for generating home delivery set of fresh food supermarket
CN110633939A (en) * 2016-06-09 2019-12-31 藤泽和则 Commodity shipment management method and storage medium
CN110633939B (en) * 2016-06-09 2023-11-24 藤泽和则 Commodity shipment management method and storage medium
CN109816284A (en) * 2017-11-22 2019-05-28 上海德启信息科技有限公司 A kind of Warehouse Management System
CN111639137A (en) * 2020-06-02 2020-09-08 广东金砖天网信息科技有限公司 Multi-platform commodity data synchronization method and system
CN111639137B (en) * 2020-06-02 2023-08-22 药林大会品牌管理(广东)有限公司 Multi-platform commodity data synchronization method and system
CN113902376A (en) * 2021-10-21 2022-01-07 广州前后科技有限公司 Cloud computing-based lost commodity processing system and method

Also Published As

Publication number Publication date
JP2001222652A (en) 2001-08-17

Similar Documents

Publication Publication Date Title
US7480628B2 (en) Smart multi-search method and system
US8325750B2 (en) Accelerated system and methods for synchronizing, managing, and publishing business information
TWI285339B (en) Mapping between part numbers that are based on different part numbering schemes
US8015076B2 (en) Interactive internet shopping and data integration method and system
US8498906B2 (en) Collaborative product taxonomy instantiation
US10546262B2 (en) Supply chain management system
JP2002536722A (en) An interactive system for looking up products on a network
CN101064036A (en) Electronic commerce system
CN1656487A (en) Electronic shipping system for package pickup and anywhere to anywhere delivery
CN101213571A (en) Internet enhanced local shopping system and method
EP3100179A1 (en) Supply chain management system
CN1291311A (en) Documents for commerce in trading partner networks and interface definitions based on the documents
CN1503955A (en) Method and system for electronic commerce using products satisfaction index
US8732036B2 (en) Supplier/buyer network that provides catalog updates
CN1309372A (en) Apparatus and method for commodity dispensing delivery service using standard commodity information over computer communication network
US20130144745A1 (en) Method and apparatus for managing a supply chain
CN1102272C (en) Polynary confidence degree adapting system and its relative method
CN1376284A (en) Ready listed electronic commerce system and method
US20030187757A1 (en) Targeted catalog information publication
US20030144859A1 (en) E-service publication and discovery method and system
JP4480511B2 (en) Traceability information acquisition system
KR100361936B1 (en) System and method for selling a gem
JP2007004672A (en) Commodity information providing system
MXPA06014628A (en) Automated purchasing method with features for high volume purchasing.
CN1636218A (en) System and method for third party management of product manufacture ordering by a sub-end-user based upon approved products of end-user

Legal Events

Date Code Title Description
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
C06 Publication
PB01 Publication
C02 Deemed withdrawal of patent application after publication (patent law 2001)
WD01 Invention patent application deemed withdrawn after publication