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 ('112048')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 '%Lockers' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Lockers' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Lockers' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Lockers"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Lockers"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Lockers"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Lockers"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Lockers' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Lockers',`category_4` ='Lockers') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Lockers,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Lockers', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Lockers

Refine Search

  GO
 
Brand

Tennsco(15)

Safco(6)

ChargeTech(4)

Phoenix(2)

 
Color

Sand(8)

Medium Gray(7)

Charcoal(3)

Black(3)

Gray(3)

Tan(3)

Walnut(1)

Cherry(1)

 
Recycled

Yes(15)

No(11)

 
Packaged Quantity

1 Each(24)

1 / Each(2)

 
Assembly Required

No(23)

Yes(1)

 
Limited Warranty

1 Year(16)

Lifetime(6)

5 Year(2)

 
Weight (Approximate)

64 lb(1)

74 lb(1)

220 lb(1)

287 lb(1)

 
Total Number of Drawers

1(2)

 
Recycled Content

30%(14)

45%(1)

 
Durability

Impact Resistant(2)

Explosive Resistant(2)

Anti-magnetic(2)

Fire Proof(2)

Heat Resistant(2)

Burglary Resistant(1)

 
Total Number of Shelves

1(4)

3(4)

 
Number of Adjustable Shelves

1(2)

 
Form Factor

Floor Stand(1)

 
Volume Capacity

2.28 ft³(2)

 
Total Number of Compartments

6(4)

2(4)

1(4)

16(1)

 
Internal Height

12"(4)

36"(4)

18"(2)

 
Internal Width

12"(10)

 
Internal Depth

18"(8)

72"(2)

 
Manufacturer Part Number

CT200041(1)

BS6-121812-CMG(1)

STS-121872-CMG(1)

STS-121872-ASD(1)

STS-121872-AMG(1)

STS1218723SD(1)

STS1218723MG(1)

SRS721872ASD(1)

DTS-121836-CSD(1)

DTS-121836-CMG(1)

DTS-121836-ASD(1)

DTS-121836-AMG(1)

BS6-121812-CSD(1)

BS6-121812-ASD(1)

CT300032(1)

BS6-121812-AMG(1)

5527TN(1)

5527GR(1)

5526TN(1)

5526GR(1)

5524TN(1)

5524GR(1)

DPS6500S(1)

DBAUM700(1)

CT-300115(1)

CT300114(1)

STS-121872-CSD(1)

 
Country of Origin

United States(15)

Vietnam(6)

China(4)

Korea(2)

 
Material

Steel(24)

Metal Handle(10)

Metal Door(2)

 
Height

72"(11)

78"(6)

36"(2)

24.8"(1)

24"(1)

26"(1)

39"(1)

25.3"(1)

27.7"(1)

 
Width

36"(9)

12"(6)

18"(4)

19"(3)

19.7"(2)

14.6"(1)

 
Depth

18"(15)

12"(2)

78"(2)

20.8"(1)

21.3"(1)

 
Length

8"(3)

 
Placement

In-Floor(4)

Wall(2)

 
Lock Type

Pin Number(3)

Digital(2)

Key(2)

Fingerprint(1)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved