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

Currently Filtered by

Category

Vacuum Cleaner Bags

Refine Search

  GO
Brand

Janitized(23)

Sanitaire(15)

Hoover Commercial(13)

Oreck Commercial(4)

Shop-Vac(3)

DataVac(3)

VacFX(1)

Country of Origin

CN(57)

VN(3)

MX(1)

US(1)

For Use With

Oreck U2000R-1, U2000RB-1, XL2100RHS(3)

Electrolux Sanitaire SC600 & SC800 Series(3)

Hoover CH50400(2)

Hoover CH54013, CH54113, CH54015, CH54115(2)

Electrolux Sanitaire SC412(2)

Electrolux Sanitaire Style Z Series(2)

Electrolux Sanitaire SC9100 Series(2)

SC5700/SC5800(2)

Hoover CH50100, CH50102(2)

Electrolux Sanitaire SC5745, SC5815, SC5845, SC5713(1)

Fro Pro Data-Vac models MDV-3TCA, DV3ESD1, MDV-2TCA and MDV-2TA(1)

Advance Spectrum CarpetMaster Paper Bag; OEM #1471058500(1)

SHO-5872410(1)

Electrolux Sanitaire SC3700A(1)

Hoover Commercial Back Pack Vacuum C2401(1)

Hoover CH32008(1)

Data-Vac Pro MDV-3TCA; 3ESD1; 2TCA; 2TA(1)

Data-Vac MDV-1BA(1)

HVR-C1703900(1)

Hoover CH34006(1)

SC3683A; SC3683B(1)

Nilfisk CarpeTwin Upright 16XP/20XP Paper Bag; OEM #323153(1)

Panasonic Upright Type U Paper Bag; OEM #MC-115PT(1)

ProTeam 10 Qt. Super Coach, MegaVac Paper Bag; OEM #100331(1)

Karcher/Tornado CV30/1, CV38/2 & CV48/2 Paper Bag; OEM #6.904-294.0(1)

Eureka Mighty Mite Paper Bag; OEM #60295(1)

Nobles Portapac/Tennant Backpack Paper Bag; OEM #611780(1)

Eureka F & G Paper Bag; OEM #54924A(1)

ProTeam 6 Qt. QuarterVac Paper Bag; OEM #100431(1)

ProTeam Super Coach Pro 10 Qt.; OEM #107313(1)

Electrolux Sanitaire EUK-SC785AT-1(1)

Advance VU500, Triple S Triumph; OEM #107407587(1)

Windsor Sensor S/S2 & XP, Versamatic Plus; Karcher Prochem PV12 & U-Vac UPV12; Sanitaire EON; Kenmore 50015; Triple S Prosense; OEM #5300(1)

Windsor Versamatic Paper Bag; OEM #2003(1)

ProTeam Super Coach Pro 6, GoFree Pro & ProVac FS 6 Qt.; OEM #107314(1)

Windsor Sensor S, S2, XP, Versamatic Plus; OEM #5300(1)

Carpet Pro CPU, CleanMax Standard and Pro Series, Fuller FB90/95, Tennant V-SMU-14, Tornado CK14 PRO; OEM #9007743(1)

Style

MM(1)

Size Group

Standard(4)

XL Standard Filtration(2)

XL Advanced Filtration(2)

Allergen SB(2)

Style LS(2)

Hepa CC1(1)

Shoulder Vac Pro(1)

Allergen C1(1)

10-14 gallon(1)

One Size Fits All(1)

Allergen Q(1)

Standard CU2(1)

Allergen B(1)

Standard Q(1)

PortaPower(1)

Type

Premium Allergen Bag(1)

Capacity Range (Volume)

2 gal - 2.5 gal(1)

15 gal - 22 gal(1)

4 qt(1)

9.5 qt(1)

6 qt(1)

10 qt(1)

OEM/Compatible

OEM(31)

Compatible(24)

Yes(2)

Special Features

For ProTeam(4)

For Windsor(4)

For Nilfisk-Advance(3)

Allergen SB(2)

XL Advanced Filtration(2)

XL Standard Filtration(2)

Style LS(2)

For Nobles/Tennant/Castex(2)

For Eureka(2)

HEPA CC1(1)

Allergen C1(1)

Standard Q(1)

Fits 2-2.5 Gallon Tanks(1)

Fits 15-22 Gallon Tanks(1)

Fits 10-14 gallon tanks(1)

For Electrolux(1)

For Carpet Pro, CleanMax, Fuller, Tennant(1)

Allergen Q(1)

For Panasonic(1)

For NSS(1)

For Karcher/Tornado(1)

For Sanitaire(1)

For Advance(1)

For Hoover(1)

Allergen B(1)

For Advance Spectrum(1)

Standard CU2(1)

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

© 2020-2021 United Supply Corp, All Rights Reserved