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

Currently Filtered by

Category

File Folder Strips

Refine Search

  GO
 
Brand

Dell(6)

Tabbies(4)

 
Color(s)

Clear(3)

White(1)

 
Size

3 1/4 x 9 1/2(1)

3.5 x 2(1)

2 x 8(1)

2 x 11(1)

 
Manufacturer Part Number

310-5811(1)

9PN5P(1)

C920K(1)

KGR81(1)

KVK63(1)

PK496(1)

55993(1)

58385(1)

68386(1)

68387(1)

 
Country of Origin

US(4)

China(3)

Mexico(1)

 
Material(s)

Polypropylene(3)

Card Stock(1)

 
Weight (Approximate)

4.40 lb(1)

 
Print Technology

Laser(6)

 
Print Color

Black(5)

 
Typical Print Yield

24000(2)

35000(1)

30000(1)

 
Device Supported

Printer(2)

 
Product Type

Imaging Drum(6)

 
Packaged Quantity

1 Each(4)

1(1)

 
Product Model

310-5811(1)

C920K(1)

 
Compatibility

Dell 5100CN Printer(1)

Dell Printers:

  • B5460dn
  • B5465dnf
(1)

Dell 1235CN Printer

(1)

Dell Color Laser Printers:

  • 1320c
  • 1320cn
  • 1320c Network
  • 2130cn
  • 2135cn
  • 2150cdn
  • 2150cn

Dell Multifunction Color Laser Printer:

  • 2155cdn
  • 2155cn
(1)

Dell Multifunction Printers:

  • B2360D
  • B2360DN
  • B3460DN
  • B3465DN
  • B3465DNF
(1)

Dell Laser Printers:

  • 2330d
  • 2330dn
  • 2350d
  • 2350dn
  • 3330dn
  • 3333dn
  • 3335dn
(1)

 
Package Type

OEM(2)

Retail(1)

 
 
 

© 2020-2021 BonTay, Inc., All Rights Reserved