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

Currently Filtered by

Category

Metered Dispenser Refills

Refine Search

  GO
 
Brand

BRIGHT Air(35)

Air Wick(16)

Boardwalk(8)

Diversey(5)

Fresh Products(4)

San Jamar(4)

TimeMist(4)

Rubbermaid Commercial(2)

 
Color(s)

Orange(10)

Clear(10)

Blue(9)

Purple(7)

Red(6)

Green(6)

Pink(5)

Yellow(2)

White/Gray(1)

 
Packing Type

Refill(18)

Diffuser(16)

Jar(13)

Box(8)

Pack(6)

Cartridge(5)

Aerosol(4)

Bottle(3)

Can(2)

Pail(1)

Starter Kit(1)

TCell Refill(1)

 
Manufacturer Part Number

900021(1)

MYFF6I036M78(1)

79716CT(1)

79716(1)

78473CT(1)

78297CT(1)

78297(1)

MYFF6I036M89(1)

MYFF6I036M72(1)

80420CT(1)

MYFF6I036M54(1)

100924937(1)

100910595(1)

100888677(1)

100888675(1)

100871126(1)

CURVESAPCT(1)

79717CT(1)

82291(1)

CURVEMANCT(1)

RW107801227(1)

1049547(1)

1044024(1)

1042419CT(1)

401693(1)

RW107801232(1)

RW107801231(1)

RW107801228(1)

402236(1)

82291EA(1)

91112EA(1)

91112(1)

91110EA(1)

91110(1)

85723(1)

85189CT(1)

85175CT(1)

CURVESAP(1)

CURVEMAN(1)

900021CT(1)

900255(1)

900270PK(1)

900270(1)

900269PK(1)

900269(1)

900256PK(1)

900256(1)

900255PK(1)

900254EA(1)

900271PK(1)

900254(1)

900134EA(1)

900134CT(1)

900115EA(1)

900115CT(1)

900022CT(1)

900022(1)

900271(1)

900272(1)

CURVECMECT(1)

900439EA(1)

CURVECME(1)

CURVECBLCT(1)

CURVECBL(1)

900441EA(1)

900441(1)

900440EA(1)

900440(1)

900439(1)

900272PK(1)

900438EA(1)

900438(1)

900437(1)

900436EA(1)

900436(1)

900288EA(1)

900288CT(1)

1049548(1)

 
Country of Origin

CN(36)

US(24)

MX(15)

AF(1)

MY(1)

TH(1)

 
Capacity (Volume)

0.67 oz(29)

2.5 oz(14)

4 oz(6)

1.7 oz(3)

0.77 oz(2)

2 oz(1)

6.17 oz(1)

48 ml(1)

5.3 oz(1)

3 oz(1)

7.5 oz(1)

 
Scent

Hawaiian Blossoms & Papaya(6)

Sweet Lavender & Violet(4)

Citrus Burst(4)

Meadow Breeze(4)

Fresh Waters(3)

Lavender & Chamomile(3)

Mango(3)

Cool & Clean(3)

Cucumber Melon(2)

Fresh Linen(2)

Summer Delights(2)

Macintosh Apple & Cinnamon(2)

Spiced Apple(2)

Cotton Blossom(2)

Midnight Woods & Vanilla(2)

Calm Waters & Spa(2)

Fresh Petals & Peach(2)

Macintosh Apples & Cinnamon(2)

Linen & Spring Breeze(2)

Cherry Blossom & Magnolia(2)

Paradise Retreat(2)

Pure Linen(1)

Mango Burst(1)

Tropic Wave(1)

Pacific Glacier(1)

Wakening Spring; Polar Mist; Blue Splash; Citrus; Crystal Breeze(1)

Country Garden(1)

Raspberry Acai Splash(1)

Xtreme Citrus(1)

Hawaii Exotic Papaya & Hibiscus Flower(1)

Seaside Breeze(1)

Hawai'i Exotic Papaya and Hibiscus Flower(1)

Snuggle Fresh Linen(1)

Apple Cinnamon Medley(1)

Alpine Forest(1)

Tea Lily(1)

Coconut Vanilla(1)

Tropical(1)

Fresh(1)

Citrus(1)

Green Apple(1)

Fresh Floral(1)

Mango Smoothie(1)

 
Capacity (Weight)

44.12 g(8)

8 oz(5)

0.03 lbs(4)

16 lb(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved