0

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

Currently Filtered by

Category

Laser Printers

Refine Search
  GO
 
Brand

Brother(12)

HP(10)

Lexmark(5)

Canon(3)

 
Color

White(1)

 
Packaged Quantity

1 Each(28)

 
Limited Warranty

1 Year(30)

 
Weight (Approximate)

19.4 lb(2)

30.9 lb(2)

30.6 lb(2)

18.9 lb(1)

58 lb(1)

47.7 lb(1)

68.8 lb(1)

16.8 lb(1)

15.2 lb(1)

10.4 lb(1)

25.6 lb(1)

15 lb(1)

37.7 lb(1)

15.4 lb(1)

29.1 lb(1)

35.1 lb(1)

26.2 lb(1)

32.2 lb(1)

28.7 lb(1)

23.6 lb(1)

47.8 lb(1)

39.7 lb(1)

31.1 lb(1)

 
Recommended Use

Plain Paper Print(30)

 
Media Type

Envelope(3)

Plain Paper(3)

Label(3)

Bond Paper(2)

Thick Paper(2)

Thin Paper(2)

Recycled Paper(2)

Glossy Paper(1)

Card Stock(1)

Vellum(1)

Photo Paper(1)

 
Form Factor

Desktop(28)

 
Input Voltage

120 V AC(15)

230 V AC(1)

 
Duty Cycle

10000(5)

50000(5)

30000(4)

100000(4)

125000(1)

80000(1)

150000(1)

250000(1)

275000(1)

120000(1)

 
Media Handling

1 x Input Tray 250 Sheet(2)

1 x Output Tray 1 Sheet(2)

1 x Output Bin 100 Sheet(1)

1 x Manual Feed Slot 1 Sheet(1)

1 x Output Bin 150 Sheet(1)

1 x Input Tray 150 Sheet(1)

1 x Output Tray 100 Sheet(1)

1 x Automatic Document Feeder 35 Sheet(1)

 
USB

Yes(28)

 
Wireless Print Technology

Apple AirPrint(21)

Google Cloud Print(19)

Mopria(18)

Wi-Fi Direct(14)

Brother iPrint&Scan(11)

HP ePrint(5)

Cortado Cloud Print(3)

Canon Mobile Printing(3)

Near Field Communication (NFC)(1)

Canon PRINT Business(1)

 
Display Screen Type

LCD(3)

 
Maximum Print Resolution

1200 x 1200 dpi(17)

600 x 600 dpi(5)

2400 x 600 dpi(3)

600 x 2400 dpi(3)

 
Maximum Mono Print Speed (ppm)

42(5)

48(3)

38(2)

25(2)

40(2)

26(1)

28(1)

65(1)

55(1)

74(1)

22(1)

63(1)

35(1)

45(1)

32(1)

30(1)

19(1)

36(1)

46(1)

 
Scan Color

Color(3)

 
Optical Resolution

1200 dpi(3)

 
Wireless LAN

Yes(18)

No(4)

 
Print Color Capability

Monochrome(24)

Color(6)

 
Copy Color

Monochrome(2)

Color(1)

 
Multifunction Devices

Copier/Printer/Scanner(2)

Copier/Fax/Printer/Scanner(1)

 
Copier Type

Flatbed(3)

 
Scanner Type

Flatbed(3)

 
Ethernet Technology

Fast Ethernet(2)

Gigabit Ethernet(1)

 
Fax Color

Monochrome(1)

 
Ethernet

Yes(22)

No(1)

 
Number of Input/Multipurpose Trays Installed

2(19)

1(3)

3(3)

 
Maximum Color Print Speed (ppm)

25(2)

19(1)

74(1)

 
Processor Speed

800 MHz(9)

1.20 GHz(5)

1 GHz(5)

600 MHz(2)

266 MHz(1)

 
USB Direct Printing

Yes(6)

No(5)

 
Bluetooth

Yes(1)

 
Manufacturer Part Number

HL-L2300D(1)

F2A68A(1)

36SC120(1)

36S0300(1)

36S0200(1)

36S0100(1)

K0Q19A(1)

K0Q14A(1)

J8A04A(1)

J7Z99A(1)

J7Z98A(1)

G3Q60A(1)

G3Q47A(1)

G3Q35A(1)

C5F93A(1)

HL-L2350DW(1)

LBP226DW(1)

ICLBP214DW(1)

ICLBP162DW(1)

HLL6300DW(1)

HLL6200DWT(1)

HLL6200DW(1)

HLL5200DWT(1)

HLL5200DW(1)

HLL5100DN(1)

HL-L3290CDW(1)

HL-L3230CDW(1)

HL-L3210CW(1)

HL-L2395DW(1)

36SC220(1)

 
Country of Origin

Vietnam(13)

China(9)

Philippines(4)

Japan(4)

 
Height

10.2"(5)

9.9"(4)

10"(2)

11.3"(2)

8.8"(1)

19.9"(1)

15"(1)

19"(1)

11"(1)

7.2"(1)

7.5"(1)

11.7"(1)

9"(1)

16.5"(1)

15.2"(1)

14.5"(1)

8.5"(1)

 
Width

15.7"(6)

14.7"(5)

16.1"(3)

15.8"(2)

17"(2)

14"(1)

14.9"(1)

15"(1)

16.5"(1)

14.4"(1)

14.6"(1)

16.7"(1)

20.1"(1)

 
Depth

15.3"(5)

14.7"(4)

18.5"(3)

18.1"(2)

18.3"(2)

14.2"(1)

18.7"(1)

15.6"(1)

16.2"(1)

14.1"(1)

25.2"(1)

9.7"(1)

16"(1)

11.4"(1)

18"(1)

 
Power Source

AC Supply(30)

 
Duplex Printing

Automatic(21)

Manual(5)

 
Maximum Memory

256 MB(6)

512 MB(5)

1.50 GB(3)

128 MB(1)

2 GB(1)

 
Screen Size

2.70"(4)

1.77"(1)

4.29"(1)

2.40"(1)

 
Touchscreen

No(5)

Yes(4)

 
 
 

© 2020-2021 CPS Office Products, All Rights Reserved

Powered by SITS Erp