How can I use a code (such as a combination of numbers) and make it identify something?

How can I use a code (such as a combination of numbers) and make it identify something?
I own a little shop, and I have items labeled by 5 numbers (so, like 01234 or 12345 or 56789 something like that, but in combinations)

You know in shopping malls, such as walmart, or anywhere where they use barcode, the scanner scans it, identifies the number, than looks into the inventory that matches that number.

Is there any way I can do something like this? Instead of using barcode, I will manually but the numbers in the computer. It has to be a computer software.

Can I use Excel, Word, or is there some kind of free software out there?

Here are my steps:

1. A customer selects a product
2. I enter the 5-code number labeled on it using a number pad to the computer (NO BARCODE OR SCANNER IS USED)
3. The computer software then uses the number to find the NAME, AND THE PRICE of the number, and shows it on the screen.
4. A receipt of some sort is printed.

That’s basically the end of it……

I also have another question. Is there a software where I can print receipts?
I need receipts the size of a normal one, not like a letter size receipt.

Thank you!

Best answer:

I am not sure about the receipt part, but if you have all the information saved in an Excel or Word file, it would be as simple as using the find function. Just hit ctrl+f, type the number you are looking for, and hit the “find next” button. That would take you right to the location where the product number is listed. It isn’t a very technical solution, but it may help.

Tags: , , , , ,

Under Forum

1 Comment for How can I use a code (such as a combination of numbers) and make it identify something?

  • 1. garbo7441  |  March 17th, 2007 at 7:21 pm

    The best way to approach this would be with a custom Excel invoice template. Set Sheet1 up as an invoice and Sheet2 with a number/catalog number/price table containing all your items.

    Then, use VLookup functions to import the invoice details when a number is keyed in. Pricing, extensions, and totals (including a tax/no tax routine) would all be automatic.

    Unique invoice numbers could be generated automatically. Invoice printing could be done with a command button macro.

    I don’t understand how you intend to print a non ‘letter’ invoice. Most standard PC printers print either letter or legal, portrait or landscape. It would actually be advisable to print the invoice twice on one letter sized printout, saving one copy for your files.

Leave a Comment for How can I use a code (such as a combination of numbers) and make it identify something?

You must be logged in to post a comment.

Trackback this post  |  Subscribe to the comments via RSS Feed

Categories