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

Currently Filtered by


Avery

Refine Search

  GO
 
Category Filter

Index Dividers(482)

Labels(283)

Binders(265)

File Inserts/Tabs(45)

Name Badge Kits(36)

Tags(32)

Sheet Protectors(29)

Markers(26)

Business Cards(20)

Pocket Folders(18)

Highlighters(15)

Greeting Cards(14)

Media Labeling(14)

Adhesives/Glues(10)

Tent Cards(8)

File Jackets/Sleeves/Wallets(6)

Report Covers(5)

Legal Index Dividers(4)

Binder Spine Inserts(4)

Hole Reinforcements(3)

Binder Pockets(3)

Office Paper(3)

Media Sleeves(2)

Laminator Supplies(2)

Art Paper(2)

Photo Albums(2)

Pens(2)

Filler Paper(1)

Sheet Lifters(1)

Label Applicators(1)

Board Erasers(1)

Label Holders(1)

Card File Refills(1)

Desktop File Folder Sorters(1)

Magnetic Printable Sheets(1)

Index Cards(1)

 
Brand

Avery(1340)

Avery®(4)

 
Recycled

Yes(4)

 
Height

1.5"(18)

1"(11)

11"(5)

1.75"(3)

11 1/4"(2)

0.81"(2)

10.5"(1)

12.88"(1)

1 1/4"(1)

3"(1)

11 3/4"(1)

 
Color(s)

Clear(41)

White(20)

Manila(17)

Assorted(15)

Assorted Primary(9)

Assorted Neon(7)

Assorted Pastel(6)

Black(4)

Semi-Clear(3)

Olive Green(2)

Assorted Metallic(2)

Fluorescent Yellow(2)

Yellow(2)

Light Pink(1)

Red(1)

Light Blue(1)

Assorted Patterns(1)

Assorted Geometric(1)

Blue(1)

Assorted Dots(1)

Translucent Clear(1)

Fluorescent Blue(1)

Red/Black(1)

Matte White(1)

Fluorescent Orange(1)

Fluorescent Purple(1)

Green(1)

Gray(1)

Manila/White(1)

 
Depth

11.5"(1)

1 7/8"(1)

 
Quantity

40 per pack(4)

20 per pack(4)

100 per pack(2)

30 per pack(1)

50 per pack(1)

250 per pack(1)

375 per pack(1)

 
Size

4 3/4 x 2 3/8(10)

Letter(5)

6 1/4 x 3 1/8(4)

1 1/4 dia.(3)

3 3/4 x 1 7/8(3)

5 1/4 x 2 5/8(3)

9" x 12"(2)

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

3 1/4 x 1 15/16(1)

8 1/2 x 11(1)

2 x 3 1/2(1)

3 1/2 x 2(1)

3 1/4 x 1 5/8(1)

2 3/4 x 1 11/16(1)

1 3/4 x 1 3/32(1)

4 1/4 x 2 1/8(1)

2 1/4 dia.(1)

 
Refillable

Nonrefillable(2)

 
Closure

Fold-Over Flap(1)

 
Diameter

1/4"(3)

 
Binder Sheet Size

11 x 8.5(248)

8.5 x 5.5(8)

14 x 8.5(5)

11 x 17(4)

 
Binder Style

View(170)

Non-View(94)

Easel(1)

 
Paper Color(s)

White(20)

Ivory(9)

Matte White(5)

Uncoated White(4)

Textured Uncoated White(2)

Glossy White(1)

Embossed Matte Ivory(1)

 
Hole-Punched

3-Hole Punched(2)