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

Currently Filtered by

Category

Index Tabs And Page Markers

Refine Search

  GO
 
Brand

Post-it®(14)

Avery®(13)

Redi-Tag(4)

Business Source(1)

3M(1)

SKILCRAFT(1)

 
Color

Assorted(5)

Yellow(1)

Orange(1)

Pink(1)

Purple(1)

Aqua(1)

Lime(1)

Multicolor(1)

 
Size

Letter(3)

Legal(1)

 
Recycled

No(30)

Yes(4)

 
Packaged Quantity

24 / Pack(6)

40 / Pack(4)

66 / Pack(4)

36 / Pack(3)

48 / Pack(3)

80 / Pack(2)

1 Pack(1)

900 / Pack(1)

3 / Pack(1)

288 / Box(1)

1 Set(1)

25 / Pack(1)

100 / Pack(1)

60 / Pack(1)

5 / Pack(1)

500 / Pack(1)

4 / Pack(1)

104 / Pack(1)

 
Divider Width

8.5"(2)

 
Divider Color

White(2)

 
Divider Length

11"(2)

 
Tab Title

1-5(1)

11-20(1)

 
Tab Color

Assorted(8)

Pink(5)

Yellow(5)

White(4)

Blue(4)

Red(4)

Green(3)

Aqua(3)

Assorted Pastel(2)

Orange(2)

Multicolor(2)

Neon(2)

Copper(2)

Rose Gold(2)

Silver(2)

Gold(2)

Lime(1)

Violet(1)

Purple(1)

Assorted Metallic(1)

Semi-transparent(1)

Assorted Neon(1)

 
Package Type

Bulk(1)

 
Divider Material

Paper(1)

 
Total Number of Tabs

40(2)

48(1)

216(1)

100(1)

36(1)

 
Tab Material

Poly(1)

Paper(1)

Plastic(1)

 
Tabs per Set

12(2)

8(2)

5(1)

 
Flag/Note Size

0.50" Width x 2" Length(2)

0.75" Width x 2" Length(1)

1" Width x 1.75" Length(1)

1" Width x 0.18" Length(1)

 
Flag/Note Quantity

40 x Yellow(1)

40 x Green(1)

40 x Pink(1)

40 x Orange(1)

500 x Assorted(1)

100(1)

60(1)

900 x Red(1)

900 x Yellow(1)

900 x Blue(1)

900 x Purple(1)

 
Total Number of Dividers

5(2)

8(1)

 
Front Ruling Type

Unruled(3)

 
Tab Width

1"(7)

1.50"(6)

2.50"(5)

2"(4)

0.63"(2)

 
Tab Height

1"(11)

1.50"(4)

2.50"(2)

3"(2)

0.98"(2)

0.43"(1)

 
Manufacturer Part Number

11492(1)

680EGALT(1)

20205(1)

10248(1)

10038(1)

7530013649489(1)

686VAD2(1)

686VAD1(1)

686-RYBT(1)

686-RYB(1)

686RALY(1)

686-PGO(1)

686METAL(1)

686GRDNT(1)

686-ALYR3IN(1)

686ALOPRYT(1)

676AYPV(1)

11493(1)

74786(1)

74762(1)

74763(1)

74773(1)

74774(1)

74776(1)

74785(1)

74801(1)

676ALYR(1)

74865(1)

74866(1)

74867(1)

36622(1)

67010AB(1)

670-5AU(1)

31002(1)

 
Country of Origin

United States(21)

Mexico(11)

Taiwan(1)

China(1)

 
Material

Paper(2)

 
Height

6.13"(1)

 
Width

3.25"(1)

 
Sheet Size

8 1/2" Width x 11" Length(1)

8 1/2" Width x 14" Length(1)

 
Shape

Rectangle(5)

 
Tab Style

Write-on(18)

Printed(2)

 
Adhesive Type

Self-adhesive(8)

Removable(2)

 
Number of Holes Punched

3(3)

 
Dispenser Included

No(2)

Yes(1)

 
 
 

© 2019-2020 Legal Name, All Rights Reserved