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 ('90138')) 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(15)

Lexmark(9)

HP(5)

Brother(4)

Ricoh(3)

Konica Minolta(1)

Kyocera(1)

Samsung(1)

 
Color(s)

Black; Tri-Color(1)

 
Manufacturer Part Number

WT100CL(1)

008R13089(1)

407100(1)

SU437A(1)

006R01146(1)

006R01551(1)

008R12990(1)

008R13036(1)

008R13061(1)

106R02624(1)

402716(1)

108R00575(1)

108R00865(1)

108R00975(1)

108R00982(1)

108R01124(1)

108R01416(1)

109R00754(1)

406665(1)

C950X76G(1)

WT200CL(1)

A06X010(1)

WT300CL(1)

WT320CL(1)

B5L09A(1)

B5L37A(1)

CE254A(1)

CE265A(1)

CE980A(1)

WT860(1)

C930X76G(1)

72K0W00(1)

74C0W00(1)

C52025X(1)

C540X75G(1)

C734X77G(1)

C792X77G(1)

C925X76G(1)

115R00129(1)

 
Country of Origin

CN(29)

JP(4)

VN(2)

IE(1)

NL(1)

CZ(1)

MY(1)

 
For Use With

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

Lexmark C950, X950, X952, X954(1)

Xerox Phaser 6510, WorkCentre 6515(1)

Xerox Phaser 6600, WorkCentre 6605(1)

Xerox Phaser 7800(1)

Xerox Phaser 6700(1)

Xerox Phaser 7500(1)

Xerox Phaser 7750(1)

Xerox Phaser 7100(1)

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

Xerox WorkCentre 7500(1)

Xerox D95, D110, D125, D136(1)

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

Xerox WorkCentre 5845(1)

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

Ricoh Aficio SP C341DN, C430DN(1)

Lexmark C935, X940e, X945e(1)

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

Lexmark C925de, C925dte, X925de(1)

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

Lexmark C734 Series, C736 Series(1)

Lexmark C540, C543, C544, C546dtn, X543, X544, X546dtn(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)

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

Konica Minolta Fax 5600 Series(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 VersaLink C7000(1)

 
Device Types

Laser Printer(19)

Multifunction Laser Printer(17)

Inkjet Printer(1)

Inkjet(1)

Fax(1)

 
Supply Type

Waste Toner Bottle(15)

Waste Toner Box(6)

Waste Toner Cartridge(5)

Toner Collection Unit(4)

Waste Toner Container(4)

Waste Cartridge(2)

Ink Collection Unit(1)

Toner; Waste Container(1)

Waste Tray(1)

 
Page-Yield

36,000(4)

30,000(4)

20,000(2)

25,000(2)

50,000(2)

20000(1)

38,000(1)

30000(1)

27,000(1)

24,000(1)

33,000(1)

43,000(1)

40000(1)

90000(1)

14,000; 3,500(1)

90,000(1)

115,000(1)

150,000(1)

54,000(1)

50000(1)

3,500(1)

21,200(1)

 
Remanufactured

No(37)

 
 
 

© 2020-2021 Dependable Office Supply, All Rights Reserved