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 ('713')) 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(76)

Energizer(64)

Rayovac(50)

Eveready(4)

AmpliVox(2)

Canon(1)

ZOLL(1)

Philips(1)

HP(1)

Acroprint(1)

Brother(1)

Streamlight(1)

 
Color(s)

Silver(1)

 
Quantity

1 each(31)

2 per pack(30)

8 per pack(29)

4 per pack(26)

12 per pack(17)

16 per pack(9)

24 per pack(9)

12 per box(7)

36 per pack(6)

72 per carton(5)

6 per pack(4)

144 per carton(3)

30 per pack(2)

60 per pack(2)

48 per pack(2)

24 per box(2)

20 per pack(2)

36 per carton(2)

6 per box(2)

18 per pack(1)

1 per pack(1)

49 per pack(1)

3 per pack(1)

40 packs per carton(1)

10 per pack(1)

36 packs per carton(1)

 
Manufacturer Part Number

L91(1)

EPX76BPZ(1)

L91BP2(1)

L91SBP12(1)

L91SBP4(1)

EN95(1)

EN93(1)

ELCRV3BP2(1)

EN22(1)

EN91(1)

EN92(1)

L91SBP8(1)

L92SBP12(1)

NH50BP-2(1)

NH35BP-2(1)

M9L89A(1)

77175(1)

LFH9154/00(1)

NH22NBP(1)

NH15BP8(1)

L92SBP4(1)

L92SBP8(1)

NH12BP-4(1)

NH15BP-4(1)

EL2CR5BP(1)

EL223APBP(1)

E93BP-4(1)

E93BP-2(1)

E93FP-8(1)

E95BP-2(1)

E95BP-4(1)

E92MP8(1)

E92LP16(1)

E91SBP36H(1)

E92BP12(1)

E92BP24(1)

E92BP-4(1)

E95FP-8(1)

E96BP-2(1)

ECR2450BP(1)

EL123APB2(1)

EL123APBP(1)

EL1CR2BP(1)

ECR2430BP(1)

ECR2032BP(1)

ECR1616BP(1)

ECR1632BP(1)

ECR2016BP(1)

ECR2025BP(1)

81312PPK(1)

8134TK(1)

ALAA24PPJ(1)

AL9V6J(1)

ALAA48PPJ(1)

ALAA8J(1)

ALAAA18PPJ(1)

AL9V12PPJ(1)

A16048PPK(1)

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

8248TFUSK(1)

8248K(1)

81530PPK(1)

81524LTK(1)

81536LK(1)

81536PPK(1)

81548PPK(1)

81516LTFUSK(1)

815-12CF(1)

8138LTFUSK(1)

81412PPK(1)

8142K(1)

8148LTFUSK(1)

8154K(1)

81560PPK(1)

82436PPK(1)

82448PPK(1)

8244K(1)

82460PPK(1)

82430PPK(1)

82416LTFUSK(1)

8156FUSK(1)

8158K(1)

8158TFUSK(1)

82412K(1)

E91MP8(1)

E91LP16(1)

MN1400B2Z(1)

MN140012(1)

MN1400R4ZX17(1)

MN14RT8Z(1)

MN1500B16Z(1)

MN1400(1)

MN13RT8Z(1)

MN1300(1)

MN1300B2Z(1)

MN1300BKD(1)

MN1300R4Z(1)

MN1500B20Z(1)

MN1500B24(1)

MN1604CT(1)

MN1604BKD(1)

MN16RT4Z(1)

MN21B4PK(1)

MN21BK(1)

MN1604B2Z(1)

MN15RT12Z(1)

MN1500B2Z(1)

MN1500B4Z(1)

MN1500B8Z(1)

MN1500BKD(1)

DLCRV3B(1)

DLCR2BPK(1)

DA10B16ZM10(1)

D309393(1)

DA10B8ZM10(1)

DA13B16ZM09(1)

DA13B8ZM09(1)

D303/357PK(1)

AACTBULK36(1)

S1405(1)

S1465(1)

PABU001(1)

2446B003(1)

DA312B16ZM09(1)

DA312B8ZM09(1)

DL2032BPK(1)

DL223ABPK(1)

DL2450BPK(1)

DL245BPK(1)

DL2032B4PK(1)

DL2032B2PK(1)

DA675B12ZMR0(1)

DL123AB2BPK(1)

DL123ABPK(1)

DL2025BPK(1)

MN2400B10Z(1)

MN2400B16Z(1)

2032BP4(1)

2032BP2(1)

357BPZ(1)

357BPZ3(1)

377BPZ2(1)

2025BP2(1)

2016BP2(1)

QU1604(1)

QU2400B4Z(1)

QU2400B8Z(1)

QU9V3BCD(1)

392BPZ(1)

522BP-2(1)

E91BP2(1)

E90BP-2(1)

E91BP24(1)

E91BP-4(1)

E91BW12EM(1)

A95-8(1)

A93-8(1)

A23BPZ(1)

A522-4(1)

A76BPZ(1)

A91BP-24HT(1)

QU1500B8Z(1)

QU1400(1)

MN24RT12Z(1)

MN24P36(1)

MN908(1)

MN9100B2PK(1)

MND389BPK(1)

MN2400BKD(1)

MN2400B8ZCT(1)

MN2400B20Z(1)

MN2400B24000(1)

MN2400B4Z(1)

MN2400B8Z(1)

MX2500B2PK(1)

NLAA2BCD(1)

PC1604BKD(1)

PL123BDK(1)

PX28LBPK(1)

PX76A675PK09(1)

PC1500CT(1)

PC1400(1)

NLAA4BCD(1)

NLAAA2BCD(1)

NLAAA4BCD(1)

PC1300(1)

58-0108-000(1)

 
Country of Origin

US(114)

CN(28)

JP(15)

MY(13)

ID(13)

SG(10)

DE(7)

CH(3)

 
Material(s)

Alkaline Manganese Dioxide(80)

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)

Nickel-Cadmium(2)

Carbon Zinc(1)

Lithium-Ion(1)

Nickel Oxide Hydroxide/Cadmium(1)

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

 
For Use With

Everyday Electronic Devices(47)

Watches; Specialty Electronics(7)

Watches; Electronics(6)

Hearing Aid(6)

All High-Drain Devices(5)

Professional and Industrial Electronic Devices(4)

Any device that uses AAA batteries(3)

Home Medical Devices(3)

Digital Cameras; Hands Free equipment(2)

Calculators; Home Medical Devices(2)

Digital Cameras(2)

Any device that uses AA batteries(2)

Lanterns and Flashlights(2)

Cameras(2)

Electronics(2)

SL-20XP LED Flashlights; UltraStingers(1)

Low-Drain Devices(1)

Any device that uses D batteries(1)

S1460(1)

Any device that uses C batteries(1)

ZOLL AED Plus(1)

S602R, S602MR(1)

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

Brother QL810W, QL820NWB(1)

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

Digital Cameras; Hands Free Equipment(1)

ES900(1)

Watches; Calculators(1)

Photographic(1)

Calculators; Computer Clocks(1)

Canon PIXMA iP100(1)

Calculators;Watches(1)

 
Replacement For

1215; E91; NH15(1)

 
Voltage

1.5 V(122)

3 V(27)

9 V(16)

1.2 V(16)

6 V(7)

1.45 V(6)

12 V(3)

8.4 V(1)

6V(1)

3.7 V(1)

14.4 V(1)

 
For Device Type

Mobile Printers(1)

 
Battery Type

Alkaline(121)

Lithium(29)

Specialty(20)

NiMH Rechargeable(10)

Rechargeable(8)

Lithium Coin(7)

Silver Oxide(3)

Lithium-Ion(2)

NiCd Rechargeable(1)

Zinc Oxide(1)

 
Battery Size

AA(45)

AAA(38)

C(19)

9V(19)

D(18)

2032(6)

123(5)

2025(3)

AAAA(2)

CRV3(2)

357(2)

N(2)

2016(2)

CR2(2)

6V(2)

21/23(2)

10(2)

312(2)

13(2)

223(2)

2450(2)

1616(1)

A76(1)

A23(1)

392(1)

1632(1)

2430(1)

EPX76(1)

2CR5(1)

377(1)

14.4 V(1)

76/675(1)

908(1)

3.7V(1)

675(1)

389(1)

CR123(1)

309/393(1)

245(1)

28L(1)

303/357(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)

1000 mAh(1)

1750 mAh(1)

700 mAh(1)

1470 mAh(1)

280 mAh(1)

 
Adapter/Charger Type

Rechargeable Printer Battery(1)

 
Charge Time

10 Seconds(1)

2 1/2 Hours(1)

4 Hours(1)

 
 
 

© 2019-2020 Desert West Office Supply, All Rights Reserved