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

Airborne(11)

Vicks(11)

Cepacol(6)

Mucinex(6)

Vaseline(6)

Move Free(5)

Lil' Drugstore(5)

Schiff(4)

Advil(4)

Digestive Advantage(4)

Rolaids(4)

First Aid Only(3)

Pepto-Bismol(3)

Ricola(3)

Carmex(2)

HALLS(2)

MegaRed(2)

Midol(2)

DayQuil(2)

Alka-Seltzer(2)

Aleve(2)

Tylenol(2)

Blistex(1)

Bayer(1)

Motrin IB(1)

 
Height

11.06"(1)

 
Color(s)

Yellow/Black(1)

 
Depth

1.63"(1)

 
Packing Type

Plastic Flip-Top Container(2)

Mini Tin(2)

Tube(2)

Display Box with Tubes(1)

Jar(1)

 
Flavor

Original(8)

 
Manufacturer Part Number

10030(1)

BXAS50(1)

01440(1)

01436(1)

01426EA(1)

01426(1)

00361EA(1)

00361(1)

BXPB-25(1)

BXMD30(1)

BXDXSV25(1)

BXBG50(1)

BXAL50(1)

01443(1)

30117(1)

019901(1)

016902(1)

015489(1)

97009EA(1)

97008(1)

97007CT(1)

97007(1)

11841(1)

98093EA(1)

95330EA(1)

01440BX(1)

01443BX(1)

44910(1)

73016CT(1)

75000CT(1)

53647EA(1)

53647CT(1)

20677EA(1)

20677CT(1)

97005EA(1)

11342(1)

11256(1)

11019(1)

74016CT(1)

74016(1)

73016(1)

01452(1)

71016CT(1)

71016(1)

05640(1)

02328CT(1)

02328(1)

02314(1)

01665(1)

00815(1)

03977BX(1)

03977(1)

01479(1)

48152(1)

R10405(1)

10030CT(1)

90031(1)

27499(1)

90794(1)

90780(1)

90316(1)

90306(1)

90109(1)

90092(1)

90091(1)

90089(1)

90087(1)

90032(1)

90016(1)

00101DA(1)

90015(1)

90014(1)

97971(1)

97970(1)

30112(1)

30017(1)

30006(1)

30004CT(1)

30004(1)

18631(1)

18630(1)

28694(1)

00116(1)

R10309(1)

62458(1)

R10049(1)

R10034(1)

97477(1)

97217(1)

97197(1)

97187(1)

97117(1)

97047(1)

7776(1)

71992(1)

70171(1)

58030(1)

00117DA(1)

51060(1)

51030(1)

3003(1)

11313(1)

FAE7014(1)

FAE7004(1)

90751(1)

90110(1)

54034(1)

40800(1)

18167(1)

75000EA(1)

 
Country of Origin

US(90)

MX(6)

GB(6)

CH(3)

CN(2)

CA(2)

DE(1)

 
Width

15.25"(1)

 
For Use With

ACM-14302, ACM-14303, ACM-5000(12)

Lil' Drugstore Display Dispenser LIL71613 or LIL71615(10)

First Aid Stations/Kits;Individual Use(8)

Individual Use(8)

Personal Use(2)

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

First Aid Stations/Kits; Individual Use(2)

PhysiciansCare ACM90014, ACM90015, ACM90016, ACM90089(1)

SmartCompliance Cabinets(1)

All SmartCompliance Kits(1)

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

Lil Drugstore Medicine Dispensers(1)

Lil' Drugstore 97047; 97187; 97217; 97197(1)

N/A(1)

 
Capacity (Volume)

0.35 oz(2)

0.6 oz(2)

1.5 oz(1)

 
Capacity (Weight)

0.25 oz(3)

0.35 oz(1)

 
Mounting

No(12)

Wall(2)

N/A(1)

 
Description

2/Pack(20)

LiquiCaps, 24 per Box(4)

Liquid, 12 oz.(3)

10 per roll, 12 rolls per box(3)

1/Pack(3)

1.76 oz. (50 g.) Jar(2)

Chewable Tablets, 30/Box(2)

80 Tablets(2)

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

16/Box, Honey Lemon Flavor(2)

16/Box, Cherry Flavor(2)

Mucinex Max Strength Expectorant, 28 Tablets/Box(2)

30 Coated Tablets(1)

30 Effervescent Tablets Zesty Orange Flavor(1)

Krill Oil, 500 mg(1)

Krill Oil Softgel 350 mg(1)

120 Coated Tablets(1)

Tylenol Extra Strength Caplets, 2/Pack(1)

Lil' Drugstore Multi-Symptom Sinus Medicine 2 Tablet Pouch(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

Six per pack, 12 packs per box(1)

Combo Pack - DayQuil Liquid, 12 oz. + NyQuil Liquid, 12 oz.(1)

Joint Health Supplement(1)

Combo Pack - 32 DayQuil LiquiCaps + 16 NyQuil LiquiCaps(1)

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

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

Mucinex Maximum Strength Fast Max Cold & Sinus, 6 oz Bottle(1)

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

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

150 Coated Glucosamine Plus MSM Tablets(1)

120 Super Calcium Softgels(1)

90 Super Calcium Plus Softgels(1)

Lil' Drugstore Severe Cold Medicine 2 Tablet Pouch(1)

Ricola Natural Herb Cough Drops(1)

DayQuil Severe Cold and Flu 2 Tablet Pouch(1)

Honey-Lemon(1)

64 Berry Chewable Tablets(1)

64 Citrus Chewable Tablets(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

10 Lemon-Lime Effervescent Tablets(1)

10 Pink Grapefruit Effervescent Tablets(1)

10 Very Berry Effervescent Tablets(1)

Airborne Chewable Tablets Berry(1)

Airborne Chewable Tablets Citrus(1)

Individually Wrapped(1)

50 doses each Aspirin, Ibuprofen, X-Strength Non Aspirin and Antacid(1)

Plastic Grid Station for Medications(1)

Cherry(1)

Probiotic Lactose Defense Capsule, 32 Capsules(1)

2,160 Effervescent Tablets Orange Flavor(1)

Probiotic Intensive Bowel Support Capsule, 32 Capsules(1)

96 Capsules(1)

Daily Probiotic Capsules, 50 Capsules(1)

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

PhysiciansCare Aspirin(1)

PhysiciansCare Antacid(1)

(10) 2 per packet Smart Compliance Refill Aspirin, per box(1)

(10) 2 per packet Ibuprofen Tablets(1)

Ricola Honey Lemon Cough Drops(1)

Aleve 1 Tablet Pouch(1)

Alka-Seltzer Single Dose Pouches(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Ricola Cherry Honey Drops(1)

150 Coated Glucosamine Plus Vitamin D3 Tablets(1)

 
Contains

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

Vitamins A, C and E, Magnesium, Zinc, Selenium, Manganese, Sodium, Proprietary Herbal Blend(4)

50 pouches of 2 tablets(4)

Benzocaine; Menthol(4)

Guaifenesin(4)

30 pouches of 2 tablets(2)

Camphor (synthetic) 4.8%, Eucalyptus oil 1.2%, Menthol 2.6%(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)

BC30(2)

Acetaminophen 325 mg, Dextromethorphan HBr 15 mg, Doxylamine succinate 6.25 mg(2)

Acetaminophen 325 mg, Dextromethorphan HBr 10 mg, Phenylephrine HCI 5 mg(2)

Bismuth Subsalicylate 262 mg(2)

20 Tablets(2)

Vitamin D3 2000 IU; Glucosamine Hydrochloride 1500 mg; MSM 750 mg; Uniflex 216 mg; Chondroitin Sulfate 200 mg; Joint Fluid 3.3 mg(2)

Benzocaine; Dextromethorphan(2)

Ibuprofen(2)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

Chondroitin; Glucosamine(1)

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

Two Tablets(1)

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

N/A(1)

Active Ingredients (in each 15 mL tablespoon): Acetaminophen 325 mg (Pain Reliever/Fever Reducer, Dextromethorphan HBr 10mg (Cough Suppressant), Phenylephrine HCl 5mg (Nasal Decongestant). Inactive Ingredients: Citric Acid, FD&C Yellow No. 6, Flavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

Bismuth Subsalicylate(1)

Astaxanthin (From Krill Oil); DHA; EPA; Krill Oil 350 mg; Phospholipids(1)

NyQuil Cold & Flu: Acetaminophen 325 mg, Dextromethorphan HBr 15 mg, Doxylamine succinate 6.25 mg; DayQuil Cold & Flu: Acetaminophen 325 mg, Dextromethorphan HBr 10 mg, Phenylephrine HCI 5 mg(1)

DayQuil Liquid: Active Ingredients (in each 15 mL tablespoon): Acetaminophen 325 mg (Pain Reliever/Fever Reducer, Dextromethorphan HBr 10mg (Cough Suppressant), Phenylephrine HCl 5mg (Nasal Decongestant). Inactive Ingredients: Citric Acid, FD&C Yellow No. 6, Flavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum. NyQuil Liquid: 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)

Acetaminophen; Guaifenesin; Phenylephrine HCI(1)

Guaifenesin; Dextromethorphan HBr(1)

Glucosamine Hydrochloride 1500 mg; MSM 1500 mg; Hyaluronic Acid 3.3 mg(1)

Vitamin D 800 IU; Calcium 1200 mg(1)

Vitamin D 800 IU; Calcium 1200 mg; Magnesium 400 mg; Boron 3 mg(1)

DHA; EPA; Krill Oil; Omega-3 Fatty Acids(1)

12 rolls of 10ct Rolaids Ultra Mint Tablets(1)

12 rolls of 10ct Rolaids Advanced Antacid and Anti-Gas Tablets(1)

1 Plastic Grid Station(1)

Aspirin(1)

Acetaminophen(1)

Dimenhydrinate(1)

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(1)

Phenylephrine HCl(1)

Calcium Carbonate(1)

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

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

Diphenhydramine(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

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

BC30; Lactase Enzymes; Soy(1)

12 Rolls of 6 count Rolaids Ultra Strength Antacid Softchew Strawberry(1)

BC30; Calcium (as Calcium Carbonate)(1)

250 Tablets(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

19 Drops(1)

30 pouches of 1 tablet(1)

15 Pouches of Single Dose Alka-Seltzer(1)

24 sticks of 10 drops(1)

Bag of 21 drops(1)

20 packs of two LiquiCaps(1)

12 rolls of 10ct Rolaids Ultra Fruit Tablets(1)

Vitamin D 2000 IU; Glucosamine Hydrochloride 2000 mg; Hyaluronic Acid 3.3 mg(1)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved