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

Currently Filtered by

Category

Toilet Tissue Dispensers

Refine Search

  GO
 
Brand

San Jamar(19)

Scott(18)

Georgia Pacific Professional(17)

Bobrick(10)

GEN(5)

Tork(5)

Kimberly-Clark Professional*(4)

Boardwalk(3)

Georgia Pacific(2)

Morcon Tissue(2)

 
Height

12 3/4"(6)

12"(5)

11"(4)

9 3/4"(3)

12 1/4"(3)

9"(3)

12.25"(3)

10.5"(3)

13.88"(2)

10 2/5"(2)

13.25"(2)

2"(2)

2 3/4"(2)

14 7/8"(2)

6.125"(1)

6 2/5"(1)

8.25"(1)

11.83"(1)

10 9/10"(1)

12.75"(1)

10.4(1)

13.750"(1)

11 7/8"(1)

6.5"(1)

12.5"(1)

6"(1)

7 5/8"(1)

16 1/2"(1)

11 9/10"(1)

1 1/2"(1)

16"(1)

7 3/5"(1)

10.75"(1)

10 5/8"(1)

11.38"(1)

13 1/2"(1)

8.75"(1)

13.5"(1)

11.25"(1)

11.5"(1)

11.42"(1)

14.44"(1)

13 1/10"(1)

13"(1)

8"(1)

8.19"(1)

7 1/8"(1)

7.13"(1)

11.3"(1)

8.63"(1)

14.25"(1)

13 6/10"(1)

14.9"(1)

 
Color(s)

Black(14)

White(11)

Smoke(9)

Stainless Steel(8)

Transparent Black Pearl(8)

Transparent(4)

Translucent Smoke(4)

Silver(3)

Black Pearl(3)

Chrome(3)

Smoke/Gray(2)

Blue(2)

Faux Stainless(2)

Faux Stainless Steel(1)

Black/Faux Stainless Steel(1)

Splash Blue(1)

Brushed Metallic(1)

Pearl White(1)

Satin Finish Cast Aluminum(1)

Smoke Gray(1)

Bright Stainless Steel(1)

Gray(1)

Satin-Finish Stainless Steel(1)

White/Clear(1)

 
Depth

6"(8)

7"(7)

6.75"(6)

5.75"(5)

5 5/8"(3)

5 4/5"(3)

4 1/2"(3)

6 5/16"(3)

6 3/4"(2)

5 1/4"(2)

5"(2)

5.5"(2)

5 3/4"(2)

6.9"(2)

5 7/8"(2)

5 15/16"(2)

5.4"(2)

14"(1)

6.375(1)

5.51"(1)

4.75"(1)

6 1/4"(1)

5 9/10"(1)

6 1/8"(1)

5.57"(1)

5.8(1)

4 7/8"(1)

10 1/8"(1)

6 in(1)

6 6/10"(1)

4.44"(1)

6.69"(1)

7.625"(1)

5 1/2"(1)

8"(1)

5.59"(1)

6.25"(1)

3 15/16"(1)

3 15/16(1)

6 7/8"(1)

5.31"(1)

5.8"(1)

 
Quantity

1 per carton(2)

1 each(1)

 
Manufacturer Part Number

273-103(1)

40407(1)

N13EZ(1)

M1007(1)

M1005(1)

49145(1)

44519(1)

44518(1)

44517(1)

39731(1)

R1500XC(1)

39729(1)

39709(1)

34832(1)

34831(1)

09609(1)

09608(1)

09606(1)

09605(1)

N16(1)

R2000TBK(1)

09603(1)

R4070SS(1)

66TR(1)

59TR(1)

56TR(1)

55TR(1)

R6500TBK(1)

R6000TBK(1)

R4090TBK(1)

R4070WHCL(1)

R4070BKSS(1)

R200XC(1)

R4000TBK(1)

R3800TBK(1)

R3600TBK(1)

R3590TBK(1)

R3500TBK(1)

R3090TBK(1)

R260XC(1)

R2090TBK(1)

09604(1)

09602(1)

2740(1)

1519(1)

56500(1)

1604(1)

1603(1)

1602(1)

1601(1)

1600(1)

1529(1)

1502(1)

56507(1)

7686(1)

7685(1)

5288(1)

4288-9(1)

4288(1)

2892(1)

2890(1)

2888(1)

56501(1)

56508(1)

09601(1)

56798(1)

09551(1)

09508(1)

09507(1)

09021(1)

594-49(1)

59209(1)

592-06(1)

59009(1)

5679500(1)

56514(1)

56790A(1)

56784A(1)

56781(1)

56748(1)

56747A(1)

56744A(1)

56518(1)

56515(1)

67TR(1)

 
Country of Origin

US(52)

CN(17)

TW(11)

MX(5)

 
Width

16.1"(3)

14 1/10"(3)

11 1/4"(3)

11"(3)

12 1/2"(2)

16"(2)

6"(2)

10 1/4"(2)

11.5"(2)

11.75"(2)

14 1/4"(2)

7 1/2"(2)

8.75"(2)

19"(2)

10.5"(2)

19 1/4"(2)

13 1/8"(1)

7.375"(1)

20 1/10"(1)

10.63"(1)

12.75"(1)

19.29"(1)

7.37"(1)

23 1/2"(1)

10"(1)

7.5"(1)

6.5"(1)

8"(1)

22"(1)

12 9/10"(1)

12 3/8"(1)

16 3/4"(1)

20 1/4"(1)

20"(1)

13.33"(1)

7 1/8"(1)

5.51"(1)

10 21/32"(1)

20.81"(1)

6 1/16(1)

6 1/4"(1)

7 1/4"(1)

13"(1)

20.25"(1)

13.5"(1)

19.5"(1)

16.5"(1)

20.13"(1)

14 3/8"(1)

12.06"(1)

14"(1)

14.06"(1)

10 1/8"(1)

10.13"(1)

10.6"(1)

13.56"(1)

20.2"(1)

14.25"(1)

6 1/16"(1)

20 2/5"(1)

12.9"(1)

 
Material(s)

Plastic(57)

Stainless Steel(9)

ABS Plastic(5)

Steel(4)

Plastic; Steel(2)

Metal(2)

Aluminum(1)

Stainless Steel/Plastic(1)

 
For Use With

Georgia Pacific Professional SofPull 19510(3)

Kimberly-Clark Professional* Scott 07005, 07006, 07007(3)

04007; 07001(3)

KIM 07005;KIM 07006(2)

Compact Coreless Bath Tissue Rolls(2)

Georgia Pacific Professional SofPull 19516(2)

19371; 19372; 19374; 19375; 19378(2)

Tork T24/T34 Conventional Bath Tissue Rolls - TM6511S, TM1601A, TM1602, TM1616, TM1616S, TM1619, TM6120S, TM6130S, TM6184, TM6510, TM6512, TS1635S, TS1636S, TS1639S, 245989, 245949, 246325, 240616, 240123, TM1604(2)

BWK 6100; GEN 9JUMBO(2)

Tork T22 Jumbo Roll Bath Tissue - TJ0912A, TJ0921A, TJ0924, TJ0928, TJ9022A(2)

San Jamar Plastic Toilet Tissue Dispensers(1)

Most Toilet Tissue Dispensers(1)

San Jamar Metal Toilet Tissue Dispensers(1)

Coreless Standard Rolls(1)

7/8" Core Bathroom Tissue(1)

Any brand of standard bath tissue up to 5"(1)

49156(1)

KIMBERLY-CLARK PROFESSIONAL* SCOTT 48180, KLEENEX 48280(1)

Kimberly-Clark Professional* SCOTT 07005 ,07006, 07007, 41884(1)

KCC48280(1)

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

Bobrick B-2730, B-2740, B-274, B-273(1)

Scott* Coreless JRT Jr. Bathroom Tissue(1)

KIM 04007(1)

Compact Coreless Bathroom Tissue(1)

B4288(1)

Bobrick B-2888, B-4388, B-4288(1)

B7685(1)

BWK 6102; GEN 9JUMBO(1)

BWK 6102; GEN 1513(1)

Georgia Pacific SofPull 19516(1)

GEP 19375(1)

Coreless JRT Rolls(1)

Georgia Pacific 19371, 19372, 19374, 19375, 19376, 19378(1)

Angel Soft ps Compact Coreless Rolls(1)

Georgia Pacific 13102, 13105(1)

KIM09021(1)

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

Bobrick Dispenser Key 33043(1)

Tork T21 Jumbo Roll Bath Tissue - TJ1212A, TJ1222A(1)

 
Capacity (text)

Holds Two Rolls(6)

Holds One 8.4" Roll(5)

Holds Two Standard Rolls(5)

Holds One Coreless JRT Roll(4)

Holds Two Standard Coreless Rolls(3)

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

Holds One Roll(3)

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

Holds One Jumbo Roll(2)

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

Holds Four Rolls(2)

Holds One JRT Roll and One Stub Roll(2)

Holds One 12" Jumbo Roll(2)

Holds Two 9" Rolls(2)

(2) 9" rolls(2)

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

Holds 500 sheets(1)

Holds Two Coreless JRT Jr. Rolls(1)

(1) 12" roll with 3 1/4" core diameter(1)

Holds One Clip (500 or 250 Folded Sheets)(1)

Holds Four Standard Bath Tissue Rolls(1)

Holds 5,000 Sheet Roll(1)

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

2 Rolls(1)

Holds Two Standard Rolls With 1 1/2" Core(1)

Holds One Standard 1 1/2" Core Toilet Tissue Roll(1)

Holds Two Standard 1 1/2" Core Toilet Tissue Rolls(1)

Two 9 3/8" Jumbo Rolls(1)

One 9-10 1/4" Roll Plus Stub Roll(1)

Holds 2000-Sheet Roll(1)

Holds Two 9 3/8" Jumbo Rolls(1)

Holds Four 5 3/4" 1,000-Sheet Compact Coreless Rolls(1)

One Jumbo 10" Roll with 3" Core(1)

Holds Two 10" Jumbo Rolls(1)

Holds One Standard Roll(1)

Holds One 9" Jumbo Roll(1)

Holds 2 Standard Rolls(1)

Holds Two 8.4" Rolls(1)

Holds Four Standard Coreless Rolls(1)

Holds 2 Rolls(1)

Holds Two Coreless Standard Rolls(1)

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

Holds Two Coreless Rolls(1)

Holds 9" Roll(1)

Holds Two 4" Rolls(1)

Holds Two 9" Roll(1)

Holds One JRT Jr. Roll and One Stub Roll(1)

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

Holds One Coreless Roll(1)

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

 
For Roll Size

9"(16)

8 9/10"(4)

4 x 3.94(3)

5 1/4"(3)

5"(3)

12"(3)

SofPull High Capacity Centerpull Tissue(3)

SofPull Mini High-Capacity Centerpull Bathroom Tissue(3)

6"(2)

9 3/8"(2)

Up to 5.5" Diameter(2)

3.85" x 4.05"(2)

5.75"(2)

8.8" Diameter(2)

5 1/2"(2)

5 3/4"(2)

10"(2)

12" - 13"(1)

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

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

10 1/4"(1)

4" x 4.25"(1)

9.38"(1)

3 3/4"(1)

1 Clip (500 Sheets)(1)

4.5" x 8.3"(1)

3 3/4w x 5dia(1)

3 3/4w x 9dia(1)

13";9 3/8"(1)

Standard(1)

4"(1)

4.5"(1)

11.8" Diameter(1)

 
Roll Type

Standard(20)

Jumbo(19)

Coreless(10)

Center-Pull(6)

Coreless JRT(4)

JRT Jr.(4)

Jumbo Roll Bath Tissue(3)

JRT(2)

Double(2)

Conventional Bath Tissue(2)

Sheet(1)

Coreless;Jumbo(1)

Coreless; Jumbo(1)

Bath Tissue(1)

Coreless JRT Jr.(1)

Interfolded Bath Tissue(1)

Small Core(1)

Jumbo;Stub(1)

Coreless Standard(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved