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 ('1143')) 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

Tork(29)

Georgia Pacific Professional(26)

Scott(25)

Boardwalk(23)

GEN(20)

Cascades PRO(16)

Morcon Tissue(12)

Windsoft(10)

Cottonelle(9)

Seventh Generation(7)

Charmin(6)

Papernet(6)

Marcal(3)

Marcal PRO(3)

General Supply(1)

Morcon Paper(1)

 
Color(s)

White(192)

Natural(3)

Beige(1)

 
Packing Type

Roll(93)

Carton(15)

Pack(13)

Case(11)

Paper Overwrap(6)

Plastic Overwrap(5)

Poly Wrap(4)

Wrapped Roll(3)

Box(3)

Coreless Roll(2)

Bundle(1)

Corrugated Case(1)

 
Manufacturer Part Number

JRT1000(2)

202(2)

201(2)

26GREEN(1)

3001(1)

M2000(1)

M250(1)

M600(1)

M750(1)

M99(1)

VT110(1)

16466(1)

16466-16-PK(1)

60101(1)

5001(1)

M1500PORTA(1)

6079(1)

52084(1)

52776(1)

71693(1)

75321(1)

79546(1)

96609(1)

137038(1)

M19(1)

M1500(1)

13733PK(1)

47747(1)

13135(1)

13217(1)

13607(1)

17713(1)

20032CT(1)

47305(1)

47612(1)

47617(1)

47618(1)

47766(1)

M125(1)

48280(1)

48605(1)

48611(1)

48625(1)

49156(1)

49182(1)

67805(1)

129X(1)

29(1)

M1000(1)

13733CT(1)

13735PK(1)

13735CT(1)

TM6511S(1)

TJ1212A(1)

TJ1222A(1)

TM1601A(1)

TM1602(1)

TM1604(1)

TM1616(1)

TM1616S(1)

TM6120S(1)

TM6184(1)

TM6512(1)

TJ0922A(1)

TS1636S(1)

TS1639S(1)

200(1)

203(1)

2200B(1)

2210(1)

2240B(1)

2400(1)

2405(1)

TJ0928(1)

TJ0912A(1)

12456(1)

11010402(1)

13738(1)

13738CT(1)

410000(1)

410001(1)

410010(1)

410013(1)

415594(1)

415596(1)

106390(1)

110292A(1)

472880(1)

112990(1)

12021502(1)

12024402(1)

160090(1)

161990(1)

162090(1)

240616(1)

245949(1)

245989(1)

12456PK(1)

07827(1)

10060(1)

B400(1)

B140(1)

B150(1)

B180(1)

B200(1)

B201(1)

B220(1)

B240(1)

B260(1)

B340(1)

B625(1)

B045(1)

B940(1)

1500-1PLY(1)

1511(1)

1512(1)

1513(1)

1516(1)

215B(1)

218(1)

29B(1)

B080(1)

B040(1)

550(1)

6103(1)

410323(1)

410979(1)

45GREEN(1)

45GREENPLT(1)

55GREEN(1)

59GREEN(1)

6100(1)

6101(1)

6102(1)

6144(1)

B010(1)

6145(1)

6147(1)

6148(1)

6150(1)

6155(1)

6156(1)

6170(1)

6180(1)

6380(1)

500(1)

700(1)

410320(1)

04007(1)

19378(1)

1944801(1)

19510(1)

19516(1)

1984101(1)

1988001(1)

1988101(1)

2172114(1)

03148(1)

04460(1)

193-74(1)

04460RL(1)

05102CT(1)

07001(1)

07005(1)

07006(1)

07202(1)

07223(1)

07304(1)

07805(1)

19375(1)

19372(1)

800(1)

13102(1)

999B(1)

9JUMBOB(1)

JRT121000V(1)

JRT2PLY(1)

ULTRA9B(1)

VALUE2PLY500(1)

10101(1)

11728(1)

12798(1)

13718(1)

19371CT(1)

13728(1)

1458001(1)

1632014(1)

16560(1)

16620(1)

16840(1)

16880(1)

1824001(1)

18280/01(1)

2440(1)

 
Country of Origin

US(149)

CA(31)

MY(10)

CN(7)

 
Width

4"(57)

3.5"(15)

4.5"(12)

3.75"(12)

3.3"(12)

3.9"(10)

3.55"(9)

4.1"(9)

4.25"(8)

3.48"(8)

3.82"(5)

3.4"(4)

3.25"(3)

3.7"(3)

3.85"(3)

4.2"(3)

3.63"(3)

3.88"(3)

3.2"(2)

5.25"(2)

4.31"(2)

3.1"(1)

9"(1)

3.95"(1)

3.45"(1)

4.13"(1)

8.3"(1)

4.3"(1)

4.33"(1)

3.94"(1)

3.66"(1)

3"(1)

 
For Use With

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

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

Universal(4)

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

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

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

Standard Bath Tissue Dispensers(2)

Georgia Pacific 58150, 59009, 59209(2)

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

Tork T11 OptiCore Bath Tissue Dispensers -565620, 565628, 565720, 565728, 565820, 565828(2)

Tork T1 Jumbo Bath Tissue Dispensers - 247549A, 554020A, 554028A(2)

Standard Tissue Holder(2)

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

Jumbo Bath Tissue Roll Dispensers(2)

Standard Roll Dispensers(2)

Boardwalk BWK 47GREEN(2)

JRT Dispensers(2)

Universal Tissue Dispensers(2)

Georgia Pacific 59012(1)

Tork T11 OptiCore Bath Tissue Dispensers - 565620, 565628, 565720, 565728, 565820, 565828(1)

Tork T7 Coreless Bath Tissue Dispensers - 473200, 473208, 473020, 473030, 473040, 473060(1)

Standard Jumbo Tissue Dispensers(1)

Tork T11 OptiCore Bath Tissue Dispensers - 565620, 565628, 565720, 565728, 565820, 565828(1)

Tork T10 OptiCore Bath Tissue Dispensers - 565520, 565528(1)

Tork T2 Mini Jumbo Bath Tissue Roll Dispensers - 465500, 555020A, 555028A, 5555200, 5555290(1)

Tork T26 High Capacity Bath Tissue Dispensers - 555620, 555628(1)

Universal Jumbo Roll Bath Tissue Dispensers(1)

JRT Jr. Dispensers(1)

Papernet 406717, 410894(1)

Georgia Pacific 56602(1)

Jumbo Roll Dispensers(1)

KCC09021(1)

KCC49145(1)

KCC44517; KCC44518; KCC44519(1)

Georgia Pacific JRT 9" Dispensers(1)

JRT 9" Dispensers(1)

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

Coreless-Spindle-Equipped Dispensers(1)

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

Georgia Pacific SofPull Mini Centerpull Bathroom Tissue Dispensers(1)

 
Length

4"(39)

3.75"(23)

1,000 ft(19)

4.05"(15)

2,000 ft(11)

3"(9)

3.92"(6)

3.5"(6)

146 ft(5)

4.5"(5)

700 ft(4)

4.0"(4)

4.1"(4)

750 ft(4)

4,000 ft(3)

3.25"(3)

500 ft(3)

3.82"(3)

3.7"(2)

8.4"(2)

3.2"(2)

4.2"(2)

525 ft(1)

4000 ft(1)

1,600 ft(1)

2,247 ft(1)

3.6"(1)

3.8"(1)

437.5 ft(1)

3.19"(1)

1,900 ft(1)

1,150 ft(1)

650 ft(1)

2,300 ft(1)

3.9"(1)

1378 ft(1)

720 ft(1)

6.13"(1)

5"(1)

800 ft(1)

4.25"(1)

751 ft(1)

 
Number of Sheets

500 per roll(14)

500(13)

550 per roll(10)

1000 per roll(9)

400 per roll(7)

450 per roll(4)

500/Roll(4)

240 per roll(4)

1,000/Roll(3)

170 per roll(3)

231 per roll(3)

750 per roll(3)

1210 per roll(3)

264(3)

2000 per roll(2)

142 per roll(2)

1,000 per roll(2)

451 per roll(2)

865 per roll(2)

460 per roll(2)

1500 per roll(2)

168 per roll(2)

800 per roll(2)

1000(2)

1,000(2)

420(2)

242 per roll(1)

330 per roll(1)

380/Roll(1)

286(1)

200 per roll(1)

350/Roll(1)

504/Roll(1)

600 per roll(1)

1,755 per roll(1)

300/Roll(1)

616 per roll(1)

550(1)

400/Roll(1)

336 per roll(1)

1700 per roll(1)

1250 per roll(1)

1125 per roll(1)

1500(1)

2500 per roll(1)

284 per roll(1)

1,500(1)

250 per pack(1)

340 per roll(1)

1100 per roll(1)

506 per roll(1)

420 per roll(1)

300(1)

550 per coil(1)

400 per box(1)

3000 per roll(1)

400(1)

 
Number of Plies

2(152)

1(45)

 
Core Size

1.65"(10)

3.3"(8)

1.61"(5)

2.3"(4)

1.67"(3)

1.625"(2)

1.6"(2)

1.665"(2)

1.93"(1)

1.7"(1)

1.75"(1)

3.41"(1)

1.63"(1)

2"(1)

1.5"(1)

3"(1)

1.92"(1)

 
Roll Diameter

9"(25)

4.5"(14)

4.35"(11)

4.25"(10)

12"(9)

5.63"(6)

8.8"(6)

4.6"(6)

3.9"(4)

5"(4)

8.85"(3)

4.75"(3)

10"(3)

11.8"(2)

8.9"(2)

5.75"(2)

18.31"(1)

8.5"(1)

7.83"(1)

7.2"(1)

7.4"(1)

5.4"(1)

7.8"(1)

9.13"(1)

4.3"(1)

7.5"(1)

4.87"(1)

3.25"(1)

4.65"(1)

4"(1)

9.05"(1)

4.33"(1)

5.5"(1)

5.85"(1)

4.13"(1)

3.5"(1)

4.85"(1)

4.9"(1)

 
Tissue Type

Toilet(197)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved