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_27` 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

Stanley Tools(9)

X-ACTO(9)

Stanley(8)

COSCO(7)

sliceŽ(6)

Fiskars(4)

Clauss(3)

IRWIN(3)

Great Neck(3)

Wiss(1)

San Jamar(1)

Westcott(1)

 
Color(s)

Gray(9)

Black(5)

Red(4)

Blue/Black(3)

Yellow(3)

Gray; Green(3)

Blue(2)

Gray; Orange(2)

Orange(2)

Chrome(2)

Green(2)

Gray/Red(2)

Yellow/Gray(1)

White/Gray/Orange(1)

Red/Silver(1)

Yellow/Black(1)

White/Orange(1)

Silver(1)

Black/Chrome(1)

Black/Silver(1)

Red Orange(1)

Royal Blue(1)

Mixed(1)

Black/Yellow(1)

 
Quantity

1 each(1)

1 set(1)

 
Packing Type

Nylon soft compression case(1)

Pack(1)

 
Manufacturer Part Number

1630501001(1)

XZ3601(1)

1651101001(1)

1651801001(1)

1651901001(1)

X5285(1)

X3732Q(1)

X3274(1)

X3204(1)

X3279(1)

X3724(1)

X3730Q(1)

12113(1)

58113(1)

10514(1)

10503(1)

10550(1)

10554(1)

WK8V(1)

10400(1)

00200(1)

2082101(1)

58116(1)

2082300(1)

2088600(1)

KK403(1)

X3001(1)

091524(1)

10-150(1)

10143P(1)

10151(1)

10175(1)

10179(1)

10-099(1)

10079(1)

18966(1)

18026(1)

18968(1)

10049(1)

10-065(1)

10-189C(1)

10209(1)

091467(1)

091460(1)

091482(1)

091508(1)

091514(1)

091459(1)

10788(1)

10299(1)

10280(1)

10-499(1)

10499BX(1)

10509(1)

15411(1)

 
Country of Origin

CN(37)

US(16)

TH(2)

 
Blade Material

Steel(16)

Stainless Steel(9)

Cutlery Steel(3)

Carbon Steel(2)

Titanium Bonded(2)

Ceramic(1)

High Carbon Steel(1)

Metal(1)

 
Blade Length

1 1/2"(3)

1.29"(3)

2.5"(2)

Assorted(2)

0.1"(1)

1 in(1)

9 mm(1)

3 1/2"(1)

15/16"(1)

6 1/2"(1)

5 9/10"(1)

18 mm(1)

1"(1)

1 3/4"(1)

2 3/10"(1)

2"(1)

4"(1)

 
Blade Width

0.24"(3)

0.47"(2)

 
Blade Type

Replaceable(13)

Retractable(11)

Double Sided; Replaceable(5)

Utility(5)

Retractable; Single Edge(4)

Single Edge(3)

Utility Knife(2)

Assorted Blades, 7 Styles(1)

Razor(1)

Assorted Blades, 4 Styles(1)

Fixed; Non Replaceable Micro Safety Blade(1)

Curved(1)

Retractable; Round Point(1)

Retractable; Snap-Off(1)

13-point Retractable Snap-Off(1)

8-point Retractable Snap-Off(1)

 
Number of Blades

1(35)

3(9)

11(2)

4(1)

12(1)

10(1)

 
Replacement Blades

11-921(4)

sliceŽ 10404; sliceŽ 10408(3)

X-ACTO X11, X231, X511(2)

Sheffield 12850(2)

Utility(2)

sliceŽ 10526; sliceŽ 10528(2)

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

11-921 Blades(2)

Sheffield 12851(1)

164210(1)

11-987(1)

Bi-Metal Utility Blades(1)

Standard(1)

11-300(1)

Quick-Point(1)

Fiskars 164190-1003(1)

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

#091471 (sold separately)(1)

#091509 (sold separately)(1)

#091483 (sold separately)(1)

#091509(1)

11-301(1)

11-931 Blades(1)

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

X-Acto X211, X411, X811(1)

#0914641 (sold separately)(1)

 
Blade Shape

Straight-Edged(13)

Triangular(5)

Oblong(2)

Snap-Off(2)

Fine Point(2)

Assorted(2)

Double-Ended Trapezoid(1)

Curved(1)

Round-Point Blade(1)

Point(1)

 
Blade #

#11(8)

10404(3)

10526(2)

12850(2)

11-921(2)

12851(1)

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

11-301(1)

No. 11(1)

11-300(1)

#2; #15; #18; #19; #22; #27(1)

 
Handle Material

Plastic(13)

Metal(7)

Aluminum(6)

Reinforced Nylon(5)

Plastic/Rubber(2)

Rubber/Aluminum(2)

Steel(1)

Contoured Metal(1)

Rubber Grip(1)

Plastic/Metal(1)

Wood(1)

Die Cast(1)

Aluminum/Rubber(1)

Reinforced Plastic(1)

Cast Metal(1)

Metal Casing;Rubber Grip(1)

Metal/Soft Bi-Material(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"(12)

4 1/2"(4)

3 1/2"(2)

5 1/2"(2)

3"(2)

5 5/8"(2)

7"(2)

4 4/5"(1)

5 1/4"(1)

2 1/4"(1)

8 1/4"(1)

4 in(1)

2.5"(1)

2 1/2"(1)

6 1/2"(1)

5 1/8"(1)

6 in(1)

5-3/8"(1)

6-1/8"(1)

5.5"(1)

4-1/4"(1)

5 3/8"(1)

6 3/4"(1)

4"(1)

 
Knife Type

Utility(17)

Retractable Blade Knife(13)

Snap-Off Blade Knife(5)

Replaceable Blade Knife(4)

Box Cutter(3)

Hobby Knife(3)

Craft Knife(2)

Retractable Utility(1)

Linoleum Flooring(1)

Folding Replaceable Blade Knife(1)

Detail Knife Set(1)

Safety Cutter(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved