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') 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)

Purex(3)

Persil(3)

Method(2)

All(2)

Seventh Generation Professional(1)

Gain(1)

 
Special Features

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

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

Washes 80 Loads(2)

16 Loads(1)

Concentrated-Washes 70 loads(1)

Washes 32 Loads(1)

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

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

Washes 48 Loads(1)

High Efficiency-Designed for HE machines.(1)

 
Application

Laundry Soap(22)

Laundry Detergent(5)

Washing Machine(2)

 
Applicable Material

Fabric(27)

Clothing; Fabric(2)

 
Dirt Types

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

Dirt; Grease; Organic Matter; Stain(5)

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

Grease; Grime(2)

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

 
Physical Form

Liquid(17)

Powder(8)

Powder/Gel(4)

 
Chemical Compound

Natural Ingredients; Plant-Derived Surfactants(6)

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

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

Alcohol Ethoxylate(1)

Biodegradable Surfactants; Enzymes(1)

Sodium Sulfonates(1)

 
Manufacturer Part Number

93127CT(1)

22769CT(1)

93127(1)

87546(1)

84998(1)

84998CT(1)

22794(1)

22794CT(1)

22977CT(1)

44734(1)

22977(1)

22803CT(1)

22803(1)

84997(1)

50978CT(1)

10245(1)

95729888(1)

09543CT(1)

09457CT(1)

06355(1)

09421CT(1)

95729896(1)

01126CT(1)

13878CT(1)

50978(1)

12783(1)

08886(1)

01127(1)

01120CT(1)

 
Country of Origin

US(27)

CA(1)

HU(1)

 
Packing Type

Bottle(12)

Box(5)

Bag(4)

Pack(2)

Pump Bottle(2)

Tub(2)

Pail(1)

Capsule(1)

 
Capacity (Volume)

150 oz(4)

50 oz(2)

64 oz.(2)

31.7 oz(2)

100 oz(2)

20 oz(2)

92 oz(1)

25 oz(1)

100 oz.(1)

75 oz(1)

 
Scent

Tide Original(6)

Free & Clear/Unscented(5)

Spring Meadow(4)

Original(3)

Fresh Spring Waters(2)

Unscented(2)

Gain Original(1)

Lavender & Blue Eucalyptus(1)

Fresh Air(1)

Intense Fresh(1)

Citrus(1)

Free & Clear(1)

Linen & Lilies(1)

 
Capacity (Weight)

144 oz(2)

112 oz(1)

95 oz(1)

32.5 lbs(1)

1.4 oz(1)

19 lbs(1)

15.6 lbs(1)

 
Number of Tabs (Single-Use Packs)

45(2)

35(2)

72(2)

40(1)

 
 
 

© 2019-2020 Midtown Office Supplies, All Rights Reserved