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_19` 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','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 '%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(489)

Labels(289)

Binders(264)

File Inserts/Tabs(45)

Name Badge Kits(36)

Tags(32)

Sheet Protectors(30)

Markers(28)

Business Cards(20)

Pocket Folders(18)

Highlighters(18)

Greeting Cards(14)

Media Labeling(14)

Adhesives/Glues(11)

Tent Cards(8)

File Jackets/Sleeves/Wallets(6)

Report Covers(5)

Binder Spine Inserts(4)

Hole Reinforcements(4)

Office Paper(3)

Binder Pockets(3)

Photo Albums(2)

Media Sleeves(2)

Laminator Supplies(2)

Art Paper(2)

Pens(2)

Index Cards(1)

Card File Refills(1)

Board Erasers(1)

Filler Paper(1)

Desktop File Folder Sorters(1)

Label Holders(1)

Presentation / View Binders(1)

Label Applicators(1)

Sheet Lifters(1)

Magnetic Printable Sheets(1)

 
Brand

Avery(1360)

Avery®(1)

 
Color

White(1)

 
Binder Capacity

1"(1)

 
Recycled

No(1)

 
Height

1.5"(18)

1"(11)

11"(5)

1.75"(3)

11 1/4"(2)

0.81"(2)

1 1/4"(1)

3"(1)

12.88"(1)

11 3/4"(1)

10.5"(1)

 
Color(s)

Clear(42)

White(21)

Manila(17)

Assorted(15)

Assorted Primary(9)

Assorted Neon(7)

Assorted Pastel(6)

Black(4)

Fluorescent Yellow(3)

Semi-Clear(3)

Assorted Metallic(2)

Yellow(2)

Olive Green(2)

Assorted Dots(1)

Fluorescent Purple(1)

Assorted Patterns(1)

Translucent Clear(1)

Gray(1)

Fluorescent Pink(1)

Fluorescent Orange(1)

Fluorescent Green(1)

Fluorescent Blue(1)

Matte White(1)

Manila/White(1)

Red/Black(1)

Green(1)

Blue(1)

Red(1)

Light Pink(1)

Light Blue(1)

Assorted Geometric(1)

 
Depth

1 7/8"(1)

11.5"(1)

 
Quantity

20 per pack(4)

40 per pack(4)

100 per pack(2)

250 per pack(1)

50 per pack(1)

375 per pack(1)

30 per pack(1)

 
Size

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

Letter(5)

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

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

1 1/4 dia.(3)

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

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

9" x 12"(2)

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

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

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

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

2 1/4 dia.(1)

2 x 3 1/2(1)

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

8 1/2 x 11(1)

3 1/2 x 2(1)

 
Packing Type

Stick(11)

 
Closure

Fold-Over Flap(1)

 
Diameter

1/4"(4)

 
Binder Sheet Size

11 x 8.5(247)

8.5 x 5.5(8)

14 x 8.5(5)

11 x 17(4)

 
Binder Style

View(169)

Non-View(94)

Easel(1)

 
Paper Color(s)

White(20)

Ivory(9)

Matte White(5)

Uncoated White(4)

Textured Uncoated White(2)

Embossed Matte Ivory(1)

Glossy White(1)

 
Hole-Punched

3-Hole Punched(2)

 
 
 

© 2020-2021 Office Industries Corporation, All Rights Reserved