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

Currently Filtered by

Category

C Fold

Refine Search

  GO
 
Brand

Scott(3)

Boardwalk(2)

Tork(2)

Wausau Paper(2)

General Supply(1)

Georgia-Pacific(1)

Georgia Pacific Professional(1)

enMotion(1)

Kleenex(1)

WypAll(1)

Morcon Tissue(1)

Penny Lane(1)

EcoSoft(1)

Windsoft(1)

 
Color

White(6)

Natural(1)

 
Recycled

Yes(5)

No(2)

 
Packaged Quantity

6 / Carton(3)

2400 / Carton(2)

10 / Carton(1)

2160 / Carton(1)

 
Special Features

C-Fold(5)

C-Fold-11 7/16 x 10. 200 towels per pack.(1)

Pop-Up* Box(1)

C-Fold One-Ply(1)

 
Application

Hand Washing; General Purpose(3)

General Purpose(3)

Bathrooms;General Purpose;Washrooms(2)

Hand Washing;Washrooms(1)

Hand Washing; Face(1)

Hand Washing(1)

 
For Use With

Standard Folded Towel Dispensers(2)

C-Fold Dispensers(1)

 
Applicable Material

Ceramic; Fiberglass; Finished Wood; Glass; Metal; Plastic; Skin; Vinyl(3)

All Surfaces(2)

Multiple(2)

 
Dirt Types

Dust; Grease; Grime; Liquid; Soil(2)

Dust; Lint; Liquid(1)

Dirt; Dust; Food(1)

Dirt;Grime;Liquid(1)

Dust;Lint;Liquid;Soil(1)

 
Number of Plys

1(1)

 
Full Size

10.40" x 10.80"(1)

8.20" x 700 ft(1)

7.87" x 1000 ft(1)

9.50" x 9.40"(1)

7.50" x 11.60"(1)

8" x 580 ft(1)

10.12" x 13"(1)

 
Sheets Per Roll

1000(1)

 
Quantity Per Container

220(1)

150(1)

90(1)

4176(1)

 
Manufacturer Part Number

11GREEN(1)

12388(1)

49500(1)

49300(1)

49140(1)

CB530(1)

CB520(1)

8220(1)

C122(1)

05930(1)

6220(1)

04442(1)

01890(1)

01005(1)

89420(1)

21924(1)

20887(1)

1510(1)

101(1)

 
Country of Origin

US(10)

United States(6)

CA(1)

MY(1)

 
Material

Paper(2)

 
Width

10 1/8"(3)

11 7/16"(1)

12"(1)

10 1/10"(1)

9 1/8"(1)

11"(1)

10.1"(1)

12 3/4"(1)

12 4/5"(1)

10 1/4"(1)

 
Color(s)

White(9)

Natural White(1)

Brown(1)

Red(1)

 
Material(s)

Paper(11)

HYDROKNIT(1)

 
Length

13"(3)

10"(2)

13 1/5"(2)

16 4/5"(1)

10.13"(1)

10 1/8"(1)

10.1"(1)

13.2"(1)

 
Scent

Unscented(9)

 
Capacity (Weight)

2.48 lbs(1)

 
Number of Plies

1(11)

 
Packaging

Pack(10)

Carton(1)

Pop-Up Box(1)

 
Towel/Wipe Type

C-Fold(7)

Folded(1)

Shop Towels(1)

 
Number of Towels/Wipes Per Container

200(6)

150(4)

240(1)

80(1)

 
Container Type

Pack(2)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved