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

Currently Filtered by

Category

Printer And Copier Accessories

Refine Search

  GO
 
Brand

Epson(14)

SICURIX(9)

Oki(6)

Lexmark(5)

Industrias Kores(2)

Dymo(1)

Monarch(1)

Panasonic(1)

 
Color

Black(1)

 
Recycled

Yes(1)

 
Height

6"(2)

2.9"(2)

5.1"(2)

2.3"(1)

 
Depth

2.6"(2)

2.4"(2)

3"(1)

2.9"(1)

5.8"(1)

 
Manufacturer Part Number

40077(1)

KX-P145(1)

925130(1)

41708210(1)

44173403(1)

44173404(1)

52102001(1)

52102001BD(1)

52107001(1)

38311(1)

3070166(1)

38312(1)

45000(1)

45010(1)

534000002(1)

534000003(1)

800033840(1)

MA250YMCKOK(1)

3070169(1)

13L0034(1)

7753(1)

ERC38BRBX(1)

7762L(1)

8750(1)

8766(1)

ERC-09B(1)

ERC-38B(1)

ERC38BBX(1)

ERC-38BR(1)

S015086(1)

1040993(1)

S015329(1)

S015335(1)

S015337(1)

S015384(1)

KOR319B(1)

KOR80CBR(1)

1040990(1)

MA300YMCKO(1)

 
Country of Origin

China(21)

Japan(7)

United Kingdom(5)

Mexico(2)

United States(2)

Malaysia(2)

 
Width

4.3"(2)

5"(2)

3.1"(2)

4"(1)

 
Material

Plastic(1)

 
Limited Warranty

2 Year(2)

15 Year(2)

Lifetime(1)

 
Weight (Approximate)

8 oz(2)

6.40 oz(2)

5.60 oz(2)

9.60 oz(1)

 
Print Technology

Dot Matrix(27)

Dye Sublimation(7)

Thermal Transfer(5)

Line Matrix(2)

 
Print Color

Black(28)

Red(3)

YMCKO(3)

YMCKOK(2)

YMCKT(2)

Color(2)

 
Yield Type

High(2)

Standard(1)

 
Typical Print Yield

3000000 Characters(5)

250 Images(3)

4 Million Characters(2)

15000000 Characters(2)

12000000 Characters(2)

200 Images(2)

20 Million Characters(2)

8 Million Characters(2)

3 Million Characters(1)

500 Images(1)

200 Pages(1)

250 Pages(1)

2000000 Characters(1)

13 Million Characters(1)

10 Million Characters(1)

2 Million Characters(1)

15 Million Characters(1)

5 Million Characters(1)

7500000 Characters(1)

200000 Characters(1)

300 Images(1)

 
Product Condition

Original(1)

 
Device Supported

Printer(1)

 
Form Factor

Handheld(1)

 
Input Voltage

110 V AC(1)

220 V AC(1)

 
Output Voltage

9 V DC(1)

 
Product Type

Ribbon Cartridge(27)

Ribbon(10)

AC Adapter(1)

Label Peeler(1)

 
Packaged Quantity

1 Each(27)

1 / Each(5)

10 / Box(2)

6 / Box(2)

1(1)

2 / Pack(1)

4 / Bundle(1)

 
Assembly Required

No(2)

 
Product Model

ERC38B(1)

S015086(1)

S015335(1)

S015384(1)

1040990(1)

1040993(1)

 
Compatible to OEM Brand

Fargo(2)

 
Compatible to OEM Part Number

45000(1)

45010(1)

 
Package Type

Retail(12)