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)

All(3)

Persil(2)

Purex(2)

Method(1)

Gain(1)

 
Special Features

Washes 99 Loads(3)

Concentrated(2)

High Efficiency(2)

Washes 80 Loads(2)

16 Loads(1)

Washes 32 Loads(1)

Washes 33 Loads(1)

Washes 48 Loads(1)

 
Application

Laundry Soap(21)

Laundry Detergent(4)

Washing Machine(1)

 
Applicable Material

Fabric(25)

Clothing; Fabric(1)

 
Dirt Types

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

Dirt; Grease; Organic Matter; Stain(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)

Grease; Grime(1)

 
Physical Form

Liquid(13)

Powder(9)

Powder/Gel Pac(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)

Biodegradable Surfactants; Enzymes(1)

Sodium Sulfonates(1)

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

 
Manufacturer Part Number

93127(1)

93127CT(1)

87546(1)

84998CT(1)

84998(1)

22769CT(1)

22794(1)

22824CT(1)

22977(1)

22824(1)

22803CT(1)

22803(1)

84997(1)

50978CT(1)

95729888(1)

95729896(1)

10245(1)

09457CT(1)

09421CT(1)

95769089(1)

01127(1)

50978(1)

13878CT(1)

12783(1)

08886(1)

06355(1)

 
Country of Origin

US(24)

CA(2)

 
Packing Type

Bottle(11)

Box(6)

Bag(4)

Tub(2)

Pack(1)

Pail(1)

Pump Bottle(1)

 
Capacity (Volume)

150 oz(3)

100 oz(2)

50 oz(2)

31.7 oz(1)

92 oz(1)

25 oz(1)

64 oz(1)

20 oz(1)

100 oz.(1)

 
Scent

Tide Original(6)

Free & Clear/Unscented(5)

Spring Meadow(4)

Original(3)

Lavender & Blue Eucalyptus(1)

Unscented(1)

Gain Original(1)

Fresh Air(1)

Intense Fresh(1)

Mountain Breeze(1)

Citrus(1)

Original Fresh(1)

 
Capacity (Weight)

31 oz.(2)

112 oz(2)

144 oz(2)

64 oz.(2)

1.4 oz(1)

19 lbs(1)

32.5 lbs(1)

95 oz(1)

15.6 lbs(1)

 
Number of Tabs (Single-Use Packs)

72(2)

35(2)

45(1)

 
 
 

© 2018-2019 Midtown Office Supplies, All Rights Reserved