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','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(476)

Labels(280)

Binders(261)

File Inserts/Tabs(45)

Name Badge Kits(36)

Tags(30)

Sheet Protectors(29)

Markers(26)

Business Cards(20)

Pocket Folders(18)

Highlighters(15)

Greeting Cards(14)

Media Labeling(13)

Adhesives/Glues(10)

Tent Cards(8)

File Jackets/Sleeves/Wallets(6)

Report Covers(5)

Binder Spine Inserts(4)

Legal Index Dividers(4)

Binder Pockets(3)

Office Paper(3)

Hole Reinforcements(3)

Photo Albums(2)

Pens(2)

Art Paper(2)

Laminator Supplies(2)

Media Sleeves(2)

Card File Refills(1)

Index Cards(1)

Filler Paper(1)

Desktop File Folder Sorters(1)

Label Holders(1)

Label Applicators(1)

Sheet Lifters(1)

Magnetic Printable Sheets(1)

Board Erasers(1)

 
Brand

Avery(1324)

Avery®(4)

 
Recycled

Yes(4)

 
Height

1.5"(18)

1"(11)

11"(5)

1.75"(3)

11.25"(2)

0.81"(2)

3"(1)

12.88"(1)

11 3/4"(1)

10.5"(1)

 
Color(s)

Clear(41)

White(19)

Manila(17)

Assorted(15)

Assorted Primary(9)

Assorted Neon(7)

Assorted Pastel(6)

Black(4)

Semi-Clear(3)

Olive Green(2)

Yellow(2)

Assorted Metallic(2)

Fluorescent Yellow(2)

Assorted Patterns(1)

Assorted Dots(1)

Translucent Clear(1)

Fluorescent Blue(1)

Gray(1)

Fluorescent Purple(1)

Fluorescent Orange(1)

Matte White(1)

Red/Black(1)

Green(1)

Blue(1)

Red(1)

Light Pink(1)

Light Blue(1)

Assorted Geometric(1)

 
Depth

11.5"(1)

 
Size

4.75 x 2.38(8)

Letter(5)

3.75 x 1.78(3)

6.25 x 3.13(3)

1.25" dia.(2)

9 x 12(2)

2.75 x 1.38(2)

5.25 x 2.63(2)

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

8 1/2 x 11(1)

2 x 3 1/2(1)

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

4.25 x 2.13(1)

2 1/4 dia.(1)

1 1/4 dia.(1)

3.25 x 1.94(1)

3.25 x 1.63(1)

1.75 x 1.09(1)

2.75 x 1.69(1)

3.5 x 2(1)

 
Packing Type

Stick(10)

 
Closure

Fold-Over Flap(1)

 
Diameter

0.25"(3)

 
Binder Sheet Size

11 x 8.5(247)

8.5 x 5.5(8)

11 x 17(4)

14 x 8.5(2)

 
Binder Style

View(169)

Non-View(91)

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 ISEOP, All Rights Reserved