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 ('30100')) 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 '%Batteries' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Batteries' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Batteries' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Batteries"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Batteries"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Batteries"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Batteries"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Batteries' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Batteries',`category_4` ='Batteries') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Batteries,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Batteries', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Batteries

Refine Search

  GO
 
Brand

Energizer(56)

Duracell(24)

Rayovac(17)

Eveready(3)

Brother(1)

 
Warranty

Manufacturer's limited lifetime warranty.(6)

 
Special Features

Reclosable Pack(6)

Value Pack-Stock up and save!(6)

Specialty Battery(1)

 
For Use With

Everyday Electronic Devices(14)

Professional and Industrial Electronic Devices(5)

All High-Drain Devices(5)

Watches; Specialty Electronics(5)

Any device that uses AAA batteries(2)

Any device that uses AA batteries(2)

Watches; Electronics(2)

Digital Cameras(1)

Calculators; Home Medical Devices(1)

Lanterns and Flashlights(1)

Everyday Electronic Devices; Clocks; Remote Control Cars; Smoke Detectors; Toys(1)

Calculators;Watches(1)

Low-drain Devices; Any Electronic Device that Uses Batteries(1)

Low-Drain Devices(1)

Home Medical Devices(1)

Any device that uses D batteries(1)

Any device that uses C batteries(1)

Digital Cameras; Hands Free Equipment(1)

QL810W, QL820NWB(1)

 
Manufacturer Part Number

PABU001(1)

EN22(1)

L91SBP12(1)

L91BP2(1)

L91(1)

L522BP(1)

EPX76BPZ(1)

EN95(1)

EN93(1)

EN92(1)

EN91(1)

ELCRV3BP2(1)

L91SBP8(1)

EL2CR5BP(1)

EL223APBP(1)

EL1CR2BP(1)

EL123APBP(1)

EL123APB2(1)

ECR2450BP(1)

ECR2430BP(1)

ECR2032BP(1)

ECR2025BP(1)

E96BP-2(1)

L91SBP4(1)

L92SBP12(1)

E95BP-4(1)

8158TFUSK(1)

ALC12PPJ(1)

ALAAA24PPJ(1)

ALAA48PPJ(1)

ALAA24PPJ(1)

AL9V12PPJ(1)

A16044TK(1)

A16042K(1)

8248TFUSK(1)

82416LTFUSK(1)

82412K(1)

81524LTK(1)

L92SBP4(1)

81516LTFUSK(1)

8148LTFUSK(1)

8138LTFUSK(1)

8134TK(1)

NH50BP-2(1)

NH35BP-2(1)

NH22NBP(1)

NH15BP-4(1)

NH12BP-4(1)

L92SBP8(1)

E95FP-8(1)

E95BP-2(1)

AACTBULK36(1)

MN2400B4Z(1)

PC1500BKD(1)

PC1400(1)

PC1300(1)

MX2500B2PK(1)

MN9100B2PK(1)

MN908(1)

MN24RT12Z(1)

MN24P36(1)

MN2400B8ZCT(1)

MN2400B16Z(1)

PC2400BKD(1)

MN21B4PK(1)

MN16RT4Z(1)

MN15RT12Z(1)

MN1500B4Z(1)

MN1500B2Z(1)

MN1500B16Z(1)

MN14RT8Z(1)

MN13RT8Z(1)

DL2032B2PK(1)

DL123ABPK(1)

PC1604BKD(1)

2016BP2(1)

E93FP-8(1)

E91BP-4(1)

E93BP-2(1)

E92MP8(1)

E92LP16(1)

E92BP-4(1)

E92BP24(1)

E92BP12(1)

E91SBP36H(1)

E91MP8(1)

E91LP16(1)

E91BW12EM(1)

E91BP24(1)

2025BP2(1)

E91BP2(1)

E90BP-2(1)

A95-8(1)

A93-8(1)

A522-4(1)

522BP-2(1)

377BPZ2(1)

357BPZ3(1)

2032BP4(1)

2032BP2(1)

ALD12PPJ(1)

 
Country of Origin

US(57)

CN(15)

SG(10)

MY(7)

ID(7)

JP(5)

 
Material(s)

Alkaline Manganese Dioxide(49)

Alkaline(17)

Silver-Oxide Zinc(12)

Lithium Manganese Dioxide(10)

Lithium/Iron Disulfide(7)

Nickel-Metal Hydride(5)

Aluminum; Aluminum Laminated Plastic; Carbon; Copper; Iron; Lithium Transition Metal Oxidate; Organic Electrolyte(1)

 
Quantity

1 each(1)

12 per pack(1)

 
OEM/Compatible

OEM(7)

 
Replacement For

1215; E91; NH15(1)

 
Voltage

1.5 V(68)

3 V(14)

9 V(10)

1.2 V(4)

6 V(3)

14.4 V(1)

12 V(1)

 
Battery Size

AA(25)

AAA(20)

D(11)

9V(10)

C(9)

2032(4)

123(3)

AAAA(2)

N(2)

2025(2)

2450(1)

CRV3(1)

2CR5(1)

223(1)

CR2(1)

14.4 V(1)

2430(1)

377(1)

357(1)

2016(1)

908(1)

21/23(1)

EPX76(1)

 
Battery Type

Alkaline(66)

Lithium(11)

Specialty(10)

Lithium Coin(8)

Rechargeable(5)

Lithium-Ion(1)

 
Battery Capacity

1700 mAh(3)

3500 mAh(2)

1200 mAh(2)

2500 mAh(2)

1750 mAh(1)

280 mAh(1)

700 mAh(1)

2300 mAh(1)

175 mAh(1)

 
 
 

© 2020-2021 Midtown Office Supplies, All Rights Reserved