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

Currently Filtered by

Category

Reclosable Poly Bags

Refine Search

  GO
 
Brand

Xerox(15)

Lexmark(11)

HP(7)

Brother(4)

Ricoh(2)

Samsung(2)

Kyocera(1)

 
For Use With

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

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

Ricoh Aficio SP C341DN, C430DN(1)

Samsung CLX-8640ND, CLX-8650ND(1)

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

Xerox WorkCentre 5845(1)

Xerox C8130, C8145, C8155, C8170(1)

Xerox D95, D110, D125, D136(1)

Xerox WorkCentre 7500(1)

Xerox C310(1)

Lexmark C950, X950, X952, X954(1)

Xerox C230, C235 Color Multifunction Printer(1)

Xerox VersaLink C625(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)

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

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

Brother HL-L3220CDW, HL-L3280CDW, HL-L3295CDW, HL-L3300CDW, HL-L8245CDW, MFCL3720CDW, MFC-L3765CDW, MFC-L3780CDW, MFC-L8395CDW(1)

HP Color LaserJet CP5525dn, CP5525n, CP5525xh(1)

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

Brother HL-L9410CDN, L9430CDN, L9470CDN, EX470W; MFC-L9610CDN, L9630CDN, L9670CDN, EX670W(1)

HP Enterprise MFP x577, x654, x677, 6700, 6800 SFP(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 Enterprise M652dn, M652n, M653dh, M653dn, M653x(1)

Lexmark C734 Series, C736 Series(1)

Lexmark C3426dw, CS431dw, CX431adw(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 CS730, CX730, CX735, C4342, X4342, C4352(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 CS943, CX942, CX943, CX944, XC9445,XC9455, XC9465(1)

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

Lexmark CX930, CX931, XC9325, XC9335(1)

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

Xerox VersaLink C7000(1)

 
Country of Origin

CN(30)

VN(5)

JP(4)

US(1)

NL(1)

CZ(1)

 
Color(s)

Black; Tri-Color(1)

Black(1)

 
OEM/Compatible

OEM(42)

 
Device Types

Laser Printer(26)

Multifunction Laser Printer(13)

Inkjet Printer(2)

Inkjet(1)

 
Supply Type

Waste Toner Bottle(12)

Waste Toner Container(9)

Toner Collection Unit(6)

Waste Toner Cartridge(6)

Waste Toner Box(5)

Toner(2)

Ink Collection Unit(1)

Toner Waste Cartridge(1)

 
Remanufactured

No(42)

 
Page-Yield

50,000(4)

20,000(3)

36,000(3)

25,000(3)

100,000(2)

30,000(2)

15,000(2)

170,000(2)

24,000(1)

33,000(1)

43,000(1)

69,000(1)

38,000(1)

14,000; 3,500(1)

40,000(1)

27,000(1)

3,500(1)

90,000(1)

35,000(1)

115,000(1)

150,000(1)

54,000(1)

400,000(1)

21,200(1)

 
Yield Type

Standard(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved