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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 ('DIA01585','ANS92600859','GN1W07524ES','AKTIVEWIPE','CPC01900EA','GOLPURE8','DIA84022EA','GOLSTANDBK','KCC75190EA','DIA99795','SJN307951CT','SJN307951','GUR1431','DIA03016','GOLGSNF250EA','GOLGSNF249EA','GOLGSNF105EA','GJO26085','BWK8600EA','GOLET002B','GOL695618','KCC03076','GPC16560','GJO2508080','MTH01854','GOLSPRY16','AMR1001907EA','MTH01160','DIA06047','GOJ1312D1','GJO21100','GJO24080','MRC2930CT','INN748194','GOLGSVF105','GOLGSVF104','GOLGSVF103','MIIMDS6801','MIIMDS6802','RAC02814','RCMPC12001227','CLO35418CT','CLO35418EA','RAC76334','RAC94201EA','PGC58775PR','PGC22569PR','GOLSPRY32','GOLSPRY24','DIA123450','')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 ('cleaningsupply' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+cleaningsupply' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"cleaningsupply"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"cleaningsupply"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"cleaningsupply"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"cleaningsupply"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+cleaningsupply' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='cleaningsupply',`category_4` ='cleaningsupply') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'cleaningsupply,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('cleaningsupply', `pinfo`.`desc_title`)) DESC

cleaning_supplies

Currently Filtered by

cleaning_supplies

Cleaning_supplies

Refine Search

  GO
Category

Multipurpose Cleaners(7)

Gloves(7)

Hand Soaps/Cleaners(7)

Disinfectants(4)

Hand Sanitizers(3)

Facial Tissues(3)

Spray Bottles(3)

Paper Towels(2)

Bathroom Tissues(2)

Examination Gloves(2)

Bathroom Cleaners(2)

Liquid Soap / Sanitizer Dispensers(1)

Thermometers/Probe Covers(1)

Safety Masks(1)

Glass Cleaners(1)

Brand

Genuine Joe(4)

Dial(3)

Pine-Sol(2)

Medline(2)

Method(2)

Pledge(2)

Angel Soft Ultra Professional Series(1)

Innovative Living(1)

Kleenex(1)

Softsoap(1)

Gojo®(1)

Marcal Pro(1)

Dial Complete(1)

Comet(1)

Spic and Span(1)

Professional Lysol(1)

Lysol(1)

RMC(1)

Scott(1)

Color

White(9)

Clear(7)

Blue(3)

Dark Blue(2)

Red(1)

Pink(1)

Chrome Black(1)

Aqua(1)

Light Blue(1)

Recycled

No(20)

Yes(7)

Price Range

$0-$99.99(45)

$200-$299.99(1)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CleanAir Granite Office

© 2020-2021 Granite Office, LLC, All Rights Reserved