ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
Trumpy 5
Recent Posts
What do you do?
by gfretwell. 09/24/17 12:05 PM
75 kva tranformer
by sparkync. 09/23/17 06:41 PM
Another generator question
by gfretwell. 09/23/17 04:15 PM
Supporting conduit bodies
by ghost307. 09/18/17 12:12 PM
Thermal Imaging Camera upgrade
by Potseal. 09/18/17 11:57 AM
New in the Gallery:
Gallery Test
Popular Topics(Views)
240,917 Are you busy
176,707 Re: Forum
168,570 Need opinion
Who's Online Now
0 registered members (), 42 guests, and 12 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
mersadrad
mersadrad
Montreal, Quebec, Canada
Posts: 28
Joined: March 2011
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.017s Queries: 15 (0.003s) Memory: 0.7524 MB (Peak: 0.8770 MB) Zlib enabled. Server Time: 2017-09-24 17:29:35 UTC