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

Scott(27)

Georgia Pacific Professional(26)

Boardwalk(24)

GEN(21)

Tork(19)

Cascades PRO(16)

Morcon Tissue(13)

Charmin(12)

Atlas Paper Mills(11)

Windsoft(10)

Cottonelle(9)

Seventh Generation(7)

Papernet(6)

Marcal PRO(4)

Marcal(3)

Angel Soft(2)

Paper Source Converting(1)

General Supply(1)

 
Color(s)

White(207)

Natural(3)

Beige(1)

 
Packing Type

Roll(88)

Carton(15)

Case(13)

Pack(13)

Plastic Overwrap(11)

Paper Overwrap(6)

Poly Wrap(4)

Wrapped Roll(3)

Box(3)

Polybag(2)

Corrugated Case(2)

Coreless Roll(1)

Bundle(1)

 
Manufacturer Part Number

201(2)

202(2)

JRT1000(2)

062GREEN(1)

M250(1)

129X(1)

29(1)

M1000(1)

M125(1)

M1500(1)

M1500PORTA(1)

M19(1)

M2000(1)

M750(1)

M600(1)

49182(1)

M99(1)

VT110(1)

16466(1)

16466-16-PK(1)

3001(1)

5001(1)

60101(1)

60110(1)

67805(1)

49156(1)

13258(1)

13217(1)

07006(1)

07202(1)

07223(1)

07304(1)

07805(1)

07827(1)

10060(1)

12456(1)

12456PK(1)

13135(1)

13607(1)

48625(1)

17713(1)

20032CT(1)

47305(1)

47612(1)

47617(1)

47618(1)

47747(1)

47766(1)

48280(1)

48605(1)

48611(1)

6079(1)

61925(1)

13258PK(1)

TM6184(1)

TJ0922A(1)

TJ0928(1)

TJ1212A(1)

TJ1222A(1)

TM1601A(1)

TM1602(1)

TM1604(1)

TM1616(1)

TM1616S(1)

TM6120S(1)

TM6511S(1)

245989(1)

TM6512(1)

TS1636S(1)

TS1639S(1)

200(1)

203(1)

2200B(1)

2210(1)

2240B(1)

2400(1)

2405(1)

TJ0912A(1)

245949(1)

07001(1)

137038(1)

71693(1)

76556(1)

77777(1)

96609(1)

96892PK(1)

99015(1)

99015PK(1)

99016(1)

99862(1)

80240(1)

13733CT(1)

240616(1)

13733PK(1)

13735CT(1)

13735PK(1)

13738(1)

13738CT(1)

410000(1)

410001(1)

410010(1)

410013(1)

415594(1)

415596(1)

07005(1)

04460PW(1)

05102CT(1)

B140(1)

6150(1)

6155(1)

6156(1)

6170(1)

6180(1)

6380(1)

B010(1)

B040(1)

B045(1)

B080(1)

B150(1)

6147(1)

B180(1)

B200(1)

B201(1)

B220(1)

B240(1)

B260(1)

B340(1)

B400(1)

B625(1)

B940(1)

6148(1)

6145(1)

1511(1)

410319(1)

125GREEN(1)

205GREEN(1)

235GREEN(1)

250GREEN(1)

275GREEN(1)

276GREEN(1)

700GREEN(1)

730GREEN(1)

800GREEN(1)

26GREEN(1)

410320(1)

6144(1)

410323(1)

410979(1)

45GREEN(1)

45GREENPLT(1)

55GREEN(1)

59GREEN(1)

6100(1)

6101(1)

6102(1)

6103(1)

1500-1PLY(1)

1512(1)

04460RL(1)

19516(1)

16880(1)

1824001(1)

18280/01(1)

19371CT(1)

19372(1)

193-74(1)

19375(1)

19378(1)

1944801(1)

19510(1)

1984101(1)

16620(1)

1988001(1)

1988101(1)

2172114(1)

7758502(1)

7791702(1)

02129(1)

03148(1)

04007(1)

04460(1)

115GREEN(1)

16840(1)

16560(1)

1513(1)

9JUMBOB(1)

1516(1)

215B(1)

218(1)

238(1)

29B(1)

500(1)

550(1)

700(1)

800(1)

999B(1)

JRT121000V(1)

1632014(1)

JRT2PLY(1)

ULTRA9B(1)

VALUE2PLY500(1)

10101(1)

11728(1)

12798(1)

13102(1)

13718(1)

13728(1)

1458001(1)

2440(1)

 
Country of Origin

US(164)

CA(31)

MY(10)

CN(7)

 
Width

4"(66)

3.5"(15)

3.3"(13)

4.5"(12)

3.9"(10)

3.55"(10)

4.1"(9)

4.25"(8)

3.75"(7)

3.4"(5)

3.48"(5)

4 1/2"(5)

3.82"(5)

3.88"(3)

4.2"(3)

3.25"(3)

3.63"(3)

3.85"(3)

3.7"(3)

4.31"(2)

3.2"(2)

3 7/8"(2)

3 1/2"(2)

5.25"(2)

4.13"(1)

8.3"(1)

3 2/5"(1)

3.45"(1)

3.95"(1)

9"(1)

3.1"(1)

3 1/10"(1)

4.3"(1)

4.33"(1)

3 21/50"(1)

4 1/10"(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)

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

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

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

Jumbo Bath Tissue Roll Dispensers(2)

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

Standard Tissue Holder(2)

Georgia Pacific 58150, 59009, 59209(2)

Standard Bath Tissue Dispensers(2)

Standard Roll Dispensers(2)

Universal Tissue Dispensers(2)

Boardwalk BWK 47GREEN(2)

JRT Dispensers(2)

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

JRT 9" Dispensers(1)

KCC09021(1)

Georgia Pacific 59012(1)

Standard Jumbo Tissue Dispensers(1)

JRT Jr. Dispensers(1)

Papernet 406717, 410894(1)

Universal Jumbo Roll Bath Tissue Dispensers(1)

Jumbo Roll Dispensers(1)

KCC49145(1)

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

KCC44517; KCC44518; KCC44519(1)

Georgia Pacific 56602(1)

Georgia Pacific JRT 9" Dispensers(1)

Georgia Pacific SofPull Mini Centerpull Bathroom Tissue Dispensers(1)

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

Coreless-Spindle-Equipped Dispensers(1)

Scott 09021(1)

 
Length

4"(37)

3.75"(22)

1,000 ft(21)

4.05"(15)

2,000 ft(13)

3.92"(12)

3"(9)

146 ft(5)

750 ft(5)

4.1"(5)

4.5"(5)

3.5"(5)

700 ft(4)

500 ft(3)

3 4/5"(3)

4,000 ft(3)

4.0"(3)

3.82"(3)

3.25"(3)

3.7"(2)

4.2"(2)

3.2"(2)

8.4"(2)

3 1/10"(2)

4000 ft(1)

1,150 ft(1)

5"(1)

437.5 ft(1)

2,300 ft(1)

3.9"(1)

6.13"(1)

4 1/10"(1)

800 ft(1)

4.25"(1)

650 ft(1)

4 1/2"(1)

720 ft(1)

1378 ft(1)

3.19"(1)

3.8"(1)

3.6"(1)

525 ft(1)

1,200 ft(1)

525'(1)

3 1/2"(1)

1,900 ft(1)

 
Number of Sheets

500 per roll(24)

1000 per roll(14)

500(13)

550 per roll(11)

400 per roll(8)

240 per roll(4)

450 per roll(4)

71(3)

284 per roll(3)

231 per roll(3)

750 per roll(3)

170 per roll(3)

1210 per roll(3)

1,000(2)

1500 per roll(2)

460 per roll(2)

300 per roll(2)

142(2)

168 per roll(2)

142 per roll(2)

451 per roll(2)

264 per roll(2)

1000(2)

420(2)

3000 per roll(1)

1250 per roll(1)

550(1)

616 per roll(1)

420 per roll(1)

350 per roll(1)

200 per roll(1)

143(1)

286 per roll(1)

300(1)

330 per roll(1)

242 per roll(1)

400 per box(1)

600 per roll(1)

2000 per roll(1)

550 per coil(1)

1500(1)

2500 per roll(1)

504 per roll(1)

1700 per roll(1)

1,500(1)

340 per roll(1)

380 per roll(1)

1100 per roll(1)

506 per roll(1)

400(1)

336 per roll(1)

800 per roll(1)

1125 per roll(1)

250 per pack(1)

 
Number of Plies

2(164)

1(48)

 
Core Size

1.65"(10)

3.3"(9)

1.61"(5)

1.6"(2)

1.625"(2)

1.75"(1)

1.63"(1)

Standard(1)

3"(1)

1.5"(1)

2"(1)

2.3"(1)

3.41"(1)

1.925"(1)

1.92"(1)

 
Roll Diameter

9"(30)

4.5"(14)

12"(12)

4.35"(11)

4.25"(10)

8.8"(6)

4.6"(6)

5"(4)

3.9"(4)

4.65"(3)

8.85"(3)

11.8"(2)

5.63"(2)

4.75"(2)

5.75"(2)

8.9"(2)

7.5"(1)

4.87"(1)

8.5"(1)

4.3"(1)

7.8"(1)

5.5"(1)

3.25"(1)

5.85"(1)

4.85"(1)

18.31"(1)

3.5"(1)

10"(1)

4.13"(1)

4.33"(1)

9.05"(1)

4"(1)

9.13"(1)

7.83"(1)

4.9"(1)

 
Tissue Type

Toilet(211)

Bath JRT Jr. Roll(1)

 
 
 

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