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)

Tylenol(6)

HALLS(5)

Vaseline(4)

Alka-Seltzer(4)

First Aid Only(3)

Lil' Drugstore(3)

Cepacol(3)

Vicks(3)

Pepto-Bismol(3)

Aleve(3)

Midol(3)

Bayer(2)

DayQuil(2)

Airborne(2)

BIOFREEZE(2)

Carmex(1)

Blistex(1)

Theraflu(1)

Schiff(1)

O'Keeffe's(1)

Mucinex(1)

Berkley Jensen(1)

HONEES(1)

Excedrin(1)

Chap Ice(1)

Pepcid(1)

Move Free(1)

MegaRed(1)

Lip Rageous(1)

Ricola(1)

Lip Naturals(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(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)

Lil Drugstore Medicine Dispensers(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

2/Pack, 50 Packs/Box(3)

50 Packets of 2 Tablets Box(3)

Cherry(3)

Honey-Lemon(2)

Liquid, 12 oz(2)

30 Packets of 2 Caplets(2)

50 Packs of 2 Tablets(2)

30 Packets of 2 Tablets(2)

Chewable Tablets, 30/Box(2)

Pain Reliever Tablets, 50 Packs/Box(1)

32 Packets of 2 Liquicaps(1)

Joint Health Supplement Twin Pack(1)

30 Chewable Tablets/Box(1)

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

120 Krill Oil Softgels, 750 mg(1)

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

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

10 Effervescent Tablets Zesty Orange Flavor(1)

1/Pack, 50 Packs/Box(1)

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

32 Packets of 4 Chewable Tablets/Box(1)

Tylenol Extra Strength Caplets, 2/Pack(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)

24 Caplets(1)

Honey Lemon(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

PhysiciansCare Antacid(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)

Colorless, 4 oz Spray Bottle(1)

Green, 16 oz Pump(1)

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

PhysiciansCare Aspirin(1)

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

Lil' Drugstore Allergy Medicine 2 tablet pouch(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)

Advil Ibuprofen 2 Tablet Pouch(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

Ricola Original Herb Cough Drops(1)

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

 
Contains

Acetaminophen(5)

Ibuprofen(3)

Acetaminophen; Caffeine; Pyrilamine Maleate(3)

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

Menthol(2)

30 Packets of 2 Tablets(2)

20 Tablets(2)

50 Packets of 2 Tablets(2)

30 Drops(2)

Eucalyptus Oil; Menthol(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)

Aspirin(2)

Benzocaine; Dextromethorphan(2)

Bismuth Subsalicylate 262 mg(2)

Buffered Aspirin (NSAID)(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)

Chondroitin; Glucosamine(1)

Calcium Carbonate; Magnesium Hydroxide; Famotidine(1)

Acetaminophen; Dextromethorphan; Guaifenesin; Phenylephrine(1)

Ibuprofen 200 mg(1)

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

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

Ibuprofen 200 mg; Phenylephrine HCI 10 mg(1)

Bismuth Subsalicylate(1)

Benzocaine; Menthol(1)

Guaifenesin(1)

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

30 Packets of 1 Tablet(1)

Bag of 21 Drops(1)

250 Tablets(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)

250 Tablets; Aspirin 325 mg(1)

15 Pouches of Single Dose Alka-Seltzer(1)

250 Tablets; Calcium Carbonate 420 mg(1)

Naproxen Sodium(1)

6 Bags of 20 Cough Drops(1)

Eucalyptus Oil(1)

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

Acetaminophen; Phenylephrine HCl; Guaifenesin(1)

Acetaminophen; Aspirin (NSAID); Caffeine(1)

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

 
Mounting Details

No(8)

Wall(1)

 
Country of Origin

US(62)

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