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','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(15)

Vicks(9)

Airborne(8)

Dart(5)

Lil' Drugstore(5)

Mucinex(4)

Rolaids(4)

Advil(4)

Cepacol(4)

First Aid Only(3)

Ricola(3)

Pepto-Bismol(3)

Aleve(2)

Alka-Seltzer(2)

Midol(2)

DayQuil(2)

Tylenol(2)

HALLS(2)

Motrin IB(1)

Bayer(1)

Digestive Advantage(1)

 
Height

11.06"(1)

 
Color(s)

Clear(2)

White/Blue(2)

Yellow/Black(1)

White(1)

 
Depth

1.63"(1)

 
Manufacturer Part Number

10030(1)

019901(1)

00361(1)

BXPB-25(1)

BXMD30(1)

BXDXSV25(1)

BXBG50(1)

BXAS50(1)

BXAL50(1)

016902(1)

01426(1)

015489(1)

48152(1)

44910(1)

R10405(1)

R10309(1)

R10049(1)

R10034(1)

00361EA(1)

01426EA(1)

97217(1)

05640(1)

RW16(1)

R3(1)

450(1)

74016CT(1)

74016(1)

71016CT(1)

71016(1)

02328CT(1)

01436(1)

02314(1)

00815(1)

03977BX(1)

03977(1)

01443BX(1)

01443(1)

01440BX(1)

01440(1)

97477(1)

97197(1)

10030CT(1)

90031(1)

90306(1)

90109(1)

90092(1)

90091(1)

90089(1)

90087(1)

90032(1)

90016(1)

90780(1)

90015(1)

90014(1)

97971(1)

97970(1)

30112(1)

30006(1)

30004CT(1)

30004(1)

90316(1)

27499(1)

97187(1)

51030(1)

97117(1)

97047(1)

7776(1)

71992(1)

70171(1)

58030(1)

51060(1)

3003(1)

28694(1)

FAE7014(1)

FAE7004(1)

90751(1)

90110(1)

54034(1)

40800(1)

00117DA(1)

P101M(1)

TP10DGM(1)

 
Country of Origin

US(67)

MX(6)

GB(4)

CH(3)

CN(1)

DE(1)

 
Width

15.25"(1)

 
Material(s)

Paper(3)

Plastic(2)

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

Personal Use(2)

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

First Aid Stations/Kits; Individual Use(2)

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)

L16R(1)

 
Capacity (Volume)

1 oz(1)

3.5 oz(1)

3 oz(1)

16 oz(1)

10 oz(1)

 
Mounting

No(12)

Wall(1)

 
Theme

Barium(1)

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

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

Chewable Tablets, 30/Box(2)

16/Box, Cherry Flavor(2)

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

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

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

Ricola Cherry Honey Drops(1)

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

Six per pack, 12 packs per box(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)

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

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

DayQuil Severe Cold and Flu 2 Tablet Pouch(1)

Ricola Natural Herb Cough Drops(1)

30 Effervescent Tablets Zesty Orange Flavor(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Cherry(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

10 Lemon-Lime 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)

Honey-Lemon(1)

2,160 Effervescent Tablets Orange Flavor(1)

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

 
Cup Type

Hot/Cold(3)

Medical(2)

 
Contains

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

50 pouches of 2 tablets(4)

Guaifenesin(3)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

Benzocaine; Menthol(2)

Bismuth Subsalicylate 262 mg(2)

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

Acetaminophen 325 mg, Dextromethorphan HBr 15 mg, Doxylamine succinate 6.25 mg(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)

Camphor (synthetic) 4.8%, Eucalyptus oil 1.2%, Menthol 2.6%(2)

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

20 Tablets(2)

30 pouches of 2 tablets(2)

Benzocaine; Dextromethorphan(2)

Ibuprofen(2)

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

Aspirin(1)

Guaifenesin; Dextromethorphan HBr(1)

Acetaminophen(1)

Dimenhydrinate(1)

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(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)

Phenylephrine HCl(1)

Calcium Carbonate(1)

Bismuth Subsalicylate(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

N/A(1)

Two Tablets(1)

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

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

BC30(1)

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

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

20 packs of two LiquiCaps(1)

Bag of 21 drops(1)

24 sticks of 10 drops(1)

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

15 Pouches of Single Dose Alka-Seltzer(1)

30 pouches of 1 tablet(1)

19 Drops(1)

Diphenhydramine(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets(1)

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

 
 
 

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