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

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

 
Dixie Heavyweight Disposable Knives by GP Pro
Dixie 217

FREE Shipping

Please login to Add Item in Favorites.
Dixie Medium-weight Disposable Knives by GP Pro
Dixie 217

FREE Shipping

Please login to Add Item in Favorites.
Ergodyne Squids Grabber Clip
ergodyne 19118

FREE Shipping

Please login to Add Item in Favorites.
Steelmaster 28-Key Hook-Style Cabinet with Combo Lock
SteelMaster 201202889

FREE Shipping

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

FREE Shipping

Please login to Add Item in Favorites.
Merriam-Webster Spanish-English Dictionary Printed Book
Merriam Webster 824

FREE Shipping

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

FREE Shipping

Please login to Add Item in Favorites.
At-A-Glance Large Telephone/Address Book
AT-A-GLANCE 8001105

FREE Shipping

Please login to Add Item in Favorites.
Dixie Ultra® Smartstock Series-O Mediumweight Knife Refill by GP Pr
Dixie 51

FREE Shipping

Please login to Add Item in Favorites.
Akro-Mils 16-Drawer Plastic Storage Cabinet
Akro-Mils 10116

FREE Shipping

Please login to Add Item in Favorites.
Reynolds Food Packaging PactivReynolds 910 Foodservice Film
Reynolds Consumer Products 910

FREE Shipping

Please login to Add Item in Favorites.
Dixie Medium-Weight Disposable Plastic Forks by GP Pro
Dixie 517

FREE Shipping

Please login to Add Item in Favorites.
Dixie Medium-weight Disposable Knives by GP Pro
Dixie 517

FREE Shipping

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

FREE Shipping

Please login to Add Item in Favorites.
Acme United 5pc Cutting Board Knife Set
Clauss 18633

FREE Shipping

Please login to Add Item in Favorites.