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)

Tylenol(6)

Advil(6)

Alka-Seltzer(5)

Vaseline(4)

HALLS(3)

Lil' Drugstore(3)

Cepacol(3)

Vicks(3)

Pepto-Bismol(3)

First Aid Only(3)

Airborne(3)

Midol(3)

Aleve(3)

DayQuil(2)

Bayer(2)

HONEES(1)

Schiff(1)

Mucinex(1)

O'Keeffe's(1)

Berkley Jensen(1)

Blistex(1)

Pepcid(1)

Lip Rageous(1)

Move Free(1)

MegaRed(1)

Motrin IB(1)

BIOFREEZE(1)

Excedrin(1)

Carmex(1)

Lip Naturals(1)

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

Assorted(1)

Cherry; Citrus; Mint(1)

 
Volume Capacity

0.35 oz(2)

0.15 oz(1)

 
Description

50 Packets of 2 Tablets Box(3)

2/Pack, 50 Packs/Box(3)

Honey-Lemon(2)

30 Packets of 2 Caplets(2)

50 Packs of 2 Tablets(2)

30 Packets of 2 Tablets(2)

Cherry(2)

Chewable Tablets, 30/Box(2)

Liquid, 12 oz(2)

32 Packets of 2 Liquicaps(1)

25 Packets of 2 Tablets(1)

Joint Health Supplement Twin Pack(1)

30 Chewable Tablets/Box(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)

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)

Tylenol Extra Strength Caplets, 2/Pack(1)

32 Packets of 4 Chewable Tablets/Box(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)

24 Caplets(1)

Ricola Original Herb Cough Drops(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

PhysiciansCare Aspirin(1)

Immune Support Gummies, Very Berry, 42/Bottle(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 Antacid(1)

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

Advil Ibuprofen 2 Tablet Pouch(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

150 Coated Glucosamine Plus MSM Tablets(1)

 
Contains

Acetaminophen(5)

Acetaminophen; Caffeine; Pyrilamine Maleate(3)

Ibuprofen(3)

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

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

30 Drops(2)

30 Packets of 2 Tablets(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)

Bismuth Subsalicylate 262 mg(2)

50 Packets of 2 Tablets(2)

Aspirin(2)

Benzocaine; Dextromethorphan(2)

20 Tablets(2)

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; Phenylephrine HCI 10 mg(1)

Buffered Aspirin (NSAID)(1)

Ibuprofen 200 mg(1)

Bismuth Subsalicylate(1)

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

Guaifenesin(1)

Benzocaine; Menthol(1)

Bag of 21 Drops(1)

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

15 Pouches of Single Dose Alka-Seltzer(1)

Menthol(1)

Acetaminophen; Aspirin (NSAID); Caffeine(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(1)

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

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

Acetaminophen; Phenylephrine HCl; Guaifenesin(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(61)

MX(9)

GB(3)

IT(2)

CN(1)

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

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved

Powered by Dealer Commander