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_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(44)

Purex(14)

Seventh Generation(12)

All(11)

Ajax(11)

Method(10)

Persil(10)

Arm & Hammer(9)

Gain(9)

WOOLITE(8)

Seventh Generation Professional(7)

Fab(5)

Boardwalk(4)

Mrs. Meyer's(4)

Dreft(4)

PAK-IT(2)

Dial(2)

Era(2)

EASY-ON(2)

Dynamo(1)

Theochem Laboratories(1)

Surf(1)

Diversey(1)

Kess(1)

Cheer(1)

Final Touch(1)

 
Packing Type

Bottle(105)

Box(23)

Pump Bottle(9)

Pail(8)

Tub(6)

Bag(6)

Vend-Box(4)

Pack(4)

Refill Pouch(2)

Aerosol(2)

Packet(2)

Pod(2)

Capsule(1)

Pac(1)

Canister(1)

 
Manufacturer Part Number

87546(1)

87566CT(1)

87566EA(1)

89129(1)

87545(1)

87456(1)

85882(1)

85882EA(1)

86792CT(1)

86792EA(1)

89129EA(1)

89892CT(1)

94255(1)

94497(1)

96238(1)

96810CT(1)

93127CT(1)

93127(1)

89892EA(1)

93126CT(1)

93126EA(1)

85006CT(1)

84998CT(1)

23068CT(1)

23068EA(1)

27831(1)

50978(1)

23064(1)

23061(1)

13882CT(1)

13885(1)

13890(1)

50978CT(1)

51042(1)

84910(1)

84929(1)

84997(1)

84998(1)

81244EA(1)

81244(1)

80377CT(1)

80377EA(1)

81239(1)

96810EA(1)

96813CT(1)

44734EA(1)

44735(1)

651367(1)

651367EA(1)

44734(1)

44732EA(1)

44724(1)

44724EA(1)

44732CT(1)

651369(1)

651369EA(1)

2979267(1)

2979351(1)

2979355(1)

2979814(1)

035690(1)

141PL(1)

197003270(1)

197004902(1)

197004905(1)

22986(1)

22977CT(1)

77940CT(1)

83134(1)

83134CT(1)

83768(1)

77940(1)

06130CT(1)

00215(1)

00215EA(1)

06130(1)

83768CT(1)

22769CT(1)

22803CT(1)

22927(1)

22927CT(1)

22977(1)

22803(1)

22794CT(1)

22769EA(1)

22781(1)

22794(1)

13882(1)

13878EA(1)

09433(1)

09433EA(1)

09451(1)

09451EA(1)

09421CT(1)

09420EA(1)

05020(1)

05020EA(1)

06354(1)

06355(1)

09456EA(1)

09457CT(1)

430301(1)

45681(1)

46139(1)

46155(1)

2420006040EA(1)

2420006040CT(1)

09542EA(1)

09543CT(1)

10245(1)

05016CT(1)

05016(1)

33200-00008(1)

33200-00103(1)

3320000103EA(1)

33200-00106(1)

HURACAN40(1)

340ULDEA(1)

5665203100EA(1)

340LP(1)

340ULD(1)

3320000107(1)

3320000107EA(1)

01120EA(1)

01134(1)

01134EA(1)

04789(1)

01120CT(1)

00201(1)

33200-00108(1)

33200-00109(1)

33200-00928(1)

46281(1)

95729888(1)

FABBB34(1)

FABBB35(1)

00471(1)

08886(1)

FABBB33(1)

AJAXX43(1)

AJAXX41EA(1)

AJAXX42(1)

AJAXX42EA(1)

08886EA(1)

12783(1)

13784(1)

13875(1)

13875CT(1)

13878CT(1)

12894(1)

12891(1)

12783CT(1)

12784(1)

12786(1)

AJAXX41(1)

AJAXX40(1)

01127CT(1)

01489(1)

01489EA(1)

01490(1)

01127(1)

01126CT(1)

95769089(1)

A-PLUS4(1)

01126(1)

01490EA(1)

01491(1)

58221CT(1)

AJAXX36(1)

AJAXX36EA(1)

AJAXX37(1)

49704(1)

49682(1)

01491EA(1)

37737(1)

48305(1)

5665203100CT(1)

 
Country of Origin

US(168)

HU(6)

CA(3)

 
Capacity (Volume)

100 oz(24)

150 oz(17)

50 oz(14)

60 oz(9)

20 oz(6)

53.5 oz(6)

75 oz(5)

64 oz(5)

25 oz(5)

92 oz(3)

134 oz(3)

5 gal(3)

0.06 oz(2)

31.7 oz(2)

48 oz(2)

16 oz(2)

95 oz(2)

64 oz.(2)

61.25 oz(2)

100 oz.(2)

1.6 oz(1)

1.8 oz(1)

46.5 oz(1)

8 oz(1)

94.5 oz(1)

10 oz(1)

7.5 oz(1)

210 oz(1)

162 oz(1)

1 gal(1)

138 oz(1)

69 oz(1)

 
Scent

Unscented(26)

Tide Original(21)

Free & Clear/Unscented(10)

Original(9)

Gain Original(8)

Free & Clear(7)

Perfume(6)

Spring Meadow(4)

Baby Powder(4)

Fresh(4)

Fragrance Free(4)

Fresh Scent(4)

Linen & Lilies(4)

Lemon & Linen(3)

Honey Lavender(3)

Mountain Breeze(3)

Fresh Burst(3)

Lavender(2)

Musk(2)

Lemon Verbena(2)

Midnight Breeze(2)

Crisp Linen(2)

Refreshing Breeze(2)

Spring & Renewal(2)

Ocean Mist(2)

Era Original(2)

Mountain Air(2)

Fresh Air(2)

Intense Fresh(2)

Fresh Spring Waters(2)

Beach Sage(2)

Ginger Mango(2)

Clean Fresh(2)

Refreshing Falls(1)

Ocean Breeze(1)

Sparkling Ocean(1)

Crisp Clean(1)

Clean-Burst(1)

Lavender & Blue Eucalyptus(1)

After The Rain(1)

Fresh Lemon(1)

Clean Burst(1)

Citrus(1)

Wildflower Medley(1)

Sunset Symphony(1)

Love Duet(1)

Mountain Mist(1)

Neutral(1)

April Fresh(1)

Fresh Clean(1)

Mountain Stream(1)

Blue Lotus & Sunshine(1)

 
Dirt Types

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

Dirt; Grease; Organic Matter; Stain(14)

Dirt; Stains(12)

Grease; Grime(10)

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

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

Fluids; Grease; Soils(4)

Dirt; Grease; Organic Matter; Stains(3)

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

Dirt; Grease; Oil-Based Soil; Organic Matter; Stains; Water-Based Soil(2)

Stain(2)

Dirt; Soil; Food Stains(2)

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

Food Stains; Grass Stains; Grease; Organic Matter(1)

Dirt; Grime(1)

Dirt; Stains; Grease(1)

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

 
Capacity (Weight)

16 oz(2)

144 oz(2)

20 oz(2)

15 g(2)

112 oz(2)

53 oz.(2)

1.8 oz(2)

91 oz(1)

1 oz(1)

5.7 oz(1)

169 oz(1)

95 oz(1)

35 lbs(1)

143 oz(1)

45 lbs(1)

21 oz(1)

150 oz(1)

4 lbs(1)

15.6 lbs(1)

9.86 lb(1)

9.92 lbs(1)

18 lb(1)

40 lbs(1)

1.4 oz(1)

5 oz(1)

36 lbs(1)

0.71 oz(1)

56.4 oz(1)

19 lbs(1)

52 oz(1)

24 oz(1)

 
Chemical Compound

Natural Ingredients; Plant-Derived Surfactants(12)

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

Benzenesulfonic Acid; Alcohols(8)

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

Alcohol Ethoxy Sulfate; Sodium Carbonate; Linear Alkylbenzene Sulfonate; Sodium Chloride; Alcohol Ethoxylate; Sodium Polyacrylate(4)

Lauryl Glucoside(4)

Sodium Sulfonates(3)

Alcohol Ethoxylate(2)

Modified Corn Starch(2)

Biodegradable Surfactants; Enzymes(2)

Hexolyene Glycol(2)

Benzenesulfonic Acid; Alkyl Derivatives; Sodium Salts(1)

Biodegradable Surfactants (Anionic And Nonionic); Enzymes(1)

Alcohol Denat.; Blue 1.; Fragrance; Lauramine Oxide; Methylisothiazolinone; PEG-8 Propylheptyl Ether; PPG-26; Phenoxyethanol; Sodium Chloride; Sodium Laureth Sulfate; Sodium Lauryl Sulfate; Water; Yellow 5(1)

Biodegradable Surfactants (Anionic and Nonionic) and Enzymes(1)

 
Number of Tabs (Single-Use Packs)

72(6)

35(4)

45(3)

100(2)

40(2)

48(1)

20(1)

27(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved