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_1` 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(8)

Stanley(7)

COSCO(7)

Stanley Tools(4)

Fiskars(3)

Great Neck(3)

Clauss(3)

San Jamar(1)

IRWIN(1)

Wiss(1)

X-ACTOŽ(1)

Dexter(1)

Westcott(1)

 
Color(s)

Gray(5)

Black(5)

Red(4)

Blue/Black(3)

Yellow(3)

Gray/Red(2)

Chrome(2)

Blue(2)

Orange; White(1)

Orange(1)

White/Orange(1)

Yellow/Gray(1)

Red/Silver(1)

Silver(1)

Royal Blue(1)

Black/Silver(1)

Black/Chrome(1)

Red Orange(1)

Yellow/Black(1)

Brown(1)

Mixed(1)

 
Quantity

1 each(1)

1 set(1)

 
Packing Type

Nylon soft compression case(1)

Pack(1)

 
Manufacturer Part Number

X3279(1)

X3724(1)

X3730Q(1)

X5285(1)

X3274(1)

X3204(1)

20400(1)

3732Q(1)

X3001(1)

XZ3601(1)

1630501001(1)

2088600(1)

KK403(1)

WK8V(1)

58116(1)

58113(1)

1651101001(1)

1651801001(1)

12113(1)

091524(1)

091514(1)

10079(1)

10143P(1)

10-150(1)

10175(1)

10-065(1)

10049(1)

18026(1)

18966(1)

18968(1)

10-189C(1)

10280(1)

091467(1)

091482(1)

091508(1)

091460(1)

091459(1)

10-499(1)

10499BX(1)

10788(1)

15411(1)

 
Country of Origin

CN(27)

US(13)

TH(1)

 
Blade Material

Steel(9)

Stainless Steel(6)

Cutlery Steel(3)

Titanium Bonded(2)

High Carbon Steel(1)

 
Blade Length

1 1/2"(3)

2"(1)

Assorted(1)

5 9/10"(1)

6 1/2"(1)

15/16"(1)

1 in(1)

1 3/4"(1)

1"(1)

9 mm(1)

3 1/2"(1)

18 mm(1)

4"(1)

6"(1)

2 3/10"(1)

 
Blade Type

Replaceable(14)

Retractable(10)

Single Edge(3)

Utility Knife(2)

Retractable; Single Edge(2)

Razor(1)

Utility(1)

Assorted Blades, 4 Styles(1)

Retractable; Snap-Off(1)

Retractable; Round Point(1)

13-point Retractable Snap-Off(1)

8-point Retractable Snap-Off(1)

 
Number of Blades

1(28)

3(5)

11(1)

4(1)

12(1)

10(1)

 
Replacement Blades

11-921(3)

Sheffield 12850(2)

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

Fiskars 196010(1)

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

X-ACTO X11, X231, X511(1)

Fiskars 164190-1003(1)

11-300(1)

Standard(1)

Bi-Metal Utility Blades(1)

Sheffield 12851(1)

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

X-Acto X211, X411, X811(1)

#091509 (sold separately)(1)

#091483 (sold separately)(1)

#0914641 (sold separately)(1)

#091471 (sold separately)(1)

#091509(1)

11-987(1)

X-ACTOŽ X11, X231, X511(1)

11-301(1)

 
Blade Shape

Straight-Edged(6)

Triangular(5)

Point(2)

Oblong(2)

Fine Point(2)

Snap-Off(2)

Double-Ended Trapezoid(1)

Assorted(1)

Round-Point Blade(1)

 
Blade #

#11(9)

12850(2)

12851(1)

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

No. 11(1)

11-301(1)

11-300(1)

 
Handle Material

Plastic(12)

Metal(7)

Aluminum(6)

Plastic/Rubber(2)

Rubber/Aluminum(2)

Contoured Metal(1)

Steel(1)

Rubber Grip(1)

Metal/Soft Bi-Material(1)

Aluminum/Rubber(1)

Reinforced Plastic(1)

Metal Casing;Rubber Grip(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"(9)

4 1/2"(2)

3 1/2"(2)

5 1/2"(2)

5 1/4"(1)

4 4/5"(1)

2 1/4"(1)

4 in(1)

8 1/4"(1)

2 1/2"(1)

4"(1)

5 1/8"(1)

5-3/8"(1)

4-1/4"(1)

6-1/8"(1)

5 5/8"(1)

6 1/2"(1)

6 3/4"(1)

3"(1)

 
Knife Type

Retractable Blade Knife(12)

Utility(10)

Replaceable Blade Knife(4)

Snap-Off Blade Knife(4)

Craft Knife(3)

Hobby Knife(3)

Retractable Utility(1)

Knife Holder(1)

Folding Replaceable Blade Knife(1)

 
 
 
 
 

© 2018-2019 Office 8, All Rights Reserved