JP2005141658A - Replacement-needed part notification system - Google Patents

Abstract

<P>PROBLEM TO BE SOLVED: To significantly reduce labor for notifying a life to a user to urge replacement. <P>SOLUTION: A replacement-needed part notification system comprises customer information storing means 15, sales history storing means 15, merchandise specification storing means 15, part information storing means 15, life identifying means 12, life information storing means 15, replacement-needed part extracting means 12 for extracting information capable of identifying the parts whose life will be reached within a predetermined period of a current day according to the life of each part stored in the life information storing means, and replacement-needed part information outputting means 2, 13 for outputting replacement-timed part information about the parts identified by the information capable of identifying the extracted parts, and also sending information to the customers who have purchased merchandise having the parts. <P>COPYRIGHT: (C)2005,JPO&NCIPI

Description

  The present invention relates to a replacement required component notification system for notifying the owner of a facility device of a replacement required component that needs to be replaced among various components used in the facility device in a home or office.

  In recent years, from the viewpoint of environmental issues, reducing the amount of garbage has become a major issue, so it is necessary to replace parts accurately in the home and office equipment against the background of these garbage problems. By implementing the above, it has been required to extend the life (operation period) of the equipment.

  However, in each piece of equipment delivered to the user, the number of various parts that make up the equipment is calculated based on the useful life of each part, and the user is notified of the useful life to encourage replacement. Had the problem of requiring a lot of effort.

  The present invention has been made paying attention to such a problem, and provides a replacement necessary part notification system capable of greatly reducing the labor for notifying the user of the expiration date and prompting replacement. It is aimed.

In order to solve the above-described problem, a replacement required part notification system according to claim 1 of the present invention is provided.
A customer information storage means for storing sending information required for sending a notice to the customer in association with information that can identify the customer who sold the product;
Sales history storage means for storing the date related to the start of use of the product and information that can identify the customer who sold the product, in association with the information that can identify the sold product;
Product specification storage means for storing information that can identify a component that constitutes the product in association with information that can identify the product;
A component information storage means for storing information relating to the lifetime of the component in association with information capable of specifying the component;
Based on the storage information stored in the sales history storage means, the product specification storage means, and the part information storage means, the expiration date specifying means for specifying the expiration date of each part constituting each product sold to the same customer;
A lifetime information storage means for storing the lifetime specified by the lifetime expiration specifying means for each customer in association with information that can identify the part;
Based on the expiration date of each component stored in the expiration date information storage means, replacement required component extraction means for extracting information that can identify a component that will become the expiration date within a predetermined period from that day,
Purchasing a product having the relevant part based on the information stored in the customer information storage means with respect to the part required for the part identified from the information that can identify the part extracted by the necessary part extraction means. Replacement necessary part information output means for outputting as a part that needs to be replaced together with information sent to the customer,
It is characterized by having.
According to this feature, the expiration date of each part constituting the product sold to each customer is specified by the expiration date specifying means, stored in the expiration date information storage means, and stored in the expiration date information storage means Among the useful lifespans that have been used, a part that will expire within a predetermined period, for example, one month, is extracted, and information about the extracted part is output together with information sent to the customer as a part that needs to be replaced. Therefore, the labor for notifying the customer (user) of the expiration date and prompting the exchange can be greatly reduced.

The replacement part notification system according to claim 2 of the present invention is the replacement part notification system according to claim 1,
Replacement part information input means for inputting information that can identify the replaced part,
An expiration date updating means for updating the expiration date stored in the expiration date information storage means in association with the identifiable information inputted from the replacement part information input means;
It is characterized by having.
According to this feature, the expiration date is updated based on the information of the actually replaced parts input from the replacement part information input means. For example, when there is a period between notification and replacement, etc. Will also be able to specify the exact next useful life.

The replacement part notification system according to claim 3 of the present invention is the replacement part notification system according to claim 1 or 2,
The sales history storage means further stores information on the usage status of each sold product in the customer,
The expiration date specifying means corrects the specified expiration date based on information on the usage status.
According to this feature, it is possible to cope with a change in the expiration date due to a difference in usage frequency or the like depending on the customer, and it becomes possible to specify the expiration date according to the actual usage status.

The replacement necessary part notification system according to claim 4 of the present invention is the replacement required part notification system according to claim 3,
The replacement part information input means is capable of inputting information regarding the wear status of the replaced part, together with information capable of specifying the replaced part,
It is characterized by comprising usage status update means for updating the information on the usage status based on the inputted information on the wear status.
According to this feature, the usage status is updated based on the wear status of the parts in actual replacement, and the expiration date is corrected based on the updated usage status. It can be reflected in the specification of the expiration date.

The replacement necessary part notification system according to claim 5 of the present invention is the replacement required part notification system according to any one of claims 1 to 4,
The component information storage means stores information on compatible components in addition to the useful life of each component,
The replacement part extraction unit extracts information on compatible parts stored in correspondence with information that can specify the extracted parts in the part information storage unit, together with information that can specify parts.
The replacement required part information output means outputs the extracted information regarding the compatible part in addition to the replacement required part information.
According to this feature, information about compatible parts can be accurately notified.

The replacement necessary part notification system according to claim 6 of the present invention is the replacement required part notification system according to any one of claims 1 to 5,
The sending information is an email address;
The replacement-required part information output means outputs an e-mail including the replacement-required part information by transmitting it to an e-mail address of a customer who purchased a product having the part.
According to this feature, the replacement-required part information is automatically notified by e-mail, and the labor involved in notifying the customer of the replacement-required part information can be greatly reduced, and the customer can be promptly Notification can be realized.

  Examples of the present invention will be described below.

  FIG. 1 is a diagram illustrating a configuration of a replacement necessary part notification system according to the present embodiment, and FIG. 2 is a diagram illustrating a configuration of a server computer 1 used in the present embodiment.

  As shown in FIG. 1, the system for notifying parts required for replacement according to the present embodiment is connected to a server computer 1 installed at a head office, for example, and to the server computer 1 via a communication device 2 and a communication line so that data communication is possible. It is comprised from the computer terminal 3 used as the replacement part information input means installed in each branch office a, b ..., and it goes to each customer from each branch office a, b ..., and the replacement | exchange work of parts is implemented.

  The server computer 1 is connected to the Internet network via the communication device 2, and can send an e-mail to the customer's personal computer 4 connected to the Internet network.

  First, the configuration of the server computer 1 used in this embodiment will be described. The server computer 1 used in this embodiment is configured as shown in FIG. 2, and data transmission / reception is performed inside the computer. Various information such as a display device 14 such as a monitor as an output means, a printer 18 capable of printing out information on parts that need to be replaced, information on customers, information on sales, etc. Input device 16 such as a keyboard or mouse for input, a service life specifying process for specifying the service life of each component performed by the server computer 1, a correction process for correcting the specified service life, and the correction A lifetime registration (update) process for registering or updating the lifetime of each component based on the lifetime, an extraction process for extracting a component that will have a lifetime within a predetermined period, A process for creating a replacement-required part information mail including replacement-required part information related to a part extracted in the delivery process or a compatible part, a process for transmitting the created replacement-required part information mail, Life expiration date specifying means for performing various processing such as usage status update processing for updating customer usage status type information based on replacement part information on replacement parts, replacement required part extraction means, replacement required part information output means, expiration date update Central processing unit (CPU) 11 as means and usage status update means, RAM 12 used as a work memory used for each processing performed by the CPU 11, current time information, day of the month The real-time clock (RTC) 17 that can output calendar information such as the data and the communication device 2 is used for data transmission / reception. The communication interface 13 is composed of a magnetic disk or a magneto-optical disk, and stores an exchange management program in which the above-mentioned various processing contents are described, a customer information database, a sales history database, a product specification database, a parts information database, a lifetime database, etc. And a storage device 15 as a customer information storage means, a sales history storage means, a product specification storage means, a part information storage means, and an expiration date information storage means. Are connected to the Internet network and the computer terminals 3 of the branch offices a, b... Via the communication device 2 connected to the communication interface 13.

  Next, the configuration of the customer information database used in the present embodiment will be described with reference to FIG. As shown in FIG. 3A, the customer information database of this embodiment is associated with a customer ID, which is information that can identify each customer, and the usage status type used for correcting the customer name and the useful life period. The e-mail address and the branch office in charge of the customer are registered together with the postal code and address, which are the sending information required to send the notice to the customer, and these information are entered in the above-mentioned manner. Registration is performed by inputting from the device 16 in customer registration.

  In addition, the sales history database used in the present embodiment can specify the sales date as the date related to the start of use of the product, the product name of the product sold, and the product sold as shown in FIG. The product ID, which is information, and the purchase customer ID that purchased the product are registered in association with each other.

  In addition, as shown in FIG. 4A, the product specification database used in the present embodiment is configured in association with the product ID of each product, the product name, the sales unit price, and the product used for the product. The component parts of each part being registered are registered, and the component ID and the number (quantity), which are information that can identify each part constituting the product, are registered in the component part.

  In addition, as shown in FIG. 4B, the component information database used in the present embodiment is associated with each component ID, and includes a component name, a unit price, a standard replacement period that is a lifetime of the component, A part ID of a compatible part that can be used in the same manner as the part is registered.

  In addition, in the expiration date database used in the present embodiment, as shown in FIG. 5, the product ID sold to the customer is associated with each customer ID, and the product is associated with the product ID. The component ID of the component to be configured and the expiration date of the component are registered.

  The flow in which the expiration date of each part is registered in the expiration date database or the expiration date is updated will be described with reference to the flowchart shown in FIG. 6. First, products sold as sales information from the input device 16. When the sales information including the product ID, purchase customer ID, and sales date is input, the input sales information is registered as a new sales history in the sales history database.

  The registration of the new sales history is determined in S1 that a new sales history has been registered, and the process proceeds to S2. If it is determined in S1 that no new sales history has been registered, the process proceeds to S6 to determine whether or not replacement part information has been received from the computer terminal 3 provided at each branch office.

  In S2, the part ID of each part constituting the product is specified from the product specification database from the product ID of the newly sold product, and the specified part ID and the product ID are used to purchase the product. In association with the customer ID of the registered customer, it is registered in the expiration date database.

  Next, the process proceeds to S3, and after the lifetime of the part of each newly registered part ID is specified from the standard replacement period corresponding to the part ID in the part information DB, the process proceeds to S4, where the lifetime of each specified part is specified. Is corrected based on the usage status type information stored in the customer information database in association with the customer ID of the customer. Specifically, in these usage status types, the usage status is N (normal) indicating normal usage status, H (high usage) indicating very high usage status, and very low usage frequency. L (low usage) indicating usage status is registered, and when the useful life specified from the standard replacement period is 365 days, for example, the usage status type is N (normal) ), The specified 365 days are used as they are for the lifetime, and when the usage status type is H (high usage), a predetermined correction coefficient of 0.75 is set to the specified 365 days. When 273 days multiplied is used as the useful life and the usage status type is L (low use), 456 days multiplied by 1.25 which is a predetermined correction factor on the specified 365 days is corrected as the useful life. To do.

  Then, the process proceeds to S5, where a date that becomes the expiration date is calculated from the lifetime corrected in this way and the sales date included in the sales information, specified for each component, and the date that becomes the specified lifetime Is registered for each part, and the end-of-life date database registers and manages the dates that become the end-of-life of all parts that make up all the products sold to each customer.

  Based on the service life of each part registered in the service life database in this way, the flow in which the mail of the parts required for replacement is transmitted from the server computer 1 to the customer will be described below based on the flowchart shown in FIG. Then, first, the server computer 1 according to the present embodiment extracts, for each customer, a part that will reach the end of its useful life within a predetermined period of the month, for example, on the first day of the month. Sa1). Specifically, all the component IDs registered corresponding to dates in which the month of the date registered in the expiration date is the same as that month are extracted.

  Then, the process proceeds to Sa2, where the part name and unit price of the extracted part ID are specified from the part information database, and information on compatible parts of each part is extracted from the part information database.

  Then, the process proceeds to Sa3 to create a replacement necessary part mail including the part name and unit price of each identified part and information on compatible parts. Then, the process proceeds to Sa4 and the electronic device that is the transmission destination of the created replacement necessary part mail. The email address is identified from the email address registered in the customer information database corresponding to the customer ID to be extracted, and the process proceeds to Sa5 and the exchange created in Sa3 for the identified email address By transmitting the necessary parts mail, each customer is notified of the part names and unit prices of the parts that need to be replaced within the month, and information on compatible parts. In this embodiment, the same content as the email sent to the customer is also sent to the computer terminal 3 at the branch office in charge of the customer, so that the content notified to the customer is in charge. The person in charge at the branch office can also be grasped, and the person in charge at the branch office can easily promote replacement of the notified part.

  When the customer actually replaces the parts by notification of these replacement parts, the contents of the replacement are input on the replacement part information input screen shown in FIG.

  In the replacement part information input screen of this embodiment, as shown in FIG. 8, the date of replacement, the customer ID of the customer who performed the replacement, the part ID of the replaced part, and the replaced part Each of the information entered on the replacement part information input screen is selected by inputting “send” after inputting information on the replaced parts in these input parts. Is transmitted to the server computer 1 as replacement part information. For the wear status, “Normal (N)” is selected and input if the replaced part is a normal wear condition, and “High” if the wear condition of the replaced part is very worn. “Use (H)” is selected and input, and if the wear status of the replaced part is not so worn, “Low use (L)” is selected and input.

  The replacement part information is received in step S6 of the flowchart shown in FIG. 6 where it is determined that the replacement part information has been received, and the process proceeds to step S7, where wear information (“normal (N)”, “ Based on “high use (H)” or “low use (L)”), the usage status type information stored in the customer information database is updated in association with the customer ID included in the received replacement part information. To do. Specifically, the received wear information (“normal (N)”, “high usage (H)”, or “low usage (L)”) is registered in the usage status type information.

  Then, the process proceeds to S8, in which the useful life of the part ID included in the received replacement part information is specified from the data in the parts information database, and the specified useful life is updated with the wear status information. Based on the above, correction is performed in the same manner as in the process of S4 described above.

  Then, the process proceeds to S9, where the replacement date included in the received replacement part information is the registration date of the expiration date corresponding to the replaced part in the lifetime database specified from the customer ID and the part ID included in the received replacement part information. By updating to the expiration date calculated from the date and the lifetime corrected in S8, a new expiration date is set for the next notification that the part needs to be replaced. The service life period reflects the service life corrected based on the wear state of the parts actually collected by the parts replacement.

  As described above, according to the replacement necessary part notification system of the present embodiment, the service life of each part constituting the product sold to each customer is determined by the service life specifying process performed by the server computer 1 serving as the service life specifying means. It is specified and stored in the expiration date database that is the expiration date information storage means, and among the expiration dates stored in the expiration date database, a part that becomes the expiration date within a predetermined period, for example, one month is extracted, Since the replacement necessary part mail including the information on the part that needs to be replaced, which is information on the extracted part, is output by sending it to an e-mail address as information to be sent to the customer, It is possible to greatly reduce the labor for notifying the customer (user) and prompting the exchange.

  Further, according to the replacement required part notification system of the present embodiment, based on replacement part information which is information of actually replaced parts transmitted and input from the computer terminal 3 at each branch office serving as replacement part information input means. Since the expiration date is updated, an accurate next expiration date can be specified even when, for example, there is a period between notification and replacement. In the embodiment described above, the expiration date is actually updated based on the replacement part information as described above. However, the present invention is not limited to this, and the expiration date is notified by notification. It may be updated without depending on the replacement part information, assuming that the part has been replaced.

  Further, according to the replacement required part notification system of the present embodiment, by correcting the expiration date based on the usage status type information, it is possible to cope with changes in the expiration date due to different usage frequency etc. depending on the customer. Although it is preferable from the fact that it is possible to specify the expiration date according to the actual usage situation, the present invention is not limited to this, and a configuration in which these corrections are not performed may be employed.

  Further, according to the replacement required part notification system of the present embodiment, the usage status type information that is the usage status is updated based on the wear status of the components in the actual replacement included in the component replacement information from the computer terminal 3 at each branch office. Then, since the expiration date is corrected based on the updated usage status type information, the actual usage status of the customer can be reflected in the specification of the lifetime.

  In addition, according to the replacement part notification system of the present embodiment, the replacement part email notified to the customer includes information about the compatible part. Can be notified.

  Further, according to the replacement required part notification system of the present embodiment, the replacement required part information is automatically notified by a replacement required part mail, and the labor involved in notifying the customer of the replacement required part information can be reduced. It can be greatly reduced and prompt notification to customers can be realized.

  In the above-described embodiment, the replacement part information to the customer is sent by e-mail. However, the present invention is not limited to this, and these notifications are sent to the customer and need to be replaced. The component information may be printed out from the printer 18 and sent by mail.

  Although the embodiments of the present invention have been described with reference to the drawings, the specific configuration is not limited to these embodiments, and modifications and additions within the scope of the present invention are included in the present invention. It is.

  For example, in the above-described embodiment, one month within the month is applied as the predetermined period of the extraction target for notification, but the present invention is not limited to this, and other predetermined periods, for example, A half-month unit may be used, or these predetermined periods may be set and changed as appropriate.

  In the above embodiment, the usage status type is set for each customer. However, the usage status type is provided for each purchased product so that the same customer can use different usage status for each purchased product. A type may be set.

It is a figure which shows the structure of the replacement required component notification system in the Example of this invention. It is a figure which shows the structure of the server computer used for the Example of this invention. (A) is a figure which shows the customer information database used for the Example of this invention, (b) is a figure which shows the sales history database used for the Example of this invention. (A) is a figure which shows the goods specification database used for the Example of this invention, (b) is a figure which shows the components information database used for the Example of this invention. It is a figure which shows the expiration date database used for the Example of this invention. It is a flowchart which shows the processing content of the expiration date registration (update) process implemented with the server computer used for the Example of this invention. It is a flowchart which shows the processing content of the replacement | exchange required components mail transmission processing implemented with the server computer used for the Example of this invention. It is a figure which shows the replacement part information input screen in the computer terminal installed in each branch office used for the Example of this invention.

Explanation of symbols

DESCRIPTION OF SYMBOLS 1 Server computer 2 Communication apparatus 3 Computer terminal 4 Personal computer 10 Data bus 11 Central processing circuit (CPU)
12 RAM
13 Communication Interface 14 Display Device 15 Storage Device 16 Input Device 17 Real Time Clock (RTC)
18 Printer

Claims (6)

A customer information storage means for storing sending information required for sending a notice to the customer in association with information that can identify the customer who sold the product;
Sales history storage means for storing the date related to the start of use of the product and information that can identify the customer who sold the product, in association with the information that can identify the sold product;
Product specification storage means for storing information that can identify a component that constitutes the product in association with information that can identify the product;
A component information storage means for storing information relating to the lifetime of the component in association with information capable of specifying the component;
Based on the storage information stored in the sales history storage means, the product specification storage means, and the part information storage means, the expiration date specifying means for specifying the expiration date of each part constituting each product sold to the same customer;
A lifetime information storage means for storing the lifetime specified by the lifetime expiration specifying means for each customer in association with information that can identify the part;
Based on the expiration date of each component stored in the expiration date information storage means, replacement required component extraction means for extracting information that can identify a component that will become the expiration date within a predetermined period from that day,
Purchasing a product having the relevant part based on the information stored in the customer information storage means with respect to the part information required for the part identified from the information that can identify the part extracted by the necessary part extraction means. Replacement required part information output means for outputting as a part that needs to be replaced together with information sent to the customer,
A replacement required part notification system comprising: Replacement part information input means for inputting information that can identify the replaced part,
An expiration date updating means for updating the expiration date stored in the expiration date information storage means in association with the identifiable information inputted from the replacement part information input means;
The replacement necessary part notification system according to claim 1, further comprising: The sales history storage means further stores information on the usage status of each sold product in the customer,
The replacement necessary part notification system according to claim 1, wherein the expiration date specifying unit corrects the specified expiration date based on information on the usage status. The replacement part information input means is capable of inputting information regarding the wear status of the replaced part, together with information capable of specifying the replaced part,
4. The replacement required part notification system according to claim 3, further comprising usage status update means for updating the usage status information based on the inputted wear status information. The component information storage means stores information on compatible components in addition to the useful life of each component,
The replacement part extraction unit extracts information on compatible parts stored in correspondence with information that can specify the extracted parts in the part information storage unit, together with information that can specify parts.
5. The replacement required part notification system according to claim 1, wherein the replacement required part information output unit outputs information on the extracted compatible part in addition to the replacement required part information. The sending information is an email address;
2. The replacement-required parts information output means outputs an e-mail including the replacement-required parts information by transmitting to an e-mail address of a customer who has purchased a product having the part. The replacement necessary part notification system according to any one of?

Images