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

Topic Options
Rate This Topic
#171194 - 11/21/07 04:30 PM Integrated inventory/billing
Gregtaylor Offline
Member
Registered: 03/02/05
Posts: 212
Loc: 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?
Top
Business, Office, Estimating, Legal:
#171218 - 11/22/07 09:12 AM Re: Integrated inventory/billing [Re: Gregtaylor]
PE&Master Offline
Member
Registered: 02/25/06
Posts: 138
Loc: 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.
Top
#171226 - 11/22/07 12:02 PM Re: Integrated inventory/billing [Re: PE&Master]
Active 1 Offline
Member
Registered: 02/22/03
Posts: 687
Loc: 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.
Top

Member Spotlight
Member Since: 11/17/00
Posts: 2232
New in the Gallery:
SE cable question
Featured:

2017 NEC and Related
2017 NEC
Now Available!

Shout Box


Who's Online
0 registered (), 42 Guests and 11 Spiders online.
Key: Admin, Global Mod, Mod
 
New in the Gallery:
SE cable question
 
Top Posters (30 Days)
Admin 47
HotLine1 43
gfretwell 19
Ruben Rocha 12
Trumpy 9
 
Newest Members
Freecrowder, clee512, Jdscott2005, FAIZAN, Regitest2

ECN Electrical Forums - sponsored by Electrical Contractor Network - Electrical and Code Related Discussion for Electrical Contractors, Electricians, Inspectors, Instructors, Engineers and other related Professionals