WO2011113090A1 - Product ticketing system - Google Patents

Product ticketing system Download PDF

Info

Publication number
WO2011113090A1
WO2011113090A1 PCT/AU2011/000285 AU2011000285W WO2011113090A1 WO 2011113090 A1 WO2011113090 A1 WO 2011113090A1 AU 2011000285 W AU2011000285 W AU 2011000285W WO 2011113090 A1 WO2011113090 A1 WO 2011113090A1
Authority
WO
WIPO (PCT)
Prior art keywords
product
data
print
processing unit
unique identification
Prior art date
Application number
PCT/AU2011/000285
Other languages
French (fr)
Inventor
John Peter Despott
Michael John Ursino
Original Assignee
Iconiq Pty Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Priority claimed from AU2010901080A external-priority patent/AU2010901080A0/en
Application filed by Iconiq Pty Ltd filed Critical Iconiq Pty Ltd
Publication of WO2011113090A1 publication Critical patent/WO2011113090A1/en

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K7/00Methods or arrangements for sensing record carriers, e.g. for reading patterns
    • G06K7/10Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation
    • G06K7/10009Methods or arrangements for sensing record carriers, e.g. for reading patterns by electromagnetic radiation, e.g. optical sensing; by corpuscular radiation sensing by radiation using wavelengths larger than 0.1 mm, e.g. radio-waves or microwaves
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K1/00Methods or arrangements for marking the record carrier in digital fashion
    • G06K1/12Methods or arrangements for marking the record carrier in digital fashion otherwise than by punching
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06KGRAPHICAL DATA READING; PRESENTATION OF DATA; RECORD CARRIERS; HANDLING RECORD CARRIERS
    • G06K17/00Methods or arrangements for effecting co-operative working between equipments covered by two or more of main groups G06K1/00 - G06K15/00, e.g. automatic card files incorporating conveying and reading operations
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q10/00Administration; Management
    • G06Q10/08Logistics, e.g. warehousing, loading or distribution; Inventory or stock management
    • G06Q10/087Inventory or stock management, e.g. order filling, procurement or balancing against orders
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06QINFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
    • G06Q30/00Commerce
    • G06Q30/06Buying, selling or leasing transactions

Definitions

  • This invention relates to product ticketing which can be used In a warehouse or in a retail outlet.
  • the present invention relates to a method, system and apparatus to improve the efficiency of product ticketing .
  • Product ticketing can be used for a range of purposes including to identify stock items on shelving in warehouses and retail outlets, and to provide an indication of stock levels as at a certain time or to provide a price tag. The information produced on such product ticketing depends on the location. Product identification and pricing is likely to be used on ticketing in a retail outlet such as a supermarket, a department store, or a large hardware store. Product Identification and stock count could be used on ticketing in a retail outlet or a warehouse during stock level audit (stocktaking) or other routine warehouse activities.
  • a staff member determines a discounted price, inputs the discounted price into printer unit and prints the discounted price on a label, and dispenses the label and applies it to the individual item, usually in juxtaposition with the normal price so the consumer can see the level of discount and factor this in when making a decision to purchase.
  • These units usually print a small label that is no larger than A7. These unite typically print no more informatipn than the price that is input by the staff member. To confirm the correct discount has been applied management need to physically Inspect the shelf.
  • POS Point-of-sale
  • BOS Back-Office System
  • the group head office has Very little, If any, visibility of what ticketing activity has actually taken place In the store or warehouse. This visibility is typically achieved by having someone from outside the store or warehouse visit the location and perform an audit. This function is typically performed by Individuals responsible for multiple sites (Area or Regional Managers). Regardless, in many retail environments it is important for users at a store level to have some degree of control over data such as pricing (to be able to compete locally) which must be balanced with the need to comply with operating requirements or internal guidelines as well as other (external) legislation.
  • a portable product ticketing apparatus including a data processing unit interfaced with a product data input to receive unique identification data identifying a product, the data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique Identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in said table of products, said data processing unit being interfaced with at least one printer, and being operable to send data to said printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data In said table of products correlating to unique identification data in said table of products.
  • the product data Input Is Interfaced with a bar code scanner, RFID tag reader or other such scanner and the unique identification data identifying a product received by the product data input is derived from a bar code or RFID tag attached to or located in physical proximity to the product.
  • the bar code or RFID tag may be applied to the product, or more likely printed on a label or ticket which is affixed to a facing edge of shelving, usually located below where the product item is stored.
  • the barcodes attached to the product may vary from those attached to the shelf or facing edge as the retail outlet or warehouse may encode additional or different information into the barcodes for operational purposes. For example the codes used may be specific to the business using them and are not used globally.
  • a portable product ticketing apparatus including a data processing unit interfaced with a barcode scanner or RFID tag reader to receive unique identification data identifying a product, the unique identification data identifying the product being derived from a bar code or RFID tag attached to or located In physical proximity to the product, the data processing unit having access to or being Interfaced with a memory containing a table of products and correlating unique identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in the table of products, the data processing unit being interfaced with at least one printer, and being operable to send data to the printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data In the table of products correlating to unique Identification data in the table of products.
  • table of products In effect refers to a look-up table, which may be as simple as a table containing bar code ' or other unique Identification data correlating to a product catalogue number. This may require recourse to a further table contained In or accessible by the data processing unit, for interrogation for the gathering of further data as necessary to gather all of the data required in order to print a ticket. There may be many levels of data, which are in effect contained within stock control and accounting systems computers used In the site in which the invention is to be employed.
  • the table of products includes for each product, data correlating to the product description, data correlating to the unique identification data which will be data correlating to the product bar code or RFID identifier, and may Include one of a number of other pieces of Information such as product Identifying stock number, and pricing data, Including any special prices to be offered.
  • the other information printed will usually be pricing information which can be selected from one or more of a normal price, a special price, or any other pricing offer pertaining to the product or additional Information pertaining to the product such as specifications, marketing information or other information used by the retailer or warehouse for operational purposes. Additional Information may not be pricing related and is limited only by the data accessible to the invention when in operation. This additional information may include operational attributes (order quantities, warehouse locations, and promotion end date for example) or customer-facing attributes (product features, descriptions, .colour options for example).
  • the table of products Includes a link to further data that can be accessed by the data processing unit, whether for printing or other reasons, which may or may not be stored on the apparatus but is accessible by the apparatus.
  • the data processing unit may be capable of performing additional calculations and applying predefined logic, this may require other data to be merged with data in the table of products.
  • the data processing unit is operable to receive a plurality of received unique identification data Identifying a plurality of products, before queuing data to the one or more printers to print one or more tickets on a single sheet
  • the printers could print to, including perforated sheet so that the operator could separate the tickets and apply them to the appropriate position.
  • the unique identification data is scanned from barcodes, (or other means such ' as a microchip based tag), the operator will be In proximity to the product location when the tickets are printed.
  • the tickets are A8 in size, there can be sixteen printed on a single A4 sheet, making it a relatively simple task to locate the correct product location for each ticket Alternatively, there can be four A6 tickets or two AS tickets printed on a single A4 sheet, to show specials or promotions on sale at a retail store.
  • layout and paper stock include continuous fan-fold or continuous roll- fed paper stocks either of predefined size or variable size where the printer features an automatic cutting mechanism to cut the ticket to the desired size.
  • the data processing unit is interfaced to a display, and when received unique identification data is successfully correlated with unique identification data from the table, data pertaining to the product is retrieved from the table and displayed on the display. This allows for operator verification, if this is required.
  • the data processing unit is interfaced with a print-stock selection input, which allows selection of print-stock for the printing of tickets.
  • the print- stock can be selected from any desired sheet size but convenient sizes are a quarto/!etter In the USA or A4 sheet in other countries.
  • Ticket size can be any portion of a sheet size, and the print-stock may be perforated to allow the printed tickets to be easily separated.
  • the data processing unit can arrange the tickets as required for the selected print-stock.
  • the print-stock selection for a product is included among data in the table, or can be derived from data in the table by performing logical operations and the data processing unit queues selected tickets by print-stock type, for printing together on the correct print-stock.
  • the print-stock selection input is operator initiated, and preferably no more than a three step process, although ideally it would be a single or two step process.
  • the print-stock selection input Is received from a bar code scanner selecting from one of a plurality of print-stock bar codes each correlating to an available print-stock type, the plurality of barcodes being printed and displayed on the portable product ticketing apparatus and being accessible by the bar code scanner.
  • the same bar code scanner as used for scanning the product bar code can be used to scan the bar code for the required print-stock type.
  • the print-stock selection Input is received from one of a plurality of user operable switches each correlating to an available print-stock type. These switches may be via the touch-screen, keyboard, mouse or other means deemed appropriate for the application.
  • the display can be a touch screen, and the print- stock selection input is received from one of a plurality of user selectable print- stock types.
  • the data processing unit receives and correlates print- stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period Is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit prompts the operator by the display to load (if necessary) the required print-stock so the tickets can be printed.
  • the apparatus includes a plurality of printers loaded with different print-stocks, and the data processing unit receives and correlates print stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence Is complete, and then the data processing unit causes the appropriate printer to print the tickets or prompts the operator by the display to load the required print-stock in the appropriate printer so the tickets can be printed.
  • the order of operation processed by the data processing unit is input unique identification data Identifying a product, whereupon product information is displayed on the display, and then input the required print stock.
  • the order of operation Is input the required print stock, in the absence of using a default print-stock or to override a default print-stock, and then input unique identification data Identifying products, one after the other until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit causes the appropriate printer to print the tickets.
  • the order of operation is' input the required print stock, in the absence of using a default print-stock, and then input unique identification data Identifying products, one after the other until a sheet of any print stock type Is filled, or a predetermined time period is exceeded, or the user manually Indicates that the queuing sequence is complete, and then the data processing unit prompts the operator by the display to load the required print-stock in the appropriate printer so the tickets can be printed.
  • the order of operation Is input the required print stock, In the absence of using a default print-stock, and then input, unique identification data identifying products, one after the other until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit causes the appropriate printer to print the tickets or prompts the operator by the display to load the required print-stock In the appropriate printer so the tickets can be printed.
  • the predetermined time period can be configured according to the unique requirements of the user in pre-defined increments if desired.
  • the predetermined time period can be disabled by setting the predetermined time to zero. A zero value is interpreted by the software as disabling a counter that runs for the predetermined time period.
  • the data processing unit is interfaced with a keyboard or other suitable input device such as for example a touch screen, for user Input of data pertaining to a product.
  • a keyboard or other suitable input device such as for example a touch screen
  • other Information relating to the product can be recorded, such as available units of product in stock, as would be recorded in a stock take/ stock audit
  • the ticket produced can Include data relating to stock levels at the time the ticket was made.
  • the user input of data pertaining to a product is recorded In the table or transmitted back to be recorded in the table, where the memory is not co-located with the data processing unit.
  • the portable product ticketing apparatus Is In the form of a trolley-like apparatus having wheels or castors, at least one mounting surface to support the at least one printer, a supply of print-stock, and a power supply.
  • the power supply may be a bank of batteries (such as lithium ion batteries or sealed lead acid batteries) supplying power either directly or via an Inverter providing local AC voltage (eg, 240 VAC 220 VAC, 110 VAC) to the at least one printer, the bar code scanner or RFID tag reader, wireless data transceiver, and the data processing unit and any other peripherals required to fulfil the operational requirements of the apparatus,
  • the data processing unit may be a mobile computing device, such as a laptop computer, tablet or low-power embedded PC.
  • the memory may be memory on board the computing device, or in a file server or other computer located in a back office or remote site and accessible remotely via wireless network technology.
  • Each mounting surface may be in the form of a shelf, on which printers, consumables and the power supply sit.
  • the trolley has castors fitted with braking devices so as to be readily moveable into position alongside shelving where product is located, and readily restrained in a desired location for the duration of data input and ticket printing.
  • the portable ticket printing apparatus is provided with three shelves.
  • a method of preparing tickets for product Items stocked in a warehouse or retail store including providing and operating a portable product ticketing apparatus as described above.
  • a method of preparing tickets for product Items stocked in a warehouse or retail store Including providing a portable product ticketing; apparatus including a data processing unit interfaced with a product data input to receive unique Identification data Identifying a product, the data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in the table of products, the data processing unit being interfaced with at least one printer, and being operable to send data to the printer to print a ticket of predetermined format containing a product description and other Information pertaining to the product derived from data in said fable of products correlating to unique identification data
  • the table of products inputting unique identification data Identifying a product via product data input, comparing the input unique identification data with unique identification data in the table of products, retrieving data from said table ' of products and sending to the printers) to print the
  • the product data input is interfaced with a bar code scanner and the unique identification data identifying a product received by the product data input is derived from a bar code attached to or located in physical proximity to the product.
  • the table of products includes' for each product, in addition to data correlating to the product description and Its correlating unique Identification data, a flag as to whether a ticket is to be printed for the product, wherein the data processing unit is operable to send data to the printer to print the ticket only If the flag Indicates a ticket is to be printed.
  • the data processing unit is operable to receive a plurality of received unique Identification data Identifying a plurality of products, before queuing data to the at least one printer to print a plurality of tickets on a single sheet.
  • the sheet would usually be perforated so that the operator could separate the tickets and apply them to the appropriate position.
  • layout and paper stock include continuous fan-fold or continuous roll-fed paper stocks either of pre-defined size or variable with a print device featuring an automatic cut mechanism.
  • the data processing unit is Interfaced with a print-stock selection Input/ which allows selection of print-stock for the printing of tickets.
  • the operator can select the desired print- stock, before sending data to print a ticket.
  • the apparatus will also include at least one camera to capture still and/or video images of the tickets placed on the product and/or shelf.
  • the camera can be operated either manually by the operator or configured to automatically capture images. These images can be communicated to a remote server and allow for a reduction In the number of physical inspections required by managers.
  • the system is also able to transmit information back to a remote server.
  • This information can include details of the new ticket; time of printing, captured Images, and any other relevant data required by management of the store.
  • Figure 1 is a front facing elevation of the apparatus without peripherals.
  • Figure 2 is a front facing elevation of the apparatus with the peripheral drawer open.
  • Figure 3 is a rear facing elevation of the apparatus with the door open and without peripherals.
  • Figure 4 Is a rear facing elevation of the apparatus with the door open and peripherals fitted.
  • Figure 5 is a front facing view of the apparatus showing detail of the internal electronics under a lockable lower shelf.
  • Figure 6 exemplifies the electronic components in one embodiment of the present Invention.
  • Figure 7 exemplifies the electronic components in an alternative embodiment of the present invention.
  • Figure 6 exemplifies the user process in a preferred arrangement of the present invention.
  • Figure 9 exemplifies the logical process of a preferred embodiment of the present invention.
  • Figure 10 exemplifies one method of selecting ticket sizes to print.
  • Figure 11 exemplifies a sample print file.
  • Figure 13 shows a sample customer product inventory table.
  • the embodiment illustrated In the figures is a portable product ticketing apparatus and system.
  • This embodiment includes a mobile apparatus supported on four castors 12, which pivot about vertical axes.
  • the wheels of the castors 12 are lockable to prevent the apparatus running away if used on a sloping surface.
  • the locking mechanism can be operated by foot operated locks on the castors 12.
  • An alternative embodiment may have the locking mechanisms operated by a lever fitted to the handle 6.
  • castors may also be Included.
  • the important aspect Is that the apparatus is able to move with relative freedom about the retail outlet.
  • the apparatus could be possible for the apparatus to be powered by a motorised wheel system, similar to those used on motorised golf carts.
  • This alternative may be particularly advantageous when the apparatus exceeds 150 kg and/or the surface on which the apparatus is to operate has high friction such as carpet.
  • the preferred arrangement has three shelves 10, 13, and 19.
  • Materials chosen for the apparatus should be robust and light to facilitate easy transport from one location to another by young adults and adults of working age who are likely to work in the environments of the intended application.
  • the batteries 27 should be selected to provide sufficient power to operate the electronic devices for the minimum period designed for the particular application.
  • the selection of the battery should take into account the expected power requirements of the electronic " equipment on the apparatus between recharges. That is, If it Is expected that the apparatus would be in use for a period of 8 hours between recharges then the batteries should be of sufficient capacity to provide the necessary power to each element of the apparatus for this period. Further, so as to prolong the battery life, It would be preferred not to fully drain the batteries. Accordingly, in the preferred embodiments, the capacity of the batteries would be double the projected requiremerits;
  • the apparatus would use sealed lead acid (SLA) batteries as such batteries can provide a less complex battery protection circuitry and safety issues compared with other batteries.
  • SLA sealed lead acid
  • An alternative could be Li-ion batteries or alternately some form of fuel cell.
  • the preferred embodiment has a battery pack 27 and electronics located on the lower shelf 19.
  • the battery pack 27 consists of a 12V or 24V battery pack which may be single battery or a plurality of batteries connected in parallel or series to provide enough capacity for the requirements. In the instance where both 24V and 12V DC power is required on the device, this would ideally be achieved through the use of a DC-DC converter to step-down 24V to12V, enabling a single charging/monitoring system to be used. Capacity ranges are expected to be in the range of 40Ah to 120Ab depending on expected usage, both volume of printing and duration of portability required, and the type and quantity of printers to be located on the apparatus.
  • the battery pack 27 is housed in a compartment under the lower lockable shelf 19, enabling individual cells or the entire battery pack to be swapped out for maintenance. Capacity is provided within the housing for the cells required to achieve the desired capacity range discussed above.
  • the electronics on the apparatus includes an inverter 29 which Is connected to the battery pack 27 and converts the 12V or 24V DC from the battery pack 27 to AC current suitable for use by the connected equipment (eg 240 VAC, 220 VAC, 110 VAC). Should suitable DC-powered devices be available an alternative embodiment would not require the use of an inverter.
  • the inverter 29 has sufficient capacity, rated for continuous use, to handle the power requirements of the connected equipment.
  • the electronics includes a charging system 28 for charging the battery pack 27, in between use of the apparatus. The charging system 28 enables the apparatus to be plugged into a standard AC power outlet to charge the battery pack 27.
  • the charging system 28 contains the necessary electronics to ensure that ⁇ the batteries are charged safely and efficiently with automatic cut-out to ensure thatthe battery pack 27 Is not overcharged.
  • Such necessary electronics would be similar to those found in a commercially available battery charger suitable for the selected battery technology.
  • Such battery chargers would contain elements which measure temperature, time current has been applied and voltage, coupled with electronics which intelligently vary the current applied to the battery pack.
  • the electronics in such chargers are pre-programmed to prolong the life of the battery and avoid dangerous conditions-such as excessive heat in the battery pack.
  • the electronics Includes a power, monitoring system 7 to monitor the battery pack 27 and preferably is able to display the remaining capacity of the battery pack to the user.
  • the power monitoring system 7 can be connected to a audible device and/or other visual Indicating devices to provide audible and/or visual warning of any fault state such as low charge or low voltage.
  • the electronics are Ideally contained In lockable compartment under the lower shelf 19 to protect them from dust and other elements and to also ensure that there is no risk of electrocution by operators accidentally making contact with the electronics in a manner that may cause damage or physical injury.
  • This lockable component also provides additional security for the electronics from malicious activities.
  • the apparatus may be fitted with a Residual Current Device (RCD) to further reduce the risk of Injury to the operator or other person.
  • RCD Residual Current Device
  • the top shelf 10 supports a touch-screen display device 1, storage compartments 4 and 5 and a barcode scanner or RFID reader 2 mounted on an appropriate cradle 3.
  • the middle shelf 13 and lower shelf 19 supports a printer 14 or multiple printers handling consumables appropriate for the use of the apparatus and according to user requirements.
  • the printers 14 are supplied power by the electronics on the apparatus and are connected to the power outlet 24
  • the embodiment shown has a data processing unit in the form of a low power computing device 26.
  • a laptop computer, tablet or other form factor device may be used.
  • the hand held bar code scanner or RFID reader 2 communicates with its cradle 3 wlrelessly, using suitable wireless technology and protocols.
  • An alternative embodiment may utilise a scanner physically connected to the apparatus via a cable. This arrangement would be less convenient In terms of use but would not have concerns wtth the need to recharge the scanner 2.
  • the cradle 3 for the scanner 2 can be connected to the computing devfce 26 via a universal serial bus or other suitable protocol, for example wireless.
  • the printers 14 can all be connected to the computing device 26 by universal serial bus or other suitable protocol, for example wireless.
  • the computing device 26 may also be connected to a USB hub which may, in turn, be connected to the power supply 24 via a power adapter.
  • the USB hub may also be used for connecting any of the other peripherals on the apparatus.
  • the computing device 26 communicates wirelessly to a computer 43 In a back office or server room, for product stock data contained in a table containing product information (name) and unique bar code identification data for each product.
  • the table containing product information (name) and unique bar code identification data for each product may be downloaded to the computing device 26 on the apparatus periodically, avoiding the need for regular wireless communication with the file server in a back office or server room.
  • Wireless capability may be extended through the use of an antenna connected to the low power computing device 26.
  • This alternative arrangement may be desirable in a large warehouse or retail outlet, where reliable wireless communication is not available without such external antenna.
  • the hand held bar code scanner 2 and printers 14 communicate wirelessly to a computer 43 located in the back office or server room.
  • This computer 43 also communicates over a network with a file server in a back office or server room, for product stock data contained in a table containing product Information (name) and unique bar code identification data for each product.
  • the computer 43 in the back office transmits print jobs wirelessly to the printers 14.
  • the apparatus computing device 26 runs on a suitable operating system such as Microsoft Windows, and Incorporates functionality described In this patent specification.
  • the computing device 26 may conveniently have a touch screen display 1, which will facilitate operation of the system, although an alternative Input device such as a keyboard, mouse, or keyboard and mouse combination may be provided.
  • an alternative Input device such as a keyboard, mouse, or keyboard and mouse combination may be provided.
  • Operation of the system Involves using the hand held bar code scanner or RFID tag reader 2 to scan the bar code or RFID tag of a product located on a shelf, or to be placed on a shelf.
  • This bar code to be scanned is located on the product Itself or on a label typically on the front of a shelf or bin on or in which the product is stored or displayed.
  • RFID tags are used in preference to barcodes, the tags will typically be located on the product itself.
  • the apparatus ideally includes a representation of each ticket size for available ticket print-stock loaded into the printers, and alongside each, a bar code or other scannable representation as exemplified in figure 10.
  • the data processing unit compares the product bar code that has been scanned with unique Identification bar code data contained in the customer product Inventory table and if present, gathers product description, pricing, and other data from the look-up table and assembles it using a template for printing on the ticket
  • the data is assembled Into the template- Selected by the operator, or the default template, if no other template is selected within a timeout period.
  • the templates are filled for a print job (ie where print stock is A4 and there are four tickets per A4 sheet, and all tickets on the sheet have been populated), or once a time out period expires, or if the user manually indicates that the queuing sequence Is complete, the print Job Is produced using the software installed on the apparatus and sent to the appropriate printer 14 containing the required print- stock.
  • the software on the apparatus assembles the ticket layout based on predefined layout and behaviour rules defined within the software.
  • the print jobs are run soon after the product bar code has been scanned or RFID tag read, they are available , while the apparatus Is in close proximity to the product, so the operator can retrieve the printed tickets and affix them to the shelf or product bin, without having to search or walk too far.
  • the operator moves the apparatus into a suitable location 100 in order to service the ticketing requirements.
  • this will involve pushing the apparatus within sight of the intended location of the ticketing, or products to be ticketed or labelled. This could be the same aisle, a different aisle, or a different section of the store.
  • the operator decides If they would like to use the default layout that the operator will automatically apply to the scanned items or if they would like to use a layout that they will manually select, In which case the operator scans a code located on the apparatus which corresponds to the layout they would like to use for subsequently scanned items. In some arrangements the operator may not be given choice of layout in which case that step can be skipped.
  • the process is driven by the barcode scanner 2 connected wlrelessly to the data processing unit which may or may not be located on the apparatus.
  • the operator scans 103 the label, RFID tag or packaging of the product or another barcode or RFID tag in close proximity to the product to add it to a queue of items to be ticketed or labelled.
  • this scanning process may also Incorporate the selection of a "template type", also using the barcode scanner or touch-screen, which will ' pre-select or override the preferred layout to use for the scanned product. In this arrangement the effect is to combine step 101 Into step 103.
  • the bar code or RFID tag may be applied to the product, or more commonly is printed on a label or ticket which is affixed to a facing edge of shelving, usually located below where the product item is stored. It Is also common for both methods to be used In a single environment and also known for the barcodes attached to the product to vary from those attached to the shelf or facing as the retail outlet or warehouse may encode additional or different information into the barcodes for operational purposes.
  • tickets are printed to one of the print devices 14 located on the apparatus. This can be done by either manually triggering the creation of the print Job by either a keyboard, mouse, touch-screen gesture, or bar code or RFID scanned command, or by utilising a pre-determined delay timer on the software which will automatically commence the print job if no scanning activity has occurred within the defined period of time. This period of time may or may not be configurable by the operator but should be configurable within the software.
  • the software creates a print job for the relevant printers 14.
  • the software uses the list as exemplified in figure 11, of scanned products and their associated preferred layouts to produce a print job which will be sent to the print devices 14 located on the apparatus.
  • the contents of a sample print file Is illustrated. In this example:
  • Column 4 is the template to print.
  • the printers 14 produce tickets and/or labels using the layout defined by the software, as selected by the operator. Sample tickets are illustrated in Figure 12.
  • the operator collects the printed tickets and/or labels from the printers 14 and places them in the intended location. The process is repeated as required, either in the same location or after physically relocating the apparatus to a different location.
  • a delay timer 105 keeps track of the time in between scanning activity when the initiation timer has been configured. If the specified timeout has been reached then ticket/label production processing is initiated automatically. The timer 105 process runs in parallel with the main process steps if the automatic initiation timer has been enabled.
  • a software module gathers details of scanned items, gathering the details generated by the barcode scanner or RFID reader 2 and related template layout activities, at step 107.
  • the software module then processes scanned items, queries scanned item data against data contained in the look-up table, to determine what data should be gathered, processed, enriched and output to a temporary file on the computing device.
  • the look-up table may point to other data sources from which data Is to be gathered, and the data broker software module, where necessary, may apply pre-configured logic (for example to determine final price based on required parameters which may include discount percentage to be applied, and/or may correlate to stock levels) for each Item in the list of scanned products.
  • pre-configured logic for example to determine final price based on required parameters which may include discount percentage to be applied, and/or may correlate to stock levels
  • Examples of logic to be applied include, but are not limited to:
  • a) determining which template layout to apply to the item being processed This may be either the layout automatically determined by the system or the selection made by the operator in the layout override step.
  • a temporary storage file is created.
  • the output of the data broker process is one or more temporary files which contain the processed information in a format that can be used by other software . components for printing or review.
  • the printing module processes the print job. Once the temporary file(s) has been created by the data broker component, the print module is initiated. This component processes the temporary file(s) and
  • a) applies the correct template layout based on the information contained within the temporary file(s) for the current item being processed
  • printer settings including but not limited to orientation, quality, paper size
  • the print job is sent to the printers) 14.
  • the print module sends the print Job to the appropriate printer drivers) for printing.
  • the corresponding printer drivers communicate with the printer hardware 14 to commence the print job.
  • the software In one embodiment where the software Is being executed on a mobile computing device on the apparatus, the software communicates directly with the printers. In an alternative embodiment where the software Is being executed from another location, the Information is sent to the printers via a wireless connection. - ' .
  • the software may also record the print activity 112 and transmit this at intervals to a specified location for later processing.
  • the interval could be set to real-time that is, immediately following the completion of the print job.
  • the print activity may also be saved to a file. This file can be encrypted and then compressed and the unique identifier for the apparatus recorded in this file.
  • the software is configured to transmit the data 121 in real-time
  • the created activity files including any files that may have previously failed to be transmitted can be uploaded to a centralised service. If the upload Is successful, the files are deleted.
  • a software service running on the computing device 26 attempts the upload process. This service Is started when the computing device 26 is started, and regularly checks whether the specified Interval has elapsed and there is retained print activity. When these conditions are met the print activity files are uploaded to a centralised server. If the upload is successful, the files are deleted. In an alternative configuration, the files can be archived by the apparatus in addition to being transmitted to the central service and processed by the centralised service.
  • the central service When the central service receives the transmitted print activity, the central service begins by receiving the transmitted print activity. The data is uncompressed from the received files, decrypted and then inserted into a database. The central service then assesses the inserted data to see If any alert conditions have been met. If no alert conditions have been met then the service waits for a specified interval before repeating these processes. If alert conditions are met then the relevant alerts are produced. These alerts may include notifications of relevant data to be transmitted by SMS, email, fax, instant message or other such electronic means to designated recipients according to defined policies. This can be. particularly helpful for a head office managing a chain of stores. Management can be alerted if a particular store has not printed sale tickets, which can ensure some consumer laws are not broken. Management can also look at other aspects, such as the amount of times tickets are printed, how long It took to print a sale ticket, when the ticket was printed and what is the sale price compared to the cost price etc.
  • the production of tickets and posting is as described earlier.
  • the operator determines if there are any additional items to be ticketed or labelled. If so, they repeat the above steps. If no further activity is to take place, the operator relocates the apparatus to a suitable location.
  • the first of such software methods provides the apparatus with the means to produce a wide range of ticket and label formats specific to the environment in which the apparatus is situated.
  • each of the printers will be configured to produce different size or format tickets to that of the other printers).
  • the apparatus can be configured with suitable software providing the user with the ability to produce the required tickets and labels according to prescribed guidelines outlining formatting, accessibility and behaviour attributes.
  • the software can include a mechanism for ensuring that all such apparatus located in one or a plurality of sites operate according to the guidelines defined centrally. Ideally the software Is template-based ensuring that the output from the apparatus is consistent across all such apparatus over time,
  • the system can also provide for remote visibility of the activity being conducted by the apparatus either in real-time or as ' part of a batch process. All activity completed on the apparatus can be recorded on the memory of the apparatus and then transmitted to a central computer system. The data can be transmitted either at the time it is produced, or transmitted in a batch process either when pre-defined conditions are met (such as a time-based event or docking of the apparatus) or a manually initiated event Information collected and transmitted will include detailed accounts of each ticket or label printed, in sufficient detail as to be able to reproduce the same ticket or label at a later time at a different location.
  • Collected data can be made available to users either at the same or different location over the internet using either a secure website on a computing device or application on a network-connected electronic device such as phone, tablet or PDA.
  • the data should be searchable, sortable and available in varying levels of detail from very low level (a single ticket's data) to aggregated or summarised data. This data may or may not define trend information.
  • the data can be exportable In a manner as to be usable outside of the described system.
  • the data collection system may also generate alerts when prescribed conditions are met. These alerts may be in the form of emails, SMS phone messages, facsimile or other automatable electronic message delivery systems.
  • the alerts can be sent to a configurable but defined list of recipients.
  • the conditions triggering the alerts can be configurable by users with the correct level of access to the system. For example, If a ticket Is printed with a price below cost, a message can be sent to management for urgent review.
  • a digital camera can be mounted on the product ticketing apparatus to provide a means to collect data in the form of digital images or streaming video which could form part of an audit trail.
  • This audit trail could be used to evidence the fact that a ticket was both printed and placed on the shelf at a particular point In time. The information (pricing, description, etc.) on the ticket could also be evidenced.
  • a wireless camera may also be used to allow the operator to take an actual photo of the product or shelf with the new ticket. In this arrangement the camera would communicate back to the computing device 26:
  • This mode of operation would ideally use a hand-held digital camera Integrated with the system software.
  • the display 1 on the apparatus could remind the user to take a photo of the tickets which had just been placed on the shelf.
  • the association between product and photo could be made automatically at the time the image is captured. These images could later be recalled by searching a database for a product and viewing the associated Images.
  • the apparatus could include a 180 degree camera mounted on each side of the apparatus.to provide a 360 degree view of the aisle, Photos of the aisle could be taken at a predetermined interval, or could also be triggered manually by the user.
  • These Images could be associated with printed tickets that they represent using one of the following methods:
  • OCR optical character recognition
  • a single camera, or multiple cameras can be Included, based on what range of images management of the store wish to collect.
  • the system software could also be configured to take both before and after shots. The before shots could be triggered by the user scanning a bar code or manually by operator input.
  • the display 1 may be used to show what images is about to be captured by the camera. In this way the operator can adjust the position of the apparatus to ensure the appropriate ticket is shown on the screen.
  • video Images would allow management to ensure, and record, that a ticket price has been changed. It also means that area managers can cover a larger geographic region as the need to travel to various store locations merely to verify ticketing is mitigated.
  • the system would use commercially available facial recognition software to blurr (plxate) people's faces and other Identifiable Information to ensure privacy and security.
  • each apparatus can be uniquely Identifiable via software so as to be able to correlate activity and updates with an individual device.
  • the identifier can be transmitted in conjunction with activity information and interpreted by the centralised service receiving the activity information.
  • the centralised service can store identifier and activity information and process it into a data format for long-term storage and accessibility.

Abstract

A Portable product ticketing apparatus including a data processing unit interfaced with a product data Input to receive unique Identification data identifying a product, the data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in the table of products, the data processing unit being interfaced with at least one printer, and being operable to send data to the printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data in the table of products correlating to unique identification data in the table of products.

Description

PRODUCT TICKETING SYSTEM
FIELD OF THE INVENTION
This invention relates to product ticketing which can be used In a warehouse or in a retail outlet. In particular, the present invention relates to a method, system and apparatus to improve the efficiency of product ticketing . BACKGROUND TO THE INVENTION
The following discussion of the background art is intended to facilitate an understanding of the present invention only. It should be appreciated that the discussion is not an acknowledgement or admission that any of the material referred to was part of the common general knowledge as at the priority date of the application.
Product ticketing can be used for a range of purposes including to identify stock items on shelving in warehouses and retail outlets, and to provide an indication of stock levels as at a certain time or to provide a price tag. The information produced on such product ticketing depends on the location. Product identification and pricing is likely to be used on ticketing in a retail outlet such as a supermarket, a department store, or a large hardware store. Product Identification and stock count could be used on ticketing in a retail outlet or a warehouse during stock level audit (stocktaking) or other routine warehouse activities.
In a retail outlet, where product ticketing is used to Identify a product and Its price and other attributes, this is often displayed as retail shelf edge ticketing. There is often a requirement to change the pricing, where a retail outlet wants to discount the price of an Item, either on single purchase or a bulk purchase (ie buy one for $2.99 or two for $4.99), in addition to identifying items which have a special discounted price or belong to another non-price based promotion such as a clearance, or everyday tow price. There Is also a requirement to print tickets where an existing ticket is missing, has been damaged, or is no longer suitable for the amount of stock on the shelf, for example where there is a large amount of stock, a retailer may want to display a larger ticket or multiple ticket, and as the stock level reduces, the retailer may want to display smaller tickets, in keeping with the space taken by the stock on a shelf. Individual item discounting such as for the sale of perishables or products approaching their "best before" date has been achieved using small hand held printer units. With these hand held printer units, a staff member determines a discounted price, inputs the discounted price into printer unit and prints the discounted price on a label, and dispenses the label and applies it to the individual item, usually in juxtaposition with the normal price so the consumer can see the level of discount and factor this in when making a decision to purchase. These units, being hand held, usually print a small label that is no larger than A7. These unite typically print no more informatipn than the price that is input by the staff member. To confirm the correct discount has been applied management need to physically Inspect the shelf.
Changing the price on an item has been a centralised process, either in- house or contracted out, and using fixed hardware located in a back office. In this process, "specials" labels are produced, and then sorted and placed by staff in the appropriate place on shelving in Juxtaposition with the product, as required. This arrangement is often used by chain stores, where the same specials are to be offered across all stores in the group or within a subset of stores in the group. In the case of subsets of stores In the group, these may be divided into regions, price zones or other relevant store groupings. Implementing this arrangement of labelling is time intensive, as by Its nature it requires staff to sort through a multitude of printed labels and locate the product on shelving in a store in order to place the correct Iabel on It Often the amount of information given on the Iabel makes it time consuming for the staff to ensure that they have matched the correct Iabel to the product, as they need to read and match the labels closely. It also requires some initial sorting of labels in order to make the process as effortless as possible, for example sorting the labels by aisle. With larger quantities of different labels, it becomes quite a task to locate each different product location in a store, in order to apply the correct Iabel. There is significant wastage and time delay with this method of production.
Where a business' head office provides the trigger for a promotion of some form, price changes may be distributed electronically to the network of stores or warehouses and reflected in the Point-of-sale (POS) or other Back-Office System (BOS) system. As the back office of a retail store is busy and is typically restricted in its available hardware and software, significant time delays can be avoided by removing the need for staff to rely on this fixed location hardware. Allowing standard tasks to be performed outside of the baok office not only reduces time In producing ticketing, but also provides for more efficient time usage of existing assets.
In practice It is usual for a single computer and printer to be provided in the office of a retail outlet which may be used by staff and agents to print tickets. The process would usually Involve the agent using the computer terminal to print a batch of tickets which are to be applied to products on the shelf. Once those tickets are printed, the agent would then search the shelves for the products and replace the tickets. At this point the agent may recognise that an incorrect ticket has been printed or alternatively that additional tickets are required. This could for example be where the agent has noticed that certain products do not Include a ticket. In this circumstance it is then necessary for the agent to return to the terminal and reprint additional tickets. A large amount of time can therefore be wasted while the agent travels between the computer terminal and the relevant shelves. This problem can be exacerbated in larger retail outlets where multiple agents may be performing the same task. In this circumstance, it is not uncommon for one agent to have to wait for another agent to finish their print job before they can access the terminal. '
In all scenarios, the group head office has Very little, If any, visibility of what ticketing activity has actually taken place In the store or warehouse. This visibility is typically achieved by having someone from outside the store or warehouse visit the location and perform an audit. This function is typically performed by Individuals responsible for multiple sites (Area or Regional Managers). Regardless, in many retail environments it is important for users at a store level to have some degree of control over data such as pricing (to be able to compete locally) which must be balanced with the need to comply with operating requirements or internal guidelines as well as other (external) legislation.
In chain stores, this need for local control does need to be weighed against the larger Interest of the chain as a whole. For example, if product is underprtced the store still could be selling the product at a loss. There are also Issues with incorrect pricing, for example if an advertising campaign indicates that a particular product is a available for a certain price, and the retail outlet is not offering that discounted price then the retail chain may have issues with the ACCC or other like consumer protection bodies. The only way that head office is able to ensure that each retail outlet is meeting its obligations and providing the appropriate pricing is through physical in person onsite inspections.
It is an object of this invention to provide an alternative system for labelling inventory that simplifies the task and saves time.
Throughout the specification unless the context requires otherwise, the word "include" or variations such as "includes" or "including", will be understood to Imply the Inclusion of a stated Integer or group of integers but not the exclusion of any other integer or group of integers,
Throughout the specification unless the context requires otherwise, the word "include" or variations such as "includes" or "including", will be understood to Imply the Inclusion of a stated Integer or group of Integers but not the exclusion of any other integer or group of Integers.
SUMMARY OF THE INVENTION
In accordance with one aspect of the present invention there is provided a portable product ticketing apparatus including a data processing unit interfaced with a product data input to receive unique identification data identifying a product, the data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique Identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in said table of products, said data processing unit being interfaced with at least one printer, and being operable to send data to said printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data In said table of products correlating to unique identification data in said table of products.
Preferably the product data Input Is Interfaced with a bar code scanner, RFID tag reader or other such scanner and the unique identification data identifying a product received by the product data input is derived from a bar code or RFID tag attached to or located in physical proximity to the product. In a retail outlet or a warehouse, the bar code or RFID tag may be applied to the product, or more likely printed on a label or ticket which is affixed to a facing edge of shelving, usually located below where the product item is stored. It is also known for both methods to be used in an environment and also known for the barcodes attached to the product to vary from those attached to the shelf or facing edge as the retail outlet or warehouse may encode additional or different information into the barcodes for operational purposes. For example the codes used may be specific to the business using them and are not used globally.
In accordance with a second aspect of the invention there is provided a portable product ticketing apparatus including a data processing unit interfaced with a barcode scanner or RFID tag reader to receive unique identification data identifying a product, the unique identification data identifying the product being derived from a bar code or RFID tag attached to or located In physical proximity to the product, the data processing unit having access to or being Interfaced with a memory containing a table of products and correlating unique identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in the table of products, the data processing unit being interfaced with at least one printer, and being operable to send data to the printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data In the table of products correlating to unique Identification data in the table of products.
The expression "table of products" In effect refers to a look-up table, which may be as simple as a table containing bar code' or other unique Identification data correlating to a product catalogue number. This may require recourse to a further table contained In or accessible by the data processing unit, for interrogation for the gathering of further data as necessary to gather all of the data required in order to print a ticket. There may be many levels of data, which are in effect contained within stock control and accounting systems computers used In the site in which the invention is to be employed.
Ideally the table of products includes for each product, data correlating to the product description, data correlating to the unique identification data which will be data correlating to the product bar code or RFID identifier, and may Include one of a number of other pieces of Information such as product Identifying stock number, and pricing data, Including any special prices to be offered. The other information printed will usually be pricing information which can be selected from one or more of a normal price, a special price, or any other pricing offer pertaining to the product or additional Information pertaining to the product such as specifications, marketing information or other information used by the retailer or warehouse for operational purposes. Additional Information may not be pricing related and is limited only by the data accessible to the invention when in operation. This additional information may include operational attributes (order quantities, warehouse locations, and promotion end date for example) or customer-facing attributes (product features, descriptions, .colour options for example).
Preferably the table of products Includes a link to further data that can be accessed by the data processing unit, whether for printing or other reasons, which may or may not be stored on the apparatus but is accessible by the apparatus. As the data processing unit may be capable of performing additional calculations and applying predefined logic, this may require other data to be merged with data in the table of products.
Preferably the data processing unit is operable to receive a plurality of received unique identification data Identifying a plurality of products, before queuing data to the one or more printers to print one or more tickets on a single sheet There are a range of potential paper stocks that the printers) could print to, including perforated sheet so that the operator could separate the tickets and apply them to the appropriate position. Where the unique identification data is scanned from barcodes, (or other means such ' as a microchip based tag), the operator will be In proximity to the product location when the tickets are printed. If the tickets are A8 in size, there can be sixteen printed on a single A4 sheet, making it a relatively simple task to locate the correct product location for each ticket Alternatively, there can be four A6 tickets or two AS tickets printed on a single A4 sheet, to show specials or promotions on sale at a retail store. Other variations of layout and paper stock include continuous fan-fold or continuous roll- fed paper stocks either of predefined size or variable size where the printer features an automatic cutting mechanism to cut the ticket to the desired size. Preferably the data processing unit is interfaced to a display, and when received unique identification data is successfully correlated with unique identification data from the table, data pertaining to the product is retrieved from the table and displayed on the display. This allows for operator verification, if this is required.
Preferably the data processing unit is interfaced with a print-stock selection input, which allows selection of print-stock for the printing of tickets. The print- stock can be selected from any desired sheet size but convenient sizes are a quarto/!etter In the USA or A4 sheet in other countries. Ticket size can be any portion of a sheet size, and the print-stock may be perforated to allow the printed tickets to be easily separated. The data processing unit can arrange the tickets as required for the selected print-stock.
Preferably the print-stock selection for a product is included among data in the table, or can be derived from data in the table by performing logical operations and the data processing unit queues selected tickets by print-stock type, for printing together on the correct print-stock. With this arrangement, there is no requirement for the operator of the portable product ticketing apparatus to make a decision regarding the ticket print-stock, as it is predetermined.
Alternatively, the print-stock selection input is operator initiated, and preferably no more than a three step process, although ideally it would be a single or two step process.
Preferably the print-stock selection input Is received from a bar code scanner selecting from one of a plurality of print-stock bar codes each correlating to an available print-stock type, the plurality of barcodes being printed and displayed on the portable product ticketing apparatus and being accessible by the bar code scanner. The same bar code scanner as used for scanning the product bar code can be used to scan the bar code for the required print-stock type.
Alternatively the print-stock selection Input is received from one of a plurality of user operable switches each correlating to an available print-stock type. These switches may be via the touch-screen, keyboard, mouse or other means deemed appropriate for the application.
As a further alternative, the display can be a touch screen, and the print- stock selection input is received from one of a plurality of user selectable print- stock types. Preferably the data processing unit receives and correlates print- stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period Is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit prompts the operator by the display to load (if necessary) the required print-stock so the tickets can be printed.
Alternatively the apparatus includes a plurality of printers loaded with different print-stocks, and the data processing unit receives and correlates print stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence Is complete, and then the data processing unit causes the appropriate printer to print the tickets or prompts the operator by the display to load the required print-stock in the appropriate printer so the tickets can be printed.
Preferably the order of operation processed by the data processing unit is input unique identification data Identifying a product, whereupon product information is displayed on the display, and then input the required print stock.
Alternatively, the order of operation Is input the required print stock, in the absence of using a default print-stock or to override a default print-stock, and then input unique identification data Identifying products, one after the other until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit causes the appropriate printer to print the tickets.
Alternatively, the order of operation is' input the required print stock, in the absence of using a default print-stock, and then input unique identification data Identifying products, one after the other until a sheet of any print stock type Is filled, or a predetermined time period is exceeded, or the user manually Indicates that the queuing sequence is complete, and then the data processing unit prompts the operator by the display to load the required print-stock in the appropriate printer so the tickets can be printed. Alternatively, the order of operation Is input the required print stock, In the absence of using a default print-stock, and then input, unique identification data identifying products, one after the other until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then the data processing unit causes the appropriate printer to print the tickets or prompts the operator by the display to load the required print-stock In the appropriate printer so the tickets can be printed.
In any of the above arrangements, the predetermined time period can be configured according to the unique requirements of the user in pre-defined increments if desired. The predetermined time period can be disabled by setting the predetermined time to zero. A zero value is interpreted by the software as disabling a counter that runs for the predetermined time period.
Preferably the data processing unit is interfaced with a keyboard or other suitable input device such as for example a touch screen, for user Input of data pertaining to a product. In this manner other Information relating to the product can be recorded, such as available units of product in stock, as would be recorded in a stock take/ stock audit Then the ticket produced can Include data relating to stock levels at the time the ticket was made. Preferably the user input of data pertaining to a product is recorded In the table or transmitted back to be recorded in the table, where the memory is not co-located with the data processing unit.
Preferably the portable product ticketing apparatus Is In the form of a trolley-like apparatus having wheels or castors, at least one mounting surface to support the at least one printer, a supply of print-stock, and a power supply. The power supply may be a bank of batteries (such as lithium ion batteries or sealed lead acid batteries) supplying power either directly or via an Inverter providing local AC voltage (eg, 240 VAC 220 VAC, 110 VAC) to the at least one printer, the bar code scanner or RFID tag reader, wireless data transceiver, and the data processing unit and any other peripherals required to fulfil the operational requirements of the apparatus, The data processing unit may be a mobile computing device, such as a laptop computer, tablet or low-power embedded PC. The memory may be memory on board the computing device, or in a file server or other computer located in a back office or remote site and accessible remotely via wireless network technology.
Each mounting surface may be in the form of a shelf, on which printers, consumables and the power supply sit. Typically the trolley has castors fitted with braking devices so as to be readily moveable into position alongside shelving where product is located, and readily restrained in a desired location for the duration of data input and ticket printing.
Preferably the portable ticket printing apparatus is provided with three shelves.
In accordance with a third aspect of the invention there is provided a method of preparing tickets for product Items stocked in a warehouse or retail store, including providing and operating a portable product ticketing apparatus as described above.
In accordance with a fourth aspect of the invention there is provided a method of preparing tickets for product Items stocked in a warehouse or retail store, Including providing a portable product ticketing; apparatus including a data processing unit interfaced with a product data input to receive unique Identification data Identifying a product, the data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique identification data for each of the products, the data processing unit being operable to compare received unique identification data identifying a product with unique identification data in the table of products, the data processing unit being interfaced with at least one printer, and being operable to send data to the printer to print a ticket of predetermined format containing a product description and other Information pertaining to the product derived from data in said fable of products correlating to unique identification data In the table of products, inputting unique identification data Identifying a product via product data input, comparing the input unique identification data with unique identification data in the table of products, retrieving data from said table'of products and sending to the printers) to print the tickets).
Preferably the product data input is interfaced with a bar code scanner and the unique identification data identifying a product received by the product data input is derived from a bar code attached to or located in physical proximity to the product.
Preferably the table of products includes' for each product, in addition to data correlating to the product description and Its correlating unique Identification data, a flag as to whether a ticket is to be printed for the product, wherein the data processing unit is operable to send data to the printer to print the ticket only If the flag Indicates a ticket is to be printed.
Preferably in the method, the data processing unit is operable to receive a plurality of received unique Identification data Identifying a plurality of products, before queuing data to the at least one printer to print a plurality of tickets on a single sheet.
The sheet would usually be perforated so that the operator could separate the tickets and apply them to the appropriate position. Other variations of layout and paper stock include continuous fan-fold or continuous roll-fed paper stocks either of pre-defined size or variable with a print device featuring an automatic cut mechanism.
Preferably the data processing unit is Interfaced with a print-stock selection Input/ which allows selection of print-stock for the printing of tickets. In accordance with this preferred feature, the operator can select the desired print- stock, before sending data to print a ticket.
Ideally the apparatus will also include at least one camera to capture still and/or video images of the tickets placed on the product and/or shelf. The camera can be operated either manually by the operator or configured to automatically capture images. These images can be communicated to a remote server and allow for a reduction In the number of physical inspections required by managers.
The system is also able to transmit information back to a remote server. This information can include details of the new ticket; time of printing, captured Images, and any other relevant data required by management of the store.
BRIEF DESCRIPTION OF THE DRAWINGS
An illustrative embodiment of the present Invention will now be described with reference to the accompanying figures. Further features and advantages of the invention will also become apparent from the accompanying description: Figure 1 is a front facing elevation of the apparatus without peripherals. Figure 2 is a front facing elevation of the apparatus with the peripheral drawer open.
Figure 3 is a rear facing elevation of the apparatus with the door open and without peripherals.
Figure 4 Is a rear facing elevation of the apparatus with the door open and peripherals fitted.
Figure 5 is a front facing view of the apparatus showing detail of the internal electronics under a lockable lower shelf.
Figure 6 exemplifies the electronic components in one embodiment of the present Invention.
Figure 7 exemplifies the electronic components in an alternative embodiment of the present invention;
Figure 6 exemplifies the user process in a preferred arrangement of the present invention.
Figure 9 exemplifies the logical process of a preferred embodiment of the present invention.
Figure 10 exemplifies one method of selecting ticket sizes to print.
Figure 11 exemplifies a sample print file.
Figure 12 shows possible sample tickets
Figure 13 shows a sample customer product inventory table.
. Table 1 - Brief description of apparatus elements and Identifiers In preferred embodiment.
Figure imgf000013_0001
Figure imgf000014_0001
DESCRIPTION OF PREFERRED EMBODIMENT
The following description is presented to enable any person skilled in the art to make and use the invention, and Is provided in the context of a particular application and its requirements. Various modifications to the disclosed embodiments will be readily apparent to those skilled in the art, and the general principals defined herein may be applied to other embodiments and applications without departing from the spirit and scope of the present invention. Thus,, the present invention is not intended to be limited to the embodiments shown, but is to be accorded the widest scope consistent with the principals and features disclosed herein,
The embodiment illustrated In the figures is a portable product ticketing apparatus and system. This embodiment includes a mobile apparatus supported on four castors 12, which pivot about vertical axes. The wheels of the castors 12 are lockable to prevent the apparatus running away if used on a sloping surface. The locking mechanism can be operated by foot operated locks on the castors 12. An alternative embodiment may have the locking mechanisms operated by a lever fitted to the handle 6.
An alternative to castors may also be Included. The important aspect Is that the apparatus is able to move with relative freedom about the retail outlet. For example it could be possible for the apparatus to be powered by a motorised wheel system, similar to those used on motorised golf carts. This alternative may be particularly advantageous when the apparatus exceeds 150 kg and/or the surface on which the apparatus is to operate has high friction such as carpet.
The preferred arrangement has three shelves 10, 13, and 19. Materials chosen for the apparatus should be robust and light to facilitate easy transport from one location to another by young adults and adults of working age who are likely to work in the environments of the intended application.
The batteries 27 should be selected to provide sufficient power to operate the electronic devices for the minimum period designed for the particular application. The selection of the battery should take into account the expected power requirements of the electronic" equipment on the apparatus between recharges. That is, If it Is expected that the apparatus would be in use for a period of 8 hours between recharges then the batteries should be of sufficient capacity to provide the necessary power to each element of the apparatus for this period. Further, so as to prolong the battery life, It would be preferred not to fully drain the batteries. Accordingly, in the preferred embodiments, the capacity of the batteries would be double the projected requiremerits;
Based on preliminary testing, of a reasonable estimation for an apparatus utilising a low-power PC or similar processing device and 2 printers, then the apparatus would need to deliver a minimum of 150W power for the expected operating duration of 8 hours.
In the preferred embodiments, the apparatus would use sealed lead acid (SLA) batteries as such batteries can provide a less complex battery protection circuitry and safety issues compared with other batteries. An alternative could be Li-ion batteries or alternately some form of fuel cell.
The preferred embodiment has a battery pack 27 and electronics located on the lower shelf 19. The battery pack 27 consists of a 12V or 24V battery pack which may be single battery or a plurality of batteries connected in parallel or series to provide enough capacity for the requirements. In the instance where both 24V and 12V DC power is required on the device, this would ideally be achieved through the use of a DC-DC converter to step-down 24V to12V, enabling a single charging/monitoring system to be used. Capacity ranges are expected to be in the range of 40Ah to 120Ab depending on expected usage, both volume of printing and duration of portability required, and the type and quantity of printers to be located on the apparatus. The battery pack 27 is housed in a compartment under the lower lockable shelf 19, enabling individual cells or the entire battery pack to be swapped out for maintenance. Capacity is provided within the housing for the cells required to achieve the desired capacity range discussed above.
The electronics on the apparatus includes an inverter 29 which Is connected to the battery pack 27 and converts the 12V or 24V DC from the battery pack 27 to AC current suitable for use by the connected equipment (eg 240 VAC, 220 VAC, 110 VAC). Should suitable DC-powered devices be available an alternative embodiment would not require the use of an inverter. The inverter 29 has sufficient capacity, rated for continuous use, to handle the power requirements of the connected equipment. The electronics includes a charging system 28 for charging the battery pack 27, in between use of the apparatus. The charging system 28 enables the apparatus to be plugged into a standard AC power outlet to charge the battery pack 27. The charging system 28 contains the necessary electronics to ensure that · the batteries are charged safely and efficiently with automatic cut-out to ensure thatthe battery pack 27 Is not overcharged. Such necessary electronics would be similar to those found in a commercially available battery charger suitable for the selected battery technology. Such battery chargers would contain elements which measure temperature, time current has been applied and voltage, coupled with electronics which intelligently vary the current applied to the battery pack. The electronics in such chargers are pre-programmed to prolong the life of the battery and avoid dangerous conditions-such as excessive heat in the battery pack.
The electronics Includes a power, monitoring system 7 to monitor the battery pack 27 and preferably is able to display the remaining capacity of the battery pack to the user. The power monitoring system 7 can be connected to a audible device and/or other visual Indicating devices to provide audible and/or visual warning of any fault state such as low charge or low voltage.
The electronics are Ideally contained In lockable compartment under the lower shelf 19 to protect them from dust and other elements and to also ensure that there is no risk of electrocution by operators accidentally making contact with the electronics in a manner that may cause damage or physical injury. This lockable component also provides additional security for the electronics from malicious activities. The apparatus may be fitted with a Residual Current Device (RCD) to further reduce the risk of Injury to the operator or other person.
The top shelf 10 supports a touch-screen display device 1, storage compartments 4 and 5 and a barcode scanner or RFID reader 2 mounted on an appropriate cradle 3. The middle shelf 13 and lower shelf 19 supports a printer 14 or multiple printers handling consumables appropriate for the use of the apparatus and according to user requirements. The printers 14 are supplied power by the electronics on the apparatus and are connected to the power outlet 24
The embodiment shown has a data processing unit in the form of a low power computing device 26. In some arrangements a laptop computer, tablet or other form factor device may be used. Preferably the hand held bar code scanner or RFID reader 2 communicates with its cradle 3 wlrelessly, using suitable wireless technology and protocols. An alternative embodiment may utilise a scanner physically connected to the apparatus via a cable. This arrangement would be less convenient In terms of use but would not have concerns wtth the need to recharge the scanner 2. The cradle 3 for the scanner 2 can be connected to the computing devfce 26 via a universal serial bus or other suitable protocol, for example wireless. The printers 14 can all be connected to the computing device 26 by universal serial bus or other suitable protocol, for example wireless. The computing device 26 may also be connected to a USB hub which may, in turn, be connected to the power supply 24 via a power adapter. The USB hub may also be used for connecting any of the other peripherals on the apparatus.
The computing device 26 communicates wirelessly to a computer 43 In a back office or server room, for product stock data contained in a table containing product information (name) and unique bar code identification data for each product. In an alternative embodiment, the table containing product information (name) and unique bar code identification data for each product may be downloaded to the computing device 26 on the apparatus periodically, avoiding the need for regular wireless communication with the file server in a back office or server room.
Wireless capability may be extended through the use of an antenna connected to the low power computing device 26.
This alternative arrangement may be desirable in a large warehouse or retail outlet, where reliable wireless communication is not available without such external antenna.
In a further embodiment shown In figure 7, the hand held bar code scanner 2 and printers 14 communicate wirelessly to a computer 43 located in the back office or server room. This computer 43 also communicates over a network with a file server in a back office or server room, for product stock data contained in a table containing product Information (name) and unique bar code identification data for each product. The computer 43 in the back office transmits print jobs wirelessly to the printers 14.
The apparatus computing device 26 runs on a suitable operating system such as Microsoft Windows, and Incorporates functionality described In this patent specification. The computing device 26 may conveniently have a touch screen display 1, which will facilitate operation of the system, although an alternative Input device such as a keyboard, mouse, or keyboard and mouse combination may be provided. As the apparatus is likely to be used in a retail environment with high traffic of persons, all elements of the apparatus should ideally be secured or securable to prevent theft or vandalism if the trolley is left unattended.
Operation of the system Involves using the hand held bar code scanner or RFID tag reader 2 to scan the bar code or RFID tag of a product located on a shelf, or to be placed on a shelf. This bar code to be scanned is located on the product Itself or on a label typically on the front of a shelf or bin on or in which the product is stored or displayed. In the case that RFID tags are used in preference to barcodes, the tags will typically be located on the product itself. The apparatus ideally includes a representation of each ticket size for available ticket print-stock loaded into the printers, and alongside each, a bar code or other scannable representation as exemplified in figure 10.
If the operator requires the ticket to be printed on print-stock other than the default, the operator scans the barcode corresponding to the required print stock. The data processing unit (computing device on the apparatus 2Θ) compares the product bar code that has been scanned with unique Identification bar code data contained in the customer product Inventory table and if present, gathers product description, pricing, and other data from the look-up table and assembles it using a template for printing on the ticket
The data is assembled Into the template- Selected by the operator, or the default template, if no other template is selected within a timeout period. Once the templates are filled for a print job (ie where print stock is A4 and there are four tickets per A4 sheet, and all tickets on the sheet have been populated), or once a time out period expires, or if the user manually indicates that the queuing sequence Is complete, the print Job Is produced using the software installed on the apparatus and sent to the appropriate printer 14 containing the required print- stock. The software on the apparatus assembles the ticket layout based on predefined layout and behaviour rules defined within the software.
An alternative Implementation would allow the print-stock selection to be performed using the touch-screen 1. keyboard, mouse or other suitable Input.
As the print jobs are run soon after the product bar code has been scanned or RFID tag read, they are available , while the apparatus Is in close proximity to the product, so the operator can retrieve the printed tickets and affix them to the shelf or product bin, without having to search or walk too far.
With reference to figure 8, in use the operator moves the apparatus into a suitable location 100 in order to service the ticketing requirements. Typically, this will involve pushing the apparatus within sight of the intended location of the ticketing, or products to be ticketed or labelled. This could be the same aisle, a different aisle, or a different section of the store.
At step 101 , the operator decides If they would like to use the default layout that the operator will automatically apply to the scanned items or if they would like to use a layout that they will manually select, In which case the operator scans a code located on the apparatus which corresponds to the layout they would like to use for subsequently scanned items. In some arrangements the operator may not be given choice of layout in which case that step can be skipped.
Once the layout has been determined, the process is driven by the barcode scanner 2 connected wlrelessly to the data processing unit which may or may not be located on the apparatus. The operator scans 103 the label, RFID tag or packaging of the product or another barcode or RFID tag in close proximity to the product to add it to a queue of items to be ticketed or labelled.
Depending on the Implementation for the specific client, this scanning process may also Incorporate the selection of a "template type", also using the barcode scanner or touch-screen, which will' pre-select or override the preferred layout to use for the scanned product. In this arrangement the effect is to combine step 101 Into step 103.
In a retail outlet or a warehouse, the bar code or RFID tag may be applied to the product, or more commonly is printed on a label or ticket which is affixed to a facing edge of shelving, usually located below where the product item is stored. It Is also common for both methods to be used In a single environment and also known for the barcodes attached to the product to vary from those attached to the shelf or facing as the retail outlet or warehouse may encode additional or different information into the barcodes for operational purposes.
Once all the required products have been scanned 104, tickets are printed to one of the print devices 14 located on the apparatus. This can be done by either manually triggering the creation of the print Job by either a keyboard, mouse, touch-screen gesture, or bar code or RFID scanned command, or by utilising a pre-determined delay timer on the software which will automatically commence the print job if no scanning activity has occurred within the defined period of time. This period of time may or may not be configurable by the operator but should be configurable within the software.
At step 116, the software creates a print job for the relevant printers 14. The software uses the list as exemplified in figure 11, of scanned products and their associated preferred layouts to produce a print job which will be sent to the print devices 14 located on the apparatus. With reference to figure 11, the contents of a sample print file Is illustrated. In this example:
Column 1 indicates the number of copies required of the ticket.
Column 2 is the product barcode.
Column 3 is a description of the product which matches the barcode.
Column 4 is the template to print.
At step 117 the printers 14 produce tickets and/or labels using the layout defined by the software, as selected by the operator. Sample tickets are illustrated in Figure 12. At step 118 the operator collects the printed tickets and/or labels from the printers 14 and places them in the intended location. The process is repeated as required, either in the same location or after physically relocating the apparatus to a different location.
Referring to figure 9, further detail of the system operation is illustrated. A delay timer 105 keeps track of the time in between scanning activity when the initiation timer has been configured. If the specified timeout has been reached then ticket/label production processing is initiated automatically. The timer 105 process runs in parallel with the main process steps if the automatic initiation timer has been enabled.
If the delay timer hasnt been configured or the operator wishes to immediately commence the processing of the Items already scanned they will be able to initiate the process by either the appropriate action using a keyboard, mouse, touch-screen or barcode scanner, at step 106. Once the process is initiated, a software module gathers details of scanned items, gathering the details generated by the barcode scanner or RFID reader 2 and related template layout activities, at step 107. At step 108, the software module then processes scanned items, queries scanned item data against data contained in the look-up table, to determine what data should be gathered, processed, enriched and output to a temporary file on the computing device. The look-up table may point to other data sources from which data Is to be gathered, and the data broker software module, where necessary, may apply pre-configured logic (for example to determine final price based on required parameters which may include discount percentage to be applied, and/or may correlate to stock levels) for each Item in the list of scanned products.
Examples of logic to be applied Include, but are not limited to:
a) determining which template layout to apply to the item being processed. This may be either the layout automatically determined by the system or the selection made by the operator in the layout override step.
b) merging the scanned data with one or more data sources either on the local machine or on an accessible computer network to provide a more complete data set to process.
c) prompting the operator to make additional selections based on information that can only be determined by the operator. d) performing calculations or other script-based logic On the acquired data to apply business rules such as text manipulation, mathematical operations or other such logic.
e) applying the correct properties to the data being written out, such as the field type of each piece of Information to ensure that It corresponds correctly with the pre-defined layout guidelines of the assigned template type.
At step 109, a temporary storage file is created. The output of the data broker process is one or more temporary files which contain the processed information in a format that can be used by other software . components for printing or review. At step 110 the printing module processes the print job. Once the temporary file(s) has been created by the data broker component, the print module is initiated. This component processes the temporary file(s) and
a) applies the correct template layout based on the information contained within the temporary file(s) for the current item being processed;
b) determines which printer 14 to send the information to based on default and selected printer data;
c) determines what printer settings (including but not limited to orientation, quality, paper size) to apply to the items using the current template (if any).
At step 111 , the print job is sent to the printers) 14. The print module sends the print Job to the appropriate printer drivers) for printing. The corresponding printer drivers communicate with the printer hardware 14 to commence the print job. In one embodiment where the software Is being executed on a mobile computing device on the apparatus, the software communicates directly with the printers. In an alternative embodiment where the software Is being executed from another location, the Information is sent to the printers via a wireless connection. - ' .
The software may also record the print activity 112 and transmit this at intervals to a specified location for later processing. The interval could be set to real-time that is, immediately following the completion of the print job. The print activity may also be saved to a file. This file can be encrypted and then compressed and the unique identifier for the apparatus recorded in this file.
If the software is configured to transmit the data 121 in real-time, the created activity files, including any files that may have previously failed to be transmitted can be uploaded to a centralised service. If the upload Is successful, the files are deleted.
If the software is configured to transmit the data at scheduled intervals (such as daily, weekly, monthly) then a software service running on the computing device 26 attempts the upload process. This service Is started when the computing device 26 is started, and regularly checks whether the specified Interval has elapsed and there is retained print activity. When these conditions are met the print activity files are uploaded to a centralised server. If the upload is successful, the files are deleted. In an alternative configuration, the files can be archived by the apparatus in addition to being transmitted to the central service and processed by the centralised service.
When the central service receives the transmitted print activity, the central service begins by receiving the transmitted print activity. The data is uncompressed from the received files, decrypted and then inserted into a database. The central service then assesses the inserted data to see If any alert conditions have been met. If no alert conditions have been met then the service waits for a specified interval before repeating these processes. If alert conditions are met then the relevant alerts are produced. These alerts may include notifications of relevant data to be transmitted by SMS, email, fax, instant message or other such electronic means to designated recipients according to defined policies. This can be. particularly helpful for a head office managing a chain of stores. Management can be alerted if a particular store has not printed sale tickets, which can ensure some consumer laws are not broken. Management can also look at other aspects, such as the amount of times tickets are printed, how long It took to print a sale ticket, when the ticket was printed and what is the sale price compared to the cost price etc.
The production of tickets and posting, is as described earlier. The operator determines if there are any additional items to be ticketed or labelled. If so, they repeat the above steps. If no further activity is to take place, the operator relocates the apparatus to a suitable location.
In each scenario the apparatus provides a series of software methods that complement and are advantageous.,
The first of such software methods provides the apparatus with the means to produce a wide range of ticket and label formats specific to the environment in which the apparatus is situated. In particular, in most configurations each of the printers will be configured to produce different size or format tickets to that of the other printers). To do this, the apparatus can be configured with suitable software providing the user with the ability to produce the required tickets and labels according to prescribed guidelines outlining formatting, accessibility and behaviour attributes. The software can include a mechanism for ensuring that all such apparatus located in one or a plurality of sites operate according to the guidelines defined centrally. Ideally the software Is template-based ensuring that the output from the apparatus is consistent across all such apparatus over time,
The system can also provide for remote visibility of the activity being conducted by the apparatus either in real-time or as' part of a batch process. All activity completed on the apparatus can be recorded on the memory of the apparatus and then transmitted to a central computer system. The data can be transmitted either at the time it is produced, or transmitted in a batch process either when pre-defined conditions are met (such as a time-based event or docking of the apparatus) or a manually initiated event Information collected and transmitted will include detailed accounts of each ticket or label printed, in sufficient detail as to be able to reproduce the same ticket or label at a later time at a different location.
Collected data can be made available to users either at the same or different location over the internet using either a secure website on a computing device or application on a network-connected electronic device such as phone, tablet or PDA. The data should be searchable, sortable and available in varying levels of detail from very low level (a single ticket's data) to aggregated or summarised data. This data may or may not define trend information. The data can be exportable In a manner as to be usable outside of the described system.
In addition to reports, the data collection system may also generate alerts when prescribed conditions are met. These alerts may be in the form of emails, SMS phone messages, facsimile or other automatable electronic message delivery systems. The alerts can be sent to a configurable but defined list of recipients. In addition, the conditions triggering the alerts can be configurable by users with the correct level of access to the system. For example, If a ticket Is printed with a price below cost, a message can be sent to management for urgent review.
In a further embodiment, and to further Improve management process, a digital camera can be mounted on the product ticketing apparatus to provide a means to collect data in the form of digital images or streaming video which could form part of an audit trail. This audit trail could be used to evidence the fact that a ticket was both printed and placed on the shelf at a particular point In time. The information (pricing, description, etc.) on the ticket could also be evidenced. In some arrangements a wireless camera may also be used to allow the operator to take an actual photo of the product or shelf with the new ticket. In this arrangement the camera would communicate back to the computing device 26:
This mode of operation would ideally use a hand-held digital camera Integrated with the system software. After tickets had been printed by the onboard printers, the display 1 on the apparatus could remind the user to take a photo of the tickets which had just been placed on the shelf. The association between product and photo could be made automatically at the time the image is captured. These images could later be recalled by searching a database for a product and viewing the associated Images.
In an alternative arrangement, the apparatus could include a 180 degree camera mounted on each side of the apparatus.to provide a 360 degree view of the aisle, Photos of the aisle could be taken at a predetermined interval, or could also be triggered manually by the user. These Images could be associated with printed tickets that they represent using one of the following methods:
a) By use of an indoor positioning system. The location of the apparatus could be recorded each time an Image is taken. Photos could later be recalled by matching the location of a product with photos that were taken in that area.
b) By manually associating the images taken and collected each day with the products/tickets they represent.
c) By optical character recognition (OCR) so that tickets that appear on a photo after it is placed on a shelf can be scanned by an OCR package so that information uniquely identified on the ticket could be automatically matched to the printed tickets.
Depending on the arrangement elected a single camera, or multiple cameras can be Included, based on what range of images management of the store wish to collect. The system software could also be configured to take both before and after shots. The before shots could be triggered by the user scanning a bar code or manually by operator input. In some implementations the display 1 may be used to show what images is about to be captured by the camera. In this way the operator can adjust the position of the apparatus to ensure the appropriate ticket is shown on the screen.
The use of video Images would allow management to ensure, and record, that a ticket price has been changed. It also means that area managers can cover a larger geographic region as the need to travel to various store locations merely to verify ticketing is mitigated.
Using this method, the system would use commercially available facial recognition software to blurr (plxate) people's faces and other Identifiable Information to ensure privacy and security.
To facilitate the software attributes, each apparatus can be uniquely Identifiable via software so as to be able to correlate activity and updates with an individual device. The identifier can be transmitted in conjunction with activity information and interpreted by the centralised service receiving the activity information. The centralised service can store identifier and activity information and process it into a data format for long-term storage and accessibility.
Having described the invention with respect to these embodiments, the skilled addressee will appreciate the changes that may be made without departing from the spirit and scope of the invention. Particularly, matters of interconnectivity of hardware such as whether the printers and the barcode scanner or RFID reader are connected by USB or other method, and the wireless communication protocols may be varied to reflect developing trends, without departing from the spirit and scope of the Invention. The manufacturer of hardware and the hardware type (laptop, tablet, notepad, or small form factor PC are possible candidates for the data processing unit), and the operating systems may also be varied without departing from the spirit and scope of the invention. Additionally, alternative methods of product identification (currently barcodes or RFID tags) are possible and may be Implemented without departing from the spirit and scope of the Invention.

Claims

CLAIMS:
1. A Portable product ticketing apparatus including a data processing unit interfaced with a product data input to receive unique identification data identifying a product, said data processing unit having access to or being Interfaced with a memory containing a table of products and correlating unique identification data for each of said products, said data processing unit being operable to compare received unique identification data identifying a product with unique identification data in said table of products, said data processing unit being interfaced with at least one printer, and being operable to send data to said printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data In said table of products correlating to unique Identification data in said table of products.
2. An apparatus as claimed in claim 1, wherein said product data Input is a bar code scanner or RFID tag reader.
3. A Portable product ticketing apparatus including a data processing unit Interfaced with a bar code scanner or RFID tag reader to receive unique Identification data identifying a product, said unique identification data identifying said product being derived from a barcode attached to or located in physical proximity to said product or RFID tag attached to the product, said data processing unit having access to or being interfaced with a memory containing a table of products and correlating unique identification data for each of said products, said data processing unit being operable to compare received unique identification data identifying a product with unique identification data in said table of products, said data processing unit being interfaced with at least one printer, and being operable to send data to said printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data in said table of products correlating to unique identification data in said table of products. In a retail outlet or a warehouse, the barcode may be applied to the product, or more commonly is printed on a label or ticket which is affixed to a facing edge of shelving, usually located below where the product item Is stored. RFID tags will commonly be attached to the product or packaging (pallet or box) of the product.
4. A Portable product ticketing apparatus as claimed in any one of the preceding claims wherein said table of products may include for each product, in addition to data correlating to the product description and its correlating unique identification data, a flag as to whether a ticket is to be printed for said product, and where said data processing unit is operable to send data to said printer to print said ticket only if said flag indicates a ticket is to be printed.
5. A Portable product ticketing apparatus as claimed in any one of the preceding claims wherein said table of products includes a link to further data that can be accessed by said data processing unit.
6. A Portable product ticketing apparatus .as claimed in any one of the preceding claims wherein said data processing unit is operable to receive a plurality of received unique identification data identifying a plurality of products, before queuing data to said at least one printer to print a plurality of tickets on a single sheet.
7. A Portable product ticketing apparatus as claimed in any one of the preceding claims wherein said data processing unit Is Interfaced to a display, and wherein when said received unique identification data is successfully correlated with said unique identification data from said table, data pertaining to the product is retrieved from said table and displayed dn said display
8. A Portable product ticketing apparatus as claimed in any one of the preceding claims wherein said data processing unit isJnterfaced wtth a print-stock selection Input, which allows selection of print-stock for the printing of tickets.
9. A Portable product ticketing apparatus as claimed in claim 8 wherein the print-stock selection for a product is included among data in said table, and said data processing unit queues selected tickets by print-stock type, for printing together on the correct print-stock. .
10. A Portable product ticketing apparatus as claimed In claim 8 wherein said print-stock selection Input is operator initiated via a touch screen, keyboard and/or mouse.
11. A Portable product ticketing apparatus as claimed in claim 8 wherein said print-stock selection input is received from a or said bar code scanner selecting from one of a plurality of print-stock bar codes each correlating to an available print-stock type, said plurality of barcodes being printed and displayed on said portable product ticketing apparatus and being accessible by said bar code scanner.
12. A Portable product ticketing apparatus as claimed in claim 11 wherein said at least one printer includes a plurality of printers loaded with different print- stocks, and said data processing unit receives and correlates print-stock selection and received unique identification data, and batch sorts data for tickets by print- stock type until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then said data processing unit causes the appropriate printer to print the tickets or prompts the operator by the display to load the required print- stock in the appropriate printer so the tickets can be printed.
13. A Portable product ticketing apparatus as claimed in any one of the preceding claims wherein said portable product ticketing apparatus is in the form of a trolley having wheels or castors, at least one mounting surface to support said -at least one printer, a supply of print-stock, and a power supply.
14. A portable product ticketing device as Claimed in any preceding claim further Including an image capture device interfaced to said data processing unit, said Image capture device operable to capture video and/or still Images of said ticket and/or product.
15. A portable product ticketing device as claimed in any preceding claim further Including a communications module to transmit data to a remote server, said data including said unique identification data.
16. A system of preparing tickets for product items stocked in a warehouse or retail store, Including:
operating a product data input in communication with a data processing unit to obtain a unique identification data of a product;
comparing received said unique identification data with an index of stored identification data in a memory, said stored Identification data Including a table of products containing data for said product, and obtaining product data linked to said unique identification data;
formatting said product data Into a template for a ticket suitable for printing; and
printing said ticket on a printer in communication with said data processing unit.
17. A system as claimed in claim 16 wherein said product data input is a barcode scanner or RFID tag reader.
18. A system as claimed in claim 16 or 17 wherein said table of products includes for each product, a flag as to whether a ticket should be printed for said product, and wherein said data processing unit fs operable to send data to said printer to print said ticket only If said flag indicates a ticket is allowed to be printed.
19. A system as claimed in anyone of claims 16 to 18 wherein a plurality of said tickets are formatted and queued to print on a single sheet before said ticket is printed.
20. A system as claimed In anyone of claims 16 to 19 wherein an operator selects said template from a library of templates.
21. A system as claimed in anyone of claims 16 to 19 wherein said product data Includes the template to be used for said ticket.
22. A system as claimed in claim 21 wherein said product data input is operated to select said template.
23. A system as claimed in any one of claims 16 to 22 wherein prior to printing, said data processing unit batch sorts said tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period fs exceeded, or the user manually indicates that the queuing sequence is complete, and then said data processing unit prompts the operator by the display to load the required print-stock so said tickets can be printed.
24. A system as claimed in any one of claims 16 to 23 further including a plurality of said printers each loaded with different print-stocks, wherein said data processing unit selects said printer to use based on said template selected.
25. A system as claimed in any one of claims 1Θ to 24 further including the step of recording and storing on said memory information relating to the printing of said ticket.
26. A system as claimed In claim 25 wherein said recorded data is transmitted to a remote server.
27. A system as claimed in ciaim 26 wherein said data processing unit compares said stored data with predetermined triggers, and if a said trigger is found said data processing unit sends an alert message.
28. A system as claimed in claim 27 wherein said alert message is automatically sent to nominated users via SMS text message, email, or Instant Message.
29. A system as claimed in any one of claims 16 to 28 further Including a camera, said camera arranged to capture images of said ticket.
30. A system as claimed in claim 29 'wherein said camera captures video Images.
31. A system as claimed in claim 29 or claim 30 wherein said camera is arranged to capture images before said ticket is printed and after said ticket is replaced.
32. A system as claimed In any one of claims 29 to 31 wherein said camera captures video and/or still Images at predetermined intervals.
33. A system as claimed in any one of claims 29 to 31 wherein said camera captures video and/or still images continuously.
34. A method of preparing tickets for product items stocked in a warehouse or retail store, including: providing a portable product ticketing apparatus Including a data processing unit interfaced with a product data input to receive unique identification data identifying a product, said data processing unit having access to or being Interfaced with a memory containing a table of products and correlating unique identification data for each of said products, said data processing unit being operable to compare received unique identification data identifying a product with unique identification data in said table of products, said data processing unit being Interfaced with at least one printer, and being operable to send data to said printer to print a ticket of predetermined format containing a product description and other information pertaining to the product derived from data in said table of products correlating to unique identification data in said table of products, inputting unique identification data identifying a product via product data input, comparing the input unique identification data with unique identification data in said table of products, retrieving data from said table of products and sending to said at least one printer to print said ticket.
35. A method as claimed in claim 34 wherein said product data Input l$ interfaced with a barcode scanner or RFID tag reader and said unique identification data identifying a product received by said product data input is derived from a barcode or RFID tag attached to or located in physical proximity to said product.
36. A method as claimed in claim 34 or 35 wherein said table of products includes for each product, in, addition to data correlating to the product description and its correlating unique Identification data, a flag as to whether a ticket should be printed for said product, wherein said method, said data processing unit is operable to send data to said printer to print said ticket only if said flag indicates a ticket Is allowed to be printed.
37. A method as claimed in anyone of claims 34 to 36 wherein in said method, said data processing unit is operable to receive a plurality of received unique identification data identifying a plurality of products, before queuing data to said at least one printer to print a plurality of tickets on a single sheet.
38. A method as claimed in anyone of claims 34 to 37 wherein said data processing unit Is interfaced with a print-stock selection input, which allows selection of print-stock for the printing of tickets.
39. A method as claimed in claim 38 wherein the print-stock selection for a product is included among data in said table, and said data processing unit queues selected tickets by print-stock type, for printing together on the correct print-stock.
40. A method as claimed in claim 38 wherein said print-stock selection input is operator initiated.
41. A method as claimed in claim 40 wherein said print-stock selection input is received from a or said barcode scanner selecting from one of a plurality of print- stock barcodes each correlating to an available print-stock type, said plurality of barcodes being printed and displayed on said portable product ticketing apparatus and being accessible by said barcode scanner.
42. A method as claimed in claim 41 wherein in the method, said data processing unit receives and correlates print-stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period Is exceeded, or the user manually indicates that the queuing sequence is complete, and then said data processing unit prompts the operator. by the display to load the required print-stock so the tickets can be printed.
43. A method as claimed in claim 41 wherein said at least one printer includes a plurality of printers loaded with different print-stocks, and said data processing unit receives and correlates print-stock selection and received unique identification data, and batch sorts data for tickets by print-stock type until a sheet of any print stock type is filled, or a predetermined time period is exceeded, or the user manually indicates that the queuing sequence is complete, and then said data processing unit causes the appropriate printer to print the tickets or prompts the operator by the dieplay to load the required print-stock in the appropriate printer so the tickets can be printed.
44. A method as claimed In any one of. claims 34 to 43 wherein Information relating to the printing from the apparatus including all attributes contained on the printed output and used to derive the printed oufcut, in addition to information Identifying the unique apparatus and its location are recorded.
45. A method as claimed in claim 44 wherein said recorded data is securely electronically transmitted to a centralised, off-site facility to be stored in a database with a plurality of other print records from a plurality of other apparatus (such as that described in this invention or otherwise)
46. A method as claimed in claim 45 wherein stored data is processed after having been received and used as the basis for reports and alerts made available to nominated people.
47. A method as claimed In claim 46 where, reports are either accessed on- demand via interface using a web browser to be viewed onlfrie or exported to file to be stored for later use or automatically sent' to the user based on pre-defined criteria such as email address, filter criteria for the report, frequency and the like.
48, A method as claimed In claim 45 where alerts are automatically sent to nominated users via one or a plurality of means, such as SMS text message, email, Instant Message protocol or otherwise based on criteria defined within said system. Such alerts may include text, URLs to additional Information, attachments containing additional information or a combination to provide the recipient with sufficient information to act.
49. A method as claimed in claim 454 where data stored from multiple devices may be aggregated to produce trend or summary information at varying levels of detail.
PCT/AU2011/000285 2010-03-16 2011-03-15 Product ticketing system WO2011113090A1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
AU2010901080A AU2010901080A0 (en) 2010-03-16 Product Ticketing System and Method for Warehouse and Retail Use
AU2010901080 2010-03-16

Publications (1)

Publication Number Publication Date
WO2011113090A1 true WO2011113090A1 (en) 2011-09-22

Family

ID=44648344

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/AU2011/000285 WO2011113090A1 (en) 2010-03-16 2011-03-15 Product ticketing system

Country Status (1)

Country Link
WO (1) WO2011113090A1 (en)

Cited By (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014183162A1 (en) * 2013-05-14 2014-11-20 Michael Hill Group Services Pty Ltd System and method of dynamic labelling
US20220300939A1 (en) * 2019-08-16 2022-09-22 Lingdong Technology (Beijing) Co.Ltd. Intelligent interactive module and trolley
WO2024023480A1 (en) * 2022-07-26 2024-02-01 Southgate Global Limited Improvements to a portable power and/or data supply apparatus

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5172314A (en) * 1991-05-03 1992-12-15 Electronic Retailing Systems International Apparatus for communicating price changes including printer and display devices
US5382779A (en) * 1993-05-07 1995-01-17 Digicomp Research Corporation Shelf price label verification apparatus and method
US6182053B1 (en) * 1996-03-26 2001-01-30 Recovery Sales Corporation Method and apparatus for managing inventory
US20050035198A1 (en) * 2003-01-23 2005-02-17 Wilensky Craig A. Mobile wireless computer system including devices and methods related thereto

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5172314A (en) * 1991-05-03 1992-12-15 Electronic Retailing Systems International Apparatus for communicating price changes including printer and display devices
US5382779A (en) * 1993-05-07 1995-01-17 Digicomp Research Corporation Shelf price label verification apparatus and method
US6182053B1 (en) * 1996-03-26 2001-01-30 Recovery Sales Corporation Method and apparatus for managing inventory
US20050035198A1 (en) * 2003-01-23 2005-02-17 Wilensky Craig A. Mobile wireless computer system including devices and methods related thereto

Cited By (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
WO2014183162A1 (en) * 2013-05-14 2014-11-20 Michael Hill Group Services Pty Ltd System and method of dynamic labelling
US20220300939A1 (en) * 2019-08-16 2022-09-22 Lingdong Technology (Beijing) Co.Ltd. Intelligent interactive module and trolley
EP4015345A4 (en) * 2019-08-16 2023-08-02 Lingdong Technology (Beijing) Co. Ltd Intelligent interactive module and trolley
WO2024023480A1 (en) * 2022-07-26 2024-02-01 Southgate Global Limited Improvements to a portable power and/or data supply apparatus

Similar Documents

Publication Publication Date Title
US5640002A (en) Portable RF ID tag and barcode reader
CN100550048C (en) Document management apparatus and file management system
US9135542B2 (en) Handheld scanner device with display location database
US8429004B2 (en) Method and system for automatically measuring retail store display compliance
US20180365642A1 (en) Systems and methods for facilitating parcel pickup
WO1996039674A1 (en) Bar code scanner and id tag information gathering device
CN103177362A (en) Quick payment system for supermarket shopping and application method of system
US20230042303A1 (en) Reusable food or beverage related product management system
US20200320474A1 (en) Computerized systems and methods for buffered inventory management
US20100036674A1 (en) Method for shipping deliveries; shipping station and logistics system
JP2010134635A (en) Electronic shelf label and product management system
US9053452B2 (en) Supply ordering system and method
JP5386530B2 (en) Order station and order receiving device
CN111080184A (en) Intelligent terminal warehouse-in and warehouse-out management method and management system thereof
JP2014526073A (en) Product level management system
KR20050115250A (en) Networked waste processing apparatus
WO2011113090A1 (en) Product ticketing system
CN203894810U (en) Intelligent self-service ordering system based on wireless technology
US11070684B2 (en) Retail photo order production and workflow management system and methods of use
CN202217354U (en) Self-service sale service terminal in supermarket
EP3817460B1 (en) Information processing system and method
JP2009128992A (en) Management system, management method, management server, store terminal, and computer program thereof
CN113673929A (en) Task reminding method and device, electronic equipment and storage medium
CN111563605A (en) Battery management system and method
US11968334B2 (en) Multi-user retail photo product creation system and method of use

Legal Events

Date Code Title Description
121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 11755550

Country of ref document: EP

Kind code of ref document: A1

DPE1 Request for preliminary examination filed after expiration of 19th month from priority date (pct application filed from 20040101)
NENP Non-entry into the national phase

Ref country code: DE

122 Ep: pct application non-entry in european phase

Ref document number: 11755550

Country of ref document: EP

Kind code of ref document: A1