Banner1 Banner1
 
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') 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

Duracell(86)

Energizer(65)

Rayovac(50)

Eveready(4)

Canon(1)

ZOLL(1)

Philips(1)

HP(1)

Acroprint(1)

Brother(1)

AmpliVox(1)

 
Quantity

1 each(29)

2 per pack(22)

8/Pack(16)

4 per pack(16)

8 per pack(13)

4/Pack(11)

12/Pack(9)

2/Pack(8)

12 per box(7)

12/Box(6)

36/Pack(5)

72/Carton(5)

24 per box(5)

16 per pack(5)

12 per pack(5)

6/Pack(4)

24/Box(4)

16/Pack(4)

24/Pack(3)

24 per pack(3)

30/Pack(2)

144/Carton(2)

48/Pack(2)

144 per carton(2)

60/Pack(2)

20/Pack(2)

36 per pack(1)

49/Pack(1)

18/Pack(1)

1 per pack(1)

320/Carton(1)

6 per box(1)

36/Carton(1)

6/Box(1)

10/Pack(1)

36 per carton(1)

36 packs per carton(1)

72 per carton(1)

144.Carton(1)

3 per pack(1)

 
Manufacturer Part Number

EN93(1)

EN92(1)

EN95(1)

EPX76BPZ(1)

L91(1)

EN91(1)

EN22(1)

EL1CR2BP(1)

EL123APBP(1)

EL223APBP(1)

EL2CR5BP(1)

ELCRV3BP2(1)

L91BP2(1)

L91SBP12(1)

NH15BP8(1)

NH15BP-4(1)

NH22NBP(1)

NH35BP-2(1)

NH50BP-2(1)

NH12BP-4(1)

L92SBP8(1)

L91SBP4(1)

L91SBP8(1)

L92SBP12(1)

L92SBP4(1)

EL123APB2(1)

ECR2450BP(1)

E92BP24(1)

E92BP12(1)

E92BP-4(1)

E92LP16(1)

E92MP8(1)

E91SBP36H(1)

E91MP8(1)

E91BP24(1)

E91BP2(1)

E91BP-4(1)

E91BW12EM(1)

E91LP16(1)

E93BP-2(1)

E93BP-4(1)

ECR2016BP(1)

ECR1632BP(1)

ECR2025BP(1)

ECR2032BP(1)

ECR2430BP(1)

ECR1616BP(1)

E96BP-2(1)

E93FP-8(1)

E95BP-2(1)

E95BP-4(1)

E95FP-8(1)

M9L89A(1)

LFH9154/00(1)

ALAA24PPJ(1)

AL9V6J(1)

ALAA48PPJ(1)

ALAA8J(1)

ALAAA18PPJ(1)

AL9V12PPJ(1)

A16048PPK(1)

918(1)

8248TFUSK(1)

A160412PPK(1)

A16042K(1)

A16044TK(1)

ALAAA24PPJ(1)

ALAAA8J(1)

PL7154GEND(1)

PL7142GEND(1)

PL7244GEND(1)

R9VL8G(1)

8000080701(1)

PL7132GEND(1)

PL16041GEND(1)

ALC12PPJ(1)

ALC6J(1)

ALD12PPJ(1)

ALD6J(1)

8248K(1)

82460PPK(1)

81516LTFUSK(1)

815-12CF(1)

81524LTK(1)

81530PPK(1)

81536LK(1)

8148LTFUSK(1)

8142K(1)

81312PPK(1)

8134TK(1)

8138LTFUSK(1)

81412PPK(1)

81536PPK(1)

81548PPK(1)

82430PPK(1)

82416LTFUSK(1)

82436PPK(1)

82448PPK(1)

8244K(1)

82412K(1)

8158TFUSK(1)

8154K(1)

81560PPK(1)

8156FUSK(1)

8158K(1)

E90BP-2(1)

A95-8(1)

MN1500B16Z(1)

MN14RT8Z(1)

MN1500B20Z(1)

MN1500B24(1)

MN1500B2Z(1)

MN1400R4ZX17(1)

MN1400B2Z(1)

MN1300R4Z(1)

MN1300BKD(1)

MN13RT8Z(1)

MN1400(1)

MN140012(1)

MN1500B4Z(1)

MN1500B8Z(1)

MN21BK(1)

MN21B4PK(1)

MN2400B10Z(1)

MN2400B16Z(1)

MN2400B20Z(1)

MN16RT4Z(1)

MN1604CT(1)

MN1500BKD(1)

MN15RT12Z(1)

MN1604B2Z(1)

MN1604BKD(1)

MN1300B2Z(1)

MN1300(1)

DA10B8ZM10(1)

DA10B16ZM10(1)

DA13B16ZM09(1)

DA13B8ZM09(1)

DA312B16ZM09(1)

D309393(1)

D303/357PK(1)

S1405(1)

PABU001(1)

2446B003(1)

AACTBULK36(1)

DA312B8ZM09(1)

DA675B12ZMR0(1)

DL2450BPK(1)

DL223ABPK(1)

DL245BPK(1)

DLCR2BPK(1)

DLCRV3B(1)

DL2032BPK(1)

DL2032B4PK(1)

DL123AB2BPK(1)

DL123ABPK(1)

DL2025BPK(1)

DL2032B2PK(1)

MN2400B24000(1)

MN2400B4Z(1)

QU2400BKD09(1)

QU2400BKD(1)

QU9V3BCD(1)

2016BP2(1)

2025BP2(1)

QU2400B8Z(1)

QU2400B4Z(1)

QU1500BKD(1)

QU1500B8Z(1)

QU1500BKD09(1)

QU1604(1)

QU1604BKD(1)

2032BP2(1)

2032BP4(1)

A522-4(1)

A23BPZ(1)

A76BPZ(1)

A91BP-24HT(1)

A93-8(1)

522FP-4(1)

522BP-2(1)

357BPZ(1)

357BPZ3(1)

377BPZ2(1)

392BPZ(1)

QU1400BKD(1)

QU1400(1)

MND389BPK(1)

MN9100B2PK(1)

MX2500B2PK(1)

NLAA2BCD(1)

NLAA4BCD(1)

MN908(1)

MN24RT12Z(1)

MN2400B8Z(1)

MN2400B8ZCT(1)

MN2400BKD(1)

MN24P36(1)

NLAAA2BCD(1)

NLAAA4BCD(1)

PX28LBPK(1)

PL123BDK(1)

PX76A675PK09(1)

QU1300(1)

QU1300BKD(1)

PC2400BKD(1)

PC1604BKD(1)

PC1300(1)

PC1400(1)

PC1500BKD(1)

PC1500CT(1)

58-0108-000(1)

 
Country of Origin

US(112)

CN(39)

ID(13)

JP(13)

MY(13)

SG(10)

DE(7)

CH(3)

BE(2)

 
Material(s)

Alkaline Manganese Dioxide(91)

Alkaline(43)

Lithium Manganese Dioxide(22)

Silver-Oxide Zinc(17)

Nickel-Metal Hydride(16)

Lithium/Iron Disulfide(7)

Zinc Air(5)

Lithium(4)

Silver Oxide(2)

Carbon Zinc(1)

Lithium-Ion(1)

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

Nickel-Cadmium(1)

 
For Use With

Everyday Electronic Devices(55)

Watches; Specialty Electronics(7)

Professional and Industrial Electronic Devices(6)

Hearing Aid(6)

Watches; Electronics(6)

All High-Drain Devices(5)

Digital Cameras; Hands Free Equipment(3)

Home Medical Devices(3)

Any device that uses AAA batteries(3)

Lanterns and Flashlights(2)

Digital Cameras(2)

Any device that uses AA batteries(2)

Calculators; Home Medical Devices(2)

Electronics(2)

Cameras(2)

Brother QL810W, QL820NWB(1)

Low-Drain Devices(1)

Any device that uses D batteries(1)

Any device that uses C batteries(1)

ZOLL AED Plus(1)

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

S602R, S602MR(1)

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

Calculators; Home Medical Devices; Toys; Watches(1)

ES900(1)

Photographic(1)

Watches; Calculators(1)

Calculators; Computer Clocks(1)

Canon PIXMA iP100(1)

Calculators;Watches(1)

 
Replacement For

1215; E91; NH15(1)

 
Voltage

1.5 V(131)

3 V(27)

9 V(18)

1.2 V(15)

6 V(7)

1.45 V(6)

12 V(3)

8.4 V(1)

3.7 V(1)

14.4 V(1)

 
Battery Type

Alkaline(132)

Lithium(29)

Specialty(16)

Lithium Coin(11)

NiMH Rechargeable(10)

Rechargeable(7)

Silver Oxide(3)

Lithium-Ion(2)

Li-Ion(1)

Zinc Oxide(1)

 
Battery Size

AA(48)

AAA(41)

9V(21)

D(20)

C(20)

2032(6)

123(5)

2025(3)

AAAA(2)

CRV3(2)

CR2(2)

357(2)

N(2)

2016(2)

21/23(2)

10(2)

13(2)

312(2)

2450(2)

223(2)

1616(1)

1632(1)

A76(1)

392(1)

A23(1)

2CR5(1)

6V(1)

EPX76(1)

377(1)

2430(1)

28L(1)

389(1)

908(1)

3.7V(1)

675(1)

309/393(1)

CR123(1)

303/357(1)

76/675(1)

245(1)

14.4 V(1)

 
Battery Capacity

2400 mAh(3)

1700 mAh(3)

2300 mAh(2)

2500 mAh(2)

900 mAh(2)

3000 mAh(2)

3500 mAh(2)

1200 mAh(2)

2535 mAh(1)

2000 mAh(1)

200 mAh(1)

2200 mAh(1)

1550 mAh(1)

800 mAh(1)

175 mAh(1)

1,000 mA-h(1)

1750 mAh(1)

700 mAh(1)

1470 mAh(1)

280 mAh(1)

 
Charge Time

10 Seconds(1)

3 hrs(1)

2 1/2 Hours(1)

4 Hours(1)

 
 
 

© 2019-2020 Dependable Office Supply, All Rights Reserved