UPC Scanner - Paint Talk - Professional Painting Contractors Forum
CLICK HERE AND JOIN OUR COMMUNITY TODAY, IT'S FREE!
Go Back   Paint Talk - Professional Painting Contractors Forum > Business > Business, Marketing, and Sales


Like Tree2Likes
  • 1 Post By PACman
  • 1 Post By Wolfgang
Reply
 
Thread Tools Display Modes
Old 11-07-2016, 08:21 AM   #1
Senior Member
 
Join Date: Oct 2012
Posts: 8,634
Rewards Points: 942
Thanks: 4,524
Thanked 4,503 Times in 2,839 Posts
View cdpainting's Photo Album My Photos
Default UPC Scanner

I just ordered one. I want to try someting. Instead of manually entering every thing materials wise for a job I'm thinking scan it, like at the checkout counter.

We have Excell and QB. I'm going to try and use one of these programs to keep track.

Has any one done this? How did it or does it work for you?
cdpainting is offline   Reply With Quote
Sponsored Links
Advertisement
 
Old 11-07-2016, 11:07 AM   #2
Senior Member
 
PACman's Avatar
 
Join Date: Oct 2014
Location: North central Ohio
Posts: 7,598
Rewards Points: 2,118
Thanks: 2,995
Thanked 4,265 Times in 2,811 Posts
View PACman's Photo Album My Photos
Default

Quote:
Originally Posted by cdpainting View Post
I just ordered one. I want to try someting. Instead of manually entering every thing materials wise for a job I'm thinking scan it, like at the checkout counter.

We have Excell and QB. I'm going to try and use one of these programs to keep track.

Has any one done this? How did it or does it work for you?
Do you have an inventory entry screen on QB? I use their point of sale software so I just transfer to QB from that so I don't know what QB itself has. If there is an inventory entry screen, when you are prompted to enter or there is a space to enter a UPC code, all you do is make sure the cursor is in that space and scan the item. At that point you may or may not have to hit enter to input the UPC.

On Excel, the scanner will input the UPC in any position the cursor is in when the item is scanned.

Easy peesy!
__________________
"One who dares not offend cannot be honest." Thomas Paine-patriot

"Screw you guys! I'm going home!" Cartmann
PACman is offline   Reply With Quote
The Following User Says Thank You to PACman For This Useful Post:
cdpainting (11-07-2016)
Old 11-07-2016, 11:09 AM   #3
Senior Member
 
PACman's Avatar
 
Join Date: Oct 2014
Location: North central Ohio
Posts: 7,598
Rewards Points: 2,118
Thanks: 2,995
Thanked 4,265 Times in 2,811 Posts
View PACman's Photo Album My Photos
Default

And Fyi, I believe most Officemax and Staples stores sell UPC scanners if you don't want to order online. (or if like me you break one while you are busier then he..)
cdpainting likes this.
__________________
"One who dares not offend cannot be honest." Thomas Paine-patriot

"Screw you guys! I'm going home!" Cartmann
PACman is offline   Reply With Quote
 
Old 11-07-2016, 11:43 AM   #4
Senior Member
 
CApainter's Avatar
 
Join Date: Jun 2007
Location: San Francisco Bay Area, CA
Posts: 11,688
Rewards Points: 1,610
Thanks: 10,776
Thanked 9,227 Times in 5,133 Posts
View CApainter's Photo Album My Photos
Default

I've thought of using a SKU or UPC scanner for our paint inventory. How would you manage and track a stock item that gets checked out, but also gets checked back into inventory?
__________________
To avoid criticism, say nothing, do nothing, be nothing.-Aristotle (referenced from The PokerKid)
CApainter is online now   Reply With Quote
The Following User Says Thank You to CApainter For This Useful Post:
stelzerpaintinginc. (11-07-2016)
Old 11-07-2016, 12:30 PM   #5
Troy
 
stelzerpaintinginc.'s Avatar
 
Join Date: May 2012
Location: Portland, OR
Posts: 1,781
Rewards Points: 246
Thanks: 1,987
Thanked 2,473 Times in 1,066 Posts
View stelzerpaintinginc.'s Photo Album My Photos
Default

Maybe I'm missing something. Can't see how having to deal with a UPC Scanner & learning new software would ever really be a time-saver over marking a check next to an item on a pre-printed inventory sheet, unless you're doing mass amounts of volume and want to be able to reconcile each item on every job. Capainter brought up a good point. The software would really need to have the ability to be bi-directional in order to reconcile itself if/when items are returned, exchanged, etc. Let us know how it works out.
__________________
Troy Stevens, Stelzer Painting Inc.stelzerpainting.com
stelzerpaintinginc. is offline   Reply With Quote
Old 11-07-2016, 12:46 PM   #6
Senior Member
 
CApainter's Avatar
 
Join Date: Jun 2007
Location: San Francisco Bay Area, CA
Posts: 11,688
Rewards Points: 1,610
Thanks: 10,776
Thanked 9,227 Times in 5,133 Posts
View CApainter's Photo Album My Photos
Default

I like the idea of integrating a sophisticated system of paint and material management for what would otherwise be a dark, dingy, and mismanaged inventory of multiple products, but important to have stocked.

That's why I liked the idea of a tracking device attached to each product that can be activated once the product leaves the storage room and recorded upon it's return. Data can be stored on the software to audit when necessary. The next level would be to actually weigh the product before entering stock, allowing a constant measure of quantity.

With that said, I suppose there is a threshold before an inventory would be too small to hassle with all of that. I know our inventory could use better organization and tracking given the mess we currently have. A lot of product could be simply tossed if we actually knew the expiration dates.
__________________
To avoid criticism, say nothing, do nothing, be nothing.-Aristotle (referenced from The PokerKid)
CApainter is online now   Reply With Quote
Old 11-07-2016, 02:00 PM   #7
Senior Member
 
PACman's Avatar
 
Join Date: Oct 2014
Location: North central Ohio
Posts: 7,598
Rewards Points: 2,118
Thanks: 2,995
Thanked 4,265 Times in 2,811 Posts
View PACman's Photo Album My Photos
Default

That's what POS software does. And why doing returns is so important. And why SW's bi-annual inventories are so nerve wracking. Even with the proper software it is a constant job to keep inventory properly tracked. But in a store situation it is a pretty basic necessity. For a painting company, I don't really know if it would be a great benefit unless you use large quantities of the same product/color.

Using a UPS scanner can save a lot of time, assuming that the software is actually beneficial to what your needs are. It could be a big headache for a painting company, but on the other hand it could save you from some possible losses. I don't know if there is any software out there specifically for inventory tracking. There should be though.
__________________
"One who dares not offend cannot be honest." Thomas Paine-patriot

"Screw you guys! I'm going home!" Cartmann
PACman is offline   Reply With Quote
The Following User Says Thank You to PACman For This Useful Post:
cdpainting (11-07-2016)
Old 11-07-2016, 03:33 PM   #8
Renegade Mod
 
Wolfgang's Avatar
 
Join Date: Nov 2008
Posts: 9,089
Rewards Points: 574
Thanks: 6,759
Thanked 8,277 Times in 3,765 Posts
View Wolfgang's Photo Album My Photos
Default

How much yearly income would it generate you?
cdpainting likes this.
__________________
Sweeping the streets of PT, one day at a time.
Wolfgang is offline   Reply With Quote
Old 11-07-2016, 04:45 PM   #9
Senior Member
 
Join Date: Oct 2012
Posts: 8,634
Rewards Points: 942
Thanks: 4,524
Thanked 4,503 Times in 2,839 Posts
View cdpainting's Photo Album My Photos
Default

Quote:
Originally Posted by Wolfgang View Post
How much yearly income would it generate you?
That would be what I'm going to find out. I'm going to give it 2 weeks to figure it out and 2-4 weeks to test it and see if it saves me any time or not. Worst case I use it for my ebay inventory.
cdpainting is offline   Reply With Quote
Old 11-07-2016, 05:00 PM   #10
Senior Member
 
PACman's Avatar
 
Join Date: Oct 2014
Location: North central Ohio
Posts: 7,598
Rewards Points: 2,118
Thanks: 2,995
Thanked 4,265 Times in 2,811 Posts
View PACman's Photo Album My Photos
Default

Quote:
Originally Posted by Wolfgang View Post
How much yearly income would it generate you?
Most of any "income" generated would be controlling inventory shrink. There could potentially be some labor savings from easier UPC data entry. But a large painting company can actually accrue a pretty large amount of inventory shrink in a years time. It kind of depends on the situation. If you have a lot of people gathering up supplies from your shop inventory, it would be a quick and easy way to track what they are taking and find out if anything is missing at your year end inventory, which in turn is tax deductible as a business loss. (if the dollar amount isn't insanely high that is, there are caps to this deduction.)

If it's just a few guys and they usually buy supplies as they go, it wouldn't really save a lot of money. But then again, scanners aren't all that expensive so it may be worth it.
__________________
"One who dares not offend cannot be honest." Thomas Paine-patriot

"Screw you guys! I'm going home!" Cartmann
PACman is offline   Reply With Quote
Old 11-07-2016, 06:38 PM   #11
Senior Member
 
CApainter's Avatar
 
Join Date: Jun 2007
Location: San Francisco Bay Area, CA
Posts: 11,688
Rewards Points: 1,610
Thanks: 10,776
Thanked 9,227 Times in 5,133 Posts
View CApainter's Photo Album My Photos
Default

Quote:
Originally Posted by Wolfgang View Post
How much yearly income would it generate you?
Wouldn't it just be considered another operating cost. The value would seem to be in inventory efficiency and less stress.
__________________
To avoid criticism, say nothing, do nothing, be nothing.-Aristotle (referenced from The PokerKid)
CApainter is online now   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off



All times are GMT -4. The time now is 09:58 AM.


Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Content Relevant URLs by vBSEO 3.6.1
vBulletin Security provided by vBSecurity v2.2.2 (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2017 DragonByte Technologies Ltd.
Our Pro Sites Network
ContractorTalk.com | DrywallTalk.com | ElectricianTalk.com | HVACSite.com | PlumbingZone.com | RoofingTalk.com