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_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 (`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

Mailing & Address Labels(157)

Presentation / View Binders(155)

Pre-printed Index Dividers(101)

Standard Ring Binders(94)

Legal Index Dividers(81)

Index Dividers(77)

Multipurpose Labels(75)

ID & Specialty Labels(64)

Copier/Laser/Inkjet Index Dividers(59)

Top Tab Accessories(36)

Sheet Protectors(31)

Insertable Tab Index Dividers(31)

Name Badges/Systems(27)

Filing Labels & Systems(17)

Shipping Tags(17)

Business Cards(16)

Plain Tab Index Dividers(16)

Index Tabs & Page Markers(13)

Pocket Portfolios/Folders(13)

Media Labels(13)

Marking Tags(12)

Report Covers(12)

Portfolios(11)

Glue Sticks & Pens(9)

Postcards(8)

Pin Fed Labels(6)

Tent & Placement Cards(6)

Binder Pockets(6)

Name Badge Holders(5)

Safety/Caution Signs(4)

Note Cards(4)

Spine Inserts & Labels(4)

Color Hanging Folders(4)

Hole Reinforcements(4)

Label Printer Labels(3)

Labels(3)

Hanging Accessories(3)

Poly Jackets(3)

Iron-On Transfers(3)

Card File Refills(2)

Laminating Supplies(2)

Legal Binders(2)

Key Tags(2)

Tab Inserts(2)

CD/DVD Case Inserts(2)

Postage Meter Labels(2)

Greeting Cards(2)

Poly Envelopes(2)

Business Card Refills(2)

File Inserts/Tabs(1)

Ticket Holders(1)

Sheet Lifters(1)

Business Card Holders(1)

Inventory Forms & Tags(1)

Brochure Paper(1)

Desktop Organizers(1)

Stickers(1)

Wallets(1)

Index Cards(1)

ID Cards(1)

Repair Tags(1)

Dividers(1)

Magnet Sheets(1)

Data Index Dividers(1)

Dry-Erase Boards(1)

Easel Binders(1)

Permanent Markers(1)

Tickets(1)

Photo Album Refill Pages(1)

Filler Papers(1)

Hooks & Hangers(1)

 
Brand

Avery®(1244)

Avery(1)

 
Color

White(385)

Black(99)

Clear(88)

Red(40)

Blue(33)

Green(19)

Assorted(17)

Manila(16)

Navy(14)

Neon Green(14)

Yellow(13)

Purple(12)

Light Blue(11)

Neon Yellow(11)

Neon Magenta(10)

Orange(9)

Dark Blue(8)

Ivory(7)

Chartreuse(6)

Pacific Blue(6)

Diamond Clear(5)

Maroon(5)

Matte White(5)

Bright White(4)

Semi Clear(3)

Gray(3)

Bright Assorted(3)

Navy Blue(2)

Aqua(2)

Kraft(2)

Frosted Clear(2)

Silver(2)

Gold(2)

Dark Red(2)

Burgundy(1)

Neon Red(1)

Buff(1)

Royal Blue(1)

Pink(1)

Transparent(1)

Magenta(1)

Non-glare(1)

Pastel Blue(1)

Kraft Brown(1)

Coral(1)

Pearlized Ivory(1)

Crystal Clear(1)

Gold Metallic Border(1)

 
Binder Capacity

1"(67)

1 1/2"(44)

2"(44)

3"(42)

1/2"(23)

4"(18)

5"(14)

 
Size

Letter(634)

Legal(11)

Tabloid(5)

A8(5)

Statement(1)

A4(1)

Half-letter(1)

A7(1)

 
Recycled

No(699)

Yes(531)

 
Sheet Size

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

2" x 3 1/2"(13)

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

3 1/2" x 2"(5)

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

8 1/2" x 11"(5)

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

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

4" x 3"(3)

11" Width x 17" Length(3)

4" x 6"(3)

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

9" Width x 12" Length(2)

2 1/2" x 8 1/2"(2)

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

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

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

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

3" x 5"(1)

9" Width x 11" Length(1)

3 1/2" x 11"(1)

3 3/4" x 1 7/16"(1)

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

8 17/64" Width x 11 11/16" Length(1)

9 1/4" Width x 11" Length(1)

4" Width x 6" Length(1)

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

1/2" Length(1)

1" Length(1)

1 1/2" Length(1)

2" Length(1)

 
 
 

© 2020-2021 Panola Paper Co, All Rights Reserved