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

Currently Filtered by

Category

Locks

Refine Search

  GO
Brand

Master Lock(23)

Kensington(16)

AbilityOne(10)

Innovera(2)

Ex-Cell(1)

American Lock(1)

CCL(1)

Alera(1)

Color(s)

Black(11)

Silver(10)

Red(8)

Black/Silver(5)

Brass(4)

Silver/Blue(3)

Gold(2)

Steel/Red(1)

Silver/Red(1)

Graphite; Chrome(1)

Black Dial(1)

Gray(1)

Assorted(1)

Chrome-Look Lock Body with Assorted Color Wheels;Blue;Black;Red;White(1)

Black;Blue;Green;Pink(1)

Country of Origin

CN(21)

US(13)

MX(11)

TW(10)

For Use With

Lockers; Cabinets(1)

Lockers; Cabinets; Fences; Sheds(1)

Laptops(1)

MacBook; Ultra-Thin Laptop(1)

PC Desktop(1)

Alera Valencia Series(1)

Opening Type

Cylindrical Shackle(5)

Top(4)

Open Top(3)

Open top(1)

Side(1)

Back(1)

Body Material

Steel(13)

Zinc Alloy(6)

Laminated Steel(5)

Brass(4)

Stainless Steel(4)

Metal(3)

Steel Zinc Alloy Nickel Chrome Plated(2)

Solid Steel(2)

Thermoplastic(2)

Aluminum(2)

PVC; Steel; Zinc(2)

Steel/Vinyl(1)

Xenoy(1)

Die-Cast Steel(1)

Galvanized Steel(1)

Zenex(1)

Number of Keys

2(25)

1(6)

0(1)

Body Width

2"(5)

1 1/2"(4)

14 mm(3)

1 3/8"(3)

10 mm(3)

1 7/8"(3)

1.88"(2)

1 9/16"(2)

1-3/4"(2)

19 mm(2)

3.25"(2)

1.56"(1)

2 3/8"(1)

2 1/2"(1)

1 29/32"(1)

2 7/32"(1)

1.13"(1)

2 9/50"(1)

2.25"(1)

0.88"(1)

1 1/2 in(1)

17.5 mm(1)

18 mm(1)

1"(1)

12.72(1)

6.5"(1)

0.75"(1)

Number of Pins

7(7)

4(4)

5(4)

6(3)

3(2)

Shackle Size

7 mm(8)

6 mm(3)

5 mm(2)

1-1/8"(2)

1/4"(2)

8 mm(2)

1" x 5/16"(2)

1 1/2"(2)

10 mm(1)

2"(1)

1 1/16" x 1/4"(1)

7/8"(1)

1"(1)

0.9(1)

18.4 mm(1)

5/16"(1)

4 mm(1)

2.25"(1)

3/4" x 9/32"(1)

Shackle Material

Hardened Steel(14)

Steel(10)

Stainless Steel(4)

Boron Alloy(3)

Steel Zinc Alloy Nickel Chrome Plated(2)

Zinc Alloy(2)

Hardened Boron Steel(2)

Cable Material

Steel(7)

Carbon Steel(7)

Carbon Strengthened Steel(7)

4.5 mm Carbon Tempered Steel Cable(1)

Ultra Carbon Steel(1)

Galvanized Steel(1)

Cable Length

6 ft(18)

5 ft(2)

8 ft(2)

48"(1)

Lock Type

Combination(10)

Cable/Key(10)

Key(7)

Key Lock(6)

Cable/Combination(6)

Bluetooth(2)

Keyed Padlock(2)

Combination Padlock(2)

3-Number Combination(2)

Hasp(2)

Padlock(2)

Keyed Alike(1)

Combination Lock(1)

MicroSaver 2.0 Keyed Lock(1)

3-Number/Letter Combination(1)

Special Features

Model No. 5D-Thousands of key changes, dual locking levers and hardened boron alloy shackle offer a high-quality and secure lock.(1)

Model No. 7D-Hundreds of key changes for increased security.(1)

Solid Body Steel Padlock-Keyed different, set of keys included(1)

1 1/2" Inside Jaw Diameter(1)

Model No. 3D-Thousands of key changes, dual locking levers and hardened steel shackle provide a tough and durable lock.(1)

Red Cable(1)

Pack of Two-Both locks have the same combinations.(1)

Gray Cable(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved