Banner1 Banner1
 
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') 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(36)

Air Wick(22)

Fresh Products(9)

Boardwalk(8)

Diversey(6)

San Jamar(4)

TimeMist(4)

Rubbermaid Commercial(2)

 
Color(s)

Clear(11)

Blue(10)

Orange(10)

Purple(7)

Red(6)

Green(6)

Pink(5)

Yellow(2)

White/Gray(1)

Red/Orange(1)

 
Packing Type

Refill(26)

Diffuser(16)

Jar(14)

Box(8)

Pack(6)

Bottle(6)

Cartridge(5)

Aerosol(4)

Can(2)

Starter Kit(1)

TCell Refill(1)

Pail(1)

Refill Pad(1)

 
Manufacturer Part Number

78473(1)

78297CT(1)

78297(1)

MYFF6I036M89(1)

78473CT(1)

79716(1)

80095(1)

79717CT(1)

79717(1)

79716CT(1)

MYFF6I036M78(1)

MYFF6I036M72(1)

EA36CB(1)

100924937(1)

100910595(1)

100898962(1)

EA36 CME(1)

EA36CT30(1)

MYFF6I036M54(1)

EA36SAP(1)

EA36MG30(1)

80095CT(1)

80420(1)

RW107801231(1)

RW107801228(1)

RW107801227(1)

402236(1)

RW107801232(1)

401693(1)

1049548(1)

1049547(1)

1044024(1)

1042419CT(1)

91112EA(1)

91112(1)

85175(1)

82291EA(1)

82291(1)

80420CT(1)

85175CT(1)

85189CT(1)

91110EA(1)

91110(1)

85723(1)

100888677(1)

100888675(1)

900269PK(1)

900269(1)

900256PK(1)

900256(1)

900270(1)

900270PK(1)

900272PK(1)

900272(1)

900271PK(1)

900271(1)

900255PK(1)

900255(1)

900115CT(1)

900022CT(1)

900022(1)

900021CT(1)

900115EA(1)

900134CT(1)

900254EA(1)

900254(1)

900134EA(1)

900288CT(1)

900288EA(1)

CURVECME(1)

CURVECBLCT(1)

CURVECBL(1)

900441EA(1)

CURVECMECT(1)

CURVEMAN(1)

100871126(1)

CURVESAPCT(1)

CURVESAP(1)

CURVEMANCT(1)

900441(1)

900440EA(1)

900437EA(1)

900437(1)

900436EA(1)

900436(1)

900438(1)

900438EA(1)

900440(1)

900439EA(1)

900439(1)

900021(1)

 
Country of Origin

CN(37)

US(30)

MX(21)

TH(1)

AF(1)

MY(1)

 
Capacity (Volume)

0.67 oz(35)

2.5 oz(14)

4 oz(6)

1.7 oz(3)

0.77 oz(2)

7.5 oz(1)

3 oz(1)

6.17 oz(1)

2 oz(1)

48 ml(1)

5.3 oz(1)

 
Scent

Hawaiian Blossoms & Papaya(6)

Sweet Lavender & Violet(4)

Citrus Burst(4)

Mango(4)

Cool & Clean(4)

Lavender & Chamomile(4)

Meadow Breeze(4)

Fresh Waters(4)

Spiced Apple(3)

Cotton Blossom(3)

Cucumber Melon(3)

Fresh Linen(2)

Fresh(2)

Fresh Petals & Peach(2)

Apple Cinnamon Medley(2)

Macintosh Apple & Cinnamon(2)

Calm Waters & Spa(2)

Midnight Woods & Vanilla(2)

Citrus(2)

Linen & Spring Breeze(2)

Cherry Blossom & Magnolia(2)

Summer Delights(2)

Macintosh Apples & Cinnamon(2)

Paradise Retreat(2)

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

Pacific Glacier(1)

Tropic Wave(1)

Mango Smoothie(1)

Xtreme Citrus(1)

Hawaii Exotic Papaya & Hibiscus Flower(1)

Raspberry Acai Splash(1)

Country Garden(1)

Mango Burst(1)

Pure Linen(1)

Coconut Vanilla(1)

Seaside Breeze(1)

Tropical(1)

Green Apple(1)

Fresh Floral(1)

Tea Lily(1)

Alpine Forest(1)

Hawaiian Tropical Sunset(1)

Snuggle Fresh Linen(1)

White Lilac(1)

Magnolia & Cherry Blossom(1)

Hawai'i Exotic Papaya and Hibiscus Flower(1)

 
Capacity (Weight)

44.12 g(8)

8 oz(6)

2.89 oz(5)

0.03 lbs(4)

16 lb(1)

0.67 oz(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved