Banner1 Banner1
 
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') 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(47)

Dahle(8)

Universal One(5)

Wiss(5)

Scotch(5)

Clauss(4)

Universal(3)

Klein Tools(2)

First Aid Only(1)

 
Manufacturer Part Number

01-005692(1)

01009881(1)

1234667097J(1)

1234677097J(1)

01005434(1)

01-005413(1)

01005409(1)

01005411(1)

01005412(1)

1241621001(1)

1243021001(1)

1569301001(1)

158920-1001(1)

1699201001(1)

153582-1002(1)

142490-1005(1)

1245821003(1)

12-94587097J(1)

1299118697WJ(1)

01005390(1)

01-005037J(1)

50006(1)

50007(1)

50008(1)

50005(1)

50004(1)

44216(1)

44217(1)

44218(1)

50009(1)

50010(1)

01-004252J(1)

01-004681J(1)

01-004761J(1)

01-004250J(1)

01-004249J(1)

50038(1)

6004(1)

01-004244J(1)

1708201001(1)

1710201001(1)

92008(1)

92009(1)

92010(1)

1448B(1)

1448(1)

1427(1)

1428(1)

1447(1)

92011(1)

92012(1)

1DSN(1)

29N(1)

38N(1)

1571B(1)

1570B(1)

92013(1)

92021(1)

92022(1)

21007(1)

21005(1)

1945221003(1)

1949001001(1)

199700-1001(1)

1945121007(1)

1945121003(1)

1905001001(1)

194220-1001(1)

194230-1001(1)

34527797J(1)

94167097J(1)

95017197J(1)

95037197J(1)

99977797J(1)

94817797J(1)

94518697WJ(1)

94307097J(1)

94417297J(1)

94507797J(1)

43218(1)

43217(1)

14606(1)

14607(1)

14609200(1)

14597-200(1)

14597(1)

14231(1)

14596(1)

14596-200(1)

14643(1)

14648(1)

14849(1)

14850(1)

14851(1)

14756(1)

14755(1)

14669(1)

14731(1)

14739(1)

13901(1)

13824(1)

10703(1)

13130(1)

13131(1)

10572(1)

10260(1)

10252(1)

10257(1)

10259(1)

13135(1)

13138(1)

13526(1)

13529(1)

13731(1)

13402(1)

13227(1)

13139(1)

13140(1)

13141(1)

14866(1)

14871(1)

15987(1)

16197(1)

16445(1)

15986(1)

15985(1)

15913(1)

15917(1)

15984(1)

16447(1)

19016(1)

41318(1)

41418(1)

41511(1)

41218(1)

40618(1)

19017(1)

19018(1)

40617(1)

15589(1)

15588(1)

15452(1)

15454(1)

15459(1)

15387(1)

15179(1)

14872(1)

14873(1)

14874(1)

15507(1)

15508(1)

15584(1)

15585(1)

15586(1)

15583(1)

15582(1)

15552(1)

15553(1)

15554(1)

10098(1)

 
Country of Origin

CN(141)

DE(8)

IT(7)

US(2)

TW(2)

 
Material(s)

Stainless Steel(84)

Stainless Steel/Plastic(16)

Titanium(14)

Titanium-Bonded Stainless Steel(7)

ABS Plastic; Solingen Steel(7)

Recycled Plastic(5)

Metal/Plastic(5)

Steel(4)

Polycarbonate(4)

Hot Forged Carbon Steel(4)

Plastic(2)

Plastic; Stainless Steel(2)

Carbo Titanium(2)

Carbon Steel(1)

Plastic; Titanium(1)

ABS Plastic handle, Solingen Steel blade(1)

Nickel-Plated(1)

 
Style

Home/Office(109)

Safety/Classroom(35)

Utility(10)

Speed Cutter(2)

Multipurpose(1)

First-Aid(1)

Folded(1)

Home/Shop(1)

 
Tip Type

Pointed(127)

Rounded(27)

Beveled/Straight(3)

Micro Tip(2)

Beveled(1)

 
Left/Right Hand Use

For left or right hand use(139)

For right hand use(15)

For left hand use(2)

 
Handle Type

Straight(118)

Offset(35)

Double Thumb(4)

Bent(2)

Double-Loop Handle(1)

 
Handle Color

Assorted(39)

Black(34)

Gray/Yellow(12)

Blue(12)

Gray(9)

Orange(9)

Black/Green(5)

Gray/Red(5)

Red(5)

Blue/Gray(4)

Orange/Gray(4)

White/Orange(2)

Black/White(2)

White/Green(2)

Black/Gray(2)

Blue/Red; Pink/Purple; Green/Blue(1)

Pink(1)

Nickel-Plated(1)

Pink Watercolor(1)

Blue/White(1)

Black/Orange(1)

Navy/White(1)

Silver(1)

Burgundy(1)

 
Cut Length

3 1/2"(35)

2"(17)

3 1/4"(16)

1 3/4"(15)

3 1/8"(8)

3"(7)

4 1/2"(7)

2 3/4"(5)

2 1/2"(5)

3 1/10"(5)

3 3/4"(5)

1 5/8"(3)

1 3/5"(3)

3 3/8"(2)

1 1/2"(2)

2 5/8"(2)

1 7/8"(2)

1"(2)

2 4/5"(2)

3 7/8"(2)

3 3/10"(1)

3 5/8"(1)

4"(1)

1 1/4"(1)

2 1/8"(1)

2 1/4"(1)

4 1/4"(1)

3 5/16"(1)

2 1/4"; 3 1/2"(1)

2 3/5"(1)

 
Scissor Length

8"(70)

5"(40)

7"(25)

9"(9)

6"(3)

4 3/4"(2)

8 1/8"(2)

5 1/4"(2)

10"(2)

4"(2)

5";7"(1)

5"; 7"(1)

4 1/2"(1)

 
Scissor Type

Scissors(115)

Shears(45)

 
 
 

© 2019-2020 Onestop, Inc., All Rights Reserved