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

Currently Filtered by

Category

Toilet And Urinal Deodorizers

Refine Search

  GO
Brand

Fresh Products(27)

Boardwalk(22)

Diversey(14)

Big D Industries(9)

AbilityOne(4)

HOSPECO(3)

Rubbermaid Commercial(2)

Georgia Pacific Professional(2)

Bobrick(1)

OdoBan(1)

Health Gards(1)

Height

1.75(1)

Color(s)

Blue(21)

Red(12)

White(11)

Green(9)

Orange(8)

Purple(5)

White/Pink(3)

Clear(2)

Pink(2)

Yellow(1)

Gray(1)

White|FFFFFF(1)

Lavender(1)

Blue; White(1)

Red; White(1)

Black(1)

Width

16.00(2)

Country of Origin

US(68)

MX(14)

TW(2)

CN(2)

For Use With

F1000, F2000, F4000, F5000, F9000 SS, F7000, Flex(1)

Length

14.50(1)

Scent

Cherry(16)

Mango(7)

Cotton Blossom(6)

Spiced Apple(5)

Mint(4)

Springtime(4)

Cucumber Melon(4)

Apple(3)

Evergreen(3)

Berry(2)

Citrus(2)

Fresh(2)

Ocean Mist(2)

Lavender(2)

Tropical(2)

Unscented(2)

Green Apple(2)

Coastal Breeze(2)

Melon Mist(2)

Linen Fresh(1)

Natural(1)

Mandarin Orange(1)

Wintergreen(1)

Herbal Mint(1)

Melon(1)

Mountain Air(1)

Calypso Lime(1)

Lavender Lace(1)

Bubblegum(1)

Honeysuckle(1)

Camphor(1)

Fabulous(1)

Weight

2.00(1)

Capacity (Weight)

3 oz(5)

4 oz(5)

0.42 oz(4)

58 g(3)

2.5 oz(2)

1.25 lbs(2)

3.5 oz(2)

19 oz(2)

1.5 oz(1)

3.25 oz(1)

.125 oz(1)

2.25 oz(1)

0.4 lb(1)

3 1/2 oz(1)

Deodorizer Type

Urinal Screen(37)

Urinal Block(19)

Urinal Screens(11)

Toilet Bowl Block(9)

Urinal Block Screen(6)

Cleaner & Deodorizer Refill(2)

Cartridge(1)

Toilet Bowl Clip(1)

Special Features

Wave 3D(9)

Side Tab(1)

Value Pack-Stock up and save!(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved