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

Currently Filtered by

Category

Feminine Products

Refine Search

  GO
Brand

Always(27)

Seventh Generation(8)

HOSPECO(5)

Tampax(3)

Kotex(2)

Impact(2)

Tidy Girl(1)

Hospital Specialty Co.(1)

Country of Origin

CA(28)

US(16)

MX(4)

CN(1)

For Use With

Dual Vending Machines(2)

Impact Personal Care Vendors(1)

Absorbency

Regular(19)

Super Long(9)

Maxi(7)

Overnight(4)

Maximum(2)

Heavy(2)

Very Light(2)

Extra Heavy Overnight(2)

Super(1)

Special Features

Super Long(4)

Ultra Thin with Wings, Regular-18/Pack(2)

Long Length, 39 Pack(1)

Small/Medium, 19 Pack, 3 Packs/Carton(1)

Large, 17 Pack, 3 Packs/Carton(1)

Long Length, 39/Pack, 3 Packs/Carton(1)

Long Length, 44 Pack, 3 Packs/Carton(1)

Long Length, 44 Pack(1)

Size 4, 38/Pack, 6 Packs/Carton(1)

Size 4, 38 Pack(1)

Ultra Thin with Wings, Super Long-16/Pack, 12 Packs/Carton(1)

Ultra Thin with Wings, Super Long-16/Pack, 6 Packs/Carton(1)

Ultra Thin with Wings, Overnight-14/Pack, 6 Packs/Carton(1)

Ultra Thin with Wings, Overnight-14/Pack, 12 Packs/Carton(1)

Maxi Regular-24/Pack, 12 Packs/Carton(1)

Ultra Thin with Wings, Regular-18/Pack, 6 Packs/Carton(1)

Size 2, Super Long, Super Absorbent, 40/Pack(1)

Size 2, Super Long, Super-Absorbent, 32/Pack(1)

20 Pack(1)

60/Pack, 12 Pack/Carton(1)

60 Pack(1)

20/Pack, 24 Packs/Carton(1)

Absorbs 12-15 Grams of Fluid(1)

Size 8-Ultra thin.(1)

Absorbs 6-9 Grams of Fluid(1)

120/Pack, 6 Packs/Carton(1)

120 Pack(1)

Size 2, Super Long, Super-Absorbent, 32/Pack, 6 Packs/Carton(1)

Size 4(1)

Size 1, 36/Pack(1)

Size 1, 36/Pack, 6 Packs/Carton(1)

Size 5, 20/Pack, 6 Packs/Carton(1)

Size 5, 20 Pack(1)

Size 2, Super Long, Super Absorbent, 40/Pack, 6 Packs/Carton(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved