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

Airborne(10)

Vicks(9)

Lil' Drugstore(5)

Cepacol(5)

Dart(5)

Mucinex(4)

Advil(4)

Rolaids(4)

First Aid Only(3)

Ricola(3)

Pepto-Bismol(3)

HALLS(2)

Tylenol(2)

DayQuil(2)

Alka-Seltzer(2)

Aleve(2)

Midol(2)

Motrin IB(1)

Bayer(1)

Zantac(1)

Digestive Advantage(1)

 
Height

11.06"(1)

 
Color(s)

Clear(2)

White/Blue(2)

Yellow/Black(1)

White(1)

 
Depth

1.63"(1)

 
Quantity

1 each(1)

 
Manufacturer Part Number

10030(1)

019901(1)

00361(1)

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

97477(1)

00361EA(1)

01426EA(1)

97197(1)

05640(1)

RW16(1)

R3(1)

450(1)

74016CT(1)

74016(1)

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

97217(1)

97187(1)

10030CT(1)

90015(1)

90109(1)

90092(1)

90091(1)

90089(1)

90087(1)

90032(1)

90031(1)

90016(1)

90014(1)

90316(1)

97971(1)

97970(1)

30112(1)

30017(1)

30006(1)

30004CT(1)

30004(1)

18631(1)

90306(1)

90780(1)

97117(1)

FAE7014(1)

97047(1)

7776(1)

71992(1)

70171(1)

58030(1)

51060(1)

51030(1)

3003(1)

FAE7004(1)

90794(1)

90751(1)

90110(1)

54034(1)

40800(1)

00117DA(1)

P101M(1)

28694(1)

27499(1)

TP10DGM(1)

 
Country of Origin

US(69)

MX(7)

GB(5)

CH(3)

CN(2)

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)

First Aid Stations/Kits; Individual Use(3)

Personal Use(2)

Standalone First Aid or as a Refill for a Kit(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)

L16R(1)

 
Capacity (Volume)

1 oz(1)

3.5 oz(1)

3 oz(1)

16 oz(1)

10 oz(1)

 
Mounting

No(12)

Wall(2)

 
Theme

Barium(1)

GRADUATED(1)

 
Description

2/Pack(20)

1/Pack(4)

LiquiCaps, 24 per Box(4)

Liquid, 12 oz.(3)

10 per roll, 12 rolls per box(3)

Chewable Tablets, 30/Box(2)

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

Cepacol Sore Throat and Cough Lozenges, Mixed Berry, 16 Lozenges(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)

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

Advil Ibuprofen 2 Tablet Pouch(1)

Six per pack, 12 packs per box(1)

16/Box, Honey Lemon Flavor(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)

Ricola Cherry Honey Drops(1)

30 Effervescent Tablets Zesty Orange Flavor(1)

Alka-Seltzer Single Dose Pouches(1)

50 doses each Aspirin, Ibuprofen, X-Strength Non Aspirin and Antacid(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)

Plastic Grid Station for Medications(1)

2,160 Effervescent Tablets Orange Flavor(1)

Cherry(1)

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

 
Cup Type

Hot/Cold(3)

Medical(2)

 
Contains

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

50 pouches of 2 tablets(4)

Benzocaine; Menthol(3)

Guaifenesin(3)

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

Acetaminophen; Caffeine; Pyrilamine Maleate(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)

20 Tablets(2)

30 pouches of 2 tablets(2)

Benzocaine; Dextromethorphan(2)

Ibuprofen(2)

Calcium Carbonate(1)

Two Tablets(1)

N/A(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

Bismuth Subsalicylate(1)

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

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

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(1)

Dimenhydrinate(1)

Acetaminophen(1)

Guaifenesin; Dextromethorphan HBr(1)

Aspirin(1)

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

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

1 Plastic Grid Station(1)

19 Drops(1)

BC30(1)

250 Tablets(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

Diphenhydramine(1)

30 pouches of 1 tablet(1)

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

15 Pouches of Single Dose Alka-Seltzer(1)

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

24 sticks of 10 drops(1)

Bag of 21 drops(1)

20 packs of two LiquiCaps(1)

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

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

 
 
 

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