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

Currently Filtered by

Category

Waste Collection

Refine Search

  GO
 
Brand

Lexmark(10)

Xerox(7)

HP(5)

Brother(4)

Ricoh(3)

 
Manufacturer Part Number

WT100CL(1)

C792X77G(1)

108R01124(1)

108R00982(1)

108R00865(1)

108R00575(1)

106R01081(1)

006R01146(1)

407100(1)

406665(1)

402716(1)

C950X76G(1)

C930X76G(1)

C925X76G(1)

C734X77G(1)

WT200CL(1)

C540X75G(1)

C52025X(1)

74C0W00(1)

72K0W00(1)

54G0W00(1)

CE980A(1)

CE265A(1)

CE254A(1)

B5L37A(1)

B5L09A(1)

WT320CL(1)

WT300CL(1)

109R00754(1)

 
Country of Origin

CN(23)

JP(4)

IE(1)

MY(1)

 
For Use With

Brother HL-3040CN, 3070CW; MFC-9010CN, 9120CN, 9320CW(1)

Lexmark C734 Series, C736 Series(1)

Xerox Phaser 7800(1)

Xerox Phaser 7500(1)

Xerox Phaser 7400(1)

Ricoh Aficio SP C341DN, C430DN(1)

Lexmark C950, X950, X952, X954(1)

Lexmark C935, X940e, X945e(1)

Lexmark C925de, C925dte, X925de(1)

Lexmark X792DE, X792DTE, X792DTFE, X792DTME, X792DTPE, X792DTSE(1)

Lexmark C540, C543, C544, C546dtn, X543, X544, X546dtn(1)

Brother HL-4150CDN, 4570CDW, 4570CDWT; MFC-9460CDN, 9560CDW, 9970CDW(1)

Lexmark C52x, C53x(1)

Lexmark CS720de; Lexmark CX725de; Lexmark CX725dhe; Lexmark CS720dte; Lexmark CX725dthe; Lexmark CX725dthe; Lexmark CS725dte(1)

Lexmark CS820dte; Lexmark CS820dtfe; Lexmark CX860de; Lexmark CS820de; Lexmark CX825dtfe; Lexmark CX820de; Lexmark CX825dte; Lexmark CX860dtfe; Lexmark CX860dtfe; Lexmark CX825de; Lexmark CX820dtfe(1)

Lexmark MS911de; Lexmark MX910de; Lexmark MX912dxe; Lexmark MX911dte; Lexmark CX922de; Lexmark CX921de; Lexmark CX923dxe; Lexmark CX923dte; Lexmark CX924dxe; Lexmark CX924dte; Lexmark CS921de; Lexmark CS923de(1)

HP Color LaserJet CP5525dn, CP5525n, CP5525xh(1)

HP Color LaserJet Enterprise CP4025 Series, CP4525 Series(1)

HP Color LaserJet CM3530 MFP Series, CP3525 Series(1)

HP Color LaserJet Enterprise M552dn, MFP M577(1)

HP Officejet Enterprise Color X555dn, X555xh, X585dn, X585f, Color Flow X585z(1)

Xerox Phaser 6600, WorkCentre 6605(1)

 
Device Types

Laser Printer(18)

Multifunction Laser Printer(9)

Inkjet Printer(1)

Inkjet(1)

 
Supply Type

Waste Toner Bottle(9)

Waste Toner Box(6)

Toner Collection Unit(4)

Waste Toner Cartridge(4)

Waste Toner Container(3)

Ink Collection Unit(1)

Waste Cartridge(1)

Waste Tray(1)

 
Page-Yield

30,000(5)

50,000(3)

36,000(3)

20,000(2)

20000(1)

3,500(1)

50000(1)

54,000(1)

150,000(1)

115,000(1)

90,000(1)

25,000(1)

40000(1)

90000(1)

27000(1)

 
Remanufactured

No(25)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved