ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
twh 3
Recent Posts
FPE in Germany
by Texas_Ranger. 11/19/17 07:30 AM
Ceiling fan distance from outdoor hot tub
by gfretwell. 11/16/17 02:18 AM
diazed fuses
by Texas_Ranger. 11/13/17 03:02 PM
Theft deterrent alarm
by gfretwell. 11/12/17 01:39 PM
EEPROM errors on XC7Z010-2CLG225I chip
by twh. 11/07/17 05:45 PM
New in the Gallery:
Gallery Test
Popular Topics(Views)
242,573 Are you busy
178,744 Re: Forum
170,018 Need opinion
Who's Online Now
0 registered members (), 40 guests, and 8 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate This Thread
#171194 - 11/21/07 07:30 PM Integrated inventory/billing  
Gregtaylor  Offline
Member
Joined: Mar 2005
Posts: 212
Boise, Idaho, USA
My employer is trying to develop a list of common and not so common electrical parts with a simple reference code tied to the UPC code for each item. I'm thinking someone has already done this, although the list may be proprietary. Has anyone got any ideas about where to find an existing list of this sort?


Business, Office, Estimating, Legal:

#171218 - 11/22/07 12:12 PM Re: Integrated inventory/billing [Re: Gregtaylor]  
PE&Master  Offline
Member
Joined: Feb 2006
Posts: 138
TX, USA
If you had a handheld scanner you could walk thru one of the big box stores. Then download it to a PC.

Also I've heard of some suppliers sharing codes. The problem is weeding out 10's of thousands of things you don't want. Also some of the bidding software has links to UPC codes.


#171226 - 11/22/07 03:02 PM Re: Integrated inventory/billing [Re: PE&Master]  
Active 1  Offline
Member
Joined: Feb 2003
Posts: 687
Grayslake IL, USA
I got a list of maybe 3000 materials with a UPC codes in a estomating software package. Besides that I know the Craftsman has a material list but I don't remember the numbering system. Home Depot had a free estomating CD but I believe it costs $20.

What it seems like is the UPC depends on the manufacture. Box stores seem to use a SKU number.

Smaller supply houses have a code of the manufacture name abreviated with the manufacture number or a easy discription. Like SIEMQ2100, or PVC 1/2.

It seems like there are a number of systems out there.
I top of that keeping the prices current without a costly subscription may be difficult.

Also numbering systems can be copywrited. I'm not saying you enter in manufacture data. But if a product was sold it would be something for the seller to look into.



Member Spotlight
JoeKP
JoeKP
Berkley, MA
Posts: 144
Joined: March 2008
Show All Member Profiles 
Featured:

2017 Master Electrician Exam Preparation Combos
2017 NEC Electrician
Exam Prep Combos:
Master / Journeyman

 

Shout Box
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.013s Queries: 15 (0.003s) Memory: 0.7523 MB (Peak: 0.8769 MB) Zlib enabled. Server Time: 2017-11-19 14:14:10 UTC