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

Currently Filtered by

Category

Scissors

Refine Search

  GO
 
Brand

Westcott(80)

Fiskars(49)

Sparco(18)

Acme United(16)

Scotch(6)

SKILCRAFT(5)

AbilityOne(5)

Helix(4)

Clauss(2)

Medline(1)

Micro-Tip(1)

Business Source(1)

Creativity Street(1)

PhysiciansCare(1)

First Aid Only(1)

 
Color

Assorted(42)

Black(32)

Gray(27)

Blue(19)

Red(15)

Silver(14)

Orange(11)

Stainless Steel(8)

Yellow(6)

Turquoise(3)

White(3)

Purple(3)

Bright Assorted(3)

Pink(3)

Gray/Yellow(3)

Shiny Red(2)

Shiny Pink(2)

Shiny Purple(2)

Black/Gray(2)

Shiny Blue(2)

Lime(1)

Black/White(1)

Green(1)

Metallic(1)

Copper(1)

Multi(1)

Burgundy(1)

 
Packaged Quantity

1 Each(145)

12 / Pack(8)

3 / Pack(4)

12 / Box(3)

3 / Bundle(3)

2 / Pack(3)

1 Pack(3)

30 / Pack(2)

1 / Pack(2)

1 / Each(2)

6 / Pack(1)

10 / Pack(1)

12 / Set(1)

20 / Set(1)

 
Weight (Approximate)

1.12 oz(2)

1.76 oz(1)

1.28 oz(1)

3.20 oz(1)

2.08 oz(1)

10.88 oz(1)

1 lb(1)

1.60 oz(1)

 
Warranty

Manufacturer's lifetime warranty.(3)

Manufacturer's limited ten-year warranty.(2)

Manufacturer's limited lifetime warranty.(2)

 
Special Features

Non-Stick Blades(2)

Children(1)

Left Handed(1)

Most Suitable For Ages Six And Up(1)

 
Cutting Length

3.50"(15)

1.75"(10)

3"(8)

3.25"(4)

2.75"(3)

3.13"(3)

8"(3)

3.75"(3)

3.63"(2)

3.12"(2)

2"(2)

2.80"(1)

1.88"(1)

4.63"(1)

1.50"(1)

3.31"(1)

3.88"(1)

2.50"(1)

1.63"(1)

2.63"(1)

9"(1)

 
Handle Orientation

Straight-left/right(56)

Left/Right(38)

Straight(22)

Bent(10)

Bent-left/right(10)

Bent-right(4)

Straight-right(2)

Left(2)

Bent-left(1)

Straight-left(1)

 
Tip

Pointed(77)

Blunted(35)

Straight(8)

Bent(4)

Micro(2)

Round(1)

Clip Point(1)

 
Manufacturer Part Number

1708201001(1)

1905001001(1)

1941601027(1)

1941601028(1)

1541301001(1)

1539001001(1)

1535201002(1)

1535201004(1)

1535201005(1)

1535821002(1)

1941601029(1)

1941601030(1)

1943001031(1)

1949001001(1)

1997001001(1)

34527797J(1)

1943001030(1)

1943001029(1)

1941601031(1)

194220-1001(1)

1943001027(1)

1943001028(1)

1424901005(1)

1299118697WJ(1)

01004249J(1)

01004250J(1)

01004681J(1)

01004761J(1)

01004244J(1)

FAE6004(1)

44217(1)

65647(1)

962001(1)

90292(1)

01005037J(1)

01005409(1)

1243021001(1)

1294508697WJ(1)

1294518697WJ(1)

1294587097J(1)

1234677097J(1)

1055801004(1)

01005434(1)

01-005692(1)

01-009881(1)

1055801001(1)

94167097J(1)

94307097J(1)

25225BD(1)

25226(1)

25226BD(1)

25227(1)

25225(1)

02041(1)

6296575(1)

6296578(1)

6296579(1)

6296580(1)

39040(1)

39041(1)

39047(1)

39048(1)

39049(1)

99830(1)

39046(1)

39045(1)

39042(1)

39043(1)

39043BD(1)

39044(1)

6296574(1)

5110-00-293-9199(1)

99977097J(1)

069300(1)

069600(1)

379249(1)

95037197J(1)

95017197J(1)

94337097J(1)

94417297J(1)

94507797J(1)

94817797J(1)

470249(1)

MDS0895018(1)

5110-00-161-6912(1)

5110012414371(1)

5110012414373(1)

5110012414375(1)

1448B(1)

1448(1)

1427(1)

1428(1)

1441B(1)

1447(1)

44216(1)

4321-8(1)

14606(1)

14607(1)

14608(1)

14643(1)

14597200(1)

14596200(1)

13901(1)

14100(1)

14102(1)

14231(1)

14648(1)

14669(1)

14850(1)

14851(1)

14866(1)

14867(1)

14849(1)

14756(1)

14726(1)

14727(1)

14739(1)

14755(1)

13824(1)

13731(1)

10703(1)

13130(1)

13131(1)

13135(1)

10572(1)

10571(1)

10257(1)

10259(1)

10260(1)

10545(1)

13138(1)

13139(1)

13525(1)

13526(1)

13529(1)

13594(1)

13404(1)

13402(1)

13140(1)

13141(1)

13151(1)

13227(1)

14871(1)

14872(1)

16657(1)

16660(1)

16670(1)

16671(1)

16656(1)

16512(1)

16446(1)

16447(1)

16459(1)

16468(1)

18686(1)

18687(1)

4121-8(1)

41418(1)

41511(1)

4321-7(1)

4061-8(1)

4061-7(1)

18690(1)

19016(1)

19017(1)

19018(1)

16401(1)

16031(1)

15387(1)

15452(1)

15454(1)

15515(1)

15315(1)

15179(1)

14874(1)

14906(1)

14910(1)

15121(1)

15552(1)

15554(1)

15971(1)

15972(1)

15984(1)

15985(1)

15917(1)

15589(1)

15583(1)

15584(1)

15585(1)

15588(1)

10098(1)

 
Country of Origin

CN(6)

US(5)

VN(1)

 
Material

Stainless Steel(119)

Plastic(82)

Titanium(26)

Rubber(12)

Metal(4)

Steel(4)

Nickel Plated(3)

Acrylonitrile Butadiene Styrene (ABS)(2)

Polycarbonate(2)

Carbon Steel(2)

Titanium Nitride(1)

Nylon(1)

Cast Alloy(1)

Aluminum(1)

 
Height

0.3"(2)

0.5"(1)

8.7"(1)

 
Width

2.3"(2)

3.5"(1)

2.9"(1)

 
Material(s)

Titanium(6)

Stainless Steel(3)

Metal/Plastic(1)

Titanium-Bonded Stainless Steel(1)

Stainless Steel/Plastic(1)

 
Length

8"(71)

5"(61)

7"(23)

9"(4)

6"(3)

5.5"(2)

8.3"(2)

6.6"(1)

6.3"(1)

4"(1)

0.5"(1)

4.5"(1)

 
Style

Home/Office(10)

Safety/Classroom(2)

 
Handle Material

Plastic(73)

Rubber(11)

Acrylonitrile Butadiene Styrene (ABS)(2)

Polycarbonate(2)

Cast Alloy(1)

 
Handle Type

Straight(8)

Offset(4)

 
Tip Type

Pointed(9)

Rounded(2)

Beveled/Straight(1)

 
Handle Color

Assorted(27)

Black(21)

Blue(11)

Gray(11)

Gray/Yellow(9)

Stainless Steel(7)

Red(7)

Silver(6)

Orange(4)

Yellow(3)

Shiny Blue(2)

Shiny Pink(2)

Bright Assorted(2)

Shiny Red(2)

Turquoise(2)

Shiny Purple(2)

Purple(1)

Pink(1)

Blue/Gray(1)

Black/White(1)

Burgundy(1)

White(1)

 
Blade Length

7"(2)

5"(2)

8"(1)

 
Blade Material

Stainless Steel(117)

Titanium(23)

Metal(2)

Aluminum(1)

Carbon Steel(1)

 
Blade Color

Silver(4)

Black(1)

Gray(1)

 
Left/Right Hand Use

For left or right hand use(8)

For left hand use(2)

For right hand use(1)

 
Cut Length

3 1/2"(4)

3 3/10"(1)

3 1/5"(1)

3 1/4"(1)

1 3/4"(1)

1 5/8"(1)

2"(1)

2 1/2"(1)

4 1/2"(1)

 
Scissor Length

8"(6)

5"(3)

7"(1)

6"(1)

9"(1)

 
Scissor Type

Scissors(6)

Scissors/Shears(5)

Shears(1)

 
 
 

© 2018-2019 Rhino Office Products, All Rights Reserved