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

Xerox(14)

Lexmark(10)

HP(6)

Brother(4)

Ricoh(4)

Konica Minolta(1)

Kyocera(1)

Samsung(1)

 
Color(s)

Black; Tri-Color(1)

 
Manufacturer Part Number

WT100CL(1)

008R13036(1)

405783(1)

406665(1)

407100(1)

SU437A(1)

006R01146(1)

006R01551(1)

008R12990(1)

008R13061(1)

C950X76G(1)

008R13089(1)

106R02624(1)

108R00865(1)

108R00975(1)

108R00982(1)

108R01124(1)

108R01416(1)

109R00754(1)

402716(1)

C930X76G(1)

WT200CL(1)

P1B94A(1)

WT300CL(1)

WT320CL(1)

B5L09A(1)

B5L37A(1)

CE254A(1)

CE265A(1)

CE980A(1)

A06X010(1)

C925X76G(1)

WT860(1)

54G0W00(1)

72K0W00(1)

74C0W00(1)

C52025X(1)

C540X75G(1)

C734X77G(1)

C792X77G(1)

115R00129(1)

 
Country of Origin

CN(31)

JP(4)

VN(2)

IE(1)

NL(1)

CZ(1)

MY(1)

 
For Use With

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

Xerox WorkCentre 7500(1)

Ricoh SG 3100SNw, 3110DN, 3110DNw, 3110SFNw, 7100DN(1)

Ricoh Aficio SP C341DN, C430DN(1)

Samsung CLP-680ND Series; CLX-6260FD, 6260FW(1)

Xerox WorkCentre 5845(1)

Xerox DocuColor 240, 250; WorkCentre 7655, 7665(1)

Xerox D95, D110, D125, D136(1)

Xerox WorkCentre 7120, 7125, 7220, 7225(1)

Lexmark C935, X940e, X945e(1)

Xerox Phaser 7100(1)

Xerox Phaser 7500(1)

Xerox Phaser 6700(1)

Xerox Phaser 7800(1)

Xerox Phaser 6600, WorkCentre 6605(1)

Xerox Phaser 6510, WorkCentre 6515(1)

Lexmark C950, X950, X952, X954(1)

Lexmark C925de, C925dte, X925de(1)

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

Konica Minolta Fax 5600 Series(1)

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

HP Color LaserJet Enterprise M552dn, MFP M577(1)

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

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

HP Color LaserJet CP5525dn, CP5525n, CP5525xh(1)

HP Color LaserJet Enterprise M652dn, M652n, M653dh, M653dn, M653x(1)

Kyocera TASKalfa 3050CI, 3500I, 3550CI, 4500I, 4550CI, 5500I, 5550CI, FSC8650DN(1)

Lexmark X792DE, X792DTE, X792DTFE, X792DTME, X792DTPE, X792DTSE(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)

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

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

Lexmark C52x, C53x(1)

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

Lexmark C734 Series, C736 Series(1)

Xerox VersaLink C7000(1)

 
Device Types

Laser Printer(20)

Multifunction Laser Printer(17)

Inkjet Printer(2)

Inkjet(1)

Fax(1)

 
Supply Type

Waste Toner Bottle(15)

Waste Toner Box(6)

Waste Toner Container(6)

Toner Collection Unit(5)

Waste Toner Cartridge(4)

Waste Cartridge(2)

Ink Collection Unit(1)

Toner; Waste Container(1)

Waste Tray(1)

 
Page-Yield

30,000(4)

36,000(4)

50,000(3)

25,000(2)

20,000(2)

14,000; 3,500(1)

30000(1)

24,000(1)

33,000(1)

43,000(1)

38,000(1)

90000(1)

20000(1)

40000(1)

27,000(1)

90,000(1)

115,000(1)

100,000(1)

150,000(1)

54,000(1)

50000(1)

3,500(1)

21,200(1)

 
Remanufactured

No(38)

 
 
 

© 2020-2021 Desert West Office Supply, All Rights Reserved