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

Lil' Drugstore(7)

Dart(6)

Cepacol(6)

Mucinex(6)

Digestive Advantage(5)

Move Free(5)

Rolaids(4)

Advil(4)

Schiff(4)

MegaRed(3)

Pepto-Bismol(3)

First Aid Only(3)

Ricola(3)

HALLS(2)

Tylenol(2)

Aleve(2)

Midol(2)

Alka-Seltzer(2)

Zantac(2)

DayQuil(2)

Bayer(1)

Motrin IB(1)

 
Height

11.06"(1)

11"(1)

 
Color(s)

White/Blue(2)

Yellow/Black(2)

Clear(2)

White(2)

 
Depth

1.63"(1)

2.5"(1)

 
Quantity

1 each(25)

50 per box(23)

30 per box(5)

12 per carton(5)

24 per carton(5)

10 per box(4)

12 per box(4)

250 per box(3)

20 per box(2)

25 per box(2)

80 per box(2)

30 per bag(2)

720 per carton(2)

64 per bottle(2)

5,000 per case(2)

32 Tablets per box(2)

125 per box(2)

1000 per carton(1)

40 tablets each(1)

1,000 per case(1)

120 per bottle(1)

30 Tablets(1)

36 per carton(1)

6 per carton(1)

80 Tablets(1)

30 per Box(1)

20 Tablets(1)

5000 per carton(1)

32 capsules(1)

20 per pack(1)

12 packs per carton(1)

2160 per carton(1)

20 lozenges per pack(1)

32 per box(1)

96 per box(1)

15 per box(1)

24 per box(1)

19 per pack(1)

40 capsules(1)

50/Box(1)

Bag of 21 drops(1)

 
Manufacturer Part Number

BXMD30(1)

BXPB-25(1)

BXDXSV25(1)

BXBG50(1)

BXAL50(1)

BXAS50(1)

BXZA-80(1)

00361(1)

01436(1)

01436EA(1)

01426EA(1)

01426(1)

00361EA(1)

019901(1)

016902(1)

95330EA(1)

98092EA(1)

48152(1)

44910(1)

R10309(1)

R10405(1)

98093EA(1)

11841(1)

97009EA(1)

015489(1)

97008(1)

97007CT(1)

97007(1)

01440(1)

01440BX(1)

74016CT(1)

450(1)

74016(1)

73016CT(1)

71016CT(1)

73016(1)

R3(1)

RW16(1)

11342(1)

97005EA(1)

11256(1)

11019(1)

TP10DGM(1)

71016(1)

05640(1)

01479(1)

01479PK(1)

01452BX(1)

01452(1)

01443(1)

01443BX(1)

03977(1)

03977BX(1)

02328(1)

02328CT(1)

02314(1)

01665(1)

00815(1)

R10049(1)

R10034(1)

90089(1)

90091(1)

90087(1)

90032(1)

90016(1)

90031(1)

90092(1)

90109(1)

90794(1)

27499(1)

90780(1)

90316(1)

90306(1)

90015(1)

90014(1)

18631(1)

30004(1)

18630(1)

18591CT(1)

10030CT(1)

18591(1)

30004CT(1)

30006(1)

97971(1)

98853PK(1)

97970(1)

30112(1)

30017(1)

28694(1)

16J16GRAD(1)

71992(1)

7776(1)

71613(1)

70171(1)

53026(1)

58030(1)

97047(1)

97117(1)

97257(1)

97477(1)

97217(1)

97197(1)

97187(1)

51060(1)

51030(1)

18167(1)

96949EA(1)

00117DA(1)

00116(1)

P101M(1)

00101DA(1)

40800(1)

54034(1)

FAE7014(1)

3003(1)

FAE7004(1)

90751(1)

90110(1)

10030(1)

 
Country of Origin

US(100)

MX(7)

GB(6)

CH(3)

CN(2)

DE(1)

 
Width

15.25"(2)

 
Material(s)

Paper(3)

Plastic(2)

Foam(1)

 
For Use With

First Aid Stations/Kits;Individual Use(16)

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

Individual Use(8)

First Aid Stations/Kits; Individual Use(7)

All SmartCompliance Kits(2)

Personal Use(2)

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

L16R(1)

N/A(1)

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

Lil Drugstore Medicine Dispensers(1)

16JL, 16SL, 16UL, 16FTL, 16FTLS, 16EL, 16ELBLK, 16RCL, 16RCLBLK, 16LCD, 16LCDH, 16LCDHX(1)

SmartCompliance Cabinets(1)

 
Capacity (Volume)

16 oz(1)

10 oz(1)

3 oz(1)

3.5 oz(1)

1 oz(1)

16.000 oz(1)

 
Mounting

No(12)

Wall(2)

N/A(1)

 
Theme

GRADUATED(1)

Barium(1)

 
Description

2/Pack(20)

LiquiCaps, 24 per Box(4)

1/Pack(4)

Liquid, 12 oz.(4)

10 per roll, 12 rolls per box(3)

Chewable Tablets, 30 per Box(2)

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

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

Krill Oil, 500 mg(2)

80 Tablets(2)

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

20/Pack, Berry Flavor(2)

16/Box, Honey Lemon Flavor(2)

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

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

16/Box, Cherry Flavor(2)

150 Coated Glucosamine Plus Vitamin D3 Tablets(1)

Krill Oil Softgel 350 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)

Lil' Drugstore Allergy Medicine 2 tablet pouch(1)

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

Lil' Drugstore Ibuprofen 2 Tablet Pouch(1)

Lil' Drugstore Pain Reliever Acetaminophen 2 Tablet Pouch(1)

120 Coated Tablets(1)

DayQuil Severe Cold and Flu 2 Tablet Pouch(1)

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

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

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

150 Coated Glucosamine Plus MSM Tablets(1)

120 Super Calcium Softgels(1)

90 Super Calcium Plus Softgels(1)

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

Joint Health Supplement(1)

30 Coated Tablets(1)

Advil Ibuprofen 2 Tablet Pouch(1)

Immune Support Powder(1)

Airborne Chewable Tablets Citrus(1)

Airborne Chewable Tablets Berry(1)

Individually Wrapped(1)

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

Cherry(1)

Plastic Grid Station for Medications(1)

10 Very Berry Effervescent Tablets(1)

10 Pink Grapefruit Effervescent Tablets(1)

64 Berry Chewable Tablets(1)

2,160 Effervescent Tablets Orange Flavor(1)

64 Citrus Chewable Tablets(1)

10 Effervescent Tablets Zesty Orange Flavor(1)

10 Lemon-Lime Effervescent Tablets(1)

720 Effervescent Tablets Zesty Orange Flavor(1)

Honey-Lemon(1)

Probiotic Lactose Defense Capsule, 32 Capsules(1)

Aleve 1 Tablet Pouch(1)

Ricola Honey Lemon Cough Drops(1)

(10) 2 per packet Ibuprofen Tablets(1)

Alka-Seltzer Single Dose Pouches(1)

Zantac150 1 tablet Pouch(1)

Ricola Cherry Honey Drops(1)

30 Effervescent Tablets Zesty Orange Flavor(1)

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

PhysiciansCare Antacid(1)

96 Capsules(1)

Probiotic Intensive Bowel Support Capsule, 32 Capsules(1)

Daily Probiotic Capsules, 50 Capsules(1)

Enzymes + Probiotic(1)

PhysiciansCare Aspirin(1)

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

Ricola Natural Herb Cough Drops(1)

 
Cup Type

Hot/Cold(3)

Medical(2)

Measuring(1)

 
Contains

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

50 pouches of 2 tablets(5)

Guaifenesin(4)

Benzocaine; Menthol(4)

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

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

20 Tablets(2)

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

BC30(2)

Acetaminophen; Caffeine; Pyrilamine Maleate(2)

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

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)

30 pouches of 2 tablets(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)

Benzocaine; Dextromethorphan(2)

Ibuprofen(2)

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

Bismuth Subsalicylate 262 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)

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

Astanxanthin (From Krill Oil) 25 mcg; DHA 30 mg; EPA 64 mg; Krill Oil 500 mg; Omega-3 Fatty Acids 115 mg; Phospholipids 167 mg(1)

Two Tablets(1)

Chondroitin; Glucosamine(1)

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

N/A(1)

Cartilage 40 mg; Hyaluronic Acid 3.3 mg, Boron (as boron glycinate) 5 mg(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)

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)

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

Guaifenesin; Dextromethorphan HBr(1)

Acetaminophen; Guaifenesin; Phenylephrine HCI(1)

Bismuth Subsalicylate(1)

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

Acetaminophen; phenylephrineHCL; Dextromethophan HBr; Guaifenesir(1)

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

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

Acetaminophen, Chlorpheniramine Maleate, Phenylephrine Hydrochloride(1)

Diphenhydramine(1)

Acetaminophen, Aspirin, Caffeine 65 mg(1)

1 Plastic Grid Station(1)

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

Calcium Carbonate(1)

Phenylephrine HCl(1)

Aspirin(1)

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

Acetaminophen(1)

Dimenhydrinate(1)

Potassium Chloride, Calcium Phosphate, Magnesium Carbonate(1)

BC30; Lactase Enzymes; Soy(1)

BC30; Calcium (as Calcium Carbonate)(1)

24 sticks of 10 drops(1)

20 pouches of 1 tablet(1)

Bag of 21 drops(1)

20 packs of two LiquiCaps(1)

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

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

15 Pouches of Single Dose Alka-Seltzer(1)

30 pouches of 1 tablet(1)

250 Tablets(1)

BC30; Enzymes(1)

250 Tablets; Aspirin 325 mg(1)

250 Tablets; Calcium Carbonate 420 mg(1)

19 Drops(1)

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

 
 
 

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