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

Boardwalk(22)

Georgia Pacific Professional(15)

Scott(13)

Windsoft(11)

Charmin(9)

Cascades PRO(8)

Cottonelle(6)

Marcal(5)

Seventh Generation(5)

Wausau Paper(2)

Angel Soft(1)

Marcal PRO(1)

 
Color(s)

White(97)

Beige(1)

 
Packing Type

Roll(32)

Plastic Overwrap(9)

Wrapped Roll(7)

Carton(5)

Pack(4)

Poly Wrap(3)

Bundle(1)

Coreless Roll(1)

 
Manufacturer Part Number

500(2)

4580(1)

16466-16-PK(1)

67805(1)

17713(1)

42108(1)

5001(1)

6024(1)

13258PK(1)

13258(1)

6495(1)

6079(1)

13607(1)

13217(1)

07223(1)

07006(1)

07005(1)

07001(1)

07304(1)

07805(1)

13135(1)

12456PK(1)

12456(1)

07827(1)

96609(1)

96610(1)

203(1)

202(1)

201(1)

200(1)

2200(1)

2210(1)

2440(1)

2405(1)

2400(1)

2240(1)

14800(1)

13738CT(1)

99015(1)

96896(1)

96892PK(1)

96892(1)

99806(1)

245989(1)

13738(1)

13733PK(1)

13733CT(1)

137038(1)

04460(1)

04007(1)

6156(1)

6150(1)

6148(1)

6147(1)

6170(1)

6180(1)

B150(1)

B040(1)

6195(1)

6182(1)

6146(1)

6144(1)

410323(1)

410320(1)

410319(1)

25GREEN(1)

6100(1)

6101(1)

6143CT(1)

6142(1)

6103(1)

6102(1)

B200(1)

B201(1)

19378(1)

19375(1)

19372(1)

19371CT(1)

19510(1)

1984101(1)

03148(1)

02129(1)

2172114(1)

1988001(1)

18280/01(1)

1824001(1)

B400(1)

B240(1)

B220(1)

B210(1)

13102(1)

13718(1)

16840(1)

16620(1)

1632014(1)

1458001(1)

20GREEN(1)

 
Country of Origin

US(76)

CA(16)

CN(6)

 
Width

4"(35)

3 1/2"(11)

3 11/20"(7)

4 1/2"(6)

4 1/10"(5)

4 1/4"(5)

3 7/10"(5)

3 3/4"(3)

3 2/5"(3)

3 17/20"(3)

4 3/10"(2)

4 5/16"(2)

3.4"(2)

4 3/8"(2)

3.2"(1)

3"(1)

4 1/3"(1)

4 1/5"(1)

5 1/4"(1)

4.3"(1)

3 7/8"(1)

 
For Use With

Universal(6)

Standard Tissue Dispensers(2)

For use with Compact coreless dispenser (sold separately)(2)

Compact Coreless dispenser(1)

KIMBERLY-CLARK PROFESSIONAL* Double Roll Tissue Dispensers(1)

Georgia Pacific JRT 9" Dispensers(1)

Compact coreless dispenser (sold separately)(1)

Universal Tissue Dispensers(1)

 
Length

4"(20)

4 1/20"(11)

3 3/4"(10)

3.92"(9)

2,000 ft(8)

1,000 ft(6)

4 33/100"(4)

3"(3)

4 1/2"(3)

3 1/4"(3)

1000 ft(3)

750 ft(2)

3 1/2"(2)

4 1/10"(1)

1,150 ft(1)

3 33/50"(1)

4,000 ft(1)

1200 ft(1)

2,300 ft(1)

525 ft(1)

8 2/5"(1)

3 3/5"(1)

2000 ft(1)

3 2/3"(1)

3 3/16"(1)

4000 ft(1)

3 9/10"(1)

 
Number of Sheets

500 per roll(14)

550 per roll(9)

1000 per roll(7)

400 per roll(5)

300 per roll(5)

240 per roll(4)

504 per roll(3)

200 per roll(2)

170 per roll(2)

142 per roll(2)

451 per roll(2)

165 per roll(2)

168 per roll(2)

450 per roll(2)

71 per roll(1)

308 per roll(1)

336 per roll(1)

1125 per roll(1)

1,210 per roll(1)

350 per roll(1)

1210 per roll(1)

750 per roll(1)

800 per roll(1)

1500 per roll(1)

506 per roll(1)

 
Number of Plies

2(77)

1(21)

 
Roll Diameter

9"(16)

4 1/2"(7)

4 1/4"(6)

12"(6)

4 3/5"(6)

4 1/2 "(2)

3 4/5"(2)

4.38"(2)

8 9/10"(2)

5 1/2"(1)

5"(1)

5 3/4"(1)

4.85"(1)

9 1/8"(1)

4 5/15"(1)

4 3/4"(1)

 
Tissue Type

Toilet(93)

Jumbo Roll(3)

Bath JRT Roll(1)

Bath JRT Jr. Roll(1)

 
 
 

© 2018-2019 Legal Name, All Rights Reserved

Powered byDealer Commander