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

Currently Filtered by

Category

File Inserts Tabs

Refine Search

  GO
 
Brand

Avery(37)

Post-it Tabs(32)

Pendaflex(17)

Redi-Tag(15)

Smead(8)

Universal(2)

 
Height

1 1/2"(34)

1"(7)

1 1/4"(3)

1 3/4"(3)

3 1/2"(2)

1/2"(2)

9 1/4"(1)

7/16"(1)

13/16"(1)

 
Color(s)

White(22)

Assorted(17)

Assorted Primary(15)

Assorted Pastel(10)

Assorted Neon(7)

Clear(7)

Assorted Brights(6)

Red(3)

Clear Tabs; White Inserts(3)

Blue(3)

Yellow(3)

Pink(2)

Violet(2)

Orange(2)

Green(2)

Olive Green(2)

Manila(1)

Green; Orange(1)

Red; Yellow(1)

Gray(1)

Assorted Fluorescent(1)

 
Manufacturer Part Number

42-PIN(1)

42-RED(1)

42-ORA(1)

42-GRE(1)

42-CR(1)

42-VIO(1)

42-YEL(1)

43-1/2-ORA(1)

43-1/2-PIN(1)

43-1/2-GRE(1)

43-1/2-BLU(1)

43-1/2(1)

42-BLU(1)

242(1)

686-PLOY(1)

686-PLOY3IN(1)

686-PGO(1)

686L-PGO(1)

686L-GBR(1)

686-PWAV(1)

686PWAV3IN(1)

686-VAD1(1)

686-VAD2(1)

686-RYB(1)

686ROYGB(1)

686-RALY(1)

43-1/2-RED(1)

43-1/2-VIO(1)

64615(1)

64626(1)

64600(1)

39170(1)

39020(1)

64627(1)

64910(1)

42215(1)

43313(1)

68080(1)

64915(1)

64912(1)

39017(1)

39000(1)

31002(1)

31005(1)

31001(1)

31000(1)

43-1/2-YEL(1)

31010(1)

31080(1)

33148(1)

33248(1)

33120(1)

33117(1)

33001(1)

686LAPV(1)

686GBR(1)

74754(1)

74755(1)

74753(1)

59112(1)

59106(1)

74756(1)

74757(1)

74761(1)

74762(1)

74760(1)

74759(1)

74758(1)

59105(1)

59102(1)

16228(1)

16230(1)

16221(1)

16219(1)

11137(1)

16239(1)

16241(1)

16283(1)

5567(1)

16282(1)

16281(1)

16280(1)

74763(1)

74764(1)

686A-PWAV(1)

686AWV(1)

686A-PLOY(1)

686ALYR3IN(1)

686-ALYR(1)

686F1(1)

686F-1BB(1)

686F-50WH3IN(1)

686F-50YW(1)

686F-50WH(1)

686F-50RD(1)

686F-50BL(1)

686A-ALYR(1)

686A-50WH(1)

74768(1)

74769(1)

74767(1)

74766(1)

74765(1)

74770(1)

74771(1)

686A1(1)

686A-1BB(1)

6862RY(1)

6862GO(1)

74772(1)

11136(1)

 
Country of Origin

US(74)

MX(37)

 
Width

2"(46)

1"(18)

3 1/2"(16)

3"(6)

7/16"(5)

1 1/8"(4)

2 1/4"(2)

1"; 2"(2)

1/2"(2)

1 1/2"(2)

1 3/4"(2)

1 1/4"(2)

3 1/4"(1)

2 1/16"(1)

1 1/16"(1)

13/16"(1)

 
For Use With

Inkjet/Laser Printers(13)

Hanging Folders(4)

Top Tab Folders, Pockets, Jackets or Wallets.(1)

Hanging Folders/Top Tab Folders(1)

 
Tab Cut

1/3(12)

1/5(11)

01/04/2017(2)

Straight(1)

01/02/2017(1)

2"(1)

 
Tab Material(s)

Plastic(43)

Self-Stick Note Paper(32)

Poly(3)

Reinforced Cloth(3)

Paper(3)

9 1/2 pt. Manila Stock(1)

Durable Paper(1)

Durable plastic(1)

 
Body Color(s)

Clear(62)

White(4)

Clear Tabs; White Inserts(2)

Assorted(2)

Olive Green(2)

Manila(1)

Gray(1)

 
File Insert/Tab Type

Adhesive File Folder Tabs(47)

Hanging Folder Tab Inserts(22)

Repositionable Tab(20)

Printable Hanging File Folder Tabs(6)

Round Tabs(4)

Self-Adhesive File Folder Tabs(4)

Hanging Folder Tabs(3)

Hanging Folder Tab(3)

End Tab Converter(1)

Hanging Folder/File Folder Tab Labels(1)

 
 
 

© 2017-2018 Legal Name, All Rights Reserved