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

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

 
Avery® Inkjet Postcard - White
Avery 8386

FREE Shipping

Please login to Add Item in Favorites.
Allsop TriTilt Adjustable Laptop / Tablet Stand for Ultrabook, Tablet, Notebook, iPad - (31660)
Allsop 31660

FREE Shipping

Please login to Add Item in Favorites.
HON 10700 Series Bridge
HON 10760

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.
Lorell Makerspace 30x18 Natural Wood Worksurface
Lorell 00014

FREE Shipping

Please login to Add Item in Favorites.
Tripp Lite USB C to VGA Multiport Video Adapter Converter w/ USB-A Hub, USB-C PD Charging Port & Gigabit Ethernet Port, Thunderbolt 3 Compatible, USB Type C to VGA, USB-C, USB Type-C
Tripp Lite 44406

FREE Shipping

Please login to Add Item in Favorites.
3M Ergonomic Notebook Riser
3M 500

FREE Shipping

Please login to Add Item in Favorites.
HON 10500 Series Angled Center Drawer
HON 1526

FREE Shipping

Please login to Add Item in Favorites.
SKILCRAFT Employee Start-up Office Kit
SKILCRAFT 4936006

FREE Shipping

Please login to Add Item in Favorites.
Safco Aluminum Hanging Clamps
Safco 50046

FREE Shipping

Please login to Add Item in Favorites.
Safco Aluminum Hanging Clamps
Safco 50036

FREE Shipping

Please login to Add Item in Favorites.
Lorell Makerspace 60x18 Charcoal Worksurface
Lorell 00015

FREE Shipping

Please login to Add Item in Favorites.
Genuine Joe Cleaning Tool Wall Organizer Rack
Genuine Joe 12504

FREE Shipping

Please login to Add Item in Favorites.
Tripp Lite Charging Sync Station Wall Mount 16-Port USB Tablet Ipad Android
Tripp Lite 16

FREE Shipping

Please login to Add Item in Favorites.
Avery® Inkjet Postcard - White
Avery 8387

FREE Shipping

Please login to Add Item in Favorites.