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

We're sorry, there were no matches for "Extended-Warranties" 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].

 
Dixie Ultra® Smartstock Series-O Mediumweight Combo Spoon Refill by GP Pro
Dixie 51

FREE Shipping

Please login to Add Item in Favorites.
Dixie Heavyweight Disposable Forks Grab-N-Go by GP Pro
Dixie 207

FREE Shipping

Please login to Add Item in Favorites.
Akro-Mils 24-Drawer Plastic Storage Cabinet
Akro-Mils 10124

FREE Shipping

Please login to Add Item in Favorites.
Sparco All-Steel Slot-Style 60-Key Cabinet
Sparco 15602

FREE Shipping

Please login to Add Item in Favorites.
DURABLE® Brushed Aluminum Combo Lock 54-Key Cabinet with Drop Box
Durable 196823

FREE Shipping

Please login to Add Item in Favorites.
Dixie Heavy Medium-weight Disposable Soup Spoons Grab-N-Go by GP Pro
Dixie 207

FREE Shipping

Please login to Add Item in Favorites.
Avery(R) Metal Rim Key Tags, 1-1/4" Diameter Tag, Metal Split Ring, White, 50 Tags (11025)
Avery 11025

FREE Shipping

Please login to Add Item in Favorites.
Lorell 26-1/2" Mobile Storage Cabinet - 4-Drawer
Lorell 25976

FREE Shipping

Please login to Add Item in Favorites.
Baumgartens 3" Carabiner Key Ring
Baumgartens 41020

FREE Shipping

Please login to Add Item in Favorites.
DURABLE® Key Tag
Durable 194900

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.
The Pencil Grip Wrist Coil Whistle
The Pencil Grip 26201

FREE Shipping

Please login to Add Item in Favorites.
Genuine Joe Color-coded Microfiber Cleaning Cloths
Genuine Joe 48261

FREE Shipping

Please login to Add Item in Favorites.
Dixie Heavyweight Disposable Forks by GP Pro
Dixie 517

FREE Shipping

Please login to Add Item in Favorites.
First Aid Only XL SmartCompliance General Business First Aid Cabinet without Medications, Metal
First Aid Only 90829

FREE Shipping

Please login to Add Item in Favorites.