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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` WHERE (`pinfo`.`sku` IN ('KET105RSWTLH','KET105RSWTRH','KET105RSWTHCLH','KET105RSWTHCRH','KET105RWSTREC','KET172HCSM','KET173HCSM','KET174HCSM','KET175HCSM','KET172HC','KET173HC','KET174HC','KET175HC','KET1622','KET1622PE','KET1622BV','KET1626','KET1626PE','KET1626BV','KET1636','KET1636SM','KET1622SM','KET1622PESM','KET1622BVSM','KET1626SM','KET1626PESM','KET1626BVSM','KETCMC1430','KETCMC1436','KETCMC1442','KETCMC1430PE','KETCMC1436PE','KETCMC1442PE','KETCMC1430BV','KETCMC1436BV','KETCMC1442BV','KETCMC1333','KETCMC1333S','KET160SM','KET170SM','KET172SM','KET173SM','KET174SM','KET175SM','KET176SM','KET177SM','KET178SM','KET179SM','KET180SM','KET181SM','KET182SM','KET184SM','KET190SM','KET192SM','KET160PESM','KET170PESM','KET172PESM','KET173PESM','KET174PESM','KET175PESM','KET176PESM','KET177PESM','KET178PESM','KET179PESM','KET180PESM','KET181PESM','KET182PESM','KET184PESM','KET190PESM','KET192PESM','KET160BVSM','KET170BVSM','KET172BVSM','KET173BVSM','KET174BVSM','KET175BVSM','KET176BVSM','KET177BVSM','KET178BVSM','KET179BVSM','KET180BVSM','KET181BVSM','KET182BVSM','KET184BVSM','KET190BVSM','KET192BVSM','KET160','KET170','KET171','KET172','KET173','KET174','KET175','KET176','KET177','KET178','KET179','KET180','KET181','KET182','KET184','KET190','KET192','KET160PE','KET170PE','KET171PE','KET172PE','KET173PE','KET174PE','KET175PE','KET176PE','KET177PE','KET178PE','KET179PE','KET180PE','KET181PE','KET182PE','KET184PE','KET190PE','KET192PE','KET160BV','KET170BV','KET171BV','KET172BV','KET173BV','KET174BV','KET175BV','KET176BV','KET177BV','KET178BV','KET179BV','KET180BV','KET181BV','KET182BV','KET184BV','KET190BV','KET192BV','KET121','KET123','KET125','KET126','KET127','KET129','KET131','KET133','KET135','KET121PE','KET123PE','KET125PE','KET126PE','KET127PE','KET129PE','KET131PE','KET133PE','KET135PE','KET121BV','KET123BV','KET125BV','KET126BV','KET127BV','KET129BV','KET131BV','KET133BV','KET135BV','KET121SM','KET123SM','KET125SM','KET126SM','KET127SM','KET129SM','KET131SM','KET133SM','KET135SM','KET121PESM','KET123PESM','KET125PESM','KET126PESM','KET127PESM','KET129PESM','KET131PESM','KET133PESM','KET135PESM','KET121BVSM','KET123BVSM','KET125BVSM','KET126BVSM','KET127BVSM','KET129BVSM','KET131BVSM','KET133BVSM','KET135BVSM','KET121PR','KET123PR','KET125PR','KET126PR','KET127PR','KET129PR','KET131PR','KET133PR','KET135PR','KET121PEPR','KET123PEPR','KET125PEPR','KET126PEPR','KET127PEPR','KET129PEPR','KET131PEPR','KET133PEPR','KET135PEPR','KET121BVPR','KET123BVPR','KET125BVPR','KET126BVPR','KET127BVPR','KET129BVPR','KET131BVPR','KET133BVPR','KET135BVPR','KET126PEMISM','KET131PEMISM','KET126PEMI','KET131PEMI','KETSDL2419','KETSDL2419LED','KETSD2420','KETSD2420R','KETATM1630','KETATM1824','KETATM1836','KETATM2430','KETATM2436','KETFTM1630','KETFTM1824','KETFTM1836','KETFTM2430','KETFTM2436','KETTPM1622','KETTPM1824','KETTPM1830','KETTPM1836','KETTPM2436','KETTPMA1622','KETTPMA1824','KETTPMA1830','KETSSF1014','KETSSF1620','KETSSF1630','KETSSF1824','KETSSF1836','KETSSF2430','KETSSF2436','KETLB3','KETLB3D','KET715SK','KET715K','KET915K','KETR2430','KETR3030','KETR3036','KETR3630','KETR3636','KETR4830','KETR4836','KETR6036','KETR2430PE','KETR3030PE','KETR3036PE','KETR3630PE','KETR3636PE','KETR4830PE','KETR4836PE','KETR6036PE','KETR2430BV','KETR3030BV','KETR3036BV','KETR3630BV','KETR3636BV','KETR4830BV','KETR4836BV','KETR6036BV','KETSR2430','KETSR3030','KETSR3036','KETSR3630','KETSR3636','KETSR4830','KETSR4836','KETSR6036','KETSR2430PE','KETSR3030PE','KETSR3036PE','KETSR3630PE','KETSR3636PE','KETSR4830PE','KETSR4836PE','KETSR6036PE','KETSR2430BV','KETSR3030BV','KETSR3036BV','KETSR3630BV','KETSR3636BV','KETSR4830BV','KETSR4836BV','KETSR6036BV','KETSM2430','KETSM3030','KETSM3036','KETSM3630','KETSM3636','KETSM4830','KETSM4836','KETSM6036','KETSM2430PE','KETSM3030PE','KETSM3036PE','KETSM3630PE','KETSM3636PE','KETSM4830PE','KETSM4836PE','KETSM6036PE','KETSM2430BV','KETSM3030BV','KETSM3036BV','KETSM3630BV','KETSM3636BV','KETSM4830BV','KETSM4836BV','KETSM6036BV','KETSML2430','KETSML3030','KETSML3630','KETSML3636','KETSML4830','KETSML6036','KETSML2430PE','KETSML3030PE','KETSML3630PE','KETSML3636PE','KETSML4830PE','KETSML6036PE','KETSML2430BV','KETSML3030BV','KETSML3630BV','KETSML3636BV','KETSML4830BV','KETSML6036BV','KETDD2424','KETDD2430','KETDD2436','KETDD2442','KETDD2424BV','KETDD2430BV','KETDD2436BV','KETDD2442BV','KETDD2424PE','KETDD2430PE','KETDD2436PE','KETDD2442PE','KETL16','KETL18','KETL24','KETL30','KETL36','KETL48','KETL60','KETSML16','KETSML18','KETSML24','KETSML30','KETSML36','KETSML48','KETSML60','KET1526','KET1526S','KET1526SH','KETDD1926','KETDD1926S','KETDD1926SH','KETDD2326','KETDD2326S','KET3722','KET3722S','KET3722SH','KET3722SHS','KETMS322','KETMS324','KETMS326','KETMS330','KETMS336','KETMS342','KETMS424','KETMS428','KETMS430','KETMS434','KETMS436','KETMS440','KET171TL','KET173TL','KET171TLLED','KET173TLLED','KET174SS','KET175SS','KET174SSSM','KET175SSSM','KETAL1536PE','KETAL1626PE','KETAL1626BV','KETAL1630PE','KETAL1630BV','KETAL2026PE','KETAL2026BV','KETAL2430PE','KETAL2430BV','KETAL2436PE','KETAL2436BV','KETAL2440PE','KETALD2625PE','KETALD3128PE','KETALTV2625PE','KETALTV3128PE','KETALTV3625PE','KETAL2026PELED','KETALD2625PELED','KETALTV3128PELED','KET2328L','KET3528L','KET3928L','KETAL227WF','')) 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 MATCH(`desc_short`) AGAINST ('ketcham' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+ketcham' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"ketcham"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"ketcham"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"ketcham"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"ketcham"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+ketcham' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='ketcham',`category_4` ='ketcham') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'ketcham,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('ketcham', `pinfo`.`desc_title`)) DESC

We're sorry, there were no matches for "ketcham" on our site.

Search Tips

Please try searching for different keywords that describe the item you're looking for.

  • Descriptive Keyword(s) - example: "Copy Paper Letter"
  • Product Name (full or partial) - example: "Boise Fireworx Copy Paper"
  • Stock Number (full or partial) - example: "UNV21200"
  • Manufacturer Name or Abbreviation - example: "HP"

Continue Shopping

  • Order by Item Number
  • Browse Our Products

Need Help? Contact us at 516-294-9444 or email Customer Service at service@supplyowl.com.

1%
Searching for your Best Results.....
 

© 2018-2019 Supply Owl Office is A Division of Supply Owl, Inc., All Rights Reserved