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_27` 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®(12)

Vicks®(11)

Cepacol®(6)

Dart®(6)

Digestive Advantage®(6)

Mucinex®(6)

MegaRed®(6)

Lil' Drugstore®(5)

Move Free®(5)

Schiff®(5)

Advil®(4)

Rolaids®(4)

Ricola®(3)

Pepto-Bismol™(3)

First Aid Only™(3)

Alka-Seltzer®(2)

Tylenol®(2)

Aleve®(2)

Midol®(2)

HALLS(2)

DayQuil®(2)

Motrin® IB(1)

Bayer®(1)

 
Height

11.06"(1)

 
Color(s)

White(2)

Clear(2)

White/Blue(2)

Yellow/Black(1)

 
Depth

1.63"(1)

 
Quantity

1 each(1)

 
Manufacturer Part Number

10030(1)

016902(1)

01426EA(1)

01426(1)

00361EA(1)

00361(1)

BXPB-25(1)

BXMD30(1)

BXDXSV25(1)

BXBG50(1)

BXAS50(1)

BXAL50(1)

019901(1)

015489(1)

01440(1)

97009EA(1)

97008(1)

97007CT(1)

97007(1)

11841(1)

99549EA(1)

98094EA(1)

98093EA(1)

97413EA(1)

95330EA(1)

95186EA(1)

48152(1)

01436(1)

01440BX(1)

R10405(1)

73016(1)

97005EA(1)

11342(1)

11256(1)

11019(1)

TP10DGM(1)

RW16(1)

R3(1)

450(1)

74016CT(1)

74016(1)

73016CT(1)

71016CT(1)

01443(1)

71016(1)

05640(1)

02328CT(1)

02328(1)

02314(1)

01665(1)

00815(1)

03977BX(1)

03977(1)

01479(1)

01452(1)

01443BX(1)

44910(1)

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

16J16GRAD(1)

90015(1)

90014(1)

97971(1)

97970(1)

90369EA(1)

30112(1)

30017(1)

30006(1)

30004CT(1)

30004(1)

18631(1)

18630(1)

28694(1)

P101M(1)

R10049(1)

51060(1)

R10034(1)

97477(1)

97217(1)

97197(1)

97187(1)

97117(1)

97047(1)

7776(1)

71992(1)

70171(1)

58030(1)

51030(1)

00101DA(1)

3003(1)

FAE7014(1)

FAE7004(1)

90751(1)

90110(1)

54034(1)

40800(1)

96949EA(1)

18167(1)

00166EA(1)

00117DA(1)

00116(1)

97006EA(1)

 
Country of Origin

US(97)

MX(6)

GB(6)

CH(3)

CN(2)

DE(1)

 
Width

15.25"(1)

 
Material(s)

Paper(3)

Plastic(2)

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

16JL, 16SL, 16UL, 16FTL, 16FTLS, 16EL, 16ELBLK, 16RCL, 16RCLBLK, 16LCD, 16LCDH, 16LCDHX(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)

N/A(1)

 
Capacity (Volume)

16.000 oz(1)

1 oz(1)

3.5 oz(1)

3 oz(1)

16 oz(1)

10 oz(1)

 
Mounting

No(12)

Wall(2)

N/A(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)

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

16/Box, Cherry Flavor(2)

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

80 Tablets(2)

30 Effervescent Tablets Zesty Orange Flavor(1)

60 Krill Oil Softgels, 1,000 mg(1)

Omega-3 Softgel, 500mg(1)

Krill Oil Softgel 350 mg(1)

Krill Oil, 500 mg(1)

Omega-3 Softgel, 800mg(1)

40 Krill Oil Softgels, 750 mg(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)

30 Coated Tablets(1)

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

120 Coated Tablets(1)

Joint Health Supplement(1)

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

Combo Pack - DayQuil Liquid, 12 oz. + NyQuil Liquid, 12 oz.(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)

150 Coated Glucosamine Plus Vitamin D3 Tablets(1)

Lil' Drugstore® Ibuprofen 2 Tablet Pouch(1)

DayQuil® Severe Cold and Flu 2 Tablet Pouch(1)

Lil' Drugstore® Allergy Medicine 2 tablet pouch(1)

Immune Support Gummies, Elderberry, 60/Bottle(1)

Cherry(1)

Plastic Grid Station for Medications(1)

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

Individually Wrapped(1)

Airborne Chewable Tablets Citrus(1)

Airborne Chewable Tablets Berry(1)

10 Very Berry Effervescent Tablets(1)

Probiotic Lactose Defense Capsule, 32 Capsules(1)

10 Pink Grapefruit Effervescent Tablets(1)

10 Lemon-Lime Effervescent Tablets(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

64 Citrus Chewable Tablets(1)

64 Berry Chewable Tablets(1)

Honey-Lemon(1)

Probiotic Intensive Bowel Support Capsule, 32 Capsules(1)

2,160 Effervescent Tablets Orange Flavor(1)

(10) 2 per packet Ibuprofen Tablets(1)

Ricola® Natural Herb Cough Drops(1)

Ricola® Cherry Honey Drops(1)

Advil® Ibuprofen 2 Tablet Pouch(1)

Alka-Seltzer® Single Dose Pouches(1)

Aleve® 1 Tablet Pouch(1)

Ricola Honey Lemon Cough Drops(1)

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

96 Capsules(1)

PhysiciansCare Antacid(1)

PhysiciansCare Aspirin(1)

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

Enzymes + Probiotic(1)

Daily Probiotic Capsules, 50 Capsules(1)

Daily Probiotic Capsules, 30 Capsules(1)

Joint Support Tablet(1)

 
Cup Type

Hot/Cold(3)

Medical(2)

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

Acetaminophen 325 mg, Dextromethorphan HBr 10 mg, Phenylephrine HCI 5 mg(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)

30 pouches of 2 tablets(2)

20 Tablets(2)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

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

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

Bismuth Subsalicylate 262 mg(2)

Ibuprofen(2)

Benzocaine; Dextromethorphan(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(1)

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

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

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

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

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

Krill Oil 1000 mg; Omega-3 Fatty Acids 230 mg; EPA 128 mg; DHA 60 mg; Phospholipids 334 mg; Astanxanthin (from Krill Oil) 50 mcg(1)

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

Vitamin D 800 IU; Calcium 1200 mg(1)

Two Tablets(1)

Chondroitin; Glucosamine(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)

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

N/A(1)

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

Bismuth Subsalicylate(1)

Guaifenesin; Dextromethorphan HBr(1)

Astaxanthin (From Krill Oil); DHA; EPA; Krill Oil 350 mg; Phospholipids(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; Guaifenesin; Phenylephrine HCI(1)

Fish Oil Blend; EPA; DHA(1)

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

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)

BC30; Lactase Enzymes; Soy(1)

Antioxidants; Black Elder; Vitamin C; Vitamin D; Vitamin E; Zinc(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)

1 Plastic Grid Station(1)

BC30, Calcium(1)

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

BC30; Calcium (as Calcium Carbonate)(1)

BC30; Enzymes(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 Mint Tablets(1)

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

Glucosamine 2000mg; Hyaluronic Acid 3.3mg(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved