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 ('484')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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(66)

Fiskars(28)

Universal(8)

Clauss(4)

Scotch(4)

First Aid Only(1)

Klein Tools(1)

 
Manufacturer Part Number

10098(1)

01-004244J(1)

12-94587097J(1)

1234677097J(1)

1234667097J(1)

01009881(1)

01-005692(1)

01005411(1)

01005409(1)

01005390(1)

01-004761J(1)

01-004250J(1)

01-004249J(1)

FAE6004(1)

1508101001(1)

44218(1)

44217(1)

43218(1)

43217(1)

41511(1)

41418(1)

41318(1)

41218(1)

40618(1)

19018(1)

19017(1)

142490-1005(1)

153582-1002(1)

16907(1)

21005(1)

92023(1)

92022(1)

92021(1)

92019(1)

92010(1)

92009(1)

92008(1)

1448B(1)

1448(1)

1428(1)

1427(1)

99977097J(1)

1541301001(1)

95037197J(1)

95017197J(1)

94817797J(1)

94518697WJ(1)

94417297J(1)

94307097J(1)

94167097J(1)

34527797J(1)

1997101007(1)

1945001001(1)

1905001001(1)

19016(1)

16671(1)

10252(1)

13227(1)

14643(1)

14607(1)

14606(1)

14597(1)

14231(1)

13901(1)

13824(1)

13731(1)

13529(1)

13526(1)

13402(1)

13141(1)

14669(1)

13140(1)

13139(1)

13138(1)

13135(1)

13131(1)

13130(1)

10703(1)

10572(1)

10260(1)

10259(1)

10257(1)

14648(1)

14739(1)

16670(1)

15582(1)

16512(1)

16447(1)

16445(1)

15986(1)

15972(1)

15971(1)

15917(1)

15588(1)

15585(1)

15584(1)

15583(1)

15554(1)

14755(1)

15553(1)

15454(1)

15452(1)

15387(1)

15179(1)

14910(1)

14872(1)

14871(1)

14851(1)

14850(1)

14849(1)

14756(1)

92024(1)

 
Country of Origin

CN(101)

VN(5)

IT(4)

US(1)

CA(1)

 
Tip Type

Pointed(92)

Rounded(20)

 
Blade Material

Stainless Steel(78)

Titanium(8)

Titanium-Bonded Stainless Steel(6)

Steel(4)

Hot Forged Carbon Steel(3)

Metal(3)

Nickel-Plated Hot-Forged Carbon Steel(1)

CarboTitanium(1)

Carbo Titanium(1)

Titanium/Metal(1)

Nickel-Plated Steel(1)

Titanium Bonded Stainless Steel(1)

Titanium Bonded Stainless Steel with Non-Stick Coating(1)

Stainless Steel; Titanium and Non-Stick Coating(1)

Titanium-Bonded Stainless Steel with Non-Stick Coating(1)

Stainless Steel Non-Stick Coating(1)

 
Left/Right Hand Use

For left or right hand use(97)

For right hand use(12)

For left hand use(3)

 
Handle Material

Plastic(103)

Hot Forged Carbon Steel(3)

Plastic with Softgrip Inserts(3)

Nickel-Plated Hot-Forged Carbon Steel(1)

Nickel-Plated Steel(1)

Steel(1)

 
Handle Type

Straight(85)

Offset(27)

 
Handle Color

Black(23)

Assorted(17)

Gray/Yellow(12)

Blue(10)

Randomly Assorted(9)

Gray(8)

Orange(7)

Red(5)

Gray/Red(4)

Black/Gray(3)

White/Green(2)

Nickel(2)

Orange/Gray(2)

Blue/Gray(2)

Pink(1)

Gray/Purple(1)

Burgundy(1)

Black/Orange(1)

Black/White(1)

Silver(1)

 
Overall Length

8"(56)

5"(27)

7"(16)

9"(6)

5"; 7"(1)

6"(1)

4.5"(1)

10"(1)

5.25"(1)

8.5"(1)

7.75"(1)

 
Cut Length

3.5"(25)

1.75"(15)

3.25"(14)

3"(8)

2"(8)

3.1"(5)

3.13"(5)

3.75"(4)

4.5"(4)

1.6"(3)

2.75"(3)

1.5"(2)

3.38"(2)

3.88"(2)

2.25"(1)

2.25"; 3.5"(1)

3.31"(1)

2.5"(1)

8"(1)

3.3"(1)

2.63"(1)

1.88"(1)

2.8"(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved