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_27` 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 ((`desc_short` like 'epson' OR `desc_long` like 'epson' OR `desc_title` like 'epson' OR `keywords` like 'epson' OR `category_1` like 'epson' OR `category_2` like 'epson' OR `category_3` like 'epson' OR `category_4` like 'epson' OR `manufacturer_name` like 'epson' OR `color` like 'epson') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>epson>epsons)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"epson"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%epson%' OR `pinfo`.`sku` like '%epson%' OR (FIND_IN_SET('epson', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('epson', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('epson', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('epson', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('epson', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'epson' ELSE `pinfo`.`desc_title` like 'epson' END))) 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 '%epson' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('epson' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+epson' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"epson"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"epson"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"epson"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"epson"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+epson' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='epson',`category_4` ='epson') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'epson,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('epson', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Epson

Refine Search

  GO
 
Category Filter

Inks & Toners(399)

Photo Paper(152)

Correction Tapes(22)

Scanners(16)

Multimedia Projectors(13)

Projector Accessories(11)

Ink Cartridges & Printheads(10)

Warranties & Support Packs(9)

Inkjet Printers(8)

Printer Accessories(6)

Digital Projectors(6)

Copier/Fax/Multifunction Machines(6)

Printer Ribbons(5)

Dot Matrix Printers(5)

Maintenance Kits/Supplies(4)

Inks & Paper Combinations(3)

Labels(3)

Art Boards(2)

Print Servers/Network Cards(1)

Sheetfed Scanners(1)

Multifunction/All-in-One Machines(1)

Impact Printers(1)

Projection Screens(1)

Imaging Drums/Photoconductors(1)

 
Brand

Epson(666)

Innovera(7)

Lexmark(3)

Industrias Kores(3)

Avery(3)

TROY(1)

Troy(1)

AAXA(1)

EpsonŽ(1)

 
Brightness

3,200 lm(4)

3,300 lm(2)

3600 lm(2)

3,000 lm(2)

3,700 lm(1)

4,200 lm(1)

900 lm(1)

 
Recycled

No(1)

 
Height

6.4"(5)

6.9"(4)

3.2"(3)

2 1/8"(3)

3.4"(3)

13.4"(2)

17 7/10"(1)

16.2"(1)

7.5"(1)

4 1/5"(1)

7 3/4"(1)

2 1/10"(1)

7 7/10"(1)

12.8"(1)

10"(1)

6 3/50"(1)

8 1/2"(1)

12 1/5"(1)

14 3/10"(1)

1.3"(1)

16 7/10"(1)

7 1/2"(1)

5.6"(1)

11"(1)

16 1/2"(1)

8"(1)

1 7/8"(1)

 
Color(s)

Black(93)

Cyan(64)

Yellow(61)

Magenta(61)

Cyan; Magenta; Yellow(18)

Light Magenta(16)

Black; Cyan; Magenta; Yellow(16)

Light Cyan(16)

Photo Black(15)

Matte Black(13)

Light Black(10)

Light Light Black(7)

Red(5)

White(5)

Vivid Magenta(4)

Vivid Light Magenta(4)

Cyan; Light Cyan; Light Magenta; Magenta; Yellow(4)

Tri-Color(3)

White/Gray(3)

Orange(3)

Clear(3)

Cyan; Magenta; Yellow; Photo Black(2)

White/Black(2)

Gloss Optimizer(1)

Gray; Red(1)

Silver/Black(1)

Blue(1)

Black;Red(1)

Black/Red(1)

Light Cyan; Light Magenta(1)

Gray(1)

 
Depth

14.2"(5)

14.8"(4)

8 1/2"(3)

9.8"(3)

19.8"(3)

9.3"(2)

32.2"(2)

15"(2)

8 3/10"(1)

13 2/5"(1)

10 3/10"(1)

9.2"(1)

1.8"(1)

14 9/10"(1)

13.3"(1)

17 1/5"(1)

22 4/5"(1)

31 1/2"(1)

14"(1)

32"(1)

20.8"(1)

10 4/5"(1)

9 1/8"(1)

6"(1)

30.9"(1)

 
Quantity

1 each(2)

 
 
 

© 2019-2020 Hi Tech Office Products, All Rights Reserved