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

Currently Filtered by

Category

Scanners

Refine Search
  GO
 
Brand

Brother(6)

Canon(1)

 
Manufacturer Part Number

DS920DW(1)

9706B002(1)

DS720D(1)

DS620(1)

ADS1500W(1)

ADS2200(1)

ADS1000W(1)

 
Country of Origin

CN(6)

JP(1)

 
Connector/Port/Interface

USB; Wi-Fi(3)

USB(2)

USB 2.0(1)

USB; USB Flash Memory Drive(1)

 
Operating System Compatibility

Linux; Mac; Windows(5)

Mac OS X 10.7 and Later; Windows XP, Vista, 7, 8(1)

Mac; Windows(1)

 
Buttons

1(3)

4(1)

 
Dpi Graphics Resolution

600 x 600 dpi(4)

200 x 300 dpi(1)

1200 x 1200 dpi(1)

1200 x 600 dpi(1)

 
Scan Size (W x H)

8 1/2" x 32"(3)

8 1/2" x 34"(2)

2" x 14"(1)

8.5" x 14"(1)

 
Software Included

Nuance PaperPort 12 SE (Windows); Presto! PageManager 9 (Mac); Presto! BizCard; DSmobileCapture; Button Manager v2; BR-Receipts(2)

ISIS/TWAIN Drivers; Canon CaptureOnTouch; Nuance eCopyPDF Pro Office; Nuance PaperPort; Nuance OmniPage; NewSoft Presto! Bizcard; Evernote(1)

Button Manager v2; BR-Receipts; DSmobileCapture; ScanHub App(1)

Presto! Presto! PageManager (Mac); Nuance PaperPort 14SE (Windows); Presto! BizCard OCR(1)

Nuance PaperPort 12 SE (Windows); Presto! PageManager 9 (Mac); Presto! BizCard; Control Center; Captiva QuickScan Pro Trial; Nuance PDF Converter Professional 7 (Windows); BR-Receipts(1)

Nuance PaperPort 12 SE (Windows); Presto! PageManager 9 (Mac); Presto! BizCard; DSmobileCapture; Button Manager v2(1)

 
Bit Depth of Color

24-bit Color; 8-bit Grayscale(1)

24-bit Color; 8-bit Grayscale; 1-bit Monochrome(1)

 
Scan Speed (Black)

8 ppm(3)

25 ppm(1)

35 ppm(1)

18 ppm(1)

16 ppm(1)

 
Scan Speed (Color)

8 ppm(3)

25 ppm(1)

35 ppm(1)

18 ppm(1)

16 ppm(1)

 
Paper Feed

20-Sheet Automatic Document Feeder(2)

Automatic; Manual(1)

50-Sheet Duplex Automatic Document Feeder(1)