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 ('40063')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%Medicines' THEN 1 ELSE 0 END DESC, 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(11)

Advil(6)

Airborne(4)

Tylenol(4)

Move Free(4)

Vaseline(4)

First Aid Only(3)

Lil' Drugstore(3)

Cepacol(3)

Mucinex(3)

Aleve(3)

Vicks(3)

HALLS(3)

Pepto-Bismol(2)

Midol(2)

Alka-Seltzer(2)

Ricola(1)

Carmex(1)

MegaRed(1)

BIOFREEZE(1)

Blistex(1)

Bayer(1)

Lip Naturals(1)

HONEES(1)

Digestive Advantage(1)

Berkley Jensen(1)

Schiff(1)

Motrin IB(1)

 
For Use With

PhysiciansCare by First Aid Only 14302, 14303, 50000(8)

First Aid Stations/Kits; Individual Use(8)

Lil' Drugstore Display Dispenser 71613, 71615(5)

Individual Use(4)

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

SmartCompliance Cabinets(1)

All SmartCompliance Kits(1)

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

Lil Drugstore Medicine Dispensers(1)

 
Flavor

Original(5)

Cherry; Citrus; Mint(1)

 
Volume Capacity

0.35 oz(2)

1.5 oz(1)

 
Description

50 Packets of 2 Tablets Box(3)

2/Pack, 50 Packs/Box(3)

Honey-Lemon(2)

50 Packs of 2 Tablets(2)

Chewable Tablets, 30/Box(2)

Liquid, 12 oz(2)

Cherry(2)

Ibuprofen Tablets, 2/Pack, 50 Packs/Box(1)

24 Caplets(1)

Extra Strength Caplets, Two-Pack, 50 Packs/Box(1)

120 Krill Oil Softgels, 750 mg(1)

30 Coated Tablets(1)

80 Tablets(1)

120 Coated Tablets(1)

Joint Health Supplement Twin Pack(1)

Pain Reliever Tablets, 50 Packs/Box(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

Liqui-Gels, 2/Pack, 50 Packs/Box(1)

1/Pack, 50 Packs/Box(1)

Complete Menstrual Caplets, Two-Pack, 30 Packs/Box(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

1.76 oz (50 g) Jar(1)

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

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

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

Cherry Flavor, 16/Box, 24 Boxes/Carton(1)

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

Cepacol Sore Throat and Cough Lozenges, Mixed Berry, 16 Lozenges, 24 Packs/Carton(1)

Tylenol Extra Strength Caplets, 2/Pack(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

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

Immune Support Gummies, Very Berry, 42/Bottle(1)

30 Very Berry Effervescent Tablets(1)

50 Packets of 1 Tablet Box(1)

2/Pack, 125 Packs/Box(1)

Cherry Menthol Lozenges, Individually Wrapped, 50/Box(1)

50 Doses Each: Aspirin, Ibuprofen, X-Strength Non Aspirin, Antacid(1)

50 Packets of 2 Caplets(1)

100 Count(1)

Green, 16 oz Pump(1)

Daily Probiotic Capsules, 50 Capsules(1)

PhysiciansCare Aspirin(1)

Ricola Natural Herb Cough Drops(1)

PhysiciansCare Antacid(1)

Complete Menstrual Caplets, Two-Pack, 50 Packs/Box(1)

SmartCompliance Aspirin Refill, 2/Packet, 10 Packets/Box(1)

Over the Counter Pain Relief Medication for First Aid Cabinet, 20 Count(1)

Acetaminophen Pain Relief Tablets, 500 mg(1)

8-Hour Arthritis Pain Extended Release Tablets, 650 mg(1)

Aleve 220 mg Tablets(1)

Aleve 1 Tablet Pouch(1)

Alka-Seltzer Single Dose Pouches(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

150 Coated Glucosamine Plus MSM Tablets(1)

 
Contains

Acetaminophen(4)

Ibuprofen(3)

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

Benzocaine; Dextromethorphan(2)

50 Packets of 2 Tablets(2)

Guaifenesin(2)

Bismuth Subsalicylate 262 mg(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)

20 Tablets(2)

30 Packets of 2 Tablets(2)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

30 Drops(2)

Vitamin D3 2,000 IU; Glucosamine Hydrochloride 1,500 mg; MSM 750 mg; Uniflex 216 mg; Chondroitin Sulfate 200 mg; Joint Fluid 3.3 mg(1)

Krill Oil 750 mg; Omega-3 Fatty Acids 225 mg; Total EPA and DHA 180 mg; Phospholipids 390 mg; Astanxanthin (from Krill Oil) 60 mcg(1)

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

Ibuprofen 200 mg; Phenylephrine HCI 10 mg(1)

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

Chondroitin; Glucosamine(1)

Ibuprofen 200 mg(1)

Camphor (Synthetic) 4.8%; Eucalyptus Oil 1.2%; Menthol 2.6%(1)

Guaifenesin; Dextromethorphan HBr(1)

Benzocaine; Menthol(1)

Bag of 21 drops(1)

6 Bags of 20 Cough Drops(1)

15 Pouches of Single Dose Alka-Seltzer(1)

Acetaminophen; Ibuprofen(1)

Riboflavin; Vitamin A, C and E; Zinc; Selenium; Magnesium; Manganese; Potassium; Proprietary Herbal Blend; Proprietary Amino Acid Blend(1)

Aspirin(1)

Phenylephrine HCl(1)

Calcium Carbonate(1)

Acetaminophen; Chlorpheniramine Maleate; Phenylephrine Hydrochloride(1)

Diphenhydramine(1)

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

Menthol(1)

30 Packets of 1 Tablet(1)

BC30; Calcium (as Calcium Carbonate)(1)

250 Tablets(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

Naproxen Sodium(1)

Magnesium; Manganese; Proprietary Herbal Blend; Selenium; Vitamin A; Vitamin C; Vitamin E; Zinc(1)

Eucalyptus Oil(1)

Glucosamine Hydrochloride 1,500 mg; MSM 1,500 mg; Hyaluronic Acid 3.3 mg(1)

 
Mounting Details

No(8)

Wall(1)

 
Country of Origin

US(59)

MX(6)

GB(3)

CN(1)

JP(1)

CH(1)

DE(1)

 
Height

10.75"(1)

 
Width

15.5"(1)

 
Depth

2.25"(1)

 
Color(s)

Yellow(1)

 
Quantity

Bag of 21 drops(1)

1 each(1)

 
Capacity (Weight)

0.25 oz(2)

0.1 oz(1)

0.35 oz(1)

 
Edition Year

2019(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved