SELECT `pinfo`.`sku`,`pinfo`.`vendor`, IF(`pinfo`.`multi_level_pricing_check`=1,(`mlrp`.`cost`/`mlrp`.`min_qty`),IF(CURDATE() >= `ds`.`expiration_date`, `ds`.`price`, `crp`.`contract_price`)) AS `price`, CONCAT(IF(`pinfo`.`vendor`=2,`desc_long`,`desc_short`),' ',`pinfo`.`sku`,' ',`category_1`,' ',`category_2`,' ',`category_3`,' ',`category_4`,' ',IF(`pinfo`.`vendor`=2,`sales_copy`,`desc_long`),' ',IF(`dealer_sku`!='',`dealer_sku`,''),' ',`manufacturer_name`,' ',`color`) AS `search_string` FROM `product_info` `pinfo` INNER JOIN `vendor_base_costs` `vbcc` ON `pinfo`.`sku`=`vbcc`.`sku` LEFT JOIN `contract_price_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `bestseller_priority_detail` AS `bpd` ON `pinfo`.`sku`=`bpd`.`sku` LEFT JOIN `bestseller_priority_master` AS `bpm` ON `bpm`.`list_id`=`bpd`.`list_id` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` LEFT JOIN `multi_level_retail_price` AS `mlrp` ON `mlrp`.`sku`=`pinfo`.`sku` AND `mlrp`.`preferred_vendor`=`pinfo`.`preferred_vendor` AND (`mlrp`.`cost`/`mlrp`.`min_qty`)>0 WHERE (`category_id` IN ('1128')) AND `pinfo`.`status` IN ('active','discontinued') AND `pinfo`.`desc_title` != '' AND `online_status`=1 AND `custom_sku_enable`=1 AND CASE WHEN `pinfo`.`multi_level_pricing_check`=1 THEN TRUE ELSE `crp`.`contract_price`>0 END AND `pinfo`.`sku` NOT IN (SELECT `alias_sku` FROM `internal_alias_detail`) GROUP BY `pinfo`.`sku` ORDER BY ISNULL(`bpm`.`list_priority`) ASC, `bpm`.`list_priority` ASC, ISNULL(`bpd`.`priority`) ASC, `bpd`.`priority` ASC, CASE WHEN `pinfo`.`sku` LIKE '%StorageCabinets' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('StorageCabinets' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+StorageCabinets' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"StorageCabinets"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"StorageCabinets"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"StorageCabinets"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"StorageCabinets"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+StorageCabinets' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='StorageCabinets',`category_4` ='StorageCabinets') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'StorageCabinets,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('StorageCabinets', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Storage Cabinets

Refine Search

  GO
 
Brand

Tennsco(60)

HON(53)

Alera(20)

Safco Mayline(19)

Alera Plus(10)

Safco(6)

Jonti-Craft(6)

Iceberg(6)

Mayline(5)

Bush(5)

JUSTRITE(3)

Rubbermaid(2)

FireKing(2)

ZOLL(1)

 
Color

Light Gray(25)

Putty(24)

Black(22)

Medium Gray(13)

Sand(13)

Mahogany(12)

Mocha(8)

Two-Tone Gray(6)

Birch(6)

Two-Tone Tan(6)

Cherry(6)

Espresso(5)

Charcoal(5)

Columbian Walnut(4)

Gray Steel(4)

Natural Maple(4)

Medium Cherry(3)

Platinum(3)

Yellow(3)

Brilliant White(2)

Gray/Black(2)

Harvest(2)

Gray(2)

White(2)

Gray/Granite Nebula(2)

Parchment(2)

Espresso/White(2)

Cherry/Granite Nebula(2)

Sierra Cherry(1)

Modern Walnut(1)

Raven(1)

Cognac(1)

Natural Cherry; Graphite Gray(1)

Graphite Gray; Hansen Cherry(1)

Bourbon Cherry(1)

Mocha Cherry; Graphite Gray(1)

 
Quantity

1 each(32)

 
Overall Width

36"(90)

48"(21)

12"(18)

18"(15)

29 1/2"(8)

30"(8)

72"(7)

29 3/4"(6)

24"(4)

34"(4)

14 3/4"(3)

19"(3)

90"(2)

54"(2)

43"(2)

33"(2)

17"(1)

37 1/2"(1)

34 1/2"(1)

 
Overall Depth

18"(75)

24"(47)

20"(11)

18 1/4"(8)

25"(6)

11 3/4"(6)

22"(4)

14"(4)

24 1/4"(4)

23 3/8"(4)

19 1/8"(4)

15"(4)

29"(3)

19 5/8"(3)

24 3/4"(3)

22 3/4"(3)

19 1/4"(2)

19"(2)

9 1/2"(1)

20 1/2"(1)

14 3/16"(1)

19 1/2"(1)

34"(1)

 
Manufacturer Part Number

9442MH(1)

9442CY(1)

9443CY(1)

9443MH(1)

9444CY(1)

5527TN(1)

5527GR(1)

5525GR(1)

5525TN(1)

5526GR(1)

5526TN(1)

9444MH(1)

1470BK(1)

1824LGY(1)

1824PY(1)

1870BK(1)

1870LGY(1)

1824BK(1)

1480PY(1)

1470LGY(1)

1470PY(1)

1480BK(1)

1480LGY(1)

5524TN(1)

5524GR(1)

APST2LCR(1)

APST1LDC(1)

APST2LDC(1)

E5OPENSAHB(1)

MGDCLGS(1)

APST1LCR(1)

896000(1)

0440JC(1)

0441JC(1)

893000(1)

894500(1)

MSCLGS(1)

MVLCCLGS(1)

5522GR(1)

5522TN(1)

5523GR(1)

5523TN(1)

7085(1)

7083(1)

MVLCDLGS(1)

MWD3624ESP(1)

VLCCCRY(1)

VLCCMAH(1)

1870PY(1)

2470BK(1)

J478NLGY(1)

J478NBK(1)

J478NPY(1)

JAN6618DHBK(1)

JAN6618DHLGY(1)

J24SNPY(1)

J24SNLGY(1)

J2478SUCPY(1)

J2478SULGY(1)

J2478SUPY(1)

J24SNBK(1)

JAN6618DHPY(1)

SRS721872AMG(1)

STS121872ASD(1)

STS121872CMG(1)

STS121872CSD(1)

80000855(1)

STS121872AMG(1)

STS1218723SD(1)

SRS721872ASD(1)

STS1218721MG(1)

STS1218721SD(1)

STS1218723MG(1)

J2478SUCLGY(1)

J2478SUCBK(1)

BS6121812AMG(1)

BS61218123SD(1)

BS6121812ASD(1)

BS6121812CMG(1)

BS6121812CSD(1)

BS61218123MG(1)

BS61218121SD(1)

2470LGY(1)

2470PY(1)

7824PY(1)

BS61218121MG(1)

DTS1218361MG(1)

DTS1218361SD(1)

J1878SUBK(1)

J1878SULGY(1)

J1878SUPY(1)

J2478SUBK(1)

DTS121836CSD(1)

DTS121836CMG(1)

DTS1218363MG(1)

DTS1218363SD(1)

DTS121836AMG(1)

DTS121836ASD(1)

04400JC(1)

0416JC(1)

WC36796A(1)

WC24496A(1)

WC72496A(1)

BLPWCA1A1(1)

BLPWCESES(1)

WC12996A(1)

34S24WH(1)

LS593020WA(1)

VA613622ES(1)

VA61-3622MC(1)

VA61-3622MY(1)

BLPWCNN(1)

C184236L(1)

105291NN(1)

107291CC(1)

107291CO(1)

107291NN(1)

105291CC(1)

CF7236-D(1)

C184236Q(1)

C187236L(1)

C187236Q(1)

CF4436-D(1)

LS593020MY(1)

LS593020MC(1)

BR202ES(1)

BR202CY(1)

BR202GY(1)

CM4218BK(1)

CM4218LG(1)

BR181GY(1)

BR105GY(1)

BR104ES(1)

BR104GY(1)

BR105CY(1)

BR105ES(1)

CM4218PY(1)

CM6615PY(1)

CM7824PY(1)

CME4218PY(1)

CME7218PY(1)

LS593020ES(1)

CM7824LG(1)

CM7824BK(1)

CM6624PY(1)

CM7218BK(1)

CM7218LG(1)

CM7218PY(1)

115291ACHH(1)

115291AFNN(1)

SC1872L(1)

SC1842S(1)

SC1872P(1)

SC1872Q(1)

SC1872S(1)

SC1842Q(1)

SC1842P(1)

HPHC1D18MO(1)

HPHC1D18Z(1)

HPHC2D36MO(1)

SC1842L(1)

SC2472L(1)

SC2472P(1)

92571(1)

92573(1)

0415JC(1)

04160JC(1)

92563(1)

92561(1)

SC2472Q(1)

SC2472S(1)

92551(1)

92553(1)

HPHC1D18D(1)

HPCT90W(1)

FC18730LAS(1)

HPBC1D1D18D(1)

HPBC1D1D18MO(1)

HPBC1D1D18Z(1)

FC18730LAQ(1)

FC18730LAP(1)

94291NN(1)

FC1830DLFALP(1)

FC1830DLFALQ(1)

FC1830DLFALS(1)

HPBC1F1D18D(1)

HPBC1F1D18MO(1)

HPCT54Q(1)

HPCT54W(1)

HPCT72Q(1)

HPCT90Q(1)

HPCT36Q(1)

HPBC4D18Z(1)

HPBC1F1D18Z(1)

HPBC2D2D36MO(1)

HPBC4D18D(1)

HPBC4D18MO(1)

BR104CY(1)

 
Country of Origin

US(161)

CN(21)

VN(12)

TH(4)

 
Material(s)

Heavy Gauge Steel(57)

Industrial Grade Steel(29)

Melamine(16)

Heavy Gauge Welded Steel(9)

Steel(8)

Metal(7)

High-Pressure Laminate(7)

Blow-Molded High-Density Polyethylene(6)

Laminated Compressed Wood(6)

100% Thermally Fused Laminate(5)

Woodgrain Laminate(4)

Thermally Fused Laminate(4)

Laminate Wood(4)

Laminate(3)

MDF; Laminate(3)

Thermal Fused Laminate(3)

Thermofused Melamine/Laminate(3)

18-Gauge Steel(3)

Plastic(2)

MDF; Laminate; Glass; Steel(2)

Hardwood Veneer(2)

Thermofused Melamine(1)

Walnut Veneer(1)

Textured Woodgrain Laminate(1)

 
For Use With

HON Hospitality Cabinet Modular Countertop(10)

Alera Plus Hospitality Wall Cabinet(9)

Tennsco Optional Locker Base Medium Gray (Sold Separately); (1 Required)(6)

HON Modular Hospitality Single Base Cabinets; HON Modular Hospitality Double Base Cabinets(6)

Alera Open Office Desk Series; Alera Valencia Series; Alera Sedina Series; Alera Cushions(4)

HON BL Laminate Series(3)

HON Modular Hospitality Single Base Cabinets(3)

78" High Jumbo Cabinets, Box 2 of 2(2)

Mayline Glass Doors for Low Wall Cabinet; Mayline Wood Doors for Low Wall Cabinet.; To complete the wall cabinet, you must order the cabinet and the doors.(2)

Tennsco Optional Locker Base Medium Gray (Sold Separately); (3 Required)(2)

Tennsco Optional Locker Base Sand (Sold Separately); (1 Required)(2)

Tennsco Optional Locker Base Sand (Sold Separately); (3 Required)(2)

Mayline Aberdeen Personal Storage Tower (Box 1 of 2) Both pieces MUST be ordered to make this unit complete.(2)

Medina Laminate Series(2)

Mayline Aberdeen Personal Storage Tower (Box 2 of 2) Both pieces MUST be ordered to make this unit complete.(2)

ZOLL AED Plus(1)

When creating a high jumbo cabinet, use TNN-J478PU(1)

Tennsco Optional Locker Base Sand (Sold Separately); (2 Required)(1)

Tennsco Optional Locker Base Medium Gray (Sold Separately); (2 Required)(1)

78" High Jumbo Cabinets, (TNNJ24SNPY) Box 2 of 2(1)

When creating a high jumbo cabinet, use Tennsco 78" High Jumbo Cabinets(1)

MVLCCLGS(1)

Bush Momentum Desk Tops and 36" Hutch(1)

Alera Plus Hospitality Base Cabinet(1)

HON Modular Hospitality Double Base Cabinets(1)

MVLCDLGS(1)

Mayline Mira Series Lateral File(1)

When creating a high jumbo cabinet, use TNN-J478BK(1)

 
Capacity (Volume)

18 2/5 cu. Ft.(2)

27 1/2 cu. Ft.(2)

17 3/10 cu. Ft.(2)

101 gal(1)

202 gal(1)

30 gal(1)

45 gal(1)

60 gal(1)

 
Capacity (Weight)

75 lbs.(6)

225 lbs.(5)

100 lbs.(4)

300 lbs.(4)

Supports up to 250 lbs.(4)

130 lbs.(3)

135 lbs.(3)

70 lbs.(2)

175 lbs.(2)

150 lbs.(2)

20 lbs.(1)

200 lbs.(1)

360 lbs.(1)

690 lbs.(1)

336 lbs.(1)

 
Caster/Glide/Wheel

Leveling Glides(33)

Integrated Levelers(9)

Adjustable Leveling Glides(6)

Glides(5)

Four 5" Casters (2 Locking)(1)

Six 1" Glides(1)

Four 1" Glides(1)

1 1/2" Adjustable Glides(1)

 
Edge Detail Profile

Square Edgeband(23)

Square Edge(12)

3mm Protective Edge Banding(7)

4mm Fluted PVC Edge Detailing(4)

Beveled Edge(4)

PVC Protective Edgebanding(4)

Square Cabinet Corners; Rounded Door Corners(3)

Rounded Corner; Waterfall Edge(3)

Radius Edge(3)

Rounded Corner(2)

Ribbon Edge(2)

Straight Edge(2)

Square(1)

Traditional Edge Detail(1)

Edgeband PVC(1)

Square Corner(1)

 
Top Thickness

1"(24)

3/4"(14)

1 1/8"(11)

1 11/16"(6)

5/8"(6)

1 1/2"(2)

1/8"(1)

 
Drawer Quantity

1(9)

4(6)

2(5)

 
Shelf Count

4(35)

1(34)

2(27)

5(11)

3(11)

6(9)

7(2)

4, 3 Adjustable(1)

 
Door Quantity

2(110)

1(31)

6(12)

18(6)

3(6)

4(4)

16(2)

 
Shelf Capacity (Weight)

75 lbs.(16)

250 lbs.(12)

150 lbs.(12)

125 lbs.(4)

180 lbs.(4)

50 lbs.(4)

200 lbs.(4)

Top Shelf, 400 lbs.; Side Shelves, 50 lbs.(3)

65 lbs.(3)

35 lbs.(2)

120 lbs.(1)

 
Compartment Quantity

2(15)

1(13)

6(12)

18(6)

3(6)

4(3)

16(2)

 
Overall Height

78"(49)

72"(30)

29 1/2"(19)

36"(14)

71 3/4"(8)

30"(7)

66"(7)

4 3/4"(6)

28"(6)

29 3/4"(5)

22 7/8"(4)

68 3/4"(4)

41 3/4"(4)

42"(4)

29 7/8"(4)

64"(3)

40"(3)

76 1/4"(3)

35 1/2"(3)

59 1/2"(2)

65"(2)

46"(2)

44"(2)

42 3/4"(2)

17"(1)

38"(1)

21 3/4"(1)

39 1/4"(1)

24"(1)

 
Drawer Configuration

File; Storage(4)

Box/Box/Box/Box(3)

Box(3)

Box/Box/File/Lateral File(3)

Lateral File(3)

Box/Box(1)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved