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 ('661')) AND `pinfo`.`status` IN ('active','discontinued') 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)

Vicks(14)

Airborne(13)

Cepacol(6)

Lil' Drugstore(6)

Dart(5)

Mucinex(4)

Advil(4)

Rolaids(4)

Ricola(3)

Pepto-Bismol(3)

First Aid Only(3)

Tylenol(2)

Zantac(2)

Aleve(2)

Midol(2)

DayQuil(2)

HALLS(2)

Alka-Seltzer(2)

Digestive Advantage(1)

Bayer(1)

Motrin IB(1)

 
Height

11.06"(1)

11"(1)

 
Color(s)

White/Blue(2)

Yellow/Black(2)

Clear(2)

White(1)

 
Depth

1.63"(1)

2.5"(1)

 
Quantity

50 per box(22)

1 each(17)

30 per box(5)

24 per carton(5)

12 per carton(4)

10 per box(4)

12 per box(4)

250 per box(3)

30 per bag(2)

20 per box(2)

25 per box(2)

125 per box(2)

720 per carton(2)

5,000 per case(2)

32 Tablets per box(2)

1,000 per case(1)

1000 per carton(1)

6 per carton(1)

36 per carton(1)

30 per Box(1)

80 per box(1)

20 Tablets(1)

64 per bottle(1)

12 packs per carton(1)

20 lozenges per pack(1)

2160 per carton(1)

20 per pack(1)

5000 per carton(1)

24 per box(1)

15 per box(1)

19 per pack(1)

96 per box(1)

Bag of 21 drops(1)

 
Manufacturer Part Number

BXMD30(1)

BXPB-25(1)

BXDXSV25(1)

BXBG50(1)

BXAS50(1)

BXZA-80(1)

00361(1)

01436(1)

01426EA(1)

01426(1)

00361EA(1)

BXAL50(1)

019901(1)

R10049(1)

R10034(1)

97477(1)

97217(1)

R10309(1)

R10405(1)

016902(1)

015489(1)

48152(1)

44910(1)

01436EA(1)

01440(1)

73016(1)

73016CT(1)

71016CT(1)

71016(1)

05640(1)

74016(1)

74016CT(1)

TP10DGM(1)

RW16(1)

R3(1)

450(1)

02328CT(1)

02314(1)

01452(1)

01443BX(1)

01443(1)

01440BX(1)

01452BX(1)

01479(1)

00815(1)

03977BX(1)

03977(1)

01479PK(1)

97197(1)

97187(1)

90031(1)

90032(1)

90016(1)

90015(1)

90014(1)

90087(1)

90089(1)

90306(1)

90109(1)

90092(1)

90091(1)

98853PK(1)

97971(1)

18631(1)

18591CT(1)

18591(1)

10030CT(1)

30004(1)

30004CT(1)

97970(1)

30112(1)

30017(1)

30006(1)

90316(1)

90780(1)

58030(1)

53026(1)

51060(1)

51030(1)

70171(1)

71613(1)

97117(1)

97047(1)

7776(1)

71992(1)

3003(1)

FAE7014(1)

P101M(1)

28694(1)

27499(1)

90794(1)

00117DA(1)

40800(1)

FAE7004(1)

90751(1)

90110(1)

54034(1)

10030(1)

 
Country of Origin

US(79)

MX(7)

GB(6)

CH(3)

CN(2)

DE(1)

 
Width

15.25"(2)

 
Material(s)

Paper(3)

Plastic(2)

 
For Use With

First Aid Stations/Kits;Individual Use(16)

Lil' Drugstore Medicine Dispensers LIL71613 or LIL71615/First Aid Stations/Kits; Individual Use(9)

First Aid Stations/Kits; Individual Use(7)

Individual Use(6)

All SmartCompliance Kits(2)

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

Personal Use(2)

L16R(1)

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

Lil Drugstore Medicine Dispensers(1)

SmartCompliance Cabinets(1)

 
Capacity (Volume)

10 oz(1)

16 oz(1)

3 oz(1)

3.5 oz(1)

1 oz(1)

 
Mounting

No(12)

Wall(2)

 
Theme

GRADUATED(1)

Barium(1)

 
Description

2/Pack(20)

LiquiCaps, 24 per Box(4)

Liquid, 12 oz.(4)

1/Pack(4)

10 per roll, 12 rolls per box(3)

16/Box, Honey Lemon Flavor(2)

20/Pack, Berry Flavor(2)

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

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

16/Box, Cherry Flavor(2)

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

Chewable Tablets, 30 per Box(2)

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

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

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

DayQuil Severe Cold and Flu 2 Tablet Pouch(1)

Ricola Natural Herb Cough Drops(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Ricola Cherry Honey Drops(1)

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

Tylenol Extra Strength Caplets, 2/Pack(1)

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

Zantac150 1 tablet Pouch(1)

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

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

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

Six per pack, 12 packs per box(1)

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

Aleve 1 Tablet Pouch(1)

Airborne Chewable Tablets Berry(1)

10 Very Berry Effervescent Tablets(1)

Airborne Chewable Tablets Citrus(1)

Immune Support Powder(1)

Individually Wrapped(1)

10 Pink Grapefruit Effervescent Tablets(1)

10 Lemon-Lime Effervescent Tablets(1)

2,160 Effervescent Tablets Orange Flavor(1)

64 Citrus Chewable Tablets(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

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

Plastic Grid Station for Medications(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)

30 Effervescent Tablets Zesty Orange Flavor(1)

PhysiciansCare Antacid(1)

PhysiciansCare Aspirin(1)

Cherry(1)

Honey-Lemon(1)

96 Capsules(1)

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

Alka-Seltzer Single Dose Pouches(1)

 
Cup Type

Hot/Cold(3)

Medical(2)

 
Contains

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

Benzocaine; Menthol(4)

50 pouches of 2 tablets(4)

Guaifenesin(3)

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

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)

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

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

20 Tablets(2)

30 pouches of 2 tablets(2)

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

Benzocaine; Dextromethorphan(2)

Ibuprofen(2)

Bismuth Subsalicylate 262 mg(2)

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

Vitamin A; Vitamin C; Vitamin E; Magnesium; Zinc;Selenium Manganese(2)

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

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

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

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

Two Tablets(1)

12 Rolls of 6 count Rolaids Ultra Strength Antacid Softchew Strawberry(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)

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, Glavor, Glycerin, Propylene Glycol, Purified Water, Saccharin Sodium, Sodium Benzoate, Sodium Chloride, Sodium Citrate, Sorbitol, Sucralose, Xanthan Gum(1)

Guaifenesin; Dextromethorphan HBr(1)

Ranitidine(1)

Bismuth Subsalicylate(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

N/A(1)

20 pouches of 1 tablet(1)

Calcium Carbonate(1)

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

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

Diphenhydramine(1)

Phenylephrine HCl(1)

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(1)

Dried Yeast Fermentate; Magnesium; Manganese; Potassium; Selenium; Sodium; Vitamin A; Vitamin C; Vitamin E; Zinc(1)

Aspirin(1)

Acetaminophen(1)

Dimenhydrinate(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

Aspirin, Ibuprofen, Extra Strength Non Aspirin Pain Reliever, Antacid(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)

19 Drops(1)

250 Tablets; Calcium Carbonate 420 mg(1)

1 Plastic Grid Station(1)

BC30(1)

250 Tablets(1)

250 Tablets; Aspirin 325 mg(1)

20 packs of two LiquiCaps(1)

 
 
 

© 2019-2020 Office Solutions & Innovations, Inc., All Rights Reserved