SELECT `e`.*, IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) AS `is_active` FROM `catalog_category_entity` AS `e` INNER JOIN `catalog_category_entity_int` AS `at_is_active_default` ON (`at_is_active_default`.`entity_id` = `e`.`entity_id`) AND (`at_is_active_default`.`attribute_id` = '46') AND `at_is_active_default`.`store_id` = 0 LEFT JOIN `catalog_category_entity_int` AS `at_is_active` ON (`at_is_active`.`entity_id` = `e`.`entity_id`) AND (`at_is_active`.`attribute_id` = '46') AND (`at_is_active`.`store_id` = 67) WHERE (`e`.`entity_id` IN('1977', '2209', '2210')) AND (IF(at_is_active.value_id > 0, at_is_active.value, at_is_active_default.value) = '1') SCISSORS & SHEARS - HOUSEHOLD SCISSORS & SHEARS - HOUSEWARE & HOUSEHOLD SUPPLIES
  1. See Detail

SCISSORS & SHEARS


View as Grid List

16 items

Page
per page
Set Descending Direction
  1. TAKE-APART KITCHEN SCISSORS
    $14.49 /EA
    94717097 TAKEAPART KIT SCIS Learn More
  2. HOME & SEWING SCISSORS SET
    $12.49 /EA
    WHCS2 HOME & SEW SCISSOR ST Learn More
  3. 10" SHOP SHEAR
    $15.49 /EA
    W912 WISS 10" SHOP SHEAR Learn More
  4. SPRING LOADED SCISSORS
    $15.99 /EA
    58362 8-1/4 SPG LOADED SHP SCISSORS Learn More
  5. 8'' RIGHT-HANDED SHEARS
    $13.99 /EA
    12-94518697WJ 8" BENT FIS SCISS Learn More
  6. SHEFFIELD STAINLESS STEEL SCISSORS
    $4.59 /EA
    58300 5 1/2" SS SCISSORS Learn More
  7. SPRING LOADED SCISSORS
    $12.99 /EA
    58360 6 SPG LOADED SHP SCISSORS Learn More
  8. 8" STRAIGHT SCISSORS
    $11.49 /EA
    34527797 8" STRAIGHT SCISS Learn More
  9. HOUSEHOLD SCISSORS
    $9.69 /EA
    W812 HOUSEHOLD SCISSORS Learn More
View as Grid List

16 items

Page
per page
Set Descending Direction