Go Back  FlyerTalk Forums > Travel&Dining > Travel Technology
Reload this Page >

Barcode Reader App for stock check

Community
Wiki Posts
Search

Barcode Reader App for stock check

Thread Tools
 
Search this Thread
 
Old Sep 25, 2011 | 11:10 am
  #1  
Original Poster
FlyerTalk Evangelist
10 Countries Visited
1M
All eyes on you!
20 Years on Site
 
Join Date: Jun 2004
Location: LON, ACK, BOS..... (Not necessarily in that order)
Programs: **Mucci Diamond Hairbrush** - compared to that nothing else matters (+BA Bronze)
Posts: 15,952
Barcode Reader App for stock check

Bit of an odd one here, we have to do monthly stock checks and rather than do them manually I'd like to use some sort of barcode scanner to make the process easier. The boss has an iPhone and we figured that the easiest way to do it would be a barcode reading app, but we can't find one that works the way we want. Ideally we're after one that will dump the contents of what was scanned (say just under a thousand items at each location) into a text file, comma delinted would be fine.

However all the ones that I've seen are aimed at people shopping who are looking for cheapest prices where the app looks them up online. does anyone know of one that would suit the task we need it to do?

Or we could just buy a barcode reader and hook it up to a laptop and do it that way however it's a bit bulky and not the best solution, although still portable and relatively cheap. So that would be the second solution if there isn't an app. Are any brands recommended? We're not looking to spend the earth here and would like to get something from Amazon like these
Jimmie76 is offline  
Old Sep 25, 2011 | 11:49 am
  #2  
All eyes on you!
20 Years on Site
 
Join Date: Jan 2004
Posts: 4,313
I can't help you from an app perspective, but there are plenty of devices available that will scan barcodes, save them internally, and allow you to dump the contents to a computer. See, for example:

http://www.barcodesinc.com/metrologic/scanpal2.htm

It would be cheaper to just stick a laptop on a cart and buy a barcode scanner that doesn't have its own memory, but certainly less convenient. I used these ages ago with a keyboard "wedge" interface, but it looks like USB is common now.

A middle option might be finding a battery-powered barcode scanner with a Bluetooth interface and pairing it with an iPhone or any cheap PDA. Then you could just move the text file it generates to your inventory system when you're done scanning.

As you can imagine, this is something that stores have been doing for a very long time, so fortunately you're not asking for anything novel. Some questions I would have for an iPhone-based solution would be how quickly does it scan, how accurate is it, how sensitive is it, and does the design make it comfortable for somebody to use it repetitively for a thousand scans?
blort is offline  
Old Sep 25, 2011 | 12:30 pm
  #3  
FlyerTalk Evangelist
40 Countries Visited3M100 Nights20 Years on Site
 
Join Date: Sep 2000
Programs: BA, AA, DL, KLM, UA
Posts: 37,489
Can you borrow two Android devices?

https://market.android.com/details?i...eexpproa&hl=en
ScottC is offline  
Old Sep 25, 2011 | 1:04 pm
  #4  
15 Years on Site
 
Join Date: Feb 2009
Location: WI
Programs: HHonors Gold, UAMP
Posts: 895
The best cost effective bet is going to be using a laptop and a usb reader. The using of a phone to do this task will be time restrictive due to it needs you to take a picture and then convert the picture to the data. Most of my readers can read for a good distance and it isn't going to be hampered by low light.
You could also look into getting a symbol series mobile device although those require programming and fairly expensive upfront, ebay can be your friend tho.

Using a phone is more for novelty rather then production.
davef139 is offline  
Old Sep 25, 2011 | 4:03 pm
  #5  
Original Poster
FlyerTalk Evangelist
10 Countries Visited
1M
All eyes on you!
20 Years on Site
 
Join Date: Jun 2004
Location: LON, ACK, BOS..... (Not necessarily in that order)
Programs: **Mucci Diamond Hairbrush** - compared to that nothing else matters (+BA Bronze)
Posts: 15,952
Originally Posted by ScottC
Can you borrow two Android devices?

https://market.android.com/details?i...eexpproa&hl=en
That looks interesting and something I'm going to investigate but getting an android phone or two, even pre-owned is pushing it. Neither of us are Android users.
Jimmie76 is offline  
Old Sep 25, 2011 | 4:25 pm
  #6  
Original Poster
FlyerTalk Evangelist
10 Countries Visited
1M
All eyes on you!
20 Years on Site
 
Join Date: Jun 2004
Location: LON, ACK, BOS..... (Not necessarily in that order)
Programs: **Mucci Diamond Hairbrush** - compared to that nothing else matters (+BA Bronze)
Posts: 15,952
Originally Posted by blort
I can't help you from an app perspective, but there are plenty of devices available that will scan barcodes, save them internally, and allow you to dump the contents to a computer. See, for example:

http://www.barcodesinc.com/metrologic/scanpal2.htm

It would be cheaper to just stick a laptop on a cart and buy a barcode scanner that doesn't have its own memory, but certainly less convenient. I used these ages ago with a keyboard "wedge" interface, but it looks like USB is common now.

A middle option might be finding a battery-powered barcode scanner with a Bluetooth interface and pairing it with an iPhone or any cheap PDA. Then you could just move the text file it generates to your inventory system when you're done scanning.

As you can imagine, this is something that stores have been doing for a very long time, so fortunately you're not asking for anything novel. Some questions I would have for an iPhone-based solution would be how quickly does it scan, how accurate is it, how sensitive is it, and does the design make it comfortable for somebody to use it repetitively for a thousand scans?
Yeah I think we're going to have to plump for a barcode scanner, I'm looking for a cheap one now that I can get delivered this week. Some where I've got a PDA we could use if I can find it so that's another option.

Thanks for all the responses, having just tried an iPhone with a reader app minutes ago (I've just discovered that someone here has one) and I agree it would take a while with an iPhone.
Jimmie76 is offline  
Old Sep 25, 2011 | 4:51 pm
  #7  
15 Years on Site
 
Join Date: Feb 2009
Location: WI
Programs: HHonors Gold, UAMP
Posts: 895
Symbol is the industry leader and will be a bit of a premium, you could just buy a used one on ebay tho, currently use a 2208 which has done outstanding work for me. You may consider trying to write a small app with a number pad also so you can punch in a qty afterwards unless you are doing just solo scans, if not you will need to setup it a little differently.
davef139 is offline  
Old Sep 25, 2011 | 5:23 pm
  #8  
Original Poster
FlyerTalk Evangelist
10 Countries Visited
1M
All eyes on you!
20 Years on Site
 
Join Date: Jun 2004
Location: LON, ACK, BOS..... (Not necessarily in that order)
Programs: **Mucci Diamond Hairbrush** - compared to that nothing else matters (+BA Bronze)
Posts: 15,952
Originally Posted by davef139
Symbol is the industry leader and will be a bit of a premium, you could just buy a used one on ebay tho, currently use a 2208 which has done outstanding work for me. You may consider trying to write a small app with a number pad also so you can punch in a qty afterwards unless you are doing just solo scans, if not you will need to setup it a little differently.
What we plan to do is just scan everything and manually count and delete the duplicates. This should be relatively easy as they should be mostly few and far between. We've found a few that will do a scan, type the code and then press return. I can easily make that format work for us.
Jimmie76 is offline  
Old Sep 29, 2011 | 11:23 pm
  #9  
jdn
 
Join Date: May 2003
Location: SJC/SFO and LGB/SNA/LAX
Programs: WN A-List, HHonors Gold (Ex AA PLT and HH Diamond)
Posts: 169
There are a couple options I'd like to add:

1. Not necessarily recommended for your use, but it is what you asked for - "CNS Barcode" is an iPhone / iOS app that uses the camera to scan barcodes. It is "programmable" so you can integrate it with FileMaker go, or maybe you would be able to use "Scan Multiple Barcodes" and then parse the output. I'm not sure what the limit on data size is for that option - if interested, you might contact the author. I have in the past (needed 2of5 barcode support turned on) and he was very responsive and helpful.

2. You could write your own app and use the zbar bar code reader opensource project to add camera-barcode-reading support.

3. Opticon OPN2002 http://www.opticon.com/OPN2002.aspx I have one of these and it could work for you two ways... 1, you could hook it up via bluetooth keyboard mode to input to your phone or laptop. 2, use it in batch mode and it will scan 20,000 scans and then transmit them from memory when you link with a computer. It is very small, light, and a good reader. See more at http://serialio.com/products/scanner...anfob_2002.php

It sounds like having a duplicate scan wouldn't be too concerning to you... if you are simply scanning unique barcodes (meaning a duplicate in the set could be automatically removed), then this would be good. If, on the other hand, you are scanning the same barcode (eg a sku or model#) and want to get a count on the # of that sku, then maybe a memory/batch scanner wouldn't be best... it can be hard to keep things straight, you can sometimes double scan the same barcode, and although there are ways to "delete last scan" etc, that is clumsy and difficult.
jdn is offline  
Old Sep 30, 2011 | 9:33 am
  #10  
FlyerTalk Evangelist
All eyes on you!
15 Years on Site
 
Join Date: Nov 2009
Location: Earth. Residency:HKG formerly:YYZ
Programs: CX, DL, Nexus/GE, APEC
Posts: 11,081
Older Win CE base PDA had optional bar-code scanning attachment and applications to store the reading to be downloaded later.
tentseller is offline  
Old Oct 3, 2011 | 3:42 pm
  #11  
jdn
 
Join Date: May 2003
Location: SJC/SFO and LGB/SNA/LAX
Programs: WN A-List, HHonors Gold (Ex AA PLT and HH Diamond)
Posts: 169
Originally Posted by tentseller
Older Win CE base PDA had optional bar-code scanning attachment and applications to store the reading to be downloaded later.
Yes - I've used a "Socket" brand plugin on a WinCE device.
jdn is offline  
Old Oct 3, 2011 | 5:02 pm
  #12  
Original Poster
FlyerTalk Evangelist
10 Countries Visited
1M
All eyes on you!
20 Years on Site
 
Join Date: Jun 2004
Location: LON, ACK, BOS..... (Not necessarily in that order)
Programs: **Mucci Diamond Hairbrush** - compared to that nothing else matters (+BA Bronze)
Posts: 15,952
Thanks for all the subsequent replies we have had a directive from head office that has now made this an academic enquiry We're changing how things are recorded and they have removed the ability to import from a CSV file into the system. It'll still be a manual count (where the scanner would have been useful) but includes duplicates now and has to be sent both in electronic and hand marked paper format. There is a reason for this is because some people weren't bothering to actually make a count and were just uploading the same electronic copy every time

They are going to audit more now and the hand written pages allow discrepancies to be recorded on the sheet, explained on the same page and signed off.

Thanks again for all the suggestions, I'm still looking at this but just not with the same urgency as I was before.

Last edited by Jimmie76; Oct 3, 2011 at 5:13 pm
Jimmie76 is offline  


Contact Us - Archive - Advertising - Cookie Policy - Privacy Statement - Terms of Service -

This site is owned, operated, and maintained by MH Sub I, LLC dba Internet Brands. Copyright © 2026 MH Sub I, LLC dba Internet Brands. All rights reserved. Designated trademarks are the property of their respective owners.