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

Currently Filtered by

Category

Towels And Wipes

Refine Search

  GO
 
Brand

Boardwalk(4)

Clorox(4)

Georgia Pacific Professional(4)

Kleenex(3)

Scott(2)

WypAll(2)

LYSOL Brand(2)

EXPO(1)

 
Color(s)

White(19)

Natural(2)

Blue(1)

 
Manufacturer Part Number

6202(1)

01500(1)

77182EA(1)

77182CT(1)

88130(1)

50606(1)

41041(1)

34790BX(1)

02068(1)

01890(1)

27300(1)

6220(1)

23000(1)

21000(1)

20887(1)

15949EA(1)

15949CT(1)

15948EA(1)

15948CT(1)

6272(1)

6256(1)

81850(1)

 
Country of Origin

US(19)

CA(3)

 
Width

7"(6)

8"(3)

9.2"(3)

11"(2)

9"(1)

11.44"(1)

10.2"(1)

10.1"(1)

10.13"(1)

9.1"(1)

12.5"(1)

5.6"(1)

 
Material(s)

Paper(13)

Non-Woven Fiber(6)

HYDROKNIT*(2)

Cloth(1)

 
For Use With

56650/01, 56640, 56630/01, 56620, 56601, 54720, 54701(2)

56650/01, 56640, 56630/01, 56620, 56601, 55701(1)

52720(1)

KIM 09803(1)

 
Length

8"(7)

9.4"(3)

16.8"(2)

9.45"(1)

10"(1)

9"(1)

10.8"(1)

13.2"(1)

8.8 "(1)

13.15"(1)

 
Scent

Unscented(15)

Lemon Fresh(2)

Fresh Scent(2)

Lemon & Lime Blossom(2)

Low Odor(1)

 
Dirt Types

Dust; Lint; Liquid(5)

Bacteria; Dust; Fungus; Germs; Grease; Grime; Mildew; Mold; Soil; Viruses(4)

Dust;Lint;Liquid;Soil(3)

Dust;Liquid(2)

Viruses; Bacteria; Everyday Messes; Food Spills; Dirt; Dust(2)

Dust;Liquid;Soil(1)

Dust;Lint;Liquid(1)

Grease;Grime;Liquid(1)

Liquid;Soil(1)

Dust(1)

 
Number of Plies

1(15)

2(4)

 
Towel/Wipe Type

Disinfecting Wipes(6)

Multi-Fold(4)

C-Fold(3)

Hardwound Roll Towel(3)

Perforated Roll(2)

Z-Fold(1)

Dry Wipes(1)

Wet Wipes(1)

 
Chemical Compound

Hexoxyethanol; Alkyl C12-18 Dimethylbenzyl Ammonium Chloride; Alkyl C12-14 Dimethyl Ethylbenzyl Ammonium Chloride; C12-14 Alcohols Ethoxylated Proproxylate; Isopropanol; Citric Acid(4)

Alkyl (50%C14, 40%C12, 10%C16) Dimethyl Benzyl Ammonium Chlorides(2)

Alcohol-Free(1)

 
Number of Towels/Wipes Per Container

75(4)

150(3)

80(2)

250(1)

200(1)

85(1)

220(1)

125(1)

120(1)

100(1)

126(1)

160(1)

50(1)

 
Core Size

1.75"(1)

 
Roll Length

800 ft(1)

400 ft(1)

600 ft(1)

 
Packaging

Pack(8)

Canister(6)

Roll(5)

POP-UP* Box(1)

Box(1)

Pop-Up Pack(1)

 
 
 

© 2020-2021 Gateway Business Products, All Rights Reserved