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

Tylenol(7)

HALLS(6)

Lil' Drugstore(5)

Vaseline(4)

Aleve(4)

Cepacol(3)

First Aid Only(3)

Midol(3)

Ricola(3)

Pepto-Bismol(3)

Alka-Seltzer(3)

Vicks(2)

Bayer(2)

DayQuil(2)

Airborne(2)

Excedrin(2)

BIOFREEZE(2)

Carmex(1)

Motrin IB(1)

Pepcid(1)

Lip Rageous(1)

Chap Ice(1)

Benadryl(1)

Blistex(1)

HONEES(1)

O'Keeffe's(1)

Mucinex(1)

Schiff(1)

Theraflu(1)

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

30 Packets of 2 Tablets(4)

Cherry(4)

30 Packets of 2 Caplets(3)

2/Pack, 50 Packs/Box(3)

50 Packets of 2 Tablets Box(3)

30 Packets of 1 Tablet(2)

50 Packs of 2 Tablets(2)

Honey-Lemon(2)

Chewable Tablets, 30/Box(2)

32 Packets of 2 Liquicaps(1)

30 Chewable Tablets/Box(1)

24 Caplets(1)

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

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

Tylenol Extra Strength Caplets, 2/Pack(1)

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

1.76 oz (50 g) Jar(1)

Liquid, 12 oz(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)

32 Packets of 4 Chewable Tablets/Box(1)

Honey Lemon(1)

Lil' Drugstore TUMS Antacid Chewy Bites(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)

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

PhysiciansCare Aspirin(1)

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

Ricola Original Herb Cough Drops(1)

SmartCompliance Aspirin Refill, 2/Packet, 10 Packets/Box(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)

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)

50 Packets of 2 Tablets(2)

20 Tablets(2)

Bismuth Subsalicylate 262 mg(2)

Benzocaine; Dextromethorphan(2)

Aspirin(2)

25 Pouches of 2 Tablets(1)

Anti-Diarrheal, Loperamide HCI Tablets, 2 mg(1)

Tylenol, Acetaminophen, 500 mg Extra Strength(1)

Calcium Carbonate; Magnesium Hydroxide; Famotidine(1)

Bag of 21 Drops(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)

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(1)

Guaifenesin(1)

Benzocaine; Menthol(1)

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

Aleve, Naproxin Tablets, 220 mg(1)

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

Advil, Ibuprofen Tablets, 200 mg(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)

30 Packets of 1 Tablet(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)

Diphenhydramine HCl, 25 mg(1)

Acetaminophen; Aspirin (NSAID); Caffeine(1)

Acetaminophen; 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)

AR(1)

IN(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)

16 oz(1)

0.15 oz(1)

0.35 oz(1)

 
Edition Year

2019(1)

 
 
 
 

© 2025-2026 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander