product_input_template.xlsx

	A	B	C	D	E	F
1	Class	Category	Item Code	Description	Unit of Measure (Purchasing)	Unit of Measure (Sales)
2	NF	CU	BBRCP	Bare Bright Copper	LBS	LBS
3	NF	CU	COP01	#1 Copper	LBS	LBS
4	NF	CU	COP02	#2 Copper	LBS	LBS
5	NF	CU	SHCOP	Sheet Copper	LBS	LBS
6	NF	BR	HBRAS	Hard Brass	LBS	LBS
7	NF	BR	RBRAS	Red Brass	LBS	LBS
8	NF	BR	YBRAS	Yellow Brass	LBS	LBS
9	NF	CU	EDMWR	EDM Wire	LBS	LBS
10	NF	BR	YBRAF	Yellow Brass -FE	LBS	LBS
11	NF	BR	ALBRO	Aluminum Bronze	LBS	LBS
12	NF	BR	BSHCL	Brass Shells - Clean	LBS	LBS
13	NF	BR	CBSHL	Chrome Brass Shells	LBS	LBS
14	NF	BR	CWMTR	Clean Water Meters	LBS	LBS
15	NF	BR	WWMFE	Whole Water Meters - FE Bottom	LBS	LBS
16	NF	BR	WWMPL	Whole Water Meters - Plastic Bottom	LBS	LBS
17	NF	BR	BTMIX	Brass Turnings - Mixed	LBS	LBS
18	NF	MI	ARABC	Auto Radiators (Brass/Copper)	LBS	LBS
19	NF	MI	ARBFE	Auto Radiators - FE (Brass/Copper)	LBS	LBS
20	NF	MI	HTCOR	Heater Cores	LBS	LBS
21	NF	MI	HTCFE	Heater Cores - FE	LBS	LBS
22	NF	EM	EMSML	Electric Motors - Small	LBS	LBS
23	NF	EM	EMMIX	Electric Motors - Mixed	LBS	LBS
24	NF	EM	EMLRG	Electric Motors - Large (500lbs or More)	LBS	LBS
25	NF	EM	LGMTR	Low Grade Motors	LBS	LBS
26	NF	EM	SEALU	Sealed Units	LBS	LBS
27	NF	EM	CISLU	Cast Iron Sealed Units	LBS	LBS
28	NF	EM	BALST	Ballast	LBS	LBS
29	NF	EM	EBALR	Electronic Ballast	LBS	LBS
30	NF	CU	CTSML	Copper Transformers - Small	LBS	LBS
31	NF	CU	CTMED	Copper Transformers - Medium	LBS	LBS
32	NF	CU	CTLRG	Copper Transformers - Large	LBS	LBS
33	NF	MI	ACTRF	Aluminum/Copper Transformers	LBS	LBS
34	NF	EM	ALTRN	Alternators	LBS	LBS
35	NF	EM	STALA	Staters - Al. Nose	LBS	LBS
36	NF	EM	STAFE	Staters - Fe Nose	LBS	LBS
37	NF	EM	ACCMP	AC Compressors	LBS	LBS
38	NF	EM	STATR	Stators	LBS	LBS
39	NF	EM	ARMTR	Armatures	LBS	LBS
40	NF	EM	ROTCS	Rotor Cases	LBS	LBS
41	NF	EM	SOLND	Solenoid	LBS	LBS
42	NF	AL	DCCLN	Die Cast - Clean	LBS	LBS
43	NF	AL	DCDRT	Die Cast - Dirty	LBS	LBS
44	NF	AL	DCGRL	Die Cast - Grills	LBS	LBS
45	NF	BATT	ABPRP	Auto Batteries - Prepared	LBS	LBS
46	NF	BATT	ABUNP	Auto Batteries - Unprepared	LBS	LBS
47	NF	BATT	SCBAT	Steel Case Batteries	LBS	LBS
48	NF	PB	SFTLD	Soft Lead	LBS	LBS
49	NF	PB	WHLWT	Wheel Weights	LBS	LBS
50	NF	PB	RNGLD	Range Lead	LBS	LBS
51	NF	IC	INS85	#1 Insulated - 85%	LBS	LBS
52	NF	IC	INS70	#1 Insulated - 70%	LBS	LBS
53	NF	IC	INS50	#2 Insulated - 50%	LBS	LBS
54	NF	IC	INS35	#2 Insulated - 35%	LBS	LBS
55	NF	IC	CHRLT	Christmas Lights	LBS	LBS
56	NF	IC	CAT5C	CAT-5 Communication Cable	LBS	LBS
57	NF	IC	AHWIR	Auto Harness Wire - No Fuse Boxes or ECMs	LBS	LBS
58	NF	CU	HLXCP	Heliax - Open Eye Copper	LBS	LBS
59	NF	AL	HLXAL	Heliax - Open Eye Aluminum	LBS	LBS
60	NF	IC	CVBAR	Cat-V Cable Bare	LBS	LBS
61	NF	IC	CVBLK	Cat-V Cable Black	LBS	LBS
62	NF	IC	CVFEC	Cat-V Cable FE	LBS	LBS
63	NF	IC	LCCWR	Lead Coated Copper Wire	LBS	LBS
64	NF	IC	JLYW4	Jelly Wire 45%	LBS	LBS
65	NF	AL	ALBXC	Aluminum BX Cable	LBS	LBS
66	NF	MI	SLBXC	Steel BX Cable	LBS	LBS
67	NF	AL	ACBAL	Aluminum Cans - Baled	LBS	LBS
68	NF	AL	ACLOS	Aluminum Cans - Loose	LBS	LBS
69	NF	AL	E63NB	6063 Ext. - New Production Bare	LBS	LBS
70	NF	AL	E63CB	6063 Ext. - Clean Bare	LBS	LBS
71	NF	AL	E63C1	6063 Ext. - Clean 10/10	LBS	LBS
72	NF	AL	E63FD	6063 Ext. - FE Dirty	LBS	LBS
73	NF	AL	E63TH	6063 Thermal Extrusion	LBS	LBS
74	NF	AL	E61BR	6061 Ext. - Bare	LBS	LBS
75	NF	AL	E61PT	6061 Ext. - Painted	LBS	LBS
76	NF	AL	E61SP	6061 Sheet/Plate/Clip/Solid	LBS	LBS
77	NF	AL	E61FD	6061 Ext. - Fe Dirty	LBS	LBS
78	NF	AL	A52NP	5052 Aluminum SEGS New Production	LBS	LBS
79	NF	AL	A33NP	3003 Aluminum SEGS New Production	LBS	LBS
80	NF	AL	PASGB	Painted Al. (Siding/Gutters) - Baled	LBS	LBS
81	NF	AL	PASGL	Painted Al. (Siding/Gutters) - Loose	LBS	LBS
82	NF	AL	SPSGB	Secondary Painted Al. (Siding/Gutters) - Baled	LBS	LBS
83	NF	AL	SPSGL	Secondary Painted Al. (Siding/Gutters) - Loose	LBS	LBS
84	NF	AL	RDSIG	Road Signs	LBS	LBS
85	NF	AL	OSALB	Old Sheet Aluminum - Baled	LBS	LBS
86	NF	AL	OSALL	Old Sheet Aluminum - Loose	LBS	LBS
87	NF	AL	ACACL	Auto Cast Aluminum - Clean	LBS	LBS
88	NF	AL	ACADR	Auto Cast Aluminum - Dirty	LBS	LBS
89	NF	AL	CALCL	Cast Aluminum - Clean	LBS	LBS
90	NF	AL	CALDR	Cast Aluminum - Dirty	LBS	LBS
91	NF	AL	ARCLN	Aluminum Radiators - Clean	LBS	LBS
92	NF	AL	ARDRT	Aluminum Radiators - Dirty	LBS	LBS
93	NF	AL	A356W	356 Aluminum Wheels	LBS	LBS
94	NF	AL	C356W	356 Chrome Wheels	LBS	LBS
95	NF	AL	T61CL	6061 Truck Wheels - Clean	LBS	LBS
96	NF	AL	T61DR	6061 Truck Wheels - Dirty	LBS	LBS
97	NF	AL	ALMTR	Aluminum Motor Blocks	LBS	LBS
98	NF	AL	ALMTC	Aluminum Motor Blocks With Transmission (Combos)	LBS	LBS
99	NF	AL	TRANS	Transmissions	LBS	LBS
100	NF	AL	ALBRK	Aluminum Breakage (50%)	LBS	LBS