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:

**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 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:
Datalogic QuickScan Presentation Video:
More info about barcode scanners:
Additional Resource for You;
Create UPC barcodes for FREE:

Nguồn:https://curbjumperstreeteats.com/

44 Comments

  • Hey! How to delete inventory using bar code scanner?

    Nick Silny
    Posted February 14, 2020
  • How do we then "Scan Out" items from the inventory when we want to use the? (ie. reduce the number when scanning barcode)

    Thanks!

    BJ
    Posted February 14, 2020
  • 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

    RIZWAN ALI YASIN
    Posted February 14, 2020
  • 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

    geovanny carvajal
    Posted February 14, 2020
  • how to insert 10,000 data different Qr Code Help Me

    Global Print Connection
    Posted February 14, 2020
  • Great video!! I own an Inventory auditing business in which we are constantly looking for a better way of comfortably taking item level counts. We even have a voice activate windows based system that works but with quirks. Could you please contact me to discuss equipment? Thanks! Scott G. 704-657-6152

    Goodman Beach House
    Posted February 14, 2020
  • I feel like an idiot sometimes. I watched your video 20 times yet I am Thank you.
    confused. You clicked and installed a header called "Barcodes". Did you just insert a cell there? When you go to sort I assume you put a checkmark in "My list has headers? Then when you sort it has two more questions 1) sort anything that looks like a number as a number 2) sort numbers and numbers stored as text separately
    I didn't see you do any of that. I am on Mac with Office 365. Thank you. If I want to buy things can I go to your website?

    Rick McCulloch
    Posted February 14, 2020
  • is there a scanner that allows you to input the number of pieces? eg. there are 50 pieces in one box, with one bar code, but shipment is based on number of pieces generally, not boxes. Is there a way I can input the number of pieces from the scanner to make it faster than manually inputting the numbers later?

    Jacob Youngpeter
    Posted February 14, 2020
  • Can we do that in an android mobile or tablet? I can't find the subotal function in the android excel

    periklis z
    Posted February 14, 2020
  • How to remove the count from the code

    Sean Hayes Love one another. As I have loved you,
    Posted February 14, 2020
  • Just use a pivot… And a helper table with barcode and name… This is absolutely no way to keep track of inventory…

    Nard Cox
    Posted February 14, 2020
  • i wanna use excel as a quick and dirty inventory control program. how could i had this automated to the point of simply scanning it and it'd add it to the stock quantity? or vice versa to remove from stock quantity when sold? it is possible, so don't try to sell me your product no matter how nice it may be i don't need 99% of it's features.

    Don Mega
    Posted February 14, 2020
  • 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).

    Boudoir Bizarre
    Posted February 14, 2020
  • thank you so much boss

    Selvakumar M.G.R
    Posted February 14, 2020
  • 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

    Shakil Khan
    Posted February 14, 2020
  • I think excel is good for certain level but can't be the best option for inventory. With limit functionality it becomes are hard later in the business. Instead you can try HDPOS. It have inventory alongside with billing, accounting and tax Checkout at: https://bit.ly/2C0u7C9

    Div Jangid
    Posted February 14, 2020
  • 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.

    Bam Bahadur
    Posted February 14, 2020
  • cheap quality dependable office scanner … https://amzn.to/2oa4ypY

    BLACK MATATA
    Posted February 14, 2020
  • You make the super video I like it video

    vishal k choudhary
    Posted February 14, 2020
  • 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.

    Nathaniel Montgomery, Sr.
    Posted February 14, 2020
  • There's no need to select all the barcodes prior to the sort; you need only select one cell among the data.

    Abbott Katz
    Posted February 14, 2020
  • How about if you want to count these items by cases or does it only counts it by eaches?

    tEiNe SaMoA
    Posted February 14, 2020
  • hello every one , i am an industrial engineer in a garments industry, currently we are facing a severe issue regarding data collection (the number of pieces produced on each operation by operator) to make timely payments for operators as we have piece rate working. the problem is that when our data collecting guys visit production floor, there they dont get exact number of peices produced by operator this way the working of one operator being noted in the account of other operator, so we are in search of a solution through a simplest and cheapest bar code system, if any one here can help us please contact me on 923366561551 from out of pakistan, and for those residing in Pakistan can contact me on 03366561551.

    Noor Ali
    Posted February 14, 2020
  • How would you scan out? Please

    John Damage
    Posted February 14, 2020
  • Just what i was looking for, thanks

    John Damage
    Posted February 14, 2020
  • U don t upload the video how these barcode delete process. Because i m in problem like this

    Kumar Shrestha
    Posted February 14, 2020
  • 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?

    Alyvia Steenhoek
    Posted February 14, 2020
  • 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

    Boldzest
    Posted February 14, 2020
  • When i scan my barcode scanner over barcode, the 0 that comes at beginning of UPC dissapeared in the cell, what do i do

    Jennifer R
    Posted February 14, 2020
  • I'm not a genius with this mate but whenever i start scanning, my item will move to the side instead downwards. How do ensure when it scan, it will go downwards?

    Ahmad Daud
    Posted February 14, 2020
  • 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 #

    Jennifer R
    Posted February 14, 2020
  • Which scaner gun are you using

    Ernie Zamora
    Posted February 14, 2020
  • 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

    bam4pro
    Posted February 14, 2020
  • 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?

    Evolve Arts MA
    Posted February 14, 2020
  • what if we need to have the name of the product rather than numbers

    Muhammad Hammad
    Posted February 14, 2020
  • 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?

    Norman Bataille
    Posted February 14, 2020
  • Hello good evening I want to scan mobile phone with barcode how I can do for expmale I have one box 20 pcs how I can scan that plz help me.

    AMIN khan
    Posted February 14, 2020
  • thank you for the info and helping out a small business!!!!

    Kirsten Turner
    Posted February 14, 2020
  • Hello I m working as store keeper in mobile company and I m scanning every day around 20000 imei# with scaner datalogic and I don't know how fix the formula for qunting the imei#plz tell me how I can fix that for example if I scan 40 imei# that file on top showing 30 only .

    AMIN khan
    Posted February 14, 2020
  • Is there a system that can do count while recording what time it was scanned too?

    Austin Semeta
    Posted February 14, 2020
  • Very good training. THANKS.

    MUNBYN POS
    Posted February 14, 2020
  • my excel cant read barcode scanner

    Abdelrahman Refaat
    Posted February 14, 2020
  • 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?

    Muhammad Hammad
    Posted February 14, 2020
  • How can i create barcodes in MS Excel?

    Soumya Roy
    Posted February 14, 2020

Leave a comment