Store transaction management device, store transaction management method, and store transaction management program
The store transaction management device addresses the challenge of managing traded-in products by integrating product information, serial numbers, and inventory data, resulting in improved receivable and inventory management, enhancing business efficiency.
Patent Information
- Application Number
- JP2022014823
- Authority / Receiving Office
- JP · JP
- Patent Type
- Patents
- Current Assignee / Owner
- Filing Date
- 2022-02-02
- Publication Date
- 2025-03-19
- Estimated Expiration
- 2042-02-02
AI Technical Summary
Existing store transaction management systems are unable to effectively manage inventory of traded-in products, leading to inefficient receivable and inventory management.
A store transaction management device equipped with a storage unit and a control unit that manages trade-in operations by linking product information, serial numbers, and inventory data, allowing for accurate tracking and updating of trade-in data and inventory levels.
Enables holistic control over store transactions, including trade-in second-hand items, allowing for accurate receivable management, inventory recording, and automatic offset, thereby improving business efficiency and decision-making.
Smart Images

Figure 0007649269000001 
Figure 0007649269000002 
Figure 0007649269000003
Abstract
Description
[Technical field]
[0001] The present invention relates to a store transaction management device, a store transaction management method, and a store transaction management program. [Background technology]
[0002] Patent Document 1 discloses a configuration in which, when a used product is traded in at the time of a product sale, the trade-in of the used product is treated as a purchase of a used product, and an invoice is created with the difference between the sales amount and the purchase amount as the net amount. [Prior art documents] [Patent documents]
[0003] [Patent Document 1] JP 2019-101874 A Summary of the Invention [Problem to be solved by the invention]
[0004] However, the invention described in the above Patent Document 1 has a problem in that the traded-in products cannot be managed as inventory.
[0005] The present invention has been made in consideration of the above problems, and aims to provide a store transaction management device, a store transaction management method, and a store transaction management program that enable seamless management, including account receivable management and inventory management, by managing operations when trading in used goods in a core system in line with customer service management at the store. [Means for solving the problem]
[0006] In order to solve the above-mentioned problems and achieve the object, the store transaction management device of the present invention is a store transaction management device including a memory unit and a control unit, the memory unit includes a serial master in which a serial record is set that is linked to a product, a serial number including a trade-in count, an original serial number which is the serial number of the product when it was new, and a used product flag indicating whether the product is a used product or not, and an inventory storage means for storing current stock data including product inventory data that is linked to a store, the product, the serial number, and the number of items in stock, and the control unit stores a current stock data including a product inventory data that is linked to a store, the product, the serial number, and the number of items in stock, and stores a current stock data including a product inventory data that is set by linking the ... The system is characterized in that, when a trade-in request is made for an item, the system comprises: a store sales acquisition means for acquiring store trade-in data set by linking together the transaction store of the trade-in item, the original serial number of the trade-in item, the trade-in quantity, and the trade-in amount; a serial number assignment means for assigning a trade-in serial number, which is the serial number of the trade-in item, based on the serial master and the store trade-in data; and an inventory update means for updating the current inventory data stored in the inventory storage means with the trade-in inventory data set by linking together the transaction store, the trade-in item, the trade-in serial number, and the trade-in inventory quantity.
[0007] In addition, in the store transaction management device of the present invention, the control unit is further characterized by having an inventory inquiry means for displaying the trade-in inventory data based on the current inventory data stored in the inventory storage means when a used goods inventory search request is input.
[0008] In addition, in the store transaction management device of the present invention, the inventory inquiry means is characterized in that when the used goods inventory search request is input on the inventory inquiry screen, it displays the inventory inquiry screen with the trade-in inventory data set based on the current stock data stored in the inventory storage means.
[0009] In addition, in the store transaction management device of the present invention, the trade-in serial number is characterized in that it includes an addition count obtained by adding 1 to the maximum value of the trade-in count included in the serial number of the serial record to which the same product as the trade-in product is set.
[0010] In addition, in the store transaction management device of the present invention, the serial numbering means further adds to the serial master a serial record in which the serial number set in the serial record in which the same product as the trade-in product is set is changed to the trade-in serial number, and the control unit further includes a purchase acquisition means for acquiring purchase data set in association with the transaction store, the trade-in serial number, purchase quantity, and purchase amount of the trade-in product based on the store trade-in data and the serial master.
[0011] In addition, in the store transaction management device of the present invention, the purchase acquisition means is characterized in that when sales confirmation for the store trade-in data is selected on the store sales confirmation screen, the purchase acquisition means acquires the purchase data that is set in association with the transaction store of the trade-in item, the trade-in serial number, and the purchase quantity based on the store trade-in data and the serial master.
[0012] In addition, in the store transaction management device of the present invention, the store sales acquisition means, when a trade-in request for the trade-in product is received at the time of selling the sold product, determines based on the serial master whether or not the serial record in which the same product as the trade-in product is set is set in the serial master, and if it determines that the serial record is set in the serial master, acquires the store trade-in data.
[0013] In addition, in the store transaction management device of the present invention, when a trade-in request for the trade-in product is received at the time of sale of the sold product, the store sales acquisition means determines, based on the serial master, whether the maximum value of the trade-in count included in the serial number of the serial record in which the same product as the trade-in product is set is the trade-in upper limit, and if it determines that the trade-in count is not the trade-in upper limit, acquires the store trade-in data.
[0014] In addition, in the store transaction management device of the present invention, the store sales acquisition means, when a trade-in request is made for the trade-in product at the time of selling the sales product, determines based on the current inventory data whether the inventory quantity of the product having the same serial number as the trade-in product and for which the maximum trade-in count is set is 0, and acquires the store trade-in data if it determines that the inventory quantity is 0.
[0015] In addition, in the store transaction management device of the present invention, the memory unit further includes a store master that is set in association with the store and the billing destination, and the control unit further includes a deposit acquisition means that acquires deposit data that sets the billing destination and the deposit amount which is the trade-in amount based on the store master and the store trade-in data, and a payment acquisition means that acquires payment data that sets a dummy payee as the payee, trade-in as the payment category, and a payment amount which is the purchase amount based on the purchase data.
[0016] In addition, in the store transaction management device of the present invention, the deposit acquisition means is characterized in that when deposit confirmation for the store trade-in data is selected on the store deposit confirmation screen, it acquires the deposit data, which sets the billing destination and the deposit amount, based on the store master and the store trade-in data.
[0017] In addition, in the store transaction management device of the present invention, the store sales acquisition means is further characterized by acquiring store sales data at the time of sale of the product, which is linked to the transaction store of the product, the serial number of the product, the sales quantity, and the sales amount.
[0018] Further, a store transaction management method according to the present invention is a store transaction management method to be executed by a store transaction management device having a memory unit and a control unit, the memory unit including: a serial master in which a serial record is set that is linked to a product, a serial number including a trade-in count, an original serial number which is the serial number of the product when it was new, and a used product flag indicating whether the product is a used product or not; and inventory storage means for storing current stock data including product inventory data that is linked to a store, the product, the serial number, and an inventory quantity; and the control unit is configured to execute a store transaction management method for a store transaction management device having a memory unit and a control unit, the memory unit including: a serial master in which a serial record is set that is linked to a product, a serial number including a trade-in count, an original serial number which is the serial number of the product when it was new, and a used product flag indicating whether it is a used product or not, and inventory storage means for storing current stock data including product inventory data that is set by linking a store, the product, the serial number, and an inventory quantity. When a trade-in request is received, the method includes a store sales acquisition step of acquiring store trade-in data that is set by linking together the store selling the trade-in item, the original serial number of the trade-in item, the trade-in quantity, and the trade-in amount, a serial number assignment step of assigning a trade-in serial number, which is the serial number of the trade-in item, based on the serial master and the store trade-in data, and an inventory update step of updating the current inventory data stored in the inventory storage means with the trade-in inventory data that is set by linking together the store selling the trade-in item, the trade-in serial number, and the trade-in inventory quantity.
[0019] Further, a store transaction management program according to the present invention is a store transaction management program to be executed by a store transaction management device having a memory unit and a control unit, the memory unit includes a serial master in which a serial record is set in which a serial number including a product, a trade-in count, an original serial number which is the serial number of the product when it was new, and a used product flag indicating whether the product is a used product are linked together, and an inventory storage means for storing current stock data including product inventory data in which a store, the product, the serial number, and an inventory quantity are linked together, and the control unit stores a serial master in which a serial record is set in which a store, the product, the serial number, and an inventory quantity are linked together, and When a trade-in request is received, the method executes the following steps: a store sales acquisition step for acquiring store trade-in data that is set by linking the transaction store of the trade-in item, the original serial number of the trade-in item, the trade-in quantity, and the trade-in amount; a serial number assignment step for assigning a trade-in serial number, which is the serial number of the trade-in item, based on the serial master and the store trade-in data; and an inventory update step for updating the current inventory data stored in the inventory storage means with trade-in inventory data that is set by linking the transaction store, the trade-in item, the trade-in serial number, and the trade-in inventory quantity. Effect of the Invention
[0020] According to the present invention, it is possible to manage store transactions including trade-ins of used goods. According to the present invention, it is possible to allocate a part of the sales amount as the trade-in amount when recording store sales. According to the present invention, it is possible to systematize when a retailer that handles luxury goods also handles sales of used goods. According to the present invention, it is possible to execute inventory recording and automatic offsetting including a series of flows of sales data and trade-in data and generation of a serial master. According to the present invention, it is possible to manage the serial master chronologically and the number of trade-ins. According to the present invention, it is possible to not only transfer but also update the attached data of the serial master. According to the present invention, it is possible to refer to purchase data in chronological order. [Brief description of the drawings]
[0021] [Figure 1] FIG. 1 is a block diagram showing an example of the configuration of a store transaction management device according to the present embodiment. [Diagram 2] FIG. 2 is a diagram illustrating an example of a serial master in this embodiment. [Diagram 3] FIG. 3 is a flowchart showing an example of the process of the store transaction management device in this embodiment. [Figure 4] FIG. 4 is a diagram showing an example of a store transaction management process in this embodiment. [Diagram 5] FIG. 5 is a diagram showing an example of a store transaction management process in this embodiment. [Figure 6] FIG. 6 is a diagram showing an example of a store transaction management process in this embodiment. [Figure 7] FIG. 7 is a diagram showing an example of a store sales deposit input screen in this embodiment. [Figure 8] FIG. 8 is a diagram showing an example of a store sales confirmation screen in this embodiment. [Figure 9] FIG. 9 is a diagram showing an example of the store payment confirmation screen in this embodiment. [Figure 10] FIG. 10 is a diagram showing an example of a stock inquiry screen in this embodiment. DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS
[0022] DETAILED DESCRIPTION OF THE PREFERRED EMBODIMENTS An embodiment of the present invention will be described in detail with reference to the drawings. However, the present invention is not limited to the embodiment.
[0023] [1. Overview] First, an overview of the present invention will be described.
[0024] Previously, handling of used goods was mainly done through paper management outside the core system, and many items could not be managed through the system. There was no connection of data including accounts receivable management, and trade-ins of used goods were also linked to inventory management tasks, making the process complicated.
[0025] Therefore, in this embodiment, a mechanism is provided that allows used goods to be managed as inventory items, and when a used item is traded in, the trade-in amount is included as part of the total amount received, thereby enabling accurate debt management.
[0026] [2. Configuration] An example of the configuration of the store transaction management device 100 according to this embodiment will be described with reference to Fig. 1 and Fig. 2. Fig. 1 is a block diagram showing an example of the configuration of the store transaction management device 100 according to this embodiment.
[0027] As shown in Fig. 1, the store transaction management device 100 is a commercially available desktop personal computer. The store transaction management device 100 is not limited to a stationary information processing device such as a desktop personal computer, but may be a portable information processing device such as a commercially available notebook personal computer, a PDA (Personal Digital Assistant), a smartphone, or a tablet personal computer.
[0028] The store transaction management device 100 includes a control unit 102, a communication interface unit 104, a memory unit 106, and an input / output interface unit 108. Each unit included in the store transaction management device 100 is connected to each other so as to be able to communicate with each other via any communication path.
[0029] The communication interface unit 104 communicably connects the store transaction management device 100 to the network 300 via a communication device such as a router and a wired or wireless communication line such as a dedicated line. The communication interface unit 104 has a function of communicating data with other devices via the communication line. Here, the network 300 has a function of connecting the store transaction management device 100 and the server 200 to each other so that they can communicate with each other, and is, for example, the Internet or a LAN (Local Area Network).
[0030] An input device 112 and an output device 114 are connected to the input / output interface unit 108. The output device 114 may be a monitor (including a touch panel), a speaker, or a printer. The input device 112 may be a keyboard, a mouse, a microphone, or a monitor that cooperates with a mouse to realize a pointing device function. In the following, the output device 114 may be referred to as the monitor 114 or the printer 114, and the input device 112 may be referred to as the keyboard 112 or the mouse 112.
[0031] The storage unit 106 stores various databases, tables, files, and the like. The storage unit 106 records computer programs for cooperating with an OS (Operating System) to give instructions to a CPU (Central Processing Unit) to perform various processes. For example, memory devices such as RAM (Random Access Memory) and ROM (Read Only Memory), fixed disk devices such as hard disks, flexible disks, and optical disks can be used as the storage unit 106. The storage unit 106 includes a serial master 106a, an inventory database 106b, a store master 106c, a billing destination master 106d, a product master 106e, and a transaction database 106f.
[0032] The serial master 106a is a master that sets a serial record in which the product, the serial number including the trade-in count, the original serial number which is the serial number of the product when it was new, and a used product flag indicating whether or not it is a used product are linked together. Here, the serial record may also set additional data (e.g., the product model, specifications, or functions, etc.). For example, the serial record may set a product code, serial number, used product flag, and additional data linked together.
[0033] An example of the serial master 106a in this embodiment will now be described with reference to Fig. 2. Fig. 2 is a diagram showing an example of the serial master 106a in this embodiment.
[0034] As shown in FIG. 2, in the serial master 106a of this embodiment, a serial record is set that is linked to a serial number including the number of times the trade-in item has been traded in (1 to 3 times), a used item flag (FLG) that is “1: used item”, and ancillary data that is carried over directly from the trade-in item with the number of times traded in subtracted by 1.
[0035] 1, the inventory database 106b stores inventory data of products. Here, the inventory database 106b may store current stock data including product inventory data that is set by associating a store, a product, a serial number, and an inventory quantity.
[0036] The store master 106c is a master in which the store and the billing destination are linked to each other. Here, the store master 106c may be set in which the store code, the store name, and the billing destination code are linked to each other.
[0037] The billing destination master 106d is a master in which billing destinations are set. Here, the billing destination master 106d may be set in association with a billing destination code and a billing destination name.
[0038] The product master 106e is a master that sets products. Here, the product master 106e may set product codes and product names in association with each other.
[0039] The transaction database 106f stores transaction data of products. Here, the transaction data may include store sales data, store sales header data, store sales detail data, sales header data, sales detail data, store trade-in data, store trade-in detail data, purchase data, purchase header data, purchase detail data, deposit data, deposit header data, deposit detail data, deposit reconciliation detail data, payment data, payment header data, payment detail data, and / or payment reconciliation detail data.
[0040] The control unit 102 is a CPU or the like that performs overall control of the store transaction management device 100. The control unit 102 has an internal memory for storing control programs such as an OS, programs that define various processing procedures, and required data, and executes various information processing based on these stored programs. In terms of functional concept, the control unit 102 includes a store sales acquisition unit 102a, a serial number allocation unit 102b, a purchase acquisition unit 102c, an inventory update unit 102d, a deposit acquisition unit 102e, a payment acquisition unit 102f, and an inventory inquiry unit 102g.
[0041] The store sales acquisition unit 102a acquires store trade-in data of the trade-in product. Here, when a trade-in request for the trade-in product is received at the time of the sale of the sales product, the store sales acquisition unit 102a may acquire store trade-in data that is set by linking the transaction store of the trade-in product, the original serial number of the trade-in product, the trade-in number, and the trade-in amount. The store sales acquisition unit 102a may also determine whether or not a serial record in which the same product as the trade-in product is set is set in the serial master 106a based on the serial master 106a, and acquire the store trade-in data when it is determined that the serial record is set in the serial master 106a. The store sales acquisition unit 102a may also determine whether or not the maximum value of the trade-in number included in the serial number of the serial record in which the same product as the trade-in product is set is the trade-in upper limit based on the serial master 106a, and acquire the store trade-in data when it is determined that the trade-in number is not the trade-in upper limit. Furthermore, the store sales acquisition unit 102a may determine whether the inventory quantity of an item having the same serial number as the trade-in item and for which the maximum number of trade-ins is set is 0 based on the current inventory data, and may acquire the store trade-in data if it is determined that the inventory quantity is 0. Furthermore, the store sales acquisition unit 102a may acquire store sales data set at the time of sale of the item in association with the transaction store of the item, the serial number of the item, the sales quantity, and the sales amount.
[0042] The serial numbering unit 102b assigns a trade-in serial number, which is the serial number of the trade-in product. Here, the serial numbering unit 102b may assign the trade-in serial number, which is the serial number of the trade-in product, based on the serial master 106a and the store trade-in data. Here, the trade-in serial number may include an added number obtained by adding 1 to the maximum number of trade-ins included in the serial number of the serial record in which the same product as the trade-in product is set. Furthermore, the serial numbering unit 102b may additionally set a serial record in which the serial number set in the serial record in which the same product as the trade-in product is set has been changed to the trade-in serial number, into the serial master 106a.
[0043] The purchase acquisition unit 102c acquires purchase data of the trade-in product. Here, the purchase acquisition unit 102c may acquire purchase data that is set by linking the transaction store of the trade-in product, the trade-in serial number, the purchase quantity, and the purchase amount based on the store trade-in data and the serial master 106a. In addition, when the sales confirmation for the store trade-in data is selected on the store sales confirmation screen, the purchase acquisition unit 102c may acquire purchase data that is set by linking the transaction store of the trade-in product, the trade-in serial number, and the purchase quantity based on the store trade-in data and the serial master 106a.
[0044] The inventory update unit 102d updates the current inventory data stored in the inventory database 106b. Here, the inventory update unit 102d may update the current inventory data stored in the inventory database 106b with trade-in inventory data that is set by linking the transaction store, the trade-in product, the trade-in serial number, and the trade-in inventory quantity.
[0045] The deposit acquisition unit 102e acquires deposit data in which a billing destination and a deposit amount, which is the trade-in amount, are set. Here, the deposit acquisition unit 102e may acquire deposit data in which a billing destination and a deposit amount, which is the trade-in amount, are set based on the store master 106c and the store trade-in data. In addition, when deposit confirmation for the store trade-in data is selected on the store deposit confirmation screen, the deposit acquisition unit 102e may acquire deposit data in which a billing destination and a deposit amount are set based on the store master 106c and the store trade-in data.
[0046] The payment acquisition unit 102f acquires payment data in which the payment amount, which is the purchase amount, is set. Here, the payment acquisition unit 102f may acquire payment data in which a dummy payment destination is set as the payment destination, trade-in is set as the payment category, and the payment amount, which is the purchase amount, is set based on the purchase data.
[0047] The inventory inquiry unit 102g displays the trade-in inventory data based on the current inventory data stored in the inventory database 106b. Here, when a used goods inventory search request is input, the inventory inquiry unit 102g may display the trade-in inventory data based on the current inventory data stored in the inventory database 106b. Also, when a used goods inventory search request is input on the inventory inquiry screen, the inventory inquiry unit 102g may display the inventory inquiry screen on which the trade-in inventory data is set based on the current inventory data stored in the inventory database 106b.
[0048] [3. Specific Examples] A specific example of this embodiment will be described with reference to FIGS.
[0049] [Store transaction management processing] An example of a store transaction management process in this embodiment will now be described with reference to Fig. 3. Fig. 3 is a flowchart showing an example of a process of the store transaction management device 100 in this embodiment.
[0050] As shown in FIG. 3, when a user inputs sales and trade-in information via the input device 112 at the time of sale of a product, the store sales acquisition unit 102a acquires store sales data that is linked to the transaction store of the product, the serial number of the product, the sales quantity, and the sales amount (step SA-1).
[0051] Then, the store sales acquisition unit 102a determines, based on the serial master 106a, whether or not a serial record in which the same product as the trade-in product is set exists (is set) in the serial master 106a (step SA-2).
[0052] If the store sales obtaining unit 102a determines that a serial record in which the same product as the trade-in product is set is not set in the serial master 106a (step SA-2: No), the store sales obtaining unit 102a ends the process.
[0053] On the other hand, if the store sales acquisition unit 102a determines that a serial record in which the same product as the trade-in product is set is set in the serial master 106a (step SA-2: Yes), it transitions the process to step SA-3.
[0054] Then, the store sales acquisition unit 102a determines, based on the serial master 106a, whether the maximum number of trade-ins included in the serial number of the serial record in which the same product as the trade-in product is set is the trade-in upper limit (step SA-3).
[0055] Then, if the store sales acquisition unit 102a determines that the maximum number of trade-ins included in the serial number of the serial record in which the same product as the trade-in product is set is the trade-in upper limit (step SA-3: Yes), it terminates the processing.
[0056] On the other hand, if the store sales acquisition unit 102a determines that the maximum number of trade-ins included in the serial number of the serial record in which the same product as the trade-in product is set is not the trade-in upper limit (step SA-3: No), it transitions the processing to step SA-4.
[0057] Then, based on the current inventory data stored in the inventory database 106b, the store sales acquisition unit 102a determines whether the inventory quantity of a product that is the same as the trade-in product and has a serial number for which the maximum number of trade-ins is set is 0 (step SA-4).
[0058] If the store sales obtaining unit 102a determines that the inventory quantity of the product is not 0 (step SA-4: No), the process ends.
[0059] On the other hand, if the store sales obtaining unit 102a determines that the inventory quantity of the product is 0 (step SA-4: Yes), the store sales obtaining unit 102a shifts the process to step SA-5.
[0060] Then, the store sales acquisition unit 102a acquires store trade-in data that is set by linking together the transaction store of the trade-in item, the original serial number of the trade-in item, the trade-in quantity, and the trade-in amount (step SA-5).
[0061] Then, based on the serial master 106a and the store trade-in data, the serial number assignment unit 102b assigns a trade-in serial number, which is the serial number of the trade-in item, that includes an additional number obtained by adding 1 to the maximum number of trade-ins included in the serial number of the serial record in which the same item as the trade-in item is set, and adds the serial record in which the serial number set in the serial record in which the same item as the trade-in item is set has been changed to the trade-in serial number to the serial master 106a (step SA-6).
[0062] Then, when the user selects sales confirmation for the store trade-in data on the store sales confirmation screen via the input device 112, the purchase acquisition unit 102c acquires purchase data that is linked to the transaction store, trade-in serial number, and purchase quantity of the trade-in item based on the store trade-in data and the serial master 106a (step SA-7).
[0063] Then, the inventory update unit 102d updates the current inventory data stored in the inventory database 106b with the trade-in inventory data that is set by linking the transaction store, the trade-in item, the trade-in serial number, and the trade-in inventory quantity (step SA-8).
[0064] Then, when the user selects to confirm the deposit for the store trade-in data on the store deposit confirmation screen via the input device 112, the deposit acquisition unit 102e acquires deposit data that sets the billing destination and deposit amount based on the store master 106c and the store trade-in data (step SA-9).
[0065] Then, the payment acquisition unit 102f acquires payment data based on the purchase data, in which a dummy payee is set as the payee, trade-in is set as the payment category, and the payment amount, which is the purchase amount, is set (step SA-10).
[0066] Then, when a user inputs a used goods inventory search request on the inventory inquiry screen via the input device 112, the inventory inquiry unit 102g causes the output device 114 to display an inventory inquiry screen on which trade-in inventory data has been set based on the current inventory data stored in the inventory database 106b (step SA-11), and ends the process.
[0067] Here, an example of store transaction management processing in this embodiment will be described with reference to Fig. 4 to Fig. 9. Fig. 4 to Fig. 6 are diagrams showing an example of store transaction management processing in this embodiment. Fig. 7 is a diagram showing an example of a store sales deposit input screen in this embodiment. Fig. 8 is a diagram showing an example of a store sales confirmation screen in this embodiment. Fig. 9 is a diagram showing an example of a store deposit confirmation screen in this embodiment.
[0068] As shown in Fig. 4, in the store sales deposit input process in this embodiment, when sales data and trade-in data are input based on customer service data at the store, when a product code and / or serial number are input on the trade-in details input screen shown in Fig. 7, a check is made to see if the serial master 106a exists, and if the product code and / or serial number cannot be obtained, an error is generated. That is, in this embodiment, the serial master 106a is checked (for example, "trade-in details input screen.product code=serial master 106a.product code" and / or "trade-in details input screen.serial number=serial master 106a.original serial number" is checked) to determine whether the product requested for trade-in is eligible for trade-in.
[0069] As shown in FIG. 4, in the store sales deposit input process in this embodiment, the maximum value X of “*X*” included in the serial number of the serial record set in the acquired serial master 106a is acquired, and it is determined whether it is equal to the trade-in upper limit (9). If it is equal to the upper limit, an error is generated (note that the number X in ** indicates the number of trade-ins).
[0070] Then, as shown in FIG. 4, in the store sales deposit input process in this embodiment, the maximum value X of “*X*” in the acquired serial master 106a is acquired, the inventory data is confirmed, and if inventory is present, an error is generated.
[0071] As shown in FIG. 4, in the store sales deposit input process in this embodiment, if the trade-in requested product is a trade-in target, X is not the trade-in upper limit, and no stock data exists, data is updated.
[0072] As shown in FIG. 5, in the store sales confirmation process in this embodiment, the business department (headquarters) confirms the input contents and confirms the store sales. That is, in this embodiment, the store sales header data with "Sales number = NULL: unconfirmed" is targeted, and details confirmed by the business department (details with a check mark on the store sales confirmation screen shown in FIG. 8) are updated, and confirmed sales data is created, and purchase data and inventory data are created from the trade-in details, and a serial record for the used item is also created at the same time. Here, in creating the serial record in this embodiment, a serial record is obtained from the serial number in the store trade-in detail data, and the maximum value of the numbers in "**" in the serial record is obtained.
[0073] Then, as shown in FIG. 6, in the store payment confirmation process in this embodiment, the accounting department performs a confirmation process for the trade-in payment data, and among the store trade-in detail data, those with "Sales confirmed FLG = 1" and "Payment confirmed FLG = 0" are targeted, and the details that have been confirmed by the accounting department (those with a check mark on the store payment confirmation screen shown in FIG. 9) are updated, and payment data is created for the trade-in amount, as well as payment data for the purchase data.
[0074] An example of a secondhand goods inventory inquiry process in this embodiment will be described with reference to Fig. 10. Fig. 10 is a diagram showing an example of an inventory inquiry screen in this embodiment.
[0075] As shown in FIG. 10, on the inventory inquiry screen in this embodiment, second-hand goods can be inquired in the same way as other inventory, or separately from other inventory.
[0076] [4. Contribution to the United Nations-led Sustainable Development Goals (SDGs)] This embodiment can contribute to improving business efficiency and promoting appropriate management decisions by companies, thereby contributing to goals 8 and 9 of the SDGs.
[0077] Furthermore, this embodiment can contribute to reducing waste and promoting paperless and electronic systems, thereby contributing to the achievement of SDGs Goals 12, 13, and 15.
[0078] Furthermore, this embodiment can contribute to strengthening control and governance, making it possible to contribute to Goal 16 of the SDGs.
[0079] 5. Other embodiments The present invention may be embodied in various different embodiments other than those described above within the scope of the technical concept set forth in the claims.
[0080] For example, among the processes described in the embodiments, all or part of the processes described as being performed automatically can be performed manually, or all or part of the processes described as being performed manually can be performed automatically using known methods.
[0081] In addition, the processing procedures, control procedures, specific names, information including parameters such as registered data and search conditions for each process, screen examples, and database configurations shown in this specification and drawings may be changed as desired unless otherwise specified.
[0082] Furthermore, with regard to the store transaction management device 100, the components shown in the figures are merely conceptual functional elements, and the device does not necessarily have to be physically configured as shown in the figures.
[0083] For example, the processing functions of the store transaction management device 100, particularly the processing functions performed by the control unit 102, may be realized in whole or in part by a CPU and a program interpreted and executed by the CPU, or may be realized as hardware using wired logic. The program is recorded in a non-transient computer-readable recording medium containing programmed instructions for causing the information processing device to execute the processes described in this embodiment, and is mechanically read by the store transaction management device 100 as necessary. That is, a computer program for giving instructions to the CPU in cooperation with the OS and performing various processes is recorded in a storage unit such as a ROM or HDD (Hard Disk Drive). This computer program is executed by being loaded into a RAM, and cooperates with the CPU to form a control unit.
[0084] In addition, this computer program may be stored in an application program server connected to the store transaction management apparatus 100 via any network, and it is also possible to download all or part of it as needed.
[0085] In addition, the program for executing the process described in this embodiment may be stored in a non-transient computer-readable recording medium, or may be configured as a program product. Here, the "recording medium" includes any "portable physical medium" such as a memory card, a Universal Serial Bus (USB) memory, a Secure Digital (SD) card, a flexible disk, a magneto-optical disk, a ROM, an Erasable Programmable Read Only Memory (EPROM), an Electrically Erasable and Programmable Read Only Memory (EEPROM (registered trademark)), a Compact Disk Read Only Memory (CD-ROM), a Magneto-Optical disk (MO), a Digital Versatile Disk (DVD), and a Blu-ray (registered trademark) Disc.
[0086] Moreover, a "program" is a data processing method written in any language or description method, and may be in any form, such as source code or binary code. Note that a "program" is not necessarily limited to a single configuration, but also includes a configuration that is distributed as a plurality of modules or libraries, and a program that achieves its function by cooperating with a separate program, such as an OS. Note that the specific configuration and reading procedure for reading a recording medium in each device shown in this embodiment, as well as the installation procedure after reading, may use well-known configurations and procedures.
[0087] The various databases etc. stored in the memory unit 106 are storage means such as memory devices such as RAM and ROM, fixed disk devices such as hard disks, flexible disks, and optical disks, and store various programs, tables, databases, and web page files etc. used for various processes and providing websites.
[0088] The store transaction management device 100 may be configured as an information processing device such as a known personal computer or a workstation, or may be configured as the information processing device to which any peripheral device is connected. The store transaction management device 100 may be realized by implementing software (including programs or data, etc.) that causes the device to realize the processing described in this embodiment.
[0089] Furthermore, the specific form of distribution and integration of the devices is not limited to that shown in the drawings, and all or part of them can be functionally or physically distributed and integrated in any unit according to various additions or functional loads. In other words, the above-mentioned embodiments can be implemented in any combination, or the embodiments can be implemented selectively. [Industrial Applicability]
[0090] The present invention is useful in any industry that involves trade-ins at the time of sale, including the luxury retail industry, such as the jewelry industry or watch industry. [Explanation of symbols]
[0091] 100 Store transaction management device 102 Control section 102a Store Sales Acquisition Department 102b Serial numbering section 102c Purchasing Department 102d Inventory Update Department 102e Deposit Collection Department 102f Payment Acquisition Department 102g Stock Inquiry Section 104 Communication interface section 106 Storage section 106a Serial Master 106b inventory database 106c Store Master 106d Billing Master 106e Product Master 106f Trade Database 108 Input / Output Interface Section 112 Input Devices 114 Output Device 200 Servers 300 Network
Claims
1. A store transaction management device including a memory unit and a control unit, The storage unit is a serial master in which a serial record is set in which a product, a serial number including the number of trade-ins, an original serial number which is the serial number of the product when it was new, and a used product flag which indicates whether the product is a used product are linked to each other; an inventory storage means for storing current inventory data including product inventory data that is set by linking a store, the product, the serial number, and the number of items in stock; Equipped with The control unit is a store sales acquisition means for acquiring store trade-in data that is set by linking together a store that trades in the trade-in product, the original serial number of the trade-in product, the number of trade-ins, and the trade-in amount when a trade-in request is made at the time of the sale of the product; a serial number assigning means for assigning a trade-in serial number, which is the serial number of the trade-in product, based on the serial master and the store trade-in data; an inventory update means for updating the current inventory data stored in the inventory storage means with trade-in inventory data that is set by linking the transaction store, the trade-in product, the trade-in serial number, and the trade-in inventory quantity; A store transaction management device comprising:
2. The control unit is an inventory inquiry means for displaying the trade-in inventory data based on the current inventory data stored in the inventory storage means when a used goods inventory search request is input; 2. The store transaction management device according to claim 1, further comprising:
3. The inventory inquiry means is The store transaction management device according to claim 2, characterized in that when the used goods inventory search request is input on the inventory inquiry screen, the inventory inquiry screen is displayed with the trade-in inventory data set based on the current inventory data stored in the inventory storage means.
4. The trade-in serial number is A store transaction management device as described in any one of claims 1 to 3, characterized in that it includes an additional number added by 1 to the maximum value of the trade-in number included in the serial number of the serial record in which the same product as the trade-in product is set.
5. The serial number assignment means is Furthermore, a serial record in which the serial number set in the serial record in which the same product as the trade-in product is set is changed to the trade-in serial number is added to the serial master; The control unit is a purchase acquisition means for acquiring purchase data that is set by linking the transaction store of the trade-in product, the trade-in serial number, the purchase quantity, and the purchase price of the trade-in product based on the store trade-in data and the serial master; 5. The store transaction management device according to claim 1, further comprising:
6. The purchase acquisition means includes: The store transaction management device described in claim 5, characterized in that when sales confirmation for the store trade-in data is selected on the store sales confirmation screen, the purchase data is obtained based on the store trade-in data and the serial master, and is set in association with the transaction store, the trade-in serial number, and the purchase quantity of the trade-in item.
7. The store sales acquisition means includes: A store transaction management device as described in any one of claims 1 to 6, characterized in that when a trade-in request is made for the trade-in product at the time of the sale of the product, it is determined based on the serial master whether the serial record in which the product identical to the trade-in product is set is set in the serial master, and if it is determined that the serial record is set in the serial master, the store trade-in data is obtained.
8. The store sales acquisition means includes: A store transaction management device as described in any one of claims 1 to 3, characterized in that when a trade-in request is made for the trade-in product at the time of selling the product, the device determines based on the serial master whether the maximum value of the trade-in count included in the serial number of the serial record in which the same product as the trade-in product is set is the trade-in upper limit, and if it determines that the trade-in count is not the trade-in upper limit, it acquires the store trade-in data.
9. The store sales acquisition means includes: A store transaction management device as described in any one of claims 1 to 3, characterized in that when a trade-in request is made for the trade-in product at the time of the sale of the product, a determination is made based on the current inventory data as to whether the inventory quantity of the product having the same serial number as the trade-in product and for which the maximum trade-in count is set is 0, and if it is determined that the inventory quantity is 0, the store trade-in data is obtained.
10. The storage unit is A store master that links the store and the billing destination, Further comprising: The control unit is a deposit acquisition means for acquiring deposit data in which the billing destination and the deposit amount, which is the trade-in amount, are set based on the store master and the store trade-in data; a payment acquisition means for acquiring payment data in which a dummy payment destination is set as a payment destination, a trade-in is set as a payment category, and a payment amount that is the purchase amount is set based on the purchase data; 7. The store transaction management device according to claim 5, further comprising:
11. The deposit acquisition means includes: A store transaction management device as described in claim 10, characterized in that when confirmation of payment for the store trade-in data is selected on the store payment confirmation screen, the payment data, which sets the billing destination and the deposit amount, is obtained based on the store master and the store trade-in data.
12. The store sales acquisition means includes: A store transaction management device as described in any one of claims 1 to 11, further characterized in that at the time of sale of the product, store sales data is acquired that is linked to the transaction store of the product, the serial number of the product, the sales quantity, and the sales amount.
13. A store transaction management method to be executed by a store transaction management device having a memory unit and a control unit, The storage unit is a serial master in which a serial record is set in which a product, a serial number including the number of trade-ins, an original serial number which is the serial number of the product when it was new, and a used product flag which indicates whether the product is a used product are linked to each other; an inventory storage means for storing current inventory data including product inventory data that is set by linking a store, the product, the serial number, and the number of items in stock; Equipped with The control unit executes a store sales acquisition step of acquiring store trade-in data that is set by linking together a store that handles the trade-in product, the original serial number of the trade-in product, the number of trade-ins, and the trade-in amount when a trade-in request is made at the time of the sale of the product; a serial number assignment step of assigning a trade-in serial number, which is the serial number of the trade-in product, based on the serial master and the store trade-in data; an inventory update step of updating the current inventory data stored in the inventory storage means with trade-in inventory data that is set by linking the transaction store, the trade-in product, the trade-in serial number, and the trade-in inventory quantity; A method for managing store transactions, comprising:
14. A store transaction management program to be executed by a store transaction management device having a memory unit and a control unit, The storage unit is a serial master in which a serial record is set in which a product, a serial number including the number of trade-ins, an original serial number which is the serial number of the product when it was new, and a used product flag which indicates whether the product is a used product are linked to each other; an inventory storage means for storing current inventory data including product inventory data that is set by linking a store, the product, the serial number, and the number of items in stock; Equipped with In the control unit, a store sales acquisition step of acquiring store trade-in data that is set by linking together a store that handles the trade-in product, the original serial number of the trade-in product, the number of trade-ins, and the trade-in amount when a trade-in request is made at the time of the sale of the product; a serial number assignment step of assigning a trade-in serial number, which is the serial number of the trade-in product, based on the serial master and the store trade-in data; an inventory update step of updating the current inventory data stored in the inventory storage means with trade-in inventory data that is set by linking the transaction store, the trade-in product, the trade-in serial number, and the trade-in inventory quantity; A store transaction management program for executing the above.
Citation Information
Patent Citations
Commodity circulation system, and method for providing information to customer in the system
JP2001312658A
Used article dealing processing system
JP2002032449A
Commodity management system
JP2006330905A
Data creation device, data creation method, and data creation program
JP2019101874A
Reuse merchandise distribution managing system and reuse merchandise distribution managing method
JP2019144795A