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

Currently Filtered by

Category

Knives

Refine Search

  GO
 
Brand

X-ACTO(9)

Stanley(8)

COSCO(8)

Stanley Tools(6)

IRWIN(3)

Quality Park(3)

Great Neck(3)

Fiskars(3)

Clauss(3)

Klein Tools(2)

Wiss(1)

San Jamar(1)

Dexter(1)

Westcott(1)

 
Color(s)

Gray(8)

Black(7)

Red(4)

Blue/Black(3)

Yellow(3)

Green/Black(2)

Orange(2)

Chrome(2)

Blue(2)

Silver(2)

Gray/Red(2)

White/Orange(1)

Orange; White(1)

Yellow/Gray(1)

Red/Silver(1)

Orange/Black(1)

Black/Yellow(1)

Royal Blue(1)

Black/Chrome(1)

Black/Silver(1)

Red Orange(1)

Green(1)

Brown(1)

Mixed(1)

 
Quantity

1 each(1)

1 set(1)

 
Packing Type

Nylon soft compression case(1)

Pack(1)

 
Manufacturer Part Number

XZ3601(1)

X5285(1)

1630501001(1)

1651101001(1)

1651801001(1)

X3732Q(1)

X3730Q(1)

X3204(1)

X3001(1)

X3274(1)

X3279(1)

X3724(1)

12113(1)

58113(1)

46908(1)

46907(1)

46909(1)

KK403(1)

WK8V(1)

15703(1)

15504(1)

58116(1)

2082101(1)

2082300(1)

2088600(1)

20400(1)

091524(1)

10151(1)

10-150(1)

10175(1)

10179(1)

10-189C(1)

10-099(1)

10079(1)

18026(1)

18966(1)

18968(1)

10-065(1)

10280(1)

10299(1)

091479(1)

091467(1)

091482(1)

091508(1)

091514(1)

091460(1)

091459(1)

10399(1)

10-499(1)

10499BX(1)

10788(1)

15411(1)

 
Country of Origin

CN(32)

US(18)

TH(2)

 
Blade Material

Steel(15)

Stainless Steel(6)

Cutlery Steel(3)

Ceramic(3)

Titanium Bonded(2)

High Carbon Steel(1)

Metal(1)

 
Blade Length

1 1/2"(4)

1 1/4"(3)

6 1/2"(1)

5 9/10"(1)

2 5/8"(1)

2"(1)

1 in(1)

15/16"(1)

3"(1)

1 3/4"(1)

18 mm(1)

9 mm(1)

3 1/2"(1)

4"(1)

6"(1)

2 3/10"(1)

1"(1)

Assorted(1)

 
Blade Type

Replaceable(14)

Retractable(12)

Utility(5)

Double Sided(3)

Retractable; Single Edge(3)

Utility Knife(2)

Single Edge(2)

Concave(1)

Razor(1)

Curved Slitting Blade(1)

Retractable; Snap-Off(1)

13-point Retractable Snap-Off(1)

Retractable; Round Point(1)

8-point Retractable Snap-Off(1)

Assorted Blades, 4 Styles(1)

 
Number of Blades

1(34)

3(9)

11(1)

4(1)

12(1)

10(1)

 
Replacement Blades

11-921(4)

QUA46912(3)

X-ACTO X11, X231, X511(2)

Utility(2)

Sheffield 12850(2)

X-Acto X602, X511, X611, X616(2)

11-921 Blades(2)

Fiskars 164190-1003(1)

Fiskars 196010(1)

Sheffield 12851(1)

Quick-Point(1)

Standard(1)

11-300(1)

Bi-Metal Utility Blades(1)

X-ACTO #11 Classic Fine Point Blade(1)

11-987(1)

#091509 (sold separately)(1)

#091483 (sold separately)(1)

#0914641 (sold separately)(1)

#091471 (sold separately)(1)

#091509(1)

X-ACTO EPIX211, EPIX411, EPIX511, EPIX611(1)

X-Acto X211, X411, X811(1)

11-301(1)

Utility Fixed Blade(1)

 
Blade Shape

Straight-Edged(12)

Triangular(5)

Rectangle(3)

Oblong(2)

Point(2)

Fine Point(2)

Snap-Off(2)

Double-Ended Trapezoid(1)

Concave(1)

Curved(1)

Assorted(1)

Round-Point Blade(1)

 
Blade #

#11(9)

#S3(3)

12850(2)

11-921(2)

12851(1)

No. 11(1)

11-301(1)

11-300(1)

#10, #11, #16, #17(1)

 
Handle Material

Plastic(13)

Metal(7)

Aluminum(6)

ABS Plastic(3)

Plastic/Rubber(2)

Rubber/Aluminum(2)

Contoured Metal(1)

Rubber Grip(1)

Steel(1)

Die-Cast Zinc(1)

Die Cast(1)

Aluminum/Rubber(1)

Reinforced Plastic(1)

Metal Casing;Rubber Grip(1)

Metal/Soft Bi-Material(1)

Plastic/Metal(1)

 
Contains

Assorted Hobby Knife Blades;#1 Precision Handle;#2 Trimming Handle;#5 Cutting Handle(1)

One Knife; 5 Blades: Straight, Seam Ripper, Button Hole, Rounded Detail, Fine Detail(1)

 
Handle Length

6"(10)

6 3/4"(3)

4"(3)

5 5/8"(2)

3 1/2"(2)

5 1/2"(2)

4 1/2"(2)

8 1/4"(1)

2 1/4"(1)

5"(1)

4 in(1)

2 3/8"(1)

2 1/2"(1)

5 1/4"(1)

5-3/8"(1)

6-1/8"(1)

5 1/8"(1)

5 3/8"(1)

6 1/2"(1)

6 in(1)

3"(1)

4 4/5"(1)

 
Knife Type

Utility(18)

Retractable Blade Knife(14)

Snap-Off Blade Knife(4)

Craft Knife(3)

Replaceable Blade Knife(3)

Hobby Knife(3)

Retractable Utility(1)

Skinning Knife(1)

Slitting Pocket Knife(1)

Folding Replaceable Blade Knife(1)

Knife Holder(1)

 
 
 

© 2018-2019 Horizon Business Products, All Rights Reserved