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_38` 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)

COSCO(8)

Westcott(7)

Stanley(7)

slice(6)

AbilityOne(5)

Great Neck(3)

Clauss(3)

Boardwalk(3)

Quality Park(3)

Stanley Tools(3)

Fiskars(2)

IRWIN(2)

Wiss(1)

San Jamar(1)

 
Color(s)

Gray(8)

Yellow/Black(5)

Green(5)

Black(5)

Red(5)

Gray; Green(3)

Blue/Black(3)

Yellow(3)

Blue(2)

Chrome(2)

Silver(2)

Green/Black(2)

Gray; Orange(2)

Orange(2)

Gray/Red(2)

White/Orange(1)

Orange/Black(1)

Red/Silver(1)

Mixed(1)

Black/Silver(1)

Assorted(1)

Yellow/Gray(1)

Red Orange(1)

Black/Yellow(1)

Black/Chrome(1)

Royal Blue(1)

 
Quantity

1 each(1)

 
Packing Type

Nylon soft compression case(1)

 
Manufacturer Part Number

12113(1)

1651801001(1)

58113(1)

58116(1)

2088600(1)

2082101(1)

1630501001(1)

XZ3601(1)

X3274(1)

X3204(1)

X3279(1)

X3724(1)

X5285(1)

X3730Q(1)

6215252(1)

6215253(1)

10503(1)

10400(1)

10514(1)

10550(1)

WK8V(1)

10554(1)

00200(1)

KK403(1)

6215259(1)

6215255(1)

6217915(1)

46907(1)

46909(1)

46908(1)

X3001(1)

3732Q(1)

10049(1)

18968(1)

10-065(1)

10079(1)

10-150(1)

10-099(1)

18966(1)

18026(1)

16475(1)

16474(1)

17379(1)

17519(1)

17521(1)

17520(1)

10175(1)

10-189C(1)

091479(1)

091467(1)

091482(1)

091508(1)

091524(1)

091514(1)

091460(1)

091459(1)

10499BX(1)

10-499(1)

10788(1)

UKNIFE25(1)

UKNIFE75(1)

UKNIFE45(1)

16473(1)

 
Country of Origin

CN(45)

US(17)

MX(1)

 
Blade Material

Steel(13)

Ceramic(7)

Zirconium Oxide(6)

Stainless Steel(5)

Cutlery Steel(3)

Carbon Steel(3)

Titanium Bonded(2)

Metal(1)

High Carbon Steel(1)

 
Blade Length

1/2"(4)

1 1/2"(4)

1.29"(3)

1 1/4"(3)

1.2"(3)

1"(2)

4"(2)

2.5"(2)

3 1/4"(1)

15/16"(1)

0.1"(1)

6 1/2"(1)

1 3/4"(1)

3 1/2"(1)

2 3/10"(1)

9 mm(1)

0.39"(1)

2"(1)

Assorted(1)

5 9/10"(1)

 
Blade Width

0.25"(7)

0.24"(3)

0.47"(2)

 
Blade Type

Retractable(18)

Replaceable(16)

Double Sided; Replaceable(5)

Fixed(4)

Utility(4)

Single Edge(3)

Double Sided(3)

Retractable; Snap-Off(2)

Razor(1)

Fixed; Non Replaceable Micro Safety Blade(1)

Retractable; Round Point(1)

Retractable; Single Edge(1)

13-point Retractable Snap-Off(1)

8-point Retractable Snap-Off(1)

Assorted Blades, 4 Styles(1)

 
Number of Blades

1(45)

3(7)

8(2)

7(1)

13(1)

4(1)

10(1)

12(1)

11(1)

 
Replacement Blades

11-921(4)

slice 10404; slice 10408(3)

QUA46912(3)

slice 10526; slice 10528(2)

Sheffield 12850(2)

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

X-ACTO X11, X231, X511(2)

Bi-Metal Utility Blades(1)

5110-01-621-4767(1)

5110-01-621-8439(1)

5110-01-621-6647(1)

Standard(1)

5110-01-627-5257(1)

5110-01-621-5254(1)

Utility(1)

Fiskars 164190-1003(1)

#091483 (sold separately)(1)

#0914641 (sold separately)(1)

11-987(1)

11-300(1)

#091509 (sold separately)(1)

#091471 (sold separately)(1)

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

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

X-Acto X211, X411, X811(1)

#091509(1)

Sheffield 12851(1)

 
Blade Shape

Straight(12)

Straight-Edged(11)

Triangular(5)

Rectangle(3)

Fine Point(2)

Oblong(2)

Double-Ended Trapezoid(1)

Assorted(1)

Point(1)

Snap-Off(1)

Round-Point Blade(1)

 
Blade #

#11(8)

#S3(3)

10404(3)

10526(2)

12850(2)

No. 11(1)

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

11-300(1)

12851(1)

 
Handle Material

Plastic(22)

Metal(8)

Aluminum(6)

Reinforced Nylon(5)

ABS Plastic(3)

Plastic/Rubber(3)

Rubber/Aluminum(2)

Die Cast(2)

Steel(1)

Rubber Grip(1)

Die-Cast Metal; Rubber(1)

Plastic/Metal(1)

Metal Casing;Rubber Grip(1)

Aluminum/Rubber(1)

Reinforced Plastic(1)

Metal/Soft Bi-Material(1)

Contoured Metal(1)

 
Contains

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

 
Handle Length

6"(13)

5 1/2"(5)

7"(5)

5 3/4"(3)

4"(3)

6 3/4"(2)

3 1/2"(2)

2 1/4"(2)

4 1/2"(2)

2 1/2"(2)

4 4/5"(1)

2 3/8"(1)

2.5"(1)

2.4"(1)

5 1/4"(1)

8 1/4"(1)

5"(1)

5 3/8"(1)

4 1/4"(1)

6.15"(1)

5 1/8"(1)

6 1/8"(1)

6 1/2"(1)

5 5/8"(1)

3"(1)

 
Knife Type

Utility(19)

Retractable Blade Knife(15)

Safety Cutter(8)

Snap-Off Blade Knife(4)

Replaceable Blade Knife(4)

Box Cutter(3)

Hobby Knife(3)

Craft Knife(2)

Utility Knife(2)

Retractable Utility(1)

Folding Replaceable Blade Knife(1)

 
 
 

© 2019-2020 NBJ Form & Function Inc. , All Rights Reserved