How to Track Inventory in Excel with a Barcode Scanner | POS Catch Tutorial Inventory in Excel
Вставка
- Опубліковано 26 сер 2024
- How to Track Inventory in Excel with a Barcode Scanner.
PLEASE READ: *This tutorial shows a quick way to easily count/track UPC barcoded items in an Excel spreadsheet with a barcode scanner. This tutorial is not intended to offer a complete inventory control solution with Excel. If you need the ability to add item barcodes from batch-in files, or automatically deduct barcoded items from inventory category count totals, or have complete item descriptions pull from database records, for example, then it is recommended that you get a dedicated inventory control software program for those functions if needed. You can view our wide selection of inventory control solutions at this link: bit.ly/2m5fovm
**At this time, we do not offer additional Excel macros or any other type of spreadsheet modifications to expand functionality.
***Before sending us a question in the comments section below, please be sure to read previous questions by others first to see if any are like your question.
POSCatch.com presents to learn how to easily and cost-efficiently keep track of inventory or assets with a barcode scanner and an Excel spreadsheet. This video tutorial will also show you how to scan barcodes into an Excel spreadsheet.
The barcode scanner we use in this video is a plug n’ play Datalogic USB barcode scanner.
Featured barcode scanner, Datalogic QuickScan, details: bit.ly/1UJ2kHe
Datalogic QuickScan Presentation Video: • Datalogic QuickScan QD...
More info about barcode scanners: bit.ly/2bpmZEq
Additional Resource for You;
Create UPC barcodes for FREE: • How to Track Inventory...
Follow us for more point of sale product presentation, reviews and more!
Facebook - / poscatch
Twitter - / poscatch
Instagram - / poscatch
#howtotrackinventory #howtotrackinventoryinexcel #barcodescanner
![How to keep Inventory using an Excel Spreadsheet - [create your own Template]](/img/n.gif)
am using a barcode scanner to read in barcode numbers into excel. But everytime after I scan a barcode, excel moves to the cell in the next row. What I want is moves down to the next column. Anyone with information please help.
Excel is not doing that, your barcode scanner is. Check the user's manual of your barcode scanner to see how to program it to perform the function you want. Or you can contact the manufacturer's tech support of your scanner and ask them for help.
@@Poscatch I saw the automatic bottom cell being selected while scanning in this video of yours. The cell on the right is selected when I use the barcode scanner.
Carriage Return or CR needs to be set on the terminator field of your barcode scanners setup.
It basically acts as if you were pushing the Enter key on your keyboard.
Try to setup enter function
You can probably try ua-cam.com/video/Eba5oZl0fGo/v-deo.html
How do I decrease my inventory if I scanned?
Thank you so much! Do you have a video explaining how to put an identifier so that the scanner says what the item is once we have scanned it? Thanks a bunch!
Great video. Is this only for taking a one time inventory, or is there a way to keep a running tally and scan in additional items down the road that will be added to the running total?
Have you managed to find out this?
@@Cra19y1 This was a while ago but I set it up to add the barcode to a column everytime it was scanned, then used a formula to count the number of times each number appeared and spit it out in another cell for each item.
I don't understand how the scanner scanned the info to the sheet. How did you connect the scanner to the sheet? And how can you use this as a pos record to record what you sell.
love it - you can type or obtain a list of items then and paste them in the sheet and index i believe. that way the description pops up.
Excellent video. Well explained and easy to follow. Please what if i have a lot of stuff to count but the barcodes are item specific?
Great tutorial, easy to follow, in just a few minutes you will learn to Track Inventory in Excel with a Barcode Scanner.
Great Sir Thankyou very very much❤
Dear lord thank you for this !!!
Thanks for your great video
Hi there it was great watching the video.
With this video it will record the inventory.
How to keep a track of outgoing inventory please
is it possible to have : multiple bar code readers scan barcodes to different areas or boxes depending on the bar code scanner used?
Thank you for this video! I work in order processing and quality assurance and was tasked with finding a good system to inventory with a scanner. Excel and google sheets are officially my best friend.
after you ad item descriptions in that extra column you added, would that pop up later if I scanned the bar code?
Do you know how to start a new count for an item that has a previously used barcode? Like if you get a new shipment of inventory that has the same barcode as a previously used shipment, is it possible to start a new count?
How do we then "Scan Out" items from the inventory when we want to use the? (ie. reduce the number when scanning barcode)
Thanks!
I wanna know that as well.. do you have a answer on that question already?
how do you scan items out?
How would you scan out? Please
so after you do this part, how do i set it up so that i can use my barcode scanner to scan the barcodes of the things i'm pulling from my inventory or when i get new inventory in to add it to the sheet easily without having to manually enter everything. I'm looking for something that i can scan my barcode, it registers it and can subtract ex. 2 shirts from my stock if i need to pull 2 shirts.
Is there a base for this to be able to communicate with the computer?
Will this work with Ford part numbers?
can you use a basic bar code scanner that I bought for 10 bucks on amazon?
thank you for the info and helping out a small business!!!!
Just wanted to ask, my barcode scanner can detect by Hercules serial , but I can’t detect on my software serial input. Is this has to do with port 2,3 RC , TX reverse problem ? The programming software only have serial input selection and setting such as baud rate same as scanner but still can’t trigger
Is this no need any driver or software install on data logic power scanner 9330 series ?
I have a big clothing inventory, all barcoded, and I just want to use this to list contents in each bin. If I have 50 bins, can I use 50 columns, one for each bin and scan items under each bin? Wouild that work?
Great video. How can i assign the barcode to product name? Can ya advice any formula? Thanks
Add a new tab with two columns for unique barcodes and product names - use columns A and B, respectively. Call the tab Product LKU TBL. Then in the first tab with all the scanned barcodes, in next column over use =VLOOKUP(A2,'Product LKU TBL'!A:B,2,FALSE). This assumes the scanned barcodes are in column A.
@@crazysleepintime Thanks alot.
Looking for help with scanning barcoded assets In & Out . List of assets, their barcode numbers and date/tim scanned in date, date/ime scanned out. To track expensive tools etc
How can I have this track incoming and outgoing items being checked out at the cash-register? We do not want to use a cloud based product.
HI,how I can remove products that I use from the stock with the scan reader ,please?
I want a barcode which will scan the description on the excel sheet . Any idea ?
Do bar codes match SKUs ?
hi, if the barcode entered is the same in a cell 2nd time then increase only the quantity in "quantity" but not go down unless new barcode enters. How to do this? or from VBA code you can guide me?
I am based in UK and I like your inventory video, it is something I think I might us. How do I get my scanner is connected to my PC.
Please watch this video to see how: ua-cam.com/video/tvCSeX0abJg/v-deo.html
hola buen dia, te hago una consulta tengo una lectora symbol ds6878 la base enciede y luego de 2 segundos se apaga, sera q tiene que leer algun codigo para solucionarlo, saludos desde argentina
if i enter manually barcodes in this sheet than the sheet manually entered barcodes are showing in one by in diff column, so kindly help me if i scan barcodes with barcodes scanner or manually barcodes enter quantities showed in a column.
please advise i have date on excel sheet with barcodes and then i want to scan check the item excel to match with barcode scanner how to do this
Interesting and informative, very interesting to see how it is done in Excel.
As an aside, you seem to have made a lot of people unhappy and I for one can't understand why.
Thanks Wallace
Can we do that in an android mobile or tablet? I can't find the subotal function in the android excel
Is it only use that barcode scanner tools and Excel ?
I love your volume
Thanks for sharing. Have you any ide why, when my Zebr MC3300 is paired with BT does not send the information to the excel sheet opened. I getting crazy :) Any help is appreciated
Be sure that your portable data terminal is set to transmit in keyboard emulation mode. Verify that the cursor is in the cell where you want to input the scanned data; wherever the blinking cursor is at on your screen is where the scanned data will go. You can also test this by opening Notepad and attempt to scan into that. If this does not resolve the situation, then contact Zebra tech support for additional assistance.
Hi, is there a way to scan a barcode, and locate it within excel? Say, you already added in several barcodes, but when you scan it again, it takes you right to that cell, rather than adding it to the excel sheet?
How about if you want to count these items by cases or does it only counts it by eaches?
This is great! I need to capture barcodes and get a total of codes as each is unique. Is there an easy way to set this up to do that - I don't need the subtotal as each are unique.
How to turn on the auto scroll down function, because everytime I used enter button, please reply asap
Lol “please reply ASAP”.
Our scanner can scan or very well
thank you for helping me
So, I watched your video because I'm looking for a way to simplify our inventory every year. I have everything already loaded into excel as far as inventory including quantity and pricing. If I use this scanner, do you think it will also allow Excel to automatically calculate the pricing (sum) without me having to do it manually? Right now I have to edit the quantities every year one by one and it automatically calculates the sum. I'm just looking for a way to simplify this process. So, I guess what I'm wondering is if Excel will still be able to calculate the totals automatically or if I will need a separate inventory software to do this. Any help is appreciated.
Is there a system that can do count while recording what time it was scanned too?
Just use VBA in excel, heres some leads.
First)
This scanner automatically pastes (I assume) the data it scans, detect it. stackoverflow.com/questions/12525942/how-to-detect-paste-event-in-excel
Second)
You can use ActiveCell in VBA and Offset to go to the cell on the right from the one scanner just wrote and then do ActiveCell.Value = Now . www.excel-easy.com/vba/date-time.html
Now should return current time, so you ll have your code in one cell, and time in another next to it if to set it up like this. Of course theres other ways to do it, VBA is powerful
docs.microsoft.com/en-us/office/vba/excel/concepts/cells-and-ranges/working-with-the-active-cell
The count for other barcodes are not correct. How do I make sure when I scan in a barcode they will automatically be counted under the same barcode. My reason for asking is, I scanned in three different barcodes, just one of them show a how count, the rest displays, a count of 1. Can you help point me in the right direction? Thanks a million.
Hello,
when you scan a code, the reader sends a CR + LF, Excel populates the cell and passes to the cell below.
Which parameter should I activate, because the cursor remains at the end of the code, it does not go to the next cell, neither to the right nor below.
thank you,
bernard in France
Thanks for making it so easy
Thanks, Saved me a lot of work.
very good lesson and fine explanations, thanks for all you help Sir.
Thank you for your feedback. Also, be sure to view some of the other video tutorials on our UA-cam channel.
Just what i was looking for, thanks
We have been trying to find a solution for tracking our work orders as they go through our manufacturing process. Basically, we would like to use bar code (generated from order #) to track when the order leaves the following stages: Order Entry, Cutting, Sewing, Assembly, Shipping. Your video intrigued me because it's somewhat headed in the right direction for us. However, I would like to capture the date of the scan. And possibly need separate scanner set up for each stage. Thoughts or recommendations?
I’m trying to find out the method. By any chance have you found the solution to the problem?
Hi! I'd like to use barcodes for a specific use, not what it was meant to be used for and maybe you can help me.
Let's say you have 10 clients, and I assign to them 10 different barcodes. You also have 100 different boxes, each with a different barcode aswell.
I want to be able to scan client 1 and then scan boxes 1, 2, 3, 4 and assign them to him. Then scan client 2 and assign 5, 6, 7. And so on.
I cannot do this beside a computer, so maybe I can do the scanning with a cellphone and google spreadsheets. Or maybe you have a better idea. I don't need to see the results in the exact moment I'm scanning.
So, my 2 questions are how I can do the scanning associating clients + boxes and how I can do this without being beside a computer.
Thanks a lot!
I was put forward for a role within the Processing area which will consist of data inputting, unpack aging, repackaging, use of handheld scanning guns, manual stock movement. Is this the data inputting part? First time warehouse work.
Hello, yes, In N. America retail products have a UPC barcode and in Europe and other regions they have an EAN barcode. These barcodes are unique product identifiers for specific products. However, there are many other types of barcodes. Code 128 can contain a lot of information and is often used for logistics and asset tracking. But no matter what the barcode is on or its type, the functionality doesn’t change… and that is to track an item accurately.
POSCatch.com
Very good training. THANKS.
Thank you !!!
Brilliant, thanks, at last I can now use my scanner... ;-)
I love you bro
my excel didn't give me the option for subtotal when I go to Data. plz help
Is there a method similar to this in Google Sheets?
How can I rest from inventory using the scanner?
Hello Sir,
I do have one problem, when I scan the bar-code, the cell jumps to another 2 cell, like A1 to A3, but supposed to be jump into cell A2, (Excel 2013) Please need your help and Thanks in Advance.
Hello, Do you know if the barcode actually contains information about the product (in this case vitamin, brand X, product Y) or is it that the barcode needs to be assigned to each of the manufacture's database (for logistics purposes maybe) and also store's database to track inventory and assign prices?
Hello, a UPC barcode does not contain any product data; it is simply an item identifier. You must assign what the item is into Excel as shown in the video tutorial. Or, if you are using a POS or inventory software program, you will need to add an item description to the program’s database unless the barcoded item has a certified GS1 UPC # that has been added to open distribution databases that some POS and inventory programs can pull product data from. For more details about UPC barcodes, please visit poscatch.com/upc-code-generator/
For logistics purposes you can use a Code 128 barcode and encode any combination of ASCII characters up to 128 characters into the barcode. You can create a Code 128 barcode for free here: poscatch.com/barcode-generator
is there a limit as to how many items can be scanned?
THANKS!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
HOw can I make in EXcel a check in and check out system and a list of user , example to assigne a device witha barcode to an user?
Our tracking time & attendance in Excel video may help you: ua-cam.com/video/UkYDcHSCQ2Q/v-deo.html
Hi there, and thanks for the great vid. I have been tasked with taking on stock items specifically old comic books. There are 1000;s of items, and I have to capture all details (eg isbn,title,price) is there a way to scan these directly into excel, or do i need POS software? thanks
Hi Steve, sounds like you will need a complete inventory solution. You have way too many products and product identifiers to track in Excel efficiently. We have some great complete inventory solutions. You can check them out here: poscatch.com/inventory-tracking-solutions/
thanks. much appreciated :)
can it scan a tracking number? I need to upload a bunch of usps tracking.
Yes, you can do that.
THANK YOU VERY MUCH!
how to use barcode if it is duplicate ( for duplicate it should sound )
Would excel work to setup scanning admission tickets for an event...?
(No I don't want any of those ticket sales website online or cloud apps for my phone, so plz don't go into that).
Is there any video you could suggest for an inventory that isn't a count. I need to use excel to track individual barcodes against a printed report and they are all different.
Hello, to compare 2 different databases in Excel, you will need to program excel with a formula that will allow you to that function. Unfortunately, we do not give advice on Excel macros at this time. You could do a search on UA-cam for tutorials on this topic.
Great can I get my spreadsheet back from COSTCO?
Hey man, what kind of barcode scanner support this? Any kind also support? or dedicated barcode scanner
Up
is there a way to use your phone as the scanner instead of buying one. This video was posted a little over 4 years ago and would like to know if there is a better system in place now? or any better apps or sites for small business.
There are phone apps now (and also 4 years ago) that can perform this functionality; however, there is usually a fee associated with them, and they can be cumbersome to use because a phone's camera is not ideal for frequent barcode scanning. A way around that is to purchase a Bluetooth mobile scanner; a good one will cost $150+. That said, this video was created specifically as a tutorial to show how one can for free do basic barcode tracking of items in MS Excel. POSCatch does offer phone barcode apps, nor do we recommend any at this time.
For a more advanced tracking solution for business, check out the AML LDX10 Mobile Batch CCD Scanner: poscatch.com/aml-ldx10-mobile-batch-ccd-scanner/
Thank you for the information! Appreciate all the knowledge and you time !!!
i am applying for a scanner coordinator at a grocery store. What advice can you give me so that I can be successful at it. I want to know what tools do I need, and etc
Hello, for more information about point of sale products, please visit our blog posts at poscatch.com/blog/ and also our buying guides at poscatch.com/pos-hardware-buying-guides/.
interesting information, what if you wanted to scan the price tag along the barcode
Hello, that can only be possible if you encode the price into a barcode, but unfortunately UPC barcodes do not include a product’s price. If you wanted to scan a product’s price and description, then a Code 39 or 128 barcode would work. A UPC barcode is generally only used as a product identifier.
If I have 3 different products can I use 1 barcode and just Duplicated for that one item and just buy two others for the remaining did too and duplicate for all the products that are the same
Different items must have different/unique barcodes for accurate identification.
Can this be done on iPad Pro? And use the camera to scan barcode? If so, how? Thanks.
Scan Karne Ke Automatic Next Line Kaise Aati Hai
In our inventory we have a scanning sheet on which gives the type, name, size, color and code of the product on scanning. How are we getting it?
Many questions here not answered. 😕
hi, how do u add more (same) items, having the same barcodes?
Hello, if you have more than one item with the same barcode, then you still need to scan each item in, or you can manually adjust the count total.
@@Poscatch How do I manually adjust? I don't want to scan 100 barcodes of the same item, I just want my subtotal for that barcode to say 100. I tried changing the formula in the spreadsheet (no worky). Or do I have to go into the main/raw data and copy/paste 100 barcodes in the spreadsheet?
How to setup?
This is a great video, but how come when I use my barcode scanner, it enters into say exp A2 it uses the formula, not the actual barcode #
Ensure your barcode scanner is functioning properly by test scanning into Notepad or some other similar application. Also, re-check your Excel formula.
Can anyone point me in the direction of doing this for not only a roster of kids but also inventory for a martial arts school?
Our tracking time & attendance in Excel video may help you: ua-cam.com/video/UkYDcHSCQ2Q/v-deo.html
You make the super video I like it video
Hello,
Does it only scan barcodes or can it scan serial numbers as well?
Hello, UPC barcodes are generally not used for tracking serial numbers. If you want to track serial numbers for logistics, then it is best to use a Code 39 (up to 39 ASCII characters) or Code 128 (up to 128 ASCII characters) barcode types. You can create these barcode types for free at this link: poscatch.com/barcode-generator. You can use the same methods as shown in the tutorial video to track Code 39 or Code 128 serial number barcodes in Excel.
thank you for the video, Do you know how can I modify the scroll on the scan? I need to move to the next column either row.
Help please!!! I though to do it by VB on excel but I don't have the code. thanks
Hello, at this time we do not provide additional Excel macros other than the one supplied in the video.
thank you so much boss
How far can you be away from the company
Hi.... Can we scan only numbers ?? thanks and appreciate
Hello, yes, a UPC barcode only contains numbers. If you wat to scan characters other than numbers, then you can use a Code 128 barcode, see this tutorial, ua-cam.com/video/UkYDcHSCQ2Q/v-deo.html ,but Code 128 barcodes are not used on individual products at the point of sale....only UPC barcodes are; however, you can use a Code 128 barcode for logistics tracking.
Last question just wanna confirm. ...I used to sell tickets/coupon without any barcode ...my ticket only consist Numbers ..Id like to do some inventory ..does it work?....a thousand thanks to u...
@Don Mega my whatspp...+6281364705341...lol
When i scan my barcode scanner over barcode, the 0 that comes at beginning of UPC dissapeared in the cell, what do i do
format cells into 'text' before you scan
U don t upload the video how these barcode delete process. Because i m in problem like this
Kumar Shrestha q--
How can i create barcodes in MS Excel?
download a barcode font