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)

HALLS(6)

Tylenol(6)

Vaseline(4)

Lil' Drugstore(4)

Cepacol(3)

First Aid Only(3)

Midol(3)

Vicks(3)

Aleve(3)

Ricola(3)

Pepto-Bismol(3)

Alka-Seltzer(3)

Bayer(2)

DayQuil(2)

Airborne(2)

Excedrin(2)

Blistex(1)

Theraflu(1)

Schiff(1)

BIOFREEZE(1)

Mucinex(1)

O'Keeffe's(1)

HONEES(1)

Benadryl(1)

Lip Naturals(1)

Chap Ice(1)

Lip Rageous(1)

Pepcid(1)

Move Free(1)

MegaRed(1)

Motrin IB(1)

Carmex(1)

 
For Use With

First Aid Stations/Kits; Individual Use(8)

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

Lil' Drugstore Display Dispenser 71613, 71615(5)

Individual Use(3)

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)

 
Flavor

Original(5)

Cherry; Kiwi; Orange(1)

Assorted(1)

Bing Cherry; Tea Tree Mint; Vanilla Bean(1)

 
Volume Capacity

0.35 oz(2)

0.15 oz(1)

 
Description

Cherry(4)

30 Packets of 2 Caplets(3)

2/Pack, 50 Packs/Box(3)

50 Packets of 2 Tablets Box(3)

30 Packets of 2 Tablets(2)

50 Packs of 2 Tablets(2)

Honey-Lemon(2)

Chewable Tablets, 30/Box(2)

Liquid, 12 oz(2)

10 Effervescent Tablets Zesty Orange Flavor(1)

32 Packets of 2 Liquicaps(1)

30 Chewable Tablets/Box(1)

Joint Health Supplement Twin Pack(1)

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

120 Krill Oil Softgels, 750 mg(1)

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

24 Caplets(1)

Pain Reliever Tablets, 50 Packs/Box(1)

32 Packets of 4 Chewable Tablets/Box(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 Max Strength Expectorant, 14 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)

150 Coated Glucosamine Plus MSM Tablets(1)

Tylenol Extra Strength Caplets, 2/Pack(1)

Ricola Original Herb Cough Drops(1)

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

Complete Menstrual Caplets, Two-Pack, 50 Packs/Box(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)

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

PhysiciansCare Aspirin(1)

PhysiciansCare Antacid(1)

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

Lil' Drugstore TUMS Antacid Chewy Bites(1)

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

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

Aleve 220 mg Tablets(1)

Throat Drops(1)

Cough Drops(1)

60 Packets of 2 Tablets(1)

Aleve 1 Tablet Pouch(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Honey Lemon(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

6 Packets Theraflu Multi-Symptom Severe Cold Hot Liquid Powder(1)

 
Contains

Acetaminophen(4)

Acetaminophen; Caffeine; Pyrilamine Maleate(3)

Ibuprofen(3)

Eucalyptus Oil; Menthol(3)

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

30 Packets of 2 Tablets(2)

2 Bags of 65 Drops(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)

Bismuth Subsalicylate 262 mg(2)

50 Packets of 2 Tablets(2)

Benzocaine; Dextromethorphan(2)

Aspirin(2)

Chondroitin; Glucosamine(1)

25 Pouches of 2 Tablets(1)

Calcium Carbonate; Magnesium Hydroxide; Famotidine(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)

Ibuprofen 200 mg(1)

Acetaminophen; Dextromethorphan; Guaifenesin; Phenylephrine(1)

Buffered Aspirin (NSAID)(1)

Acetaminophen; Chlorpheniramine Maleate; Dextromethorphan Hydrobromide; Phenylephrine Hydrochloride(1)

Ibuprofen 200 mg; Phenylephrine HCI 10 mg(1)

Bismuth Subsalicylate(1)

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

Guaifenesin(1)

Benzocaine; Menthol(1)

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

Bag of 21 Drops(1)

Diphenhydramine HCl, 25 mg(1)

30 Packets of 1 Tablet(1)

30 Drops(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)

Acetaminophen; Ibuprofen(1)

Menthol(1)

30 Drops per Bag(1)

Acetaminophen 250 mg; Aspirin (NSAID) 250 mg; Caffeine 65 mg(1)

Acetaminophen; Phenylephrine HCl; Guaifenesin(1)

250 Tablets(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

Naproxen Sodium(1)

6 Bags of 20 Cough Drops(1)

Eucalyptus Oil(1)

Acetaminophen; Aspirin (NSAID); Caffeine(1)

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

Acetaminophen 500 mg; Dextromethorphan HBr 20 mg; Phenylephrine HCI 10 mg(1)

 
Mounting Details

No(8)

Wall(1)

 
Country of Origin

US(65)

MX(8)

CN(3)

GB(3)

IT(2)

JP(1)

CA(1)

SE(1)

DE(1)

 
Height

10.75"(1)

 
Width

15.5"(1)

 
Depth

2.25"(1)

 
Color(s)

Yellow(1)

 
Capacity (Weight)

0.1 oz(2)

0.25 oz(2)

0.15 oz(1)

0.35 oz(1)

 
Edition Year

2019(1)

 
 
 
 

© 2025-2026 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander