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 (`pinfo`.`sku` IN ('SPN870000','SPN860000','SPN808700','SPN808600','SPN808500','SPN808400','SPN808300','SPN808200','SPN808100','SPN800200','SPN800100','SPN800000','SPN766105','SPN766104','SPN766003','SPN765965','SPN765960','SPN765955','SPN765905','SPN765904','SPN765805','SPN765804I','SPN765804','SPN765705','SPN765704','SPN765605','SPN765604','SPN765603','SPN765505','SPN765504','SPN765405','SPN765404I','SPN765404','SPN765305','SPN765304I','SPN765304','SPN765205','SPN765204I','SPN765204','SPN765105','SPN765104I','SPN765104','SPN765005','SPN765004I','SPN765004','SPN764905','SPN764904I','SPN764904','SPN764855','SPN764805','SPN764804','SPN764803','SPN749665','SPN749655','SPN749630','SPN749615','SPN749605','SPN749604','SPN738015','SPN738004','SPN738003','SPN732003','SPN722515','SPN722503','SPN718003','SPN712015','SPN712003','SPN711815','SPN711803','SPN711603','SPN711515','SPN711503','SPN711055','SPN711004','SPN711003','SPN710803','SPN710603','SPN710503','SPN710403','SPN710203','SPN706404','SPN706304','SPN706204','SPN706104','SPN705503','SPN705403','SPN705303','SPN705203','SPN705103','SPN702355','SPN702315','SPN702305','SPN702304','SPN702215','SPN702205','SPN702155','SPN702115','SPN702105','SPN702104','SPN702055','SPN702015','SPN702005','SPN702004','SPN701955','SPN701915','SPN701905','SPN701904','SPN701855','SPN701815','SPN701805','SPN701804','SPN701755','SPN701715','SPN701705','SPN701655','SPN701615','SPN701605','SPN701555','SPN701515','SPN701505','SPN701455','SPN701415','SPN701405','SPN701404','SPN701355','SPN701315','SPN701305','SPN701304','SPN701255','SPN701215','SPN701205','SPN701155','SPN701115','SPN701105','SPN701104','SPN701055','SPN701015','SPN701005','SPN700955','SPN700915','SPN700905','SPN700904','SPN700855','SPN700815','SPN700805','SPN700804','SPN700755','SPN700715','SPN700705','SPN700704','SPN700655','SPN700615','SPN700605','SPN700604','SPN700555','SPN700515','SPN700505','SPN700504','SPN700455','SPN700415','SPN700405','SPN700404','SPN700355','SPN700315','SPN700305','SPN700304','SPN700255','SPN700215','SPN700205','SPN700204','SPN700155','SPN700115','SPN700105','SPN700104','SPN691900','SPN690300','SPN682000','SPN652500','SPN652000','SPN644500','SPN641000','SPN637400','SPN634300','SPN631000','SPN629000','SPN628000','SPN621700','SPN612000','SPN611000','SPN609900','SPN609700','SPN609500','SPN608600','SPN608500','SPN608100','SPN607600','SPN607500','SPN606800','SPN587505','SPN587004','SPN586500','SPN586205','SPN586105','SPN583955','SPN583930','SPN583915','SPN583905','SPN583865','SPN583860','SPN583855','SPN583830','SPN583815','SPN583804','SPN583755','SPN583730','SPN583715','SPN583705','SPN583704','SPN583400','SPN583104','SPN582955','SPN582930','SPN582915','SPN582905','SPN582904','SPN582865','SPN582860','SPN582855','SPN582830','SPN582815','SPN582804','SPN582704','SPN582405','SPN582404','SPN582255','SPN582230','SPN582215','SPN582205','SPN582204','SPN582105','SPN582065','SPN582055','SPN582030','SPN582015','SPN582005','SPN582004','SPN581560','SPN581555','SPN581530','SPN581515','SPN581505','SPN581355','SPN581255','SPN581155','SPN581065','SPN581055','SPN581030','SPN581015','SPN581005','SPN581004','SPN580300','SPN580200','SPN580100','SPN556065','SPN556060','SPN556055','SPN556030','SPN556015','SPN556005','SPN556004','SPN555565','SPN555555','SPN555530','SPN555515','SPN555505','SPN555504','SPN485602','SPN485002','SPN484502','SPN484002','SPN483502','SPN483002','SPN482202','SPN482002','SPN481502','SPN480702','SPN480602','SPN480502','SPN480402','SPN480302','SPN480202','SPN480102','SPN480002','SPN478602','SPN474002','SPN473802','SPN473602','SPN473402','SPN473002','SPN472402','SPN471602','SPN471002','SPN470402','SPN470202','SPN459702','SPN453402','SPN445065','SPN445055','SPN445030','SPN445015','SPN445004','SPN444065','SPN444055','SPN444030','SPN444015','SPN444005','SPN444004','SPN433065','SPN433055','SPN433030','SPN433015','SPN433005','SPN433004','SPN409065','SPN409055','SPN409030','SPN409015','SPN409005','SPN409004','SPN408904','SPN408903','SPN408803','SPN408265','SPN408255','SPN408230','SPN408215','SPN408205','SPN408204','SPN407504','SPN407365','SPN407360','SPN407355','SPN407330','SPN407315','SPN407305','SPN407304','SPN406465','SPN406460','SPN406455','SPN406430','SPN406415','SPN406405','SPN406404','SPN406065','SPN406060','SPN406055','SPN406030','SPN406015','SPN406005','SPN406004','SPN405565','SPN405560','SPN405555','SPN405530','SPN405515','SPN405505','SPN405504','SPN405065','SPN405060','SPN405055','SPN405030','SPN405015','SPN405005','SPN405004','SPN404760','SPN404755','SPN404730','SPN404715','SPN404705','SPN404704','SPN404665','SPN404660','SPN404655','SPN404630','SPN404615','SPN404605','SPN404604','SPN404565','SPN404555','SPN404530','SPN404515','SPN404505','SPN404504','SPN404205','SPN403065','SPN403060','SPN403055','SPN403030','SPN403015','SPN403005','SPN403004','SPN401765','SPN401755','SPN401730','SPN401715','SPN401705','SPN401704','SPN401465','SPN401460','SPN401455','SPN401430','SPN401415','SPN401405','SPN401404','SPN401365','SPN401360','SPN401355','SPN401330','SPN401315','SPN401305','SPN401304','SPN401265','SPN401255','SPN401230','SPN401215','SPN401205','SPN401065','SPN401060','SPN401055','SPN401030','SPN401015','SPN401005','SPN401004','SPN400465','SPN400455','SPN400430','SPN400415','SPN400405','SPN400404','SPN400065','SPN400055','SPN400030','SPN400015','SPN400005','SPN383560','SPN383555','SPN383530','SPN383515','SPN383505','SPN383504','SPN383060','SPN383055','SPN383030','SPN383015','SPN383005','SPN383004','SPN382160','SPN382155','SPN382130','SPN382115','SPN382105','SPN382104','SPN353604','SPN353503','SPN353003','SPN351602','SPN351502','SPN351402','SPN351302','SPN351202','SPN351102','SPN350960','SPN350955','SPN350930','SPN350915','SPN350904','SPN350860','SPN350855','SPN350830','SPN350815','SPN350805','SPN350804','SPN350760','SPN350755','SPN350730','SPN350715','SPN350704','SPN350660','SPN350655','SPN350630','SPN350615','SPN350605','SPN350604','SPN350560','SPN350555','SPN350530','SPN350515','SPN350505','SPN350504','SPN350460','SPN350455','SPN350430','SPN350415','SPN350405','SPN350404','SPN350303','SPN350260','SPN350255','SPN350230','SPN350215','SPN350205','SPN350204','SPN350160','SPN350155','SPN350130','SPN350115','SPN350105','SPN350104','SPN349765','SPN349760','SPN349755','SPN349730','SPN349715','SPN349705','SPN349704','SPN339703','SPN339655','SPN334306','SPN334304','SPN334206','SPN334204','SPN334106','SPN334104','SPN334055','SPN334004','SPN333955','SPN333904','SPN333806','SPN333804','SPN333706','SPN333704','SPN331003','SPN330855','SPN330805','SPN330804','SPN330555','SPN330505','SPN330504','SPN330065','SPN330055','SPN330030','SPN330015','SPN330005','SPN330004','SPN329765','SPN329755','SPN329730','SPN329715','SPN329705','SPN329704','SPN329003','SPN326503','SPN326265','SPN326260','SPN326255','SPN326230','SPN326215','SPN326205','SPN326204','SPN326103','SPN326003','SPN325103','SPN324007','SPN323903','SPN323104','SPN323055','SPN323005','SPN323004','SPN322065','SPN322055','SPN322030','SPN322015','SPN322005','SPN322004','SPN321865','SPN321860','SPN321855','SPN321805','SPN321804','SPN321704','SPN321600','SPN321303','SPN321003','SPN320500','SPN320265','SPN320255','SPN320230','SPN320215','SPN320205','SPN320204','SPN320003','SPN319703','SPN319503','SPN319403','SPN319003','SPN318960','SPN318955','SPN318930','SPN318915','SPN318905','SPN318603','SPN317960','SPN317955','SPN317930','SPN317915','SPN317905','SPN317103','SPN315960','SPN315955','SPN315930','SPN315915','SPN315905','SPN315904','SPN315460','SPN315455','SPN315430','SPN315415','SPN315405','SPN315404','SPN315255','SPN315206','SPN315205','SPN315204','SPN315155','SPN315105','SPN315104','SPN315004','SPN314800','SPN314600','SPN314400','SPN314200','SPN314000','SPN313955','SPN313905','SPN313800','SPN313703','SPN313600','SPN313355','SPN313305','SPN312960','SPN312955','SPN312905','SPN312855','SPN312805','SPN312804','SPN312660','SPN312655','SPN312605','SPN312555','SPN312505','SPN312455','SPN312405','SPN312007','SPN311807','SPN311707','SPN311607','SPN311165','SPN311155','SPN311130','SPN311115','SPN311105','SPN311104','SPN311103','SPN311065','SPN311060','SPN311055','SPN311030','SPN311015','SPN311005','SPN311004','SPN310903','SPN310605','SPN310505','SPN310405','SPN310265','SPN310255','SPN310230','SPN310215','SPN310205','SPN309765','SPN309755','SPN309730','SPN309715','SPN309705','SPN309704','SPN309665','SPN309655','SPN309630','SPN309615','SPN309605','SPN309604','SPN309265','SPN309255','SPN309230','SPN309215','SPN309205','SPN309204','SPN309060','SPN309055','SPN309030','SPN309015','SPN309005','SPN309004','SPN308965','SPN308955','SPN308905','SPN308904','SPN308855','SPN308805','SPN308804','SPN308603','SPN308504','SPN308260','SPN308255','SPN308230','SPN308215','SPN308205','SPN308204','SPN308160','SPN308155','SPN308130','SPN308115','SPN308105','SPN308060','SPN308055','SPN308030','SPN308015','SPN308005','SPN308004','SPN307560','SPN307555','SPN307530','SPN307515','SPN307505','SPN307504','SPN307460','SPN307455','SPN307430','SPN307415','SPN307405','SPN307204','SPN307104','SPN306803','SPN306765','SPN306760','SPN306755','SPN306730','SPN306715','SPN306705','SPN306704','SPN306055','SPN306030','SPN306015','SPN306005','SPN306004','SPN306003','SPN305003','SPN304803','SPN304703','SPN304560','SPN304555','SPN304530','SPN304515','SPN304505','SPN304504','SPN304355','SPN304305','SPN304304','SPN304003','SPN303704','SPN303503','SPN303305','SPN303304','SPN303103','SPN303065','SPN303060','SPN303055','SPN303030','SPN303015','SPN303005','SPN303004','SPN302905','SPN302904','SPN302803','SPN302503','SPN302404','SPN302403','SPN302303','SPN302265','SPN302255','SPN302205','SPN302204','SPN302103','SPN302065','SPN302055','SPN302005','SPN302004','SPN301803','SPN301665','SPN301655','SPN301630','SPN301615','SPN301605','SPN301604','SPN301465','SPN301460','SPN301455','SPN301430','SPN301415','SPN301405','SPN301404','SPN301365','SPN301355','SPN301330','SPN301315','SPN301305','SPN301304','SPN300865','SPN300855','SPN300830','SPN300815','SPN300805','SPN300804','SPN300604','SPN300565','SPN300555','SPN300530','SPN300515','SPN300505','SPN300504','SPN300430','SPN300415','SPN300404','SPN300365','SPN300360','SPN300355','SPN300330','SPN300315','SPN300305','SPN300304','SPN300265','SPN300260','SPN300255','SPN300230','SPN300215','SPN300205','SPN300204','SPN300065','SPN300055','SPN300030','SPN300015','SPN300005','SPN300004','SPN300003','SPN298005','SPN298004','SPN297755','SPN297705','SPN280465','SPN280455','SPN280430','SPN280415','SPN280405','SPN280365','SPN280355','SPN280330','SPN280315','SPN280305','SPN248560','SPN248555','SPN248530','SPN248515','SPN248505','SPN233060','SPN233055','SPN233030','SPN233015','SPN233005','SPN231055','SPN231005','SPN229055','SPN229005','SPN224055','SPN224005','SPN224004','SPN221603','SPN221555','SPN221505','SPN221504','SPN220060','SPN220055','SPN220030','SPN220015','SPN220005','SPN220004','SPN213060','SPN213055','SPN213030','SPN213015','SPN213005','SPN213004','SPN211560','SPN211555','SPN211530','SPN211515','SPN211505','SPN211504','SPN206565','SPN206555','SPN206505','SPN205165','SPN205155','SPN205130','SPN205115','SPN205105','SPN205104','SPN205003','SPN204765','SPN204755','SPN204730','SPN204715','SPN204705','SPN204704','SPN204465','SPN204455','SPN204430','SPN204415','SPN204405','SPN204165','SPN204155','SPN204130','SPN204115','SPN204105','SPN204104','SPN204003','SPN203865','SPN203855','SPN203830','SPN203815','SPN203805','SPN203804','SPN203465','SPN203460','SPN203455','SPN203430','SPN203415','SPN203405','SPN203404','SPN125165','SPN125160','SPN125155','SPN125130','SPN125115','SPN125105','SPN121065','SPN121055','SPN121030','SPN121015','SPN121005','SPN121004','SPN120465','SPN120455','SPN120430','SPN120415','SPN120405','SPN120404','SPN120265','SPN120255','SPN120230','SPN120215','SPN120205','SPN120204','SPN108706','SPN108606','SPN108506','SPN106265','SPN106255','SPN106230','SPN106215','SPN106205','SPN106204','SPN106065','SPN106055','SPN106030','SPN106015','SPN106005','SPN106004','SPN105604','SPN105565','SPN105555','SPN105530','SPN105515','SPN105505','SPN105504','SPN102404','SPN102403','SPN102103','SPN101865','SPN101860','SPN101855','SPN101830','SPN101815','SPN101805','SPN101804','SPN101765','SPN101755','SPN101730','SPN101715','SPN101605','SPN101604','SPN101360','SPN101355','SPN101330','SPN101315','SPN101305','SPN101304','SPN101255','SPN101230','SPN101215','SPN101205','SPN101204','SPN008765','SPN008760','SPN008755','SPN008730','SPN008715','SPN008705','SPN008704','SPN008565','SPN008560','SPN008555','SPN008530','SPN008515','SPN008505','SPN008504','SPN008460','SPN008455','SPN008430','SPN008415','SPN008405','SPN008404','SPN008265','SPN008255','SPN008230','SPN008215','SPN008205','SPN008204','SPN007860','SPN007855','SPN007830','SPN007815','SPN007805','SPN007804','SPN007560','SPN007555','SPN007530','SPN007515','SPN007505','SPN007504','SPN007065','SPN007055','SPN007030','SPN007015','SPN007005','SPN006760','SPN006755','SPN006730','SPN006715','SPN006705','SPN006704','SPN006560','SPN006555','SPN006530','SPN006515','SPN006505','SPN006504','SPN006160','SPN006155','SPN006130','SPN006115','SPN006105','SPN006104','SPN005565','SPN005555','SPN005530','SPN005515','SPN005505','SPN005504','SPN004065','SPN004055','SPN004030','SPN004015','SPN004005','SPN004004','SPN003560','SPN003555','SPN003530','SPN003515','SPN003505','SPN003504','SPN002065','SPN002055','SPN002030','SPN002015','SPN002005','SPN002004','SPN001955','SPN001905','SPN001904','')) 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 '%SpartanChemicals' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('SpartanChemicals' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+SpartanChemicals' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"SpartanChemicals"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"SpartanChemicals"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"SpartanChemicals"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"SpartanChemicals"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+SpartanChemicals' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='SpartanChemicals',`category_4` ='SpartanChemicals') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'SpartanChemicals,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('SpartanChemicals', `pinfo`.`desc_title`)) DESC

Currently Filtered by

SpartanChemicals

SpartanChemicals

Refine Search

  GO
 
Category Filter

Floor Finishes, Waxes, Seals(150)

Disinfectants(99)

Clothesline Fresh Laundry Care(94)

Food Processing/Handling/Service(93)

Industrial Cleaners(79)

Specialty Cleaners(61)

Wax Strippers(46)

All Purpose Cleaners(44)

Contempo Carpet Care(41)

Wood Floor Care(37)

Green Solutions Environmentally Preferred Products(34)

Consume Nature's Way(33)

RTU Handi Sprays(32)

Kitchen Services(30)

Clean On The Go Captive Dispensing System Products(30)

Restroom Cleaners(29)

SparClean Warewash Products(27)

Skin Care(26)

Lite'n Foamy(26)

Aerosols(24)

Vehicle Care(20)

Concrete Care(18)

BioRenewables(17)

Restroom Care(11)

ecoreAircare System(5)

Green Solutions Captive Dispensing System Products(4)

Wipes(3)

ecore Aircare System(1)

 
 
 

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