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

Currently Filtered by

Manufacturer

PROCTER GAMBLE

Refine Search

  GO
 
Category Filter

Cleaners & Detergents(159)

Air Fresheners/Odor Eliminators(50)

Towels & Wipes(42)

Toilet Tissues(23)

Diapers(21)

Sponges(17)

Facial Tissues(14)

Dusters(12)

Mops(10)

Mop Heads(6)

Vacuum Cleaners(6)

Napkins(5)

Personal Soaps(5)

Dryer Sheets(3)

Mouthwash(2)

Air Freshener Dispensers(2)

Medicines(2)

Deodorant(1)

Toothpaste(1)

Soap Dispensers(1)

 
Brand

Febreze(52)

Swiffer(47)

Tide(44)

Bounty(32)

Mr. Clean(32)

Dawn(27)

Charmin(23)

Pampers(18)

Cascade(15)

Puffs(14)

Comet(12)

Spic and Span(10)

Luvs(10)

Joy(8)

Gain(7)

Comet Professional(4)

Safeguard(4)

Ivory(3)

Bounce(3)

Dreft(3)

Downy(3)

DayQuil(2)

Swiffer Sweeper(2)

Scope(2)

Crest(1)

Old Spice(1)

Swiffer Max(1)

Orvus(1)

Cream Suds(1)

 
Height

4 3/5"(8)

2 2/5"(6)

46"(3)

6 1/2"(2)

3 1/5"(2)

2.4"(1)

 
Color(s)

White(114)

White/Blue(6)

Green; Silver(2)

Beige(2)

White/Red(2)

White/Gray(1)

Green;Silver(1)

 
Depth

12"(5)

7 1/8"(2)

2 3/5"(2)

7 3/4"(1)

 
Quantity

1 each(6)

100 per carton(2)

3 per carton(2)

2 per carton(2)

104 per carton(2)

136 per carton(2)

116 per carton(2)

108 per carton(1)

148 per carton(1)

168 per carton(1)

128 per carton(1)

84 per carton(1)

20 per box(1)

124 per carton(1)

140 per carton(1)

88 per carton(1)

25 per box(1)

120 per carton(1)

96 per carton(1)

80 per carton(1)

72 per carton(1)

 
Packing Type

Bottle(97)

Spray Bottle(28)

Box(24)

Aerosol(17)

Bag(13)

Roll(13)

Plastic Overwrap(9)

Cartridge(6)

Tub(5)

Refill(4)

Packet(3)

Bar(3)

Pod(3)

Pack(3)

Pail(2)

Softpack(2)

Trigger Bottle(2)

Cube Box(2)

Pen(2)

Clip(2)

Pac(2)

Canister(2)

Container(1)

Deodorant Stick(1)

ToGo Pack(1)

Squeeze Bottle(1)

Pump Bottle(1)

Gallon(1)

Jar(1)

Plastic Bottle(1)

 
Flavor

Mint(2)

 
Diameter

5 1/2"(3)

6"(1)

4 3/4"(1)

 
 
 

© 2020-2021 Onestop, Inc., All Rights Reserved