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

Currently Filtered by

Category

Solid Ink Sticks

Refine Search

  GO
 
Brand

Xerox(15)

Katun(3)

 
Packaged Quantity

2 / Box(4)

3 / Box(3)

4 / Pack(3)

6 / Box(3)

 
Limited Warranty

2 Year(3)

 
Compatibility

Xerox ColorQube 8870 Printer(4)

Xerox Phaser Printers:

  • 8560DN
  • 8560DT
  • 8560N
  • 8560DX
  • 8560D
  • 8560N
  • 8560X
  • 8560MFP
(3)

Xerox ColorQube Printers:

  • 9201
  • 9202
  • 9203
  • 9301
  • 9302
  • 9303
(3)

Xerox ColorQube 8700 Printer

(3)

Xerox ColorQube 8900 Printer

(3)

Xerox Phaser Printers:

  • 8560
  • 8560/DT
  • 8560/DX
  • 8560DN
  • 8560MFP
  • 8560N
(1)

Xerox ColorQube 8570 Printer(1)

 
Print Technology

Solid Ink(18)

 
Print Color

Black(7)

Yellow(4)

Magenta(4)

Cyan(3)

 
Typical Print Yield

3400 Pages(3)

2883 Pages(3)

37000 Pages(2)

4200(2)

40000 Pages(1)

4300 Pages(1)

2783 Pages(1)

18000(1)

 
Compatible to OEM Part Number

108R00723(1)

108R00725(1)

108R00726(1)

 
Manufacturer Part Number

37991(1)

108R00952(1)

108R01016(1)

108R01015(1)

108R00993(1)

108R00992(1)

108R00991(1)

108R00953(1)

108R00951(1)

37993(1)

108R00950(1)

108R00929(1)

108R00832(1)

108R00830(1)

108R00829(1)

108R00726(1)

37994(1)

108R01017(1)

 
Country of Origin

United States(18)

 
Yield Type

Standard(8)

 
 
 
 
 

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