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

Currently Filtered by

Category

Letters

Refine Search

  GO
 
Manufacturer Part Number

T79745(1)

T79744(1)

T79743(1)

T79751(1)

T79754(1)

T79757(1)

T79756(1)

T79755(1)

T79742(1)

T79741(1)

T79512(1)

T79511(1)

T79505(1)

T79514(1)

T79622(1)

T79721(1)

T79642(1)

T79641(1)

T79758(1)

T79759(1)

T79804(1)

T79803(1)

T79802(1)

T79805(1)

T79806(1)

T79841(1)

T79840(1)

T79809(1)

T79801(1)

T79783(1)

T79768(1)

T79767(1)

T79766(1)

T79769(1)

T79780(1)

T79782(1)

T79781(1)

T79504(1)

T79503(1)

T79053(1)

T79052(1)

T79050(1)

T79101(1)

T79102(1)

T79246(1)

T79201(1)

T79104(1)

T79047(1)

T79041(1)

T79008(1)

T79007(1)

T79006(1)

T79009(1)

T79010(1)

T79021(1)

T79012(1)

T79011(1)

T79248(1)

T79290(1)

T79411(1)

T79406(1)

T79405(1)

T79412(1)

T79413(1)

T79502(1)

T79501(1)

T79414(1)

T79404(1)

T79402(1)

T79302(1)

T79301(1)

T79294(1)

T79303(1)

T79305(1)

T79401(1)

T79306(1)

T79842(1)

T79845(1)

TCR5866(1)

TCR5845(1)

TCR5822(1)

TCR75126(1)

TCR75140(1)

TCR75176(1)

TCR75174(1)

TCR75150(1)

TCR5821(1)

TCR5820(1)

TCR5694(1)

TCR5617(1)

TCR5566(1)

TCR5813(1)

TCR5814(1)

TCR5819(1)

TCR5818(1)

TCR5815(1)

TCR75178(1)

TCR75261(1)

TCR75402(1)

TCR75401(1)

TCR75400(1)

TCR77119(1)

TCR77120(1)

TCR77171(1)

TCR77161(1)

TCR77121(1)

TCR75272(1)

TCR75271(1)

TCR75264(1)

TCR75263(1)

TCR75262(1)

TCR75265(1)

TCR75266(1)

TCR75268(1)

TCR75267(1)

TCR5518(1)

TCR5454(1)

TCR5343(1)

TCR5342(1)

T79944(1)

TCR5344(1)

TCR5345(1)

TCR5348(1)

TCR5347(1)

TCR5346(1)

T79943(1)

T79941(1)

T79901(1)

T79851(1)

T79846(1)

T79902(1)

T79903(1)

T79940(1)

T79905(1)

T79904(1)

TCR5349(1)

TCR5350(1)

TCR5386(1)

TCR5385(1)

TCR5384(1)

TCR5387(1)

TCR5427(1)

TCR5453(1)

TCR5449(1)

TCR5442(1)

TCR5383(1)

TCR5382(1)

TCR5375(1)

TCR5374(1)

TCR5351(1)

TCR5376(1)

TCR5377(1)

TCR5381(1)

TCR5379(1)

T79005(1)

T79004(1)

CTP4194(1)

CTP4193(1)

CTP4191(1)

CTP4399(1)

CTP4628(1)

EU487215(1)

CTP4633(1)

CTP4632(1)

CTP4037(1)

CTP2103(1)

CTP1892(1)

CTP1889(1)

CTP1886(1)

CTP1893(1)

CTP1894(1)

CTP2102(1)

CTP2080(1)

CTP1949(1)

EU845033(1)

EU845034(1)

EU845234(1)

EU845220(1)

EU845196(1)

EU845235(1)

HYG10001(1)

HYG10010(1)

HYG10006(1)

HYG10002(1)

EU845155(1)

EU845154(1)

EU845049(1)

EU845044(1)

EU845035(1)

EU845060(1)

EU845065(1)

EU845153(1)

EU845066(1)

CTP1884(1)

CTP1868(1)

CD130060(1)

CD130059(1)

CD130058(1)

CD130061(1)

CD130062(1)

CD130065(1)

CD130064(1)

CD130063(1)

CD130057(1)

CD130056(1)

CD130047(1)

CD130046(1)

CD130045(1)

CD130050(1)

CD130051(1)

CD130055(1)

CD130054(1)

CD130053(1)

CD130066(1)

CD130067(1)

CTP0288(1)

CTP0279(1)

CD130077(1)

CTP1194(1)

CTP1196(1)

CTP1229(1)

CTP1228(1)

CTP1227(1)

CD130076(1)

CD130075(1)

CD130070(1)

CD130069(1)

CD130068(1)

CD130071(1)

CD130072(1)

CD130074(1)

CD130073(1)

HYG10019(1)

HYG10028(1)

T465(1)

T464(1)

T459(1)

T470(1)

T475(1)

T480(1)

T479(1)

T477(1)

T458(1)

T457(1)

T435(1)

T434(1)

T433(1)

T436(1)

T437(1)

T440(1)

T439(1)

T438(1)

T487(1)

T488(1)

T78302(1)

T78301(1)

T78003(1)

T78303(1)

T78304(1)

T79003(1)

T79002(1)

T79001(1)

T78002(1)

T78001(1)

T506(1)

T494(1)

T493(1)

T507(1)

T508(1)

T510(1)

T509(1)

T432(1)

T2705(1)

T1567(1)

LAS1901(1)

LAS1715(1)

T1599(1)

T1600(1)

T1613(1)

T1604(1)

T1602(1)

LAS1714(1)

LAS1713(1)

LAS1704(1)

LAS1703(1)

LAS1702(1)

LAS1705(1)

LAS1709(1)

LAS1711(1)

LAS1710(1)

T1614(1)

T1615(1)

T1790(1)

T1789(1)

T1788(1)

T1791(1)

T2700(1)

T2704(1)

T2703(1)

T2702(1)

T1787(1)

T1786(1)

T1618(1)

T1617(1)

T1616(1)

T1620(1)

T1780(1)

T1785(1)

T1781(1)

CD130042(1)

 
 
 

© 2018-2019 Office Solutions & Innovations, Inc., All Rights Reserved