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

Currently Filtered by

Category

Toilet Paper Dispensers

Refine Search

  GO
 
Brand

Kimberly-Clark Professional*(12)

San Jamar(9)

Georgia Pacific Professional(7)

Boardwalk(5)

 
Height

12 1/4"(5)

12 3/4"(4)

12"(4)

10 2/5"(2)

11 7/8"(2)

7 5/8"(1)

7 3/5"(1)

10.4(1)

16 1/2"(1)

9 3/4"(1)

6 2/5"(1)

13 6/10"(1)

10 1/2"(1)

13 7/8"(1)

7 7/8"(1)

13.25"(1)

13 1/4"(1)

11 3/10"(1)

7 1/8"(1)

8"(1)

13 1/10"(1)

 
Color(s)

Transparent Black Pearl(7)

Black(6)

White(4)

Translucent Smoke(3)

Smoke(3)

Smoke Black(3)

Stainless Steel(2)

White/Clear(1)

Black/Stainless Steel(1)

Brushed Metallic(1)

Smoke/Gray(1)

Smoke Gray(1)

 
Depth

6"(6)

5 4/5"(3)

6 3/4"(3)

6 5/16"(2)

5 5/8"(2)

5 1/4"(2)

5.8(1)

10 1/8"(1)

7"(1)

5 3/4"(1)

5 7/8"(1)

5 2/5"(1)

22 1/2"(1)

10"(1)

11 1/8"(1)

6.9"(1)

6 9/10"(1)

6 1/4"(1)

5 39/100"(1)

7.625"(1)

6 6/10"(1)

 
Quantity

1 each(29)

1 per carton(3)

4 per case(1)

 
Manufacturer Part Number

44517(1)

44518(1)

R2000TBK(1)

39731(1)

39709(1)

34831(1)

34832(1)

R2090TBK(1)

R3590TBK(1)

R4090TBK(1)

R6500TBK(1)

R4070WHCL(1)

R4070SS(1)

R3600TBK(1)

R4000TBK(1)

09606(1)

09605(1)

56501(1)

56744A(1)

56748(1)

JT210SBBW(1)

JT109SBBW(1)

1529(1)

CT205SBBW(1)

56784A(1)

5679500(1)

09603(1)

09604(1)

09551(1)

09021(1)

59009(1)

59209(1)

1519(1)

 
Country of Origin

US(23)

CN(10)

 
Width

11"(3)

14 1/10"(3)

11 1/4"(2)

10 1/4"(2)

6"(2)

19 1/4"(2)

19"(2)

7 1/8"(1)

23 1/2"(1)

7 1/2"(1)

22"(1)

8"(1)

14 1/4"(1)

20 1/50"(1)

10 1/2"(1)

5 5/8"(1)

5 3/8"(1)

20 1/4"(1)

11.75"(1)

11 3/4"(1)

10 3/5"(1)

10 1/8"(1)

11.5"(1)

20 2/5"(1)

 
Material(s)

Plastic(30)

Stainless Steel(2)

 
For Use With

Kimberly-Clark Professional* Scott Coreless JRT Jr. Bathroom Tissue(3)

Kimberly-Clark Professional* Standard Coreless Bath Tissue(2)

Cottonelle Coreless Tissue Rolls; Scott Small Core Tissue Rolls(2)

Coreless Bath Tissue Rolls(2)

Kimberly-Clark Professional* SCOTT Coreless JRT Jr. Bathroom Tissue; SCOTT Coreless Jumbo Roll Tissue(1)

Coreless Standard Rolls(1)

Coreless JRT Rolls(1)

Compact Coreless Bath Tissue Rolls(1)

Angel Soft ps Compact Coreless Rolls(1)

KIM 07223;KIM 07304;KIM 07805;KIM 07827(1)

KIM 04007(1)

 
Capacity (text)

Holds One Coreless JRT Roll(4)

Holds Two Rolls(3)

Holds Two Standard Coreless Rolls(3)

(1) 9" roll with 3 1/4" core diameter(2)

(4) Rolls of Scott or Cottonelle Coreless and Scott Small Core(2)

(2) 9" rolls with minimum core diameter of 3 1/4"(2)

(2) 9" rolls(2)

One Roll(2)

(1) 12" - 13" roll with 3 1/4" core diameter and (1) stub roll up to 6"(1)

Holds Two Coreless JRT Jr. Rolls(1)

(2) 4 1/2" - 5 1/2" rolls with 1 5/8" core diameter(1)

(2) 4 1/2" - 5 1/2" rolls with minimum core diameter of 1 1/2"(1)

Holds Two 9 3/8" Rolls Or One 13" Roll Plus Stub Roll(1)

Four Standard Coreless Rolls(1)

Holds Four Rolls(1)

Holds Two Jumbo Rolls(1)

Holds Two Standard, Coreless 2-Ply Rolls(1)

Holds 9" Roll(1)

Holds One Roll(1)

Holds two 9" Roll(1)

Holds Two Coreless Standard Rolls(1)

 
For Roll Size

9"(11)

8 9/10"(4)

5"(2)

4 x 3.94(2)

4 1/2" x 5 1/2"(1)

12" - 13"(1)

4 1/2" - 5 1/2"(1)

3 3/4w x 9dia(1)

10"(1)

5 3/4"(1)

Standard(1)

13";9 3/8"(1)

3 3/4w x 5dia(1)

 
Roll Type

Jumbo(14)

Coreless(5)

Standard(5)

Coreless JRT(4)

Double(2)

Coreless JRT Jr.(1)

Coreless Standard(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved