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

Currently Filtered by

Category

Laundry Detergents

Refine Search

  GO
 
Brand

Tide(10)

Seventh Generation(7)

WOOLITE(4)

Purex(3)

Persil(3)

Method(3)

Arm & Hammer(2)

Gain(1)

EASY-ON(1)

Seventh Generation Professional(1)

 
Special Features

Washes 99 Loads-Scent derived from whole essential oils and botanical extracts.(2)

Washes 80 Loads(2)

Washes 99 Loads-No dyes or fragrances; scent-free and natural choice for those sensitive to scents.(2)

130 Loads(1)

High Efficiency-Designed for HE machines. HE Turbo Clean formula quickly collapses suds and targets tough stains.(1)

16 Loads(1)

Washes 32 Loads(1)

High Efficiency-Designed for HE machines.(1)

Washes 48 Loads(1)

Washes 33 Loads-No dyes or fragrances; scent-free and natural choice for those sensitive to scents.(1)

Concentrated-Washes 70 loads(1)

 
Application

Laundry Detergent(33)

Laundry Soap(1)

Laundry Starch(1)

 
Applicable Material

Fabric(32)

Clothing; Fabric(3)

 
Dirt Types

Food Stains; Grass Stains; Grease; Oil-Based Soil; Organic Matter; Water-Based Soil(22)

Dirt; Grease; Organic Matter; Stain(5)

Grease; Grime(3)

Bacteria; Food Stains; Grass Stains; Grease; Oil-Based Soil; Organic Matter; Water-Based Soil(2)

Grease: Grime; Hard Water Stains; Lime; Soap Scum; Water-Based Soil; Oil-Based Soil(2)

 
Physical Form

Liquid(22)

Powder(9)

Powder/Gel(4)

 
Chemical Compound

Natural Ingredients; Plant-Derived Surfactants(6)

Benzenesulfonic Acid; Alcohols(4)

D-Glucopyranose; Oligomers; Decyl Octyl Glycosides(3)

Alcohol Ethoxy Sulfate, Alcohol Ethoxylate, Alkylbenzene Sulfonaye,Sodium Citrate,Sodium Soap, Propylene Glycol,Ethoxylated Polyethyleneimine(2)

Alcohol Ethoxylate(1)

Sodium Sulfonates(1)

Biodegradable Surfactants; Enzymes(1)

Modified Corn Starch(1)

 
Manufacturer Part Number

3320000107(1)

83768CT(1)

93127(1)

93127CT(1)

00215(1)

77940(1)

77940CT(1)

83768(1)

22769CT(1)

84998CT(1)

22794(1)

22794CT(1)

22803(1)

22803CT(1)

22977(1)

22977CT(1)

87546(1)

84998(1)

33200-00108(1)

01126CT(1)

01120CT(1)

06355(1)

09421CT(1)

09457CT(1)

09543CT(1)

10245(1)

01127(1)

84997(1)

01127CT(1)

08886(1)

12783(1)

13878CT(1)

50978(1)

50978CT(1)

44734(1)

 
Country of Origin

US(33)

HU(1)

CA(1)

 
Packing Type

Bottle(17)

Box(6)

Bag(4)

Pump Bottle(3)

Pack(2)

Pail(1)

Capsule(1)

Aerosol(1)

 
Capacity (Volume)

100 oz(4)

20 oz(4)

50 oz(4)

150 oz(4)

64 oz.(2)

31.7 oz(2)

61.25 oz(1)

75 oz(1)

100 oz.(1)

25 oz(1)

92 oz(1)

 
Scent

Tide Original(6)

Free & Clear/Unscented(5)

Spring Meadow(4)

Fresh(2)

Fresh Spring Waters(2)

Original(2)

Fresh Air(2)

Light Floral(2)

Midnight Breeze(2)

Unscented(2)

Linen & Lilies(1)

Intense Fresh(1)

Free & Clear(1)

Gain Original(1)

Crisp Linen(1)

Lavender & Blue Eucalyptus(1)

 
Capacity (Weight)

144 oz(2)

9.92 lbs(1)

15.6 lbs(1)

1.4 oz(1)

95 oz(1)

112 oz(1)

 
Number of Tabs (Single-Use Packs)

35(2)

72(2)

45(2)

40(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved