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

Currently Filtered by

Category

Medicines

Refine Search

  GO
Brand

PhysiciansCare(16)

Vicks(14)

Airborne(13)

Mucinex(6)

Cepacol(6)

Dart(6)

Lil' Drugstore(5)

Move Free(5)

Digestive Advantage(5)

Schiff(4)

Advil(4)

Rolaids(4)

Pepto-Bismol(3)

Ricola(3)

First Aid Only(3)

MegaRed(2)

DayQuil(2)

Alka-Seltzer(2)

Midol(2)

Tylenol(2)

HALLS(2)

Aleve(2)

Zantac(1)

Bayer(1)

Motrin IB(1)

Height

11.06"(1)

Color(s)

White/Blue(2)

Clear(2)

White(2)

Yellow/Black(1)

Width

15.25"(2)

Depth

1.63"(1)

Country of Origin

US(95)

MX(7)

GB(6)

CH(3)

CN(2)

DE(1)

Material(s)

Paper(3)

Plastic(2)

Foam(1)

For Use With

ACM-14302, ACM-14303, ACM-5000(12)

Lil' Drugstore Display Dispenser LIL71613 or LIL71615(10)

First Aid Stations/Kits;Individual Use(8)

Individual Use(8)

First Aid Stations/Kits; Individual Use(3)

Standalone First Aid or as a Refill for a Kit(2)

Personal Use(2)

N/A(1)

L16R(1)

Lil' Drugstore 97047; 97187; 97217; 97197(1)

90578; 90580; 90608; 90658; 90659; 90660; 746000; 746004; 746005; 746006(1)

PhysiciansCare ACM90014, ACM90015, ACM90016, ACM90089(1)

16JL, 16SL, 16UL, 16FTL, 16FTLS, 16EL, 16ELBLK, 16RCL, 16RCLBLK, 16LCD, 16LCDH, 16LCDHX(1)

SmartCompliance Cabinets(1)

All SmartCompliance Kits(1)

Lil Drugstore Medicine Dispensers(1)

Capacity (Volume)

16 oz(1)

10 oz(1)

3 oz(1)

3.5 oz(1)

1 oz(1)

16.000 oz(1)

Mounting

No(12)

Wall(2)

N/A(1)

Theme

GRADUATED(1)

Barium(1)

Description

2/Pack(20)

1/Pack(4)

LiquiCaps, 24 per Box(4)

Liquid, 12 oz.(4)

10 per roll, 12 rolls per box(3)

80 Tablets(2)

Chewable Tablets, 30/Box(2)

Combo Pack - 32 DayQuil LiquiCaps + 16 NyQuil LiquiCaps(2)

1.76 oz. (50 g.) Jar(2)

Mucinex Max Strength Expectorant, 28 Tablets/Box(2)

Combo Pack - DayQuil Liquid, 12 oz. + NyQuil Liquid, 12 oz.(2)

Cepacol Sore Throat and Cough Lozenges, Mixed Berry, 16 Lozenges(2)

16/Box, Honey Lemon Flavor(2)

16/Box, Cherry Flavor(2)

20/Pack, Berry Flavor(2)

Six per pack, 12 packs per box(1)

Krill Oil, 500 mg(1)

150 Coated Glucosamine Plus Vitamin D3 Tablets(1)

Krill Oil Softgel 350 mg(1)

Lil' Drugstore Multi-Symptom Sinus Medicine 2 Tablet Pouch(1)

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

Lil' Drugstore Severe Cold Medicine 2 Tablet Pouch(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

30 Coated Tablets(1)

Tylenol Extra Strength Caplets, 2/Pack(1)

Joint Health Supplement(1)

Mucinex Expectorant Regular Strength, 100 Single Wrapped Tablets/Box(1)

Mucinex Maximum Strength Fast Max Cold & Sinus, 6 oz Bottle(1)

Mucinex DM Expectorant and Cough Suppressant, 40 Tablets/Box(1)

DayQuil Severe Cold and Flu 2 Tablet Pouch(1)

150 Coated Glucosamine Plus MSM Tablets(1)

Mucinex Max Strength Expectorant, 14 Tablets/Box(1)

90 Super Calcium Plus Softgels(1)

120 Super Calcium Softgels(1)

120 Coated Tablets(1)

Ricola Cherry Honey Drops(1)

Airborne Chewable Tablets Citrus(1)

Airborne Chewable Tablets Berry(1)

Individually Wrapped(1)

50 doses each Aspirin, Ibuprofen, X-Strength Non Aspirin and Antacid(1)

Cherry(1)

Plastic Grid Station for Medications(1)

10 Very Berry Effervescent Tablets(1)

10 Pink Grapefruit Effervescent Tablets(1)

64 Berry Chewable Tablets(1)

2,160 Effervescent Tablets Orange Flavor(1)

64 Citrus Chewable Tablets(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

10 Lemon-Lime Effervescent Tablets(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

Honey-Lemon(1)

Probiotic Lactose Defense Capsule, 32 Capsules(1)

Ricola Honey Lemon Cough Drops(1)

(10) 2 per packet Ibuprofen Tablets(1)

Aleve 1 Tablet Pouch(1)

Alka-Seltzer Single Dose Pouches(1)

30 Effervescent Tablets Zesty Orange Flavor(1)

Advil Ibuprofen 2 Tablet Pouch(1)

(10) 2 per packet Smart Compliance Refill Aspirin, per box(1)

PhysiciansCare Antacid(1)

96 Capsules(1)

Probiotic Intensive Bowel Support Capsule, 32 Capsules(1)

Daily Probiotic Capsules, 50 Capsules(1)

Enzymes + Probiotic(1)

PhysiciansCare Aspirin(1)

Extra Strength Non-Aspirin Acetaminophen Pain Reliever, 2/Packet, 125 Packets(1)

Ricola Natural Herb Cough Drops(1)

Cup Type

Hot/Cold(3)

Medical(2)

Measuring(1)

Contains

Antioxidants; Vitamin C; Zinc; Selenium; Echinacea; Ginger(7)

Guaifenesin(4)

Benzocaine; Menthol(4)

50 pouches of 2 tablets(4)

Vitamins A, C and E, Magnesium, Zinc, Selenium, Manganese, Sodium, Proprietary Herbal Blend(4)

Acetaminophen 325 mg, Dextromethorphan HBr 15 mg, Doxylamine succinate 6.25 mg(2)

Acetaminophen 325 mg, Dextromethorphan HBr 10 mg, Phenylephrine HCI 5 mg(2)

BC30(2)

Active Ingredients (In each 30 mL Dose Cup): Acetaminophen 650 mg (Pain Reliever/Fever Reducer), Dextromethorphan HBr 30 mg (Cough Suppressant), Doxylamine Succinate 12.5 mg (Antihistamine). Inactive Ingredients: Acesulfame Potassium, Alcohol, Citric Acid, FD&C Yellow No. 10, FD&C Green No. 3, FD&C Yellow No. 6, Flavor, High Fructose Corn Syrup, Polyethylene Glycol, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Citrate(2)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

30 pouches of 2 tablets(2)

Camphor (synthetic) 4.8%, Eucalyptus oil 1.2%, Menthol 2.6%(2)

20 Tablets(2)

NyQuil Cold & Flu: Acetaminophen 325 mg, Dextromethorphan HBr 15 mg, Doxylamine succinate 6.25 mg; DayQuil Cold & Flu: Acetaminophen 325 mg, Dextromethorphan HBr 10 mg, Phenylephrine HCI 5 mg(2)

DayQuil Liquid: Active Ingredients (in each 15 mL tablespoon): Acetaminophen 325 mg (Pain Reliever/Fever Reducer, Dextromethorphan HBr 10mg (Cough Suppressant), Phenylephrine HCl 5mg (Nasal Decongestant). Inactive Ingredients: Citric Acid, FD&C Yellow No. 6, Flavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum. NyQuil Liquid: Active Ingredients (in each 30 mL Dose Cup): Acetaminophen 650 mg (Pain Reliever/Fever Reducer), Dextromethorphan HBr 30 mg (Cough Suppressant), Doxylamine Succinate 12.5 mg (Antihistamine). Inactive Ingredients: Acesulfame Potassium, Alcohol, Citric Acid, FD&C Yellow No. 10, FD&C Green No. 3, FD&C Yellow No. 6, Flavor, High Fructose Corn Syrup, Polyethylene Glycol, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Citrate(2)

Vitamin A; Vitamin C; Vitamin E; Magnesium; Zinc;Selenium Manganese(2)

Ibuprofen(2)

Benzocaine; Dextromethorphan(2)

Vitamin D3 2000 IU; Glucosamine Hydrochloride 1500 mg; MSM 750 mg; Uniflex 216 mg; Chondroitin Sulfate 200 mg; Joint Fluid 3.3 mg(2)

Bismuth Subsalicylate 262 mg(2)

Glucosamine Hydrochloride 1500 mg; MSM 1500 mg; Uniflex 216 mg; Chondroitin Sulfate 200 mg; Joint Fluid 3.3 mg(1)

Cartilage 40 mg; Hyaluronic Acid 3.3 mg, Boron (as boron glycinate) 5 mg(1)

N/A(1)

Two Tablets(1)

Chondroitin; Glucosamine(1)

Bismuth Subsalicylate(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

Active Ingredients (in each 15 mL tablespoon): Acetaminophen 325 mg (Pain Reliever/Fever Reducer, Dextromethorphan HBr 10mg (Cough Suppressant), Phenylephrine HCl 5mg (Nasal Decongestant). Inactive Ingredients: Citric Acid, FD&C Yellow No. 6, Glavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum(1)

Vitamin D 800 IU; Calcium 1200 mg(1)

Vitamin D 800 IU; Calcium 1200 mg; Magnesium 400 mg; Boron 3 mg(1)

Vitamin D 2000 IU; Glucosamine Hydrochloride 2000 mg; Hyaluronic Acid 3.3 mg(1)

Glucosamine Hydrochloride 1500 mg; MSM 1500 mg; Hyaluronic Acid 3.3 mg(1)

Guaifenesin; Dextromethorphan HBr(1)

Active Ingredients (in each 15 mL tablespoon): Acetaminophen 325 mg (Pain Reliever/Fever Reducer, Dextromethorphan HBr 10mg (Cough Suppressant), Phenylephrine HCl 5mg (Nasal Decongestant). Inactive Ingredients: Citric Acid, FD&C Yellow No. 6, Flavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum(1)

DHA; EPA; Krill Oil; Omega-3 Fatty Acids(1)

Acetaminophen; Guaifenesin; Phenylephrine HCI(1)

Ranitidine(1)

12 rolls of 10ct Rolaids Ultra Fruit Tablets(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

Diphenhydramine(1)

Aspirin, Ibuprofen, Extra Strength Non Aspirin Pain Reliever, Antacid(1)

1 Plastic Grid Station(1)

BC30; Calcium (as Calcium Carbonate)(1)

BC30; Lactase Enzymes; Soy(1)

Acetaminophen, Dextromethorphan HBr, Guaifenesin, Phenylephrine HCl(1)

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

Dimenhydrinate(1)

Acetaminophen(1)

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(1)

Phenylephrine HCl(1)

Calcium Carbonate(1)

BC30; Enzymes(1)

250 Tablets(1)

Aspirin(1)

20 packs of two LiquiCaps(1)

12 rolls of 10ct Rolaids Ultra Mint Tablets(1)

12 Rolls of 6 count Rolaids Ultra Strength Antacid Softchew Strawberry(1)

12 rolls of 10ct Rolaids Advanced Antacid and Anti-Gas Tablets(1)

Bag of 21 drops(1)

24 sticks of 10 drops(1)

250 Tablets; Calcium Carbonate 420 mg(1)

250 Tablets; Aspirin 325 mg(1)

19 Drops(1)

30 pouches of 1 tablet(1)

15 Pouches of Single Dose Alka-Seltzer(1)

Astaxanthin (From Krill Oil); DHA; EPA; Krill Oil 350 mg; Phospholipids(1)

Color Family

Blue(2)

Clear(2)

White(2)

Display Material(s)

Plastic(1)

Product Displayed

DayQuil Severe Cold; Lil Drugstore Cold Refief; Lil' Drugstore Ibuprofen; Lil' Drugstrore Multi-Symptom Sinus(1)

Special Features

Mixed Berry(2)

Severe Cold & Flu-Provides maximum strength relief for severe symptoms.(1)

Graduated Cup-Measurements marked in metric and standard US units.(1)

Assorted Berries(1)

Strawberry(1)

170 Pieces-Includes 50 doses each of Lil Drugstore Ibuprofen, Lil Drugstore Cold Relief, Lil Drugstore Multi Symptom Sinus and 20 doses of DayQuil Severe Cold.(1)

Mint(1)

Assorted Fruit Flavors(1)

Graduated(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved