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

Currently Filtered by

Category

Mobile Device Accessories

Refine Search

  GO
 
Brand

Fellowes(15)

Kensington(14)

3M(14)

Solo(13)

Targus(9)

Zebra(9)

Kantek(8)

Scosche(6)

Filofax(4)

Verbatim(4)

Dotz(4)

Victor(3)

Softalk(2)

AutoExec(2)

Case Logic(2)

Griffin(1)

Vaultz(1)

Allsop(1)

BIC(1)

Logitech(1)

Samsill(1)

Artistic(1)

Swingline(1)

 
Color(s)

Black(69)

Clear(5)

Gray(3)

Silver(3)

White(2)

Red(2)

Espresso(1)

Black/Blue(1)

Gray/Tan(1)

Floral Purple(1)

Metro Mocha(1)

Zebra Print(1)

Metro Purple(1)

Purple(1)

Navy(1)

Lime(1)

Black; Orange; Red; Yellow(1)

Black/Silver(1)

Assorted(1)

Black Metallic(1)

Pink(1)

Raspberry(1)

White/Silver(1)

Cyan(1)

Khaki(1)

 
Manufacturer Part Number

AWE55US(1)

THZ156US(1)

10139(1)

MAGWSM2(1)

MAGVM(1)

MAGWDM(1)

THZ456US(1)

THZ592US(1)

THZ634GL(1)

THZ635GL(1)

THZ622GL(1)

THZ618GL(1)

THZ617GL(1)

MAGFM(1)

MAGDM(1)

FXW37MCL(1)

B829835(1)

FXW37MCC(1)

EBC38MCPK(1)

UCPAP002(1)

EBC38MCK(1)

B829837(1)

B829927(1)

49001(1)

MAG12V(1)

00901M(1)

35007(1)

B829930(1)

ACV2314(1)

ACV2384(1)

33111(1)

33161(1)

98540(1)

98530(1)

98527(1)

98529(1)

33201(1)

33211(1)

33381(1)

33411(1)

33321(1)

33311(1)

33301(1)

PH750(1)

PH700(1)

IPD211610(1)

IPP20614(1)

IPD20664(1)

IPD201610(1)

CLS2404(1)

PRO2014(1)

TCC222-420(1)

VTA1373(1)

PH600(1)

UBN2214(1)

UBN2204(1)

UBN21010(1)

UCPAP001(1)

TS200S(1)

8203801(1)

9689901(1)

8202701(1)

8201801(1)

8201001(1)

8201101(1)

GB37543(1)

VZ01211(1)

39723(1)

67890(1)

39686(1)

39256(1)

39217(1)

8200901(1)

4813601(1)

CLCMBLK(1)

CLP179DRD(1)

MMGSTP11(1)

82007(1)

31661(1)

82003(1)

4805801(1)

4806501(1)

4812301(1)

4812601(1)

4812201(1)

4807401(1)

4806601(1)

97042(1)

97317(1)

MPPAP001(1)

NV828748(1)

MPF830130(1)

AFTMS001(1)

TS920(1)

920006912(1)

NVAG828427(1)

NVAG828762(1)

PFTAP003(1)

PFTAP007(1)

PFTAP002(1)

PFTAP001(1)

NVAG830864(1)

TS905(1)

TS890(1)

97365(1)

97367(1)

97363(1)

97362(1)

97329WW(1)

97408(1)

97442(1)

TS680(1)

TS710(1)

SVT4822(1)

SVT4723(1)

SVT4247(1)

ART43024WH(1)

 
Country of Origin

CN(83)

US(17)

KR(9)

TW(7)

JP(1)

 
Material(s)

Plastic(21)

Polyester(9)

Plastic/Metal(7)

Ballistic Nylon(6)

Polyethylene(4)

PET(4)

Vinyl(3)

Leather(2)

Marine Grade Stainless Steel Components and High Strength Composite(2)

PC/Silicon Rubber(2)

Aluminum(2)

Leather Look(2)

Silicone/Microsuede(2)

Microfiber/Leather Look(2)

Cotton/Vinyl(2)

PVC(1)

Faux Leather(1)

Polycarbonate Silicone(1)

Soft touch, durable, lightweight material designed to last(1)

Padded Twill(1)

Acrylic(1)

PU; Microfiber(1)

Chrome(1)

Carbon Steel/Plastic(1)

Mesh(1)

Nylon/Microsuede(1)

PU; Microfiber; Rubber(1)

Polyurethane; Polyester; Silicone; Paper(1)

Plastic/Silicone(1)

Simulated Leather/Aluminum/Paperboard(1)

Nontoxic Silicone Rubber(1)

EVA(1)

Metal/Rubber(1)

 
For Use With

iPad Air(12)

Smartphones; Tablets(11)

iPad Air 2(7)

Mobile Devices; Smartphones(7)

Mobile Phones(4)

iPad Air 1, 2(4)

Earbuds(4)

8.5" to 11" Tablets(3)

iPad Pro(3)

Tablets(3)

Apple Lightning Devices(2)

iPhone 5(2)

iPad Air 1, 2; iPad Pro(2)

Microsoft Surface Pro 4(2)

iPad Air; iPad Air 2; iPad Pro (9.7")(2)

iPhone 6 Plus(2)

iPad 2, 3rd Gen, 4th Gen(2)

e-Readers; Tablets(1)

10" Tablets(1)

Laptops(1)

iPhone 6, 6s(1)

iPad Pro 12.9(1)

Cell Phones(1)

iPad Air 1, 2, Pro 9.7", Portrait(1)

iPad Air 1, 2, Pro 9.7", Landscape(1)

iPad mini 1, 2, 3, 4, Portrait(1)

iPad 3rd Gen, 4th Gen(1)

9" and 10" Tablets(1)

5.5" to 8.5" Tablets(1)

Mini USB and USB Powered Devices(1)

Micro USB Devices(1)

10" Tablets and e-Readers(1)

Headphones; Smartphones; Tablets(1)

iPad; iPad 2, 3rd Gen, 4th Gen(1)

iPad mini(1)

Microsoft Surface 3(1)

Most Tablets(1)

Smartphones(1)

7" and 8" Tablets(1)

iPad 2, 3rd Gen, 4th Gen, Portrait(1)

iPhone; iPod touch(1)

Samsung Galaxy S 5(1)

Ultratablets; Tablets(1)

Samsung Galaxy Tab 4(1)

Most Mobile Devices(1)

Cables; Cords(1)

iPad mini; iPad mini 2, 3(1)

iPad mini 4(1)

Various Phones and Small Devices(1)

Iconia Tablet; Kindle Fire HD 8.9; Nook HD+; Samsung Galaxy Tab 10; Samsung Galaxy Tab 10.1; Samsung Galaxy Tab 10.1 LTE(1)

7" to 8" Tablets(1)

iPhone 6s; iPhone 6s Plus; Samsung Galaxy Note 5; Smartphones(1)

7" to 10" Tablets(1)

Microsoft Surface Pro 3, Pro 4(1)

Mobile Devices; Tablets(1)

iPhone 6(1)

7" to 10" Tablets and e-Readers(1)

Samsung Galaxy Tab 10.1(1)

Samsung Galaxy S 4(1)

iPhone 5, 5c, 5s(1)

iPad 2, 3rd Gen(1)

Large Cell Phones(1)

 
Connector/Port/Interface

Bluetooth(4)

USB(2)

Micro USB(2)

USB; Wi-Fi(1)

3.5 mm Aux(1)

8mm Headphone Jack(1)

 
Accessory Type

Tablet Case(34)

Privacy Filter(14)

Stylus(10)

Mobile Phone Holder(8)

Screen Protector(7)

Case(6)

Stand(5)

Anti-Glare Screen Protector(3)

Vehicle Dash Mount(2)

Protective Earbud Case(2)

Charging Stand/Dock(2)

Earbud Wrap(2)

Tablet Case and Keyboard(2)

Tablet Case/Keyboard(2)

Mount(2)

Shoulder Rest(1)

Phone Pouch for Belt(1)

Corded Handset(1)

Folio/Stand(1)

Cell Phone Auto Mount(1)

Charger/Dock(1)

Mobile Device(1)

Mat/Stand(1)

Privacy Screen Protector(1)

Charge & Sync Cable(1)

Mobile Lock(1)

Universal Car Mount(1)

Storage Bag(1)

Wet Electronic Rescue Kit(1)

Keyboard/Case(1)

Tablet Stand(1)

 
Expected Delivery

Allow several additional days for delivery(3)

 
 
 

© 2018-2019 BonTay Business Products, Inc., All Rights Reserved