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

We're sorry, there were no matches for "Laptop-Accessory-Kits" on our site.

Search Tips

Please try searching for different keywords that describe the item you're looking for.

  • Descriptive Keyword(s) - example: "Copy Paper Letter"
  • Product Name (full or partial) - example: "Boise Fireworx Copy Paper"
  • Stock Number (full or partial) - example: "UNV21200"
  • Manufacturer Name or Abbreviation - example: "HP"

Continue Shopping

  • Order by Item Number
  • Browse Our Products

Need Help? Contact us at 800-214-0028 or email Customer Service at [email protected].

 
Jonti-Craft SideKick Mobile Storage Seat
Jonti-Craft 3769

FREE Shipping

Please login to Add Item in Favorites.
QuickFit Landscape Round Ring View Binder for Spreadsheets
QuickFit 95011

FREE Shipping

Please login to Add Item in Favorites.
Genuine Joe Air Freshener Dispenser System
Genuine Joe 99659

Please login to Add Item in Favorites.
HON Brigade 3-Shelf Steel Bookcase
HON 42

Please login to Add Item in Favorites.
Medline Wall-mount Aneroid Sphygmomanometer
Medline 9400

FREE Shipping

Please login to Add Item in Favorites.
Pacon Dry Erase Activity Pocket Chart
Pacon 20410

FREE Shipping

Please login to Add Item in Favorites.
Xerox 109R00784 Cleaning Unit/Maintenance kit
Xerox 10900784

FREE Shipping

Please login to Add Item in Favorites.
HON Accommodate Cafe Stool, Fixed Arms
HON 210

Please login to Add Item in Favorites.
Raid Ant/Roach Killer Spray
Raid 669798

Please login to Add Item in Favorites.
Trend Life Cycles Learning Charts Combo Pack
TREND 38934

FREE Shipping

Please login to Add Item in Favorites.
Canon GPR-16 Original Toner Cartridge
Canon 16

FREE Shipping

Please login to Add Item in Favorites.
Boss Drafting Stool
Boss Office Products 16245

FREE Shipping

Please login to Add Item in Favorites.
Carson-Dellosa Reinforcement Pocket Chart
Carson-Dellosa Publishing 158161

FREE Shipping

Please login to Add Item in Favorites.
Medline Digital Wrist Plus Blood Pressure Monitor
Medline 3003

FREE Shipping

Please login to Add Item in Favorites.
Iceberg CafeWorks Bistro Stool
Iceberg 64527

Please login to Add Item in Favorites.