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','spl_call_for_price') 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(26)

Air Wick(17)

Fresh Products(9)

Boardwalk(8)

Glade(3)

Diversey(2)

 
Application

Odor Control(43)

Automatic Odor Control(19)

Warmer(3)

 
For Use With

Air Wick 78046, 78047, 78048(4)

Fresh Products ourfresh 2.0 Dispenser(3)

BRIGHT Air 900669, 900254(2)

Air Wick 78046(2)

BRIGHT Air 900668, 900254(1)

BRIGHT Air 900670CT, 900254(1)

BRIGHT Air 900670, 900254(1)

 
Physical Form

Liquid(30)

Solid(19)

Oil(10)

Gel(6)

 
Volume Capacity

0.67 oz(25)

2.5 oz(6)

4 oz(6)

1.7 oz(1)

 
Country of Origin

CN(26)

US(22)

MX(17)

 
Color(s)

Clear(12)

Orange(10)

Blue(8)

Purple(6)

Green(6)

Red(4)

Pink(1)

Red/Orange(1)

White(1)

 
Packing Type

Diffuser(2)

Pack(1)

 
Capacity (Volume)

2.5 oz(2)

0.67 oz(1)

 
Scent

Cool & Clean(4)

Citrus Burst(4)

Meadow Breeze(4)

Hawaiian Blossoms & Papaya(3)

Lavender & Chamomile(3)

Sweet Lavender & Violet(3)

Fresh Linen(3)

Cotton Blossom(3)

Cucumber Melon(3)

Mango(3)

Spiced Apple(3)

Fresh Waters(3)

Summer Delights(2)

Paradise Retreat(2)

Hawai'i Exotic Papaya and Hibiscus Flower(2)

Apple Cinnamon Medley(2)

Fresh(2)

Fabulous(2)

Macintosh Apple & Cinnamon(2)

Linen & Spring Breeze(2)

Calm Waters & Spa(2)

Seaside Breeze(1)

Coconut Vanilla(1)

Citrus(1)

Hawaiian Blossoms and Papaya(1)

Fresh Petals & Peach(1)

Hawaiian Breeze(1)

Clean Linen(1)

Cashmere Woods(1)

 
Capacity (Weight)

44.12 g(8)

8 oz(6)

2.89 oz(6)

0.16 lb(3)

0.67 oz(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved