Ask POSGuys - How do I do basic inventory management in Excel?

preview_player
Показать описание
The post-holiday inventory season is in full swing. Travis shows how to scan products and then set up a basic spreadsheet of scanned part numbers with a total quantity next to each relevant part number. Skip the intro, jump to the Excel file setup 02:34

We do not cover importing the spreadsheet to your point of sale or inventory tracking software in this video. Check out your software manufacturer's resource library to find specific software import file requirements. (.csv, .txt, .xls)

Featured Scanner: Symbol CS3070

Featured Software: Microsoft Excel 2013

  1. POSGuys.com
  2. inventory management excel
  3. excel
  4. inventory
  5. stock management
  6. scanning inventory
Рекомендации по теме
Ask POSGuys - 0:06:32

Ask POSGuys - How do I print a document by scanning a barcode?

Ask POSGuys - 0:09:14

Ask POSGuys - How do I do basic inventory management in Excel?

Ask POSGuys - 0:03:27

Ask POSGuys - How do I setup mobile coupons? (part 1)

Ask POSGuys - 0:02:46

Ask POSGuys - How do I pair the LI4278?

Ask POSGuys - 0:01:44

Ask POSGuys - How do I use a USB Scanner with an iPad?

Ask POSGuys - 0:02:02

Ask POSGuys - How do I pair the CS3070 with my iOS7 iPad?

Ask POSGuys: How 0:05:52

Ask POSGuys: How do you track attendance with Excel and Barcodes?

Ask POSGuys.com - 0:01:19

Ask POSGuys.com - How to Use Tabletop Media in Desktop Label Printer

Ask POSGuys: How 0:04:31

Ask POSGuys: How does a tablet print to a kitchen printer?

Ask POSGuys - 0:01:14

Ask POSGuys - Can I still use my Bluetooth Scanner with iOS7?

Ask POSGuys - 0:01:29

Ask POSGuys - Do I need a 2D scanner?

Ask POSGuys - 0:02:58

Ask POSGuys - How far can you extend a USB Barcode Scanner

Ask POSGuys - 0:02:23

Ask POSGuys - How do I turn off the OPN2005 beep?

Ask POSGuys - 0:01:19

Ask POSGuys - What is a dispenser or peeler on a barcode printer?

Ask POSGuys - 0:02:17

Ask POSGuys - How do I shut off suggested words in Windows Mobile 6.5?

Ask POSGuys: How 0:06:20

Ask POSGuys: How do Impact and Thermal Receipt Printers Compare? (U220 vs T88V)

Ask POSGuys - 0:04:52

Ask POSGuys - Can you improve a 1D barcode?

Ask POSGuys: How 0:05:44

Ask POSGuys: How to configure Datalogic Heron custom sound

Ask POSGuys - 0:01:09

Ask POSGuys - How do I change the scanner's beam width? (Symbol/Motorola/Zebra Brands Only)

Ask POSGuys - 0:02:39

Ask POSGuys - How do I open a cash drawer with no keys?

POSGuys How To: 0:05:49

POSGuys How To: Configure a Barcode Scanner to Skip Character Patterns

Ask POSGuys - 0:03:15

Ask POSGuys - What is the difference between desktop and tabletop barcode printing media?

Ask POSGuys: How 0:09:47

Ask POSGuys: How to configure Datalogic Heron LED Colors

POSGuys How To: 0:03:09

POSGuys How To: Set Up A Barcode Scanner

Комментарии
Автор

im using a honeywell 1200g scanner with excel. I've got a problem everytime i scan 1 barcode it will jump from line1 to line3 then line5 etc. But with notepad it is fine and will get to next line. You know how i can fix this issue and have excel scan to line1, 2, 3, 4....etc

jamesali
Автор

hi how do i connect the scanner to tablet?

BLAZINBEATS
Автор

How do you get the UPC to generate on a new line every time you scan? We're attempted something similar but instead of it entering the UPC on a new line it simply adds the numbers without a space on the same line. Any insight would be great.

zak
Автор

can I scan these numbers straight into an excel document?

jamiecozzie
Автор

My skus are alpha numeric how do i get excel to count?

anilanakrawala
Автор

why didn't you just scan into excel? miss step one entirely

dagnut