JP2001357107A - Buying assessment system for recycled article - Google Patents

Abstract

PROBLEM TO BE SOLVED: To facilitate the buying assessment of a recycled article with high accuracy and unity irrelevantly to the knowledge and experience of a person in charge. SOLUTION: A database 2 is stored with record data regarding individual recycled articles. The record data have as items price deduction contents of accessory component and damage states and a price deduction reference amount corresponding to the price deduction contents in addition to an article name, properties, and a reference buying amount. A clerk of a recycle store gives a query to the database 2 by specifying retrieval conditions of the article name or properties of a recycled article, knows the reference buying amounts, price deduction contents, and price deduction reference amounts of individual recycled articles, and assesses the articles according to them.

Description

DETAILED DESCRIPTION OF THE INVENTION

[0001]

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to a recycle merchandise purchase and evaluation system which is constituted by a computer and used in a recycle shop or the like.

[0002]

The business of a recycle store is to purchase a recycle product for a predetermined amount from a customer (sale applicant) who wants to have a used recycle product, that is, a recycle product, and sells the recycle product to another customer. At a predetermined price. When purchasing the recycled product, it is necessary to make an assessment and determine the purchase price. This assessment is based on the list price of the new product,
It must be done in consideration of various conditions such as the presence of a cosmetic box, instruction manual and various accessory parts, and the presence or absence of damage.

Conventionally, such a recycle product purchase price has been assessed by a store clerk based on predetermined criteria and experience. In particular, in the case of a store that handles a wide variety of products, the store clerk must It is difficult to memorize all the assessment criteria, and sometimes an appropriate assessment cannot be made. Further, depending on the experience of the clerk, it is inevitable that the assessment will vary for each clerk and for each recycling shop. In particular, in the case of a franchise chain-type recycle store, there is a problem in that the assessed amount varies among stores in the same franchise chain. In addition, for example, when trying to build a franchise chain, it is necessary to allocate clerks who have considerable knowledge and experience in the assessment of the purchase of recycled products to each store. It was hindering deployment.

As described in, for example, Japanese Patent Application Laid-Open No. 7-73372, the use of a computer for managing purchases and sales at a recycle store has been conventionally performed. There was no computer system available. In fact, Japanese Patent Application Laid-Open
No. 73372 discloses a merchandise sales data processor.
In the case of sales, the addition process is performed, while in the case of purchase, the subtraction process is performed.Although the purchase price and sales price are recorded in the database, it can not be used to assess the purchase price of recycled products, This assessment had to be done by the clerk himself.

[0005] The present invention is intended to solve such a problem, and it is possible to easily perform a highly accurate and uniform assessment, thereby making it possible to easily open a new recycle store. The purpose is to provide a product purchase assessment system.

[0006]

According to a first aspect of the present invention, there is provided a system for evaluating the purchase of a recycled product, comprising a computer, comprising: a product name, an attribute and a standard for each recycled product. A database for storing record data including purchase price as an item, an inquiry means for inquiring the database based on search conditions such as a product name or an attribute of a recycled product, and a display for displaying a result of the inquiry by the inquiry means Means, and the database has, as items of the record data, a reduction content and a reduction reference amount corresponding to the reduction content, and the display means displays a reference purchase price, reduction content, and reduction reference value for each recycled product. Displays the amount.

[0007] In using the purchase evaluation system for recycled products, record data on each recycled product is first registered in a database. The record data includes, in addition to items, a product name, an attribute, and a reference purchase price, reduction details and a reduction reference price corresponding to the reduction details. In addition, new record data is added to the database and existing record data is changed as needed. When the clerk of the recycle store evaluates the purchase price, the clerk specifies a search condition such as a product name or an attribute of the recycle product by the inquiry means and makes an inquiry to the database. Display the data of The displayed data includes the base purchase amount, the content of the reduction, and the reduction amount. Therefore, the assessment is performed according to conditions such as the presence or absence of attached parts and the presence or absence of damage of the recycled product to be purchased.Referring to the contents of the reduction and the reference amount of reduction displayed on the display means, if necessary, Reduce from the base purchase price. At the time of inquiring about the recycled product, it is possible to identify the recycled product by using a search function of the computer if a part of the product name or the manufacturer name is known.

According to a second aspect of the present invention, in the recycling product purchase assessment system according to the first aspect of the present invention, the database can hold different data as the deduction content for each record data of each recycled product, The reduction reference amount can be held in any data type of an actual amount and a ratio to the purchase amount.

[0009] When there are many types of merchandise handled at a recycle store, the amount of reduction differs depending on the type of merchandise. However, since the database can hold different data as deduction contents for each record data of each recycled product, the database can cope with the difference in the type of the product. The reduction reference amount may be appropriately indicated by an actual amount or may be appropriately indicated by a ratio to the purchase amount.

A third aspect of the present invention is a recycling product purchase assessment system according to the first or second aspect of the present invention, wherein a plurality of stores or a franchise store in which a management entity is different from each other are to perform a recycling product purchase assessment.
It is provided with a database distributing means capable of querying the same database.

As a result, the purchase amount can be assessed based on the same standard at a plurality of stores or franchise stores with different management entities, and the variation in the assessment of the purchase amount for each store can be suppressed.

[0012]

DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of a system for assessing the purchase of recycled goods according to the present invention will be described below with reference to the drawings. This system is used especially at recycle stores, and the target recycled products include:
PC related products, audio visual related products, various software related products including game software, musical instruments,
Camera-related products, sports equipment including golf clubs,
There are various items such as watches, furniture interior related products, home appliance related products, household goods, gift related products, outdoor related products, hobby related products and clothes. The system is configured by a computer or a network of computers. The computer referred to here is a control device such as a CPU, a storage device such as a RAM or a hard disk, an input device such as a keyboard or a mouse, and a display. Alternatively, it comprises an output device such as a printer and a bus connecting these devices.

FIG. 1 is a system configuration diagram, which is implemented in a computer 1 by software. As shown in FIG. 1, the present system includes a database 2, a database editing means 3 for adding and registering new record data in the database 2, and changing or deleting existing record data, and the like. An inquiry unit 4 for making an inquiry based on a predetermined search condition, a display unit 5 for displaying the result of the inquiry by the inquiry unit, and the like are provided.

The database 2 stores record data on individual recycled products in a storage device such as a hard disk. FIG. 2 shows the configuration of items (fields) of record data. This item contains record data identification key 10, product name 11, genre 12, maker 13, function or content 14, release date
15, the list price 16, the maximum purchase price (base purchase price) 17 or the maximum trade-in price 18, the used price 19, the reduced content 20, and the reduced basic price 21 corresponding to the reduced content 20 are included. The product name 11 can include a model and the like. The genre 12, which is an item indicating an attribute of a recycled product, can be a data type such as a code (for example, a four-digit number) or a character string (for example, "speaker system" or "model train") indicating the genre itself. . The function or content, which is an item indicating the attribute of the recycled product 14
Can store various data such as product specifications. The release date 15 which is an item indicating the attribute of the recycled product indicates the year and month when the product was first released. The list price 16, which is an item indicating an attribute of a recycled product, is a price when the product is sold as a new product. As the value of the item of the fixed price 16, a special value indicating an open price or the like may be taken in addition to a numerical value indicating an actual amount. The used selling price 19 is a reference amount when a recycled product is sold.

The items of the deduction contents 20 and the deduction reference amount 21 form a pair.
Is preferably provided. The items of the content of the reduction 20 indicate items to be reduced from the upper limit purchase amount in the purchase assessment of the recycled product, such as presence / absence of a cosmetic box, an instruction manual, various attached parts, and presence or absence of damage. Further, in the item of the deduction content 20, different data can be held for each record data of each recycled product even if the same item (field) in the database 2 is used. This can be implemented by, for example, setting the data type of the item of the deduction content 20 to be one that can store an arbitrary character string (for example, “decoration box”, “scratch / dirt”, or NULL). In addition, the deduction base amount corresponding to the deduction content 20
21 can hold any data type of the actual amount and the ratio to the purchase amount. This means that, for example, "1000 yen" or "20%"
It can be implemented by making it possible to store character strings such as.

FIG. 3 shows a search window 31 used by the inquiry means 4 to specify search conditions for a product name or various attributes of a recycled product. This search window 31 is used for general products or golf clubs.
In order to make appropriate inquiries for each type of recycled product,
A different search page 32 may be provided for each type of recycled product. In the search window 31, a product name edit box 33 for specifying conditions for the item of the product name 11 of the database 2, a maker edit box 34 for specifying conditions for the item of the maker 13 of the database 2, and a genre 12 of the database 2 There are a genre edit box 35 for designating conditions relating to items and a function edit box 36 for designating conditions relating to the functions or contents 14 of the database 2. The conditions specified in the respective edit boxes 33, 34, 35, 36 are connected by a logical product.

Each of these edit boxes 33, 34, 35,
There are condition delete buttons 37, 38, 39, and 40 corresponding to 36, respectively. By clicking these condition delete buttons 37, 38, 39, and 40, the corresponding edit boxes 33, 34, 35, and 36 are one-touch. Can be empty (the condition for the corresponding item is not specified). Further, there are list reference buttons 41 and 42 corresponding to the maker edit box 34 and the genre edit box 35, respectively. Clicking on these list reference buttons 41 and 42 opens a window (not shown) of a list of manufacturers or genres. By selecting a predetermined maker or genre, a maker edit box 34 or a genre edit box 35 is selected. It is possible to easily input the maker or genre into the system. At this time, if a character or a character string is entered in the edit boxes 34 and 35, a maker or a genre including the character or the character string is searched, and a list thereof is displayed.

In the search window 31, the manufacturer 13 is displayed.
There is also a maker search method button group 43 for specifying a search method for the item of genre and a genre search method button group 44 for specifying a search method for the genre 12 item. When "include" is selected in the search method button groups 43 and 44, a record in which the character string entered in the edit boxes 34 and 35 is included in an arbitrary position of the value of the item of the maker 13 or the genre 12 in the database 2 If the data is searched and you select "Start with",
The record data in which the character string entered in the edit boxes 34 and 35 is included at the beginning of the value of the item of the maker 13 or the genre 12 is searched, and when the “match after” is selected, the input is performed in the edit boxes 34 and 35. The record data in which the character string is included at the end of the value of the item of the maker 13 or the genre 12 is searched, and when “not included” is selected, the character string input to the edit boxes 34 and 35 is changed to the maker 13 or the genre 12 The record data not included in the item is searched. The search for the function or content 14 item is performed based on whether the character string input to the function edit box 36 is included in the character string of the value of the function or content 14 item. Also, wildcards may be used in character string searches.

Further, the search window 31 includes a search execution button 45, a condition deletion button 46, and a cancel button 47.
There is also. When the search execution button 45 is clicked, a search, that is, an inquiry to the database 2 is executed. When the condition deletion button 46 is clicked, all the edit boxes 33 and 3 are clicked.
When 4, 35 and 36 become empty and the cancel button 47 is clicked, the search window 31 is closed without executing the inquiry.

FIG. 4 shows a list window 51 opened by executing an inquiry in the search window 31, which forms a part of the display means 5. The list window 51 has a grid box 52 for displaying record data in the database 2 that meets the search conditions specified in the search window 31 in a list format. In the grid box 52, the product name 11, genre 12, maker 13, and release date of the record data of the database 2 are stored.
15, the price 16, the maximum purchase price 17, and the used price 19 are displayed. The list window 51 also includes a scroll control 53 for moving a cursor for record data in the grid box 52, a narrow search button 54, a new search button 55, and a detail display button 56. The search window 31 is opened by clicking the search buttons 54 and 55. However, when the search window 31 is opened by clicking the refined search button 54, a new one among the record data currently displayed in the grid box 52 is displayed. When a new search button 55 is clicked while an inquiry is made, a new inquiry is made in the entire database 2. Further, when the detail display button 56 is clicked, a detail display window 61 (shown in FIGS. 5 and 6) for displaying more detailed data on the record data where the cursor is currently located in the grid box 52 is opened.

The detail display window 61 is a part of the display means 5 and has one record data, that is, one recycled product, the product name 11,
It displays the values of genre 12, maker 13, function or content 14, release date 15, fixed price 16, maximum purchase price 17, maximum trade-in price 18, reduction content 20, and reduction standard price 21. In particular, the deduction contents 20 and the corresponding deduction reference amount 21 are displayed on the deduction display section 62 in the form of a list.
The detail display window 61 also has a scroll control 63, a narrow search button 64, a new search button 65, and a list display button 66. Scroll control
Numeral 63 is for moving a cursor for record data in the grid box 52 of the list window 51, and accordingly, the record data displayed in the detail display window 61 also changes. Further, the narrow search button 64 and the new search button 65 are the narrow search button 54 and the new search button in the list window 51.
55 have the same functions as each other. further,
Click the list display button 66 to display the list window
51 moves to the front.

Next, a description will be given of a method of using the recycle product purchase assessment system. In order to use this system, first, it is necessary for the database editing means 3 to register record data on each recycled product in the database 2. Record data items include the product name 11, genre 12, maker 13,
Function or content 14, Release date 15, Regular price 16, Maximum purchase price 17 or Maximum trade-in price 18, Used price 19, Reduced content 20
And the reduction base amount of 21, etc., especially the upper limit purchase amount
17, upper limit trade-in amount 18, reduction contents 20, and reduction base amount 21
May be determined based on the accumulation of past experience at a recycle store using this system. Database 2
The addition of new record data to the database and the change of existing record data are also performed by the database editing means 3 as needed.

When the clerk at the recycling store evaluates the purchase price of the recycled product, the clerk opens the search window 31 and specifies search conditions (product name, manufacturer, genre or function) corresponding to the recycled product. . For example, if the recycled product to be assessed is a speaker, "speaker" is entered in the genre edit box 35, and if the manufacturer is clear, the manufacturer name is also entered in the manufacturer edit box 34. At this time, a search method can be designated by the search method button groups 43 and 44, and an appropriate search method can be selected according to a margin of time.

When the search execution button 45 is clicked after specifying the search conditions in this way, an inquiry to the database 2 is executed, and the result is displayed in the list window 51. Then, in the grid box 52 of the list window 51, search for the corresponding recycled product by referring to the product name including the model and the manufacturer, etc., place the cursor on the record data and click the detail display button 56 to display the relevant record. Details display window 61
Will be displayed. If the number of record data displayed in the grid box 52 is too large and it is difficult to specify the record data of the recycled product, use the narrow search button.
By clicking 54, you can further narrow down the record data. If there is no record data of the recycled product in the record data displayed in the grid box 52, a new search button 55 can be clicked to perform an inquiry again. Further, by scrolling the record data in the detail display window 61, it is also possible to search for the corresponding recycled product by referring to the data of the item such as the function or the content 14.

When the detail display window 61 is opened for the record data of a predetermined recycled product to be assessed, the assessment is performed based on the data displayed there. For example, if there is no item to be reduced, the purchase may be performed with the upper limit purchase price displayed in the detail display window 61. Further, referring to the data displayed in the reduction display section 62 of the detail display window 61, if there is a matter to be reduced, the purchase price is reduced. For example, if the recycled product to be purchased does not have an instruction manual, and the instruction manual "1000 yen" is displayed in the reduction display section 62, the purchase price is 100 yen.
If the recycle product is damaged and “removable goods 20%” is displayed in the reduction display section 62, the purchase price is reduced by 20%. Of course, the clerk can also adjust the purchase price at his own discretion.

As described above, by using the recycling product purchase assessment system, the assessment of the purchase price of the recycled product can be easily performed with high accuracy and uniformity regardless of the knowledge and experience of the clerk. It can be carried out. That is, even a part-timer, a part-time job clerk, or even a clerk who has no experience can make a purchase assessment of a recycled product that requires considerable knowledge and experience in a very short time.
By improving the accuracy and uniformity of the assessment, it is possible to reduce the variability of the assessment by each clerk, and also to solve the problem of being assessed at an unreasonably low amount. It is very advantageous. Also,
In particular, in the case of a franchise chain, by referring to the same database 2 at a plurality of franchise stores, the purchase amount can be assessed based on the same standard, and the assessment of the purchase amount may vary among stores. Can be suppressed. In addition, using this system, which is a standardized system for purchasing assessment data, makes it easier for new employees to open new stores by eliminating the need for clerks with advanced knowledge and experience when opening new recycling stores. It is also possible to build a franchise chain utilizing the know-how.

Further, according to the method of referring to the database 2 using the above-described search window 31 or the like, if a part of a product name, a genre, or a maker name, etc. is known, a recycled product can be specified by the search function of the computer 1. , Making purchase assessment easier.

In the case where there are many types of merchandise handled at the recycle shop, the amount of reduction is different depending on the type of merchandise. However, the database stores different data as the value of the item of the amount of reduction 20 for each record data of each recycled item. Can be held, so that it is possible to cope with a difference in the type of product. In addition, there are cases where it is appropriate to show the reduction base amount by the actual amount and cases where it is appropriate to show it by the ratio to the purchase amount. However, the items of the reduction base amount 21 in the database 2 can correspond to both. .

As described above, especially in a franchise chain, it is necessary to refer to the same database 2 in each franchise store in order to suppress a variation in the assessed amount for each store (franchise store). For this purpose, some kind of database distribution means that allows the same database 2 to be queried at a plurality of franchise stores is required.

FIG. 7 shows an example of the database distribution means 71. In FIG. 7, reference numeral 72 denotes a computer disposed at each franchise store, and 73 denotes a computer disposed at the headquarters of the franchise chain. These computers 72 and 73 are information communication / computer networks such as LAN, WAN or the Internet. Interconnected by means. Each computer 72,
Each of the databases 73 has the database 2, and the editing of the database 2 is basically performed by the computer 73 at the headquarters. Then, the database 2 of the computer 73 itself is distributed to the computers 72 of the franchise stores as needed, and the database 2 of these computers 72 is updated. For distribution of the database 2, a file sharing service in a network, a file transfer protocol, electronic mail, or the like can be used.

FIG. 8 shows another example of the database distribution means 81. Reference numeral 82 denotes a client (computer) disposed at each franchise store, and reference numeral 83 denotes a server (computer) disposed at the headquarters of the franchise chain.
They are mutually connected by means such as N, WAN or the Internet. The database 2 exists only in the server 83 and not in the client 82. Each client 82 makes an inquiry to the database 2 by connecting to the server 83 as needed. That is, in the example shown in FIG. 8, the connection service to the database 2 in the server 83 forms the database distribution means 81.

It should be noted that the present invention is not limited to the above embodiment, and various modifications can be made. For example,
The above-described items of the record data in the database are merely examples, and various items indicating the attributes of the recycled product and the like can be set in the record data. For example, items such as the product name 11, the genre 12, the function or the content 14, etc., including the model and the like may be divided into a plurality of items. Further, the designs of the windows 31, 51, and 61 described above are merely examples. Further, in the above-described embodiment, the stores in one franchise chain are exemplified for a plurality of stores that refer to the same database. Alternatively, the same database may be referred to at a plurality of franchise stores having different management entities.

[0033]

According to the system for assessing the purchase of recycled goods according to the first aspect of the present invention, a database for storing record data including, as items, a product name, an attribute, and a reference purchase price for each recycled product is provided. Means for making an inquiry based on a search condition such as a product name or an attribute of a recycled product, and display means for displaying a result of the inquiry by the inquiry means. The display means displays the standard purchase price, the content of the reduction, and the reduction standard price for each recycled product, so that the display means displays the standard purchase price, reduction content, and reduction standard price for each recycled product. Highly accurate assessment can be easily performed. That is, even a part-timer, a part-time job clerk, or even a clerk who has no experience can make a purchase assessment of a recycled product that requires considerable knowledge and experience in a very short time. By establishing a standardized system of purchase assessment data in this way, it is easy to open new recycle stores,
It is also possible to build a franchise chain utilizing the know-how of purchase assessment. Furthermore, when making inquiries regarding recycled products, the search function of the computer can also be used to identify recycled products if part of the product name, manufacturer name, etc. is known, making assessment easier. It is possible to

Furthermore, according to the recycling product purchase assessment system of the second aspect of the present invention, the database can hold different data as the deduction content for each record data of each recycled product, and the deduction standard Since the amount of money can be stored in both the actual amount and the ratio to the purchase amount, it can be used even if there are many types of products handled at the recycle shop, and the reduction base amount is the ratio to the actual amount and the purchase amount. And the appropriate one of

According to the third aspect of the present invention, the same database can be queried at a plurality of stores or franchise stores which are different in management from which the purchase evaluation of the recycled product is to be performed. Since the database distribution means is provided, the purchase price can be assessed based on the same standard at a plurality of stores or franchise stores with different management entities, and the variation in the assessment of the purchase price for each store can be suppressed.

[Brief description of the drawings]

FIG. 1 is a system configuration diagram showing one embodiment of a recycling product purchase assessment system of the present invention.

FIG. 2 is a configuration diagram of a database according to the first embodiment;

FIG. 3 is a front view of the search window.

FIG. 4 is a front view of the list window.

FIG. 5 is a front view of the detail display window.

FIG. 6 is a front view of the detail display window.

FIG. 7 is a configuration diagram showing an example of distribution of the database.

FIG. 8 is a configuration diagram showing another example of distribution of the same database.

[Explanation of symbols]

 1 Computer 2 Database 4 Inquiry means 5 Display means 11 Product name 17 Upper limit purchase amount (base purchase amount) 20 Reduction contents 21 Reduction base amount 71 Database distribution means 81 Database distribution means

Claims (3)

[Claims] 1. A recycling product purchase assessment system constituted by a computer, comprising: a database for storing record data including, as items, a product name, an attribute and a reference purchase price for each recycled product; Inquiry means for making an inquiry based on a search condition such as a product name or an attribute of a recycled product, and display means for displaying a result of the inquiry by this inquiry means, wherein the database includes the reduced content and the A recycling product purchase assessment system, having a reduction reference amount corresponding to the content of the reduction, wherein the display means displays a reference purchase amount, reduction details, and a reduction reference amount for each recycled product. 2. The database can hold different data as the deduction content for each record data of each recycled product, and the deduction reference amount can be any data type of an actual amount and a ratio to the purchase amount. 2. The system for assessing the purchase of recycled goods according to claim 1, wherein the system can be retained. 3. The system according to claim 1, further comprising a database distributing means for enabling the same database to be referred to at a plurality of stores or franchise stores having different management entities, each of which is to evaluate the purchase of recycled products. Recycled goods purchase assessment system.