ECN Electrical Forum - Discussion Forums for Electricians, Inspectors and Related Professionals

ECN Shout Chat
Top Posters(30 Days)
Admin 16
Recent Posts
Another Forum Update
by Admin. 03/22/17 03:04 PM
Dining room plugs
by watersparkfalls. 03/21/17 10:31 PM
TRUE POWER
by jraef. 03/21/17 09:13 PM
WEG CFW-11 Frequency Inverter
by jraef. 03/21/17 08:50 PM
fuse rejectors
by HotLine1. 03/20/17 08:14 PM
New in the Gallery:
SE cable question
Popular Topics(Views)
231,218 Are you busy
165,932 Re: Forum
160,462 Need opinion
Who's Online Now
0 registered members (), 57 guests, and 10 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
Posts: 362
Joined: April 2003
Show All Member Profiles 
Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.012s Queries: 15 (0.003s) Memory: 0.7506 MB (Peak: 0.8758 MB) Zlib enabled. Server Time: 2017-03-23 14:17:40 UTC