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

Currently Filtered by

Category

Typewriter Correction Ribbons

Refine Search

  GO
 
Brand

Brother(2)

 
Color

Black(1)

 
Recycled

No(1)

 
Packaged Quantity

1 Each(1)

6 / Pack(1)

 
Assembly Required

No(1)

 
Compatibility

Brother Typewriters:

  • AX10
  • AX110
  • AX12
  • AX12M
  • AX15
  • AX15M
  • AX20
  • AX22
  • AX24
  • AX25
  • AX250
  • AX26
  • AX28
  • AX300
  • AX325
  • AX350
  • AX400
  • AX425
  • AX450
  • AX475
  • AX500
  • AX525
  • AX550
  • AX600
  • AX625
  • COM300
  • COM300M
  • COM310
  • CORRECTRONIC140
  • CORRECTRONIC145
  • CORRECTRONIC300
  • CORRECTRONIC300M
  • CORRECTRONIC310
  • CORRECTRONIC320
  • CORRECTRONIC340
  • CORRECTRONIC350
  • CORRECTRONIC355
  • CORRECTRONIC360
  • CORRECTRONIC380
  • EM30
  • EM31
  • EM31II
  • EM350
  • EM350E
  • GX6000
  • GX6500
  • GX6750
  • GX6750SP
  • GX7000
  • GX7500
  • GX7750
  • GX8000
  • GX8250
  • GX8500
  • GX8750
  • GX9000
  • GX9500
  • GX9750
  • HQ220
  • ML100
  • ML300
  • ML500
  • SX14
  • SX16
  • SX23
  • SX4000
  • WP1150
  • WP1250
  • WP1350DS
  • WP1400D
  • WP1450DS
  • WP1500D
  • WP1600D
  • WP1700MDS
  • WP1800
  • WP2200
  • WP230B
  • WP2400
  • WP2410
  • WP2410DS
  • WP2450DS
  • WP2500Q
  • WP2600Q
  • WP2800Q
  • WP330MDS
  • WP335B
  • WP3400
  • WP3410
  • WP3550
  • WP3600D
  • WP3650D
  • WP3900DS
  • WP480
  • WP490
  • WP4U
  • WP5500DS
  • WP5550MDS
  • WP5550MDSPLUS
  • WP5600MDS
  • WP5750DS
  • WP5850MDS
  • WP5900MDS
  • WP60
  • WP620
  • WP65
  • WP660
  • WP66E
  • WP760D
  • WPT470
  • ZX1700
  • ZX1900
  • ZX30
  • ZX50
(1)

  • 7500, 7600, AX10, AX110, AX12, AX12M, AX15, AX15M, AX20, AX22, AX24, AX25, AX250, AX26, AX28, AX300, AX325, AX350, AX400, AX425, AX450, AX475, AX500, AX525, AX550, AX600, AX625, CE222, CE25, CE333, CE35, CE40, CE400, CE45, CE50, CE50XL, CE555, CE58, CE60, CE65, CE666, CE68, CE70, CM1000, COM300, COM300M, COM310, CORRECTRONIC140, CORRECTRONIC145, CORRECTRONIC300, CORRECTRONIC300M, CORRECTRONIC310, CORRECTRONIC320, CORRECTRONIC340, CORRECTRONIC350, CORRECTRONIC355, CORRECTRONIC360, CORRECTRONIC380, CX440, CX80, CX90, CX95, EM1000, EM1050, EM1050D, EM2000, EM2050D, EM250, EM30, EM31, EM31II, EM350, EM350E, EM401, EM411, EM430, EM430SP, EM450, EM530, EM530SP, EM550, EM601, EM605, EM605SP, EM611, EM630, EM630SP, EM701, EM701FX, EM711, HR10, HR15, HR15XL, HR20, HR25, HR35, HR40, PERFECTYPE, WP1150, WP1250, WP1350DS, WP1400D, WP1450DS, WP1500D, WP1600D, WP1700MDS, WP1800, WP200, WP2200, WP230B, WP2400, WP2410, WP2410DS, WP2450DS, WP2500Q, WP2600Q, WP2800Q, WP330MDS, WP335B, WP3400, WP3410, WP3550, WP3600D, WP3650D,WP3900DS, WP480, WP490, WP4U, WP500, WP510, WP55, WP5500DS, WP5550MDS, WP5550MDSPLUS, WP5600MDS, WP5750DS, WP5850MDS, WP5900MDS, WP60, WP620, WP65, WP650, WP660, WP660E, WP680, WP700D, WP720, WP75, WP760D, WP760DPLUS, WP80, WP800MDS, WP800MDSSP, WP85, WP90, WP900MDS, WP95, WPT480, ZX3000
(1)

 
Print Technology

Inkjet(1)

 
Print Color

Black(1)

 
Typical Print Yield

50000 Pages(1)

 
Manufacturer Part Number

1030(1)

3015(1)

 
Country of Origin

China(2)

 
 
 
 
 

© 2020-2021 Bayshore Office Products, Inc., All Rights Reserved