ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
dsk 13
Admin 8
doc 3
Recent Posts
Bathroom electrical
by doc. 08/19/17 06:53 AM
electircal ageing test on IPC
by SIAME. 08/15/17 02:43 AM
electrical aging test on IPC
by gfretwell. 08/15/17 12:27 AM
"Line level" audio on Cat 5?
by gfretwell. 08/08/17 10:39 PM
Fire alarm phone lines and color coding
by gfretwell. 08/08/17 10:26 PM
New in the Gallery:
Gallery Test
Popular Topics(Views)
240,025 Are you busy
175,633 Re: Forum
167,867 Need opinion
Who's Online Now
0 registered members (), 69 guests, and 9 spiders.
Key: Admin, Global Mod, Mod
Previous Thread
Next Thread
Print Thread
Rate This Thread
#171194 - 11/21/07 08: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 01: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 04: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
togol
togol
NW In. USA
Posts: 421
Joined: September 2005
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.014s Queries: 15 (0.003s) Memory: 0.7532 MB (Peak: 0.8778 MB) Zlib enabled. Server Time: 2017-08-21 12:12:16 UTC