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

Currently Filtered by

Category

Index Cards

Refine Search

  GO
 
Brand

Oxford(25)

Business Source(6)

TOPS(4)

Mead(3)

Roaring Spring(2)

Avery®(1)

Exact(1)

 
Color

White(12)

Blue(4)

Cherry(3)

Green(3)

Canary(3)

Violet(3)

Orange(1)

Yellow(1)

Pink(1)

 
Brightness

97(1)

 
Recycled

No(36)

Yes(6)

 
Height

0.3"(1)

 
Manufacturer Part Number

5388(1)

61100(1)

40285(1)

40286(1)

40BD(1)

41(1)

50(1)

50BX(1)

51(1)

7320BLU(1)

40280(1)

7320CAN(1)

7320CHE(1)

7320GRE(1)

7420BLU(1)

7420CAN(1)

7420GRE(1)

28335(1)

28346(1)

40282(1)

40279(1)

65258(1)

02035(1)

65259(1)

65260(1)

65261(1)

65262(1)

65263(1)

63072(1)

63074(1)

63352(1)

04736(1)

40(1)

10009(1)

10010(1)

11314(1)

30(1)

30BD(1)

31(1)

34610(1)

35810(1)

49521(1)

 
Country of Origin

United States(31)

Mexico(7)

China(2)

India(2)

 
Width

5"(1)

 
Weight (Approximate)

1 lb(1)

 
Length

3"(1)

3.5"(1)

 
Sheet Size

3" x 5"(14)

4" x 6"(7)

5" x 8"(4)

5" Width x 3" Length(2)

6" Width x 4" Length(2)

8" Width x 5" Length(2)

5" x 3"(2)

3" Width x 5" Length(1)

3" x 2 1/2"(1)

6" x 4"(1)

3 1/2" x 5"(1)

6" x 4 1/2"(1)

8 1/2" x 11"(1)

 
Print Technology

Laser(2)

Inkjet(2)

 
Tab Style

Print-on(1)

 
Binding Type

Spiral Bound(1)

 
Number of Sheets

100(8)

50(2)

200(1)

 
Product Condition

New(1)

 
Sheet Type

Plain(8)

Printed(1)

 
Divider Width

5"(1)

2.5"(1)

 
Divider Length

3"(2)

 
Basis Weight

85 lb(10)

100 lb(2)

90 lb(1)

43 lb(1)

110 lb(1)

 
Adhesive Type

Self-adhesive(1)

Removable(1)

 
Number of Pages

100(1)

 
Number of Holes Punched

2(1)

3(1)

 
Tabs per Set

5(1)

 
Surface Finish

Smooth(1)

 
Binding Location

Top(1)

 
Front Lines Space

0.25" Ruled(1)

 
Total Number of Dividers

200(1)

 
Front Ruling Type

Unruled(1)

Ruled(1)

Narrow Ruled(1)

 
Ruling Surface Side

Front(2)

Both Side(1)

 
Grammage

160 g/m²(1)

 
Back Ruling Type

Unruled(2)

 
Product Type

Printable Index Card(16)

Note Card(10)

Index Card(8)

Notepad(5)

Index Card Guide(1)

Tab Divider(1)

Index Paper(1)

 
Packaged Quantity

100 / Pack(15)

100 Pack(12)

1 Each(4)

1 / Pack(2)

200 / Pack(2)

500 / Bundle(2)

150 / Box(1)

25 / Box(1)

50 / Each(1)

500 / Box(1)

250 / Pack(1)

 
Assembly Required

No(15)

 
Product Line

Environotes(1)

 
Divider Color

White(2)

Red(1)

Blue(1)

Black(1)

Clear(1)

 
Sheet Color

White(4)

Blue(3)

Green(3)

Cherry(2)

Canary(2)

Buff(1)

Orange(1)

Assorted(1)

 
Cover Color

White(1)

 
Package Type

Retail(1)