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

Currently Filtered by

Category

Headset Accessories

Refine Search

  GO
 
Brand

Maxell(15)

Plantronics(7)

Jabra(1)

 
Color(s)

Black(11)

Silver(4)

White(2)

Blue(1)

Pink/Blue/Silver(1)

Black/Gray(1)

 
Quantity

1 each(1)

 
Manufacturer Part Number

APC43(1)

199742(1)

199725(1)

199712(1)

APP51(1)

APV63(1)

MDA100QD(1)

M22(1)

HL10(1)

DA80(1)

199711(1)

199708(1)

190400(1)

190338(1)

190319(1)

190318(1)

190560(1)

190562(1)

199635(1)

199621(1)

190599(1)

190568(1)

7510409(1)

 
Country of Origin

CN(17)

MX(6)

 
For Use With

Smartphones; Tablets; Laptops; Portable Devices(4)

Laptops; Mobile Devices; Tablets(2)

Analog Headsets(1)

Plantronics Telephone Amplifiers PLNA20, PLNS20, PLNCA10, PLNCS10, and PLNCS50(1)

HW111N; HW121N; HW251; HW251N; HW261; HW261N; HW510; HW520; HW530; HW540; HW710; HW720(1)

Plantronics Headset and Avaya Desk Phones(1)

VoIP and PBX Phone Systems(1)

Headset and Telephone(1)

Laptops; Portable Devices; Smartphones; Tablets(1)

Portable Devices(1)

Cell Phones(1)

PC Softphones; UC Systems; Bluetooth Devices(1)

Plantronics Headset and Polycom Desk Phones(1)

 
Accessory Type

Audio Processor(2)

Hookswitch Cable(2)

Switch(1)

Handset Lifter(1)

Cable(1)

Speakerphone(1)

 
Choking Hazard

Y(2)

No(1)

 
Microphone

Yes(8)

No(1)

 
Connecting Types

Quick Disconnect(1)

USB(1)

Bluetooth; USB(1)

 
Cord Length

4 ft(8)

52"(2)

20"(1)

5 ft(1)

3 ft(1)

 
Earpiece Type

Earbud(6)

Ear Cushions(4)

Earbuds(3)

Over The Ear(1)

 
Batteries Required

None(11)

No(2)

Yes(1)

Two AAA (sold separately)(1)

 
Earpiece Material

Rubber(4)

Soft Cushion(3)

Plastic; Rubber(3)

Silicone(2)

Foam; Leatherette(1)

Hard Plastic(1)

 
Headset Features

Comfort Fit Design(3)

Copper Coil Technology(2)

Bluetooth; Wireless(1)

Foldable; Lightweight; Locking Headband; In-line Volume Control(1)

Around Ear Hook Style; Rubberized In-Ear Comfort Tip(1)

Noise Canceling(1)

Stereo/In-Ear(1)

 
 
 

© 2018-2019 Gateway Business Products, All Rights Reserved