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

Currently Filtered by

Category

Tool Kits

Refine Search

  GO
Brand

Great Neck(8)

Fellowes(2)

Stanley(2)

Unger(1)

Invisible Glass(1)

Height

2 1/2"(1)

2.8"(1)

Width

17 1/2"(2)

12.4"(2)

Depth

14 1/4"(1)

8.2"(1)

Country of Origin

CN(10)

TW(2)

DE(1)

US(1)

Material(s)

Microfiber(1)

Number of Pieces

8(2)

110(1)

119(1)

72(1)

13(1)

4(1)

48(1)

205(1)

51(1)

55(1)

100(1)

32(1)

16(1)

Tool Kits Type

Combination Set(6)

Multipurpose(2)

Janitorial/Cleaning Kit(1)

Home Repair(1)

Pliers and Wrench Set(1)

General Repair(1)

Computer Tool Kit(1)

Opening Size

1/4"(1)

Tool Composition

High-Quality Drop Forged Steel(1)

Heat Treated(1)

steel and plastic with either rubber or plastic handles(1)

Chrome Vanadium(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved