Excell

Question

I found this online.

Barcode Scanner Wireless & Wired Handheld, Turimon Rechargeable Barcode Reader Scanner, USB Quick Laser Barcode Scanner Gun for Library Book, Warehouse Inventory, Store Price Tag

I am selling puzzles and they have a UPC code on them. 

I want to start a spreadsheet for my puzzles in my Excess 2019 program.

I have been told if I buy a Scanner/Reader I will be able to use the Reader to access the information on the UPC Code.

If this is correct, I would like to use the reader to gather the information and download it to my computer into a spreadsheet that will keep track of my inventory.

Is this possible? If it is, what do I need to purchase for that to work?

How much information is on a UPC code number on my puzzles?

Answer 1

Hi, You can still use excel to make your inventory manager. To show you how to do one here might not be possible, but I could direct you to find tutorials on " How to create simple IN and OUT Inventory System in Excel" . You will find some tutorials on that on popular online video sites. if you use a shared document online that is well created with protected cells you can achieve usage by another individual. Eventually, though, you will realize that a proper inventory management system will be a necessity especially if your inventory and sales increase.

Answer 2

Okay I looked at pricing of MS Access and at this time that is not an option. So if I use Excel and put the UPC code into one line and put other information in other lines will that work? If yes, I would have to put each barcode into a spreadsheet. Then I would put a picture so I know what one it is. Then there would have to be a quantity row. Then one is sold at the market. How would that work? Would they need the computer there to scan it sold?

Answer 3

Hello LeanneMeyer1,

Consider a barcode scanner as an input device. The UPC is usually accompanied by a set of numbers/characters at the bottom. These are unique numbers that can be used to identify product types, for example, puzzle types ABC will have the UPC code PZX-123456

in short, the UPC is the product ID. Using Excel with a Reader/Scanner, you will only be inputting that code. If you used the same on a database-driven application, say MS Access[ staying within Microsoft products] and you created forms that will assist you to have meaningful interfaces, using the Reader/scanner would help you retrieve more information stored in the database based on the UPC code and thus help you better with the Inventory management.

What you would need to buy is a scanner compatible with your OS. The handheld USB scanner is best in most cases.

I hope I have covered most of your concerns but don't hesitate to ask if you need further clarification.

Kind regards.