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 ('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_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 '%VacuumCleanerBags' THEN 1 ELSE 0 END DESC, 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(15)

Sanitaire(15)

Hoover Commercial(9)

Oreck Commercial(3)

DataVac(2)

Shop-Vac(2)

VacFX(1)

 
Manufacturer Part Number

ADVU500210(1)

AH10170(1)

63881A-10(1)

63881A-10CT(1)

67715C6(1)

6810310(1)

68440-10(1)

401000BP(1)

4010100Y(1)

4010103B(1)

AH10143(1)

AH10243(1)

63262B-10(1)

AH10273(1)

AH10363(1)

AH10370(1)

DV-5PBRP(1)

TBF-7C(1)

PK800025(1)

PK800025DW(1)

PK80009(1)

9067200(1)

63262B10CT(1)

63256A-10CT(1)

JANADVSPEC21(1)

JANPTSCP102(1)

JAN-CMPRO-2(1)

JAN-CXBP-2(1)

JAN-EUFG10(1)

JAN-EUMM3(1)

JAN-KACV30-2(1)

JANNFCPTW162(1)

JAN-PAU-2(1)

JANPTMV2(1)

JAN-PTQV-2(1)

JAN-PTSCP6-2(1)

63256A-10(1)

JAN-WISEN-3(1)

JAN-WIVER-3(1)

VFXW15300310(1)

61125B10(1)

62370A10(1)

62370A10CT(1)

63213B-10(1)

63213B10CT(1)

63253A10(1)

9067300(1)

 
Country of Origin

CN(44)

VN(2)

US(1)

 
For Use With

Electrolux Sanitaire SC600 & SC800 Series(3)

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

Hoover CH54013, CH54113, CH54015, CH54115(2)

SC5700/SC5800(2)

Electrolux Sanitaire SC9100 Series(2)

Electrolux Sanitaire Style Z Series(2)

Electrolux Sanitaire SC412(2)

Hoover CH50100, CH50102(2)

Hoover CH34006(1)

SC3683A; SC3683B(1)

HVR-C1703900(1)

Hoover Commercial Back Pack Vacuum C2401(1)

Electrolux Sanitaire SC3700A(1)

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

Hoover CH32008(1)

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

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

Hoover C1320, CH53000(1)

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

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

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

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

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

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

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

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

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

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

Electrolux Sanitaire EUK-SC785AT-1(1)

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

ProTeam Super Coach Pro 10 Qt.; OEM #107313(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)

Windsor Versamatic Paper Bag; OEM #2003(1)

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

SHO-5872410(1)

 
Style

MM(1)

 
Size Group

Standard(3)

Style LS(2)

Allergen SB(2)

XL Standard Filtration(2)

Allergen B(1)

Standard CU2(1)

One Size Fits All(1)

Allergen C1(1)

Hepa CC1(1)

XL Advanced Filtration(1)

10-14 gallon(1)

 
Type

Premium Allergen Bag(1)

 
Capacity Range (Volume)

10 qt(1)

6 qt(1)

9.5 qt(1)

4 qt(1)

15 gal - 22 gal(1)

 
 
 

© 2020-2021 Office Solutions & Innovations, Inc., All Rights Reserved