SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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_cost`=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 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(17)

Lexmark(10)

HP(6)

Ricoh(4)

Brother(4)

Samsung(1)

Kyocera(1)

Konica Minolta(1)

Color(s)

Black; Tri-Color(1)

Country of Origin

CN(33)

JP(5)

CZ(2)

VN(1)

MY(1)

NL(1)

IE(1)

For Use With

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

Xerox WorkCentre 5845(1)

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

Ricoh Aficio SP C341DN, C430DN(1)

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

Lexmark C935, X940e, X945e(1)

Lexmark C950, X950, X952, X954(1)

Xerox D95, D110, D125, D136(1)

Xerox WorkCentre 7500(1)

Xerox Phaser 7800(1)

Xerox Phaser 6600, WorkCentre 6605(1)

Xerox VersaLink C7000(1)

Xerox Phaser 6700(1)

Xerox Phaser 7500(1)

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

Xerox Phaser 7100(1)

Lexmark C925de, C925dte, X925de(1)

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

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

HP Color LaserJet Enterprise M552dn, MFP M577(1)

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

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

Konica Minolta Fax 5600 Series(1)

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

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

Lexmark C734 Series, C736 Series(1)

Lexmark C52x, C53x(1)

Lexmark CS720de; Lexmark CX725de; Lexmark CX725dhe; Lexmark CS720dte; Lexmark CX725dthe; Lexmark CX725dthe; Lexmark CS725dte(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)

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

Device Types

Laser Printer(23)

Multifunction Laser Printer(17)

Inkjet Printer(2)

Fax(1)

Inkjet(1)

Supply Type

Waste Toner Bottle(16)

Waste Toner Cartridge(7)

Waste Toner Box(6)

Waste Toner Container(5)

Toner Collection Unit(5)

Waste Cartridge(2)

Waste Tray(1)

Ink Collection Unit(1)

Toner; Waste Container(1)

Page-Yield

36,000(4)

30,000(4)

50,000(3)

25,000(2)

20,000(2)

38,000(1)

33,000(1)

43,000(1)

24,000(1)

21,200(1)

27000(1)

90000(1)

44000(1)

30000(1)

27,000(1)

150,000(1)

54,000(1)

50000(1)

3,500(1)

100,000(1)

115,000(1)

40000(1)

20000(1)

90,000(1)

14,000; 3,500(1)

Remanufactured

No(38)

Market Indicator (Cartridge Number)

008R12896(1)

106R02624(1)

108R01124(1)

115R00129(1)

006R01146(1)

CLT-W506(1)

HP 648A(1)

CS820; Cx8xx(1)

CS72x; CX725(1)

HP 504A(1)

OEM/Compatible

OEM(44)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2020-2021 United Supply Corp, All Rights Reserved