ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals
ECN Shout Chat
Top Posters(30 Days)
Admin 2
Recent Posts
Casino Wiring methods
by HotLine1. 12/09/17 10:44 AM
Ground wire Size to water Line.
by HotLine1. 12/05/17 12:11 PM
Flexible conduit to an outside Spa
by gfretwell. 12/05/17 12:28 AM
2017 NEC Changes
by luckyshadow. 12/04/17 06:08 PM
Dimmable LED 2x4 lay in fixtures
by Vulsion. 11/30/17 06:37 PM
New in the Gallery:
Gallery Test
Popular Topics(Views)
242,992 Are you busy
179,386 Re: Forum
170,355 Need opinion
Who's Online Now
0 registered members (), 9 guests, and 14 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
Admin
Admin
NY, USA
Posts: 3,460
Joined: October 2000
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.009s Queries: 15 (0.002s) Memory: 0.7535 MB (Peak: 0.8781 MB) Zlib enabled. Server Time: 2017-12-11 09:14:19 UTC