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

Currently Filtered by

Category

Toilet Tissues

Refine Search

  GO
 
Brand

GEN(28)

Georgia Pacific Professional(28)

Scott(27)

Cascades PRO(19)

Boardwalk(18)

Tork(18)

Morcon Tissue(11)

Cottonelle(9)

Charmin(8)

Windsoft(8)

Seventh Generation(7)

Papernet(6)

Marcal(4)

Marcal PRO(3)

Compact(1)

Paper Source Converting(1)

 
Color

White(1)

 
Recycled

No(1)

 
Color(s)

White(190)

Natural(3)

Beige(1)

 
Packing Type

Roll(88)

Carton(17)

Pack(14)

Case(13)

Plastic Overwrap(7)

Paper Overwrap(5)

Poly Wrap(4)

Wrapped Roll(3)

Box(1)

Coreless Roll(1)

Bundle(1)

Corrugated Case(1)

 
Manufacturer Part Number

202(2)

201(2)

JRT1000(2)

48625(1)

49156(1)

49182(1)

67805(1)

129X(1)

29(1)

M1000(1)

M125(1)

M1500(1)

M19(1)

M2000(1)

M250(1)

M600(1)

M750(1)

M99(1)

16466(1)

16466-16-PK(1)

3001(1)

4580(1)

5001(1)

48611(1)

410320(1)

48605(1)

13135(1)

07006(1)

07202(1)

07223(1)

07304(1)

07805(1)

07827(1)

10060(1)

12456(1)

12456PK(1)

13217(1)

47766(1)

13607(1)

17713(1)

20032(1)

20032CT(1)

47305(1)

47612(1)

47617(1)

47618(1)

47747(1)

48280(1)

6079(1)

60101(1)

TM6130S(1)

TJ0922A(1)

TJ0928(1)

TJ1212A(1)

TJ1222A(1)

TM1601A(1)

TM1602(1)

TM1616(1)

TM1616S(1)

TM6120S(1)

TM6184(1)

246325(1)

TM6511S(1)

TM6512(1)

TS1636S(1)

TS1639S(1)

200(1)

203(1)

2210(1)

2400(1)

2405(1)

TJ0912A(1)

240616(1)

07001(1)

137038(1)

13258(1)

71693(1)

96609(1)

96892(1)

96895(1)

96896(1)

99015(1)

99862(1)

ST-296(1)

13733CT(1)

415596(1)

13733PK(1)

13735CT(1)

13735PK(1)

13738(1)

13738CT(1)

410000(1)

410001(1)

410013(1)

415594(1)

415595(1)

07005(1)

04460(1)

05102CT(1)

B940(1)

B180(1)

B200(1)

B201(1)

B220(1)

B240(1)

B260(1)

B340(1)

B400(1)

B625(1)

1000-1PLY(1)

B150(1)

1500-1PLY(1)

1511(1)

1512(1)

1513(1)

1900(1)

1901(1)

1902(1)

1904(1)

1930(1)

B166(1)

B145(1)

1932(1)

6148(1)

410979(1)

59GREEN(1)

6100(1)

6101(1)

6102(1)

6103(1)

6144(1)

6145(1)

6147(1)

6150(1)

B140(1)

6155(1)

6156(1)

6170(1)

6180(1)

B010(1)

B040(1)

B041(1)

B045(1)

B080(1)

1931(1)

1933(1)

04460RL(1)

1944801(1)

1824001(1)

18280/01(1)

19371CT(1)

19372(1)

1937300(1)

193-74(1)

19375(1)

19375B(1)

19378(1)

19510(1)

16840(1)

19516(1)

1984101(1)

1988001(1)

1988101(1)

2172114(1)

02129(1)

03148(1)

04007(1)

410323(1)

16880(1)

16620(1)

215B(1)

ULTRA9B(1)

218(1)

29B(1)

500(1)

550(1)

700(1)

800(1)

999B(1)

JRT121000V(1)

JRT2PLY(1)

VALUE2PLY500(1)

16560(1)

10101(1)

11728(1)

12798(1)

13102(1)

13718(1)

13728(1)

144-48/01(1)

1458001(1)

1632014(1)

2440(1)

 
Country of Origin

US(150)

CA(29)

MY(10)

CN(6)

United States(1)

 
Width

4"(57)

3.5"(15)

3.3"(14)

4.5"(10)

3.55"(9)

4.25"(9)

4.1"(9)

3.9"(9)

3.75"(6)

3.48"(5)

3.82"(5)

4.2"(4)

3.85"(4)

3.4"(4)

3"(4)

3.88"(4)

3.63"(3)

3.7"(3)

5.25"(2)

4.13"(2)

3.2"(2)

4.31"(2)

3.25"(2)

3.95"(1)

3.45"(1)

9"(1)

4.3"(1)

4.33"(1)

8.3"(1)

3 7/10"(1)

3.38"(1)

7.6"(1)

3 11/20"(1)

 
For Use With

Tork T24 Conventional Bath Tissue Dispensers - 55TR, 59TR(11)

Georgia Pacific 57120/01; 57220/01; 57893; 59206(9)

Universal(5)

Georgia Pacific 56743, 56744, 56784, 56783, 56789, 56790, 56787, 56788, 56780, 56781,(4)

Standard Roll Dispensers(3)

Tork T22 Jumbo Bath Tissue Dispensers - 56TR, 66TR(3)

Jumbo Bath Tissue Roll Dispensers(3)

Jumbo Double Roll Toilet Paper Dispenser; Universal Jumbo Single Roll Toilet Paper Dispenser(3)

JRT Dispensers(2)

Tork T21 Jumbo Bath Tissue Dispensers - 67TR(2)

Universal Tissue Dispensers(2)

Georgia Pacific 58150, 59009, 59209(2)

Cascades PRO DB18(1)

KCC09021(1)

Jumbo Roll Dispensers(1)

Standard Tissue Holder(1)

Papernet 406718; Papernet 410893(1)

Papernet 406717, 410894(1)

KCC44517; KCC44518; KCC44519(1)

Tork T34 Conventional Bath Tissue Dispensers - 88411, 55TR, 59TR(1)

Tork T34 Conventional Bath Tissue Dispensers - 88411, 55TR, 59TR(1)

KCC49145(1)

Coreless-Spindle-Equipped Dispensers(1)

Georgia Pacific JRT 9" Dispensers(1)

Georgia Pacific SofPull Mini Centerpull Bathroom Tissue Dispensers(1)

Georgia Pacific 56500, 56501, 56508, 56509(1)

Georgia Pacific 56743, 56744, 56784, 56783, 56789, 56790(1)

Standard Jumbo Tissue Dispensers(1)

Georgia Pacific 59012(1)

Georgia Pacific 56602(1)

JRT Jumbo Bath Tissue Roll Dispensers(1)

JRT Jr. Dispensers(1)

Universal Jumbo Roll Bath Tissue Dispensers(1)

Cascades PRO DB09; Cascades PRO DB12(1)

JRT 9" Dispensers(1)

 
Length

4"(36)

1,000 ft(22)

4.05"(17)

3.75"(17)

2,000 ft(11)

3"(9)

3.92"(8)

4.5"(6)

3.5"(5)

4.1"(5)

3.25"(4)

750 ft(4)

146 ft(4)

500 ft(3)

4,000 ft(3)

4.0"(3)

4.2"(3)

700 ft(3)

3.82"(3)

8.4"(2)

800 ft(2)

3.7"(2)

3.2"(2)

4.4"(1)

4 33/100"(1)

4000 ft(1)

1,150 ft(1)

2,300 ft(1)

3.9"(1)

525 ft(1)

6.13"(1)

5"(1)

4.25"(1)

650 ft(1)

720 ft(1)

1378 ft(1)

1,900 ft(1)

3.19"(1)

3.8"(1)

3.6"(1)

600 ft(1)

 
Number of Sheets

500(13)

500 per roll(13)

1000 per roll(10)

550 per roll(10)

400 per roll(7)

500/Roll(4)

450 per roll(4)

240 per roll(4)

142 per roll(3)

231 per roll(3)

170 per roll(3)

750 per roll(3)

1500 per roll(3)

300 per roll(3)

1210 per roll(3)

1,000(3)

1000(2)

451 per roll(2)

300(2)

420(2)

284 per roll(2)

400(2)

460 per roll(2)

168 per roll(2)

2500 per roll(1)

2000 per roll(1)

1250 per roll(1)

600 per roll(1)

71 per roll(1)

550(1)

625 per roll(1)

504 per roll(1)

616 per roll(1)

330 per roll(1)

200 per roll(1)

242 per roll(1)

400/Roll(1)

250 per pack(1)

420 per roll(1)

300/Roll(1)

350/Roll(1)

504/Roll(1)

1,000/Roll(1)

336 per roll(1)

1,500(1)

400 per box(1)

340 per roll(1)

1700 per roll(1)

1125 per roll(1)

3000 per roll(1)

550 per coil(1)

506 per roll(1)

1100 per roll(1)

800 per roll(1)

 
Number of Plies

2(148)

1(47)

 
Core Size

1.65"(11)

3.3"(10)

1.61"(4)

1.64"(2)

1.63"(1)

3"(1)

1.5"(1)

3.41"(1)

2.91"(1)

1.93"(1)

1.925"(1)

 
Number of Plys

2(1)

 
Roll Diameter

9"(29)

4.25"(12)

4.5"(11)

4.35"(11)

12"(9)

4.6"(8)

8.8"(6)

4.75"(3)

3.9"(3)

8.85"(3)

5"(3)

11.8"(2)

4.65"(2)

8.9"(2)

5.75"(2)

3.25"(1)

4.87"(1)

9.05"(1)

4.9"(1)

7.8"(1)

4.33"(1)

4.3"(1)

8.5"(1)

4.13"(1)

7.83"(1)

10"(1)

3.5"(1)

5.5"(1)

5.85"(1)

9.13"(1)

18.31"(1)

4.85"(1)

 
Sheets Per Roll

1000(1)

 
Product Type

Bathroom Tissue(1)

 
Packaged Quantity

36000 / Carton(1)

 
Tissue Type

Toilet(195)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved