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_46` 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 (`manufacturer_id` = "1700031") 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

Manufacturer

Avery

Refine Search

  GO
 
Category

Presentation / View Binders(149)

Mailing & Address Labels(138)

Standard Ring Binders(87)

Pre-printed Index Dividers(78)

Multipurpose Labels(66)

Index Dividers(62)

ID & Specialty Labels(60)

Copier/Laser/Inkjet Index Dividers(48)

Top Tab Accessories(33)

Name Badges/Systems(31)

Insertable Tab Index Dividers(30)

Sheet Protectors(28)

Permanent Markers(22)

Filing Labels & Systems(19)

Shipping Tags(18)

Business Cards(17)

Legal Index Dividers(16)

Plain Tab Index Dividers(15)

Pocket Portfolios/Folders(13)

Index Tabs & Page Markers(13)

Report Covers(12)

Portfolios(11)

Tank-Style Highlighters(11)

Marking Tags(10)

Media Labels(9)

Dry Erase Markers(8)

Glue Sticks & Pens(8)

Stamp Pads(8)

Tent & Placement Cards(7)

Postcards(6)

Pin Fed Labels(5)

Binder Pockets(5)

Labels(5)

Pen-Style Highlighters(5)

Name Badge Holders(4)

Note Cards(4)

Hole Reinforcements(4)

Color Hanging Folders(4)

Legal Binders(4)

Safety/Caution Signs(4)

Label Printer Labels(3)

Iron-On Transfers(3)

Spine Inserts & Labels(3)

Card File Refills(2)

Key Tags(2)

Tab Inserts(2)

Stamp Pad Ink(2)

Laminating Supplies(2)

Poly Jackets(2)

CD/DVD Case Inserts(2)

Gel Ink Pens(2)

Business Card Refills(2)

Postage Meter Labels(2)

Wallets(1)

Hanging Accessories(1)

Medical Labels(1)

Ticket Holders(1)

Sheet Lifters(1)

Index Cards(1)

Data Index Dividers(1)

ID Cards(1)

Seals(1)

Easel Binders(1)

Magnet Sheets(1)

Greeting Cards(1)

Dry-Erase Boards(1)

Dividers(1)

Tickets(1)

Hooks & Hangers(1)

Inventory Forms & Tags(1)

Repair Tags(1)

Filler Papers(1)

Photo Album Refill Pages(1)

Stickers(1)

 
Brand

Avery®(1124)

Marks-A-Lot(2)

PRES-a-ply(1)

 
Color

White(352)

Black(98)

Clear(75)

Red(39)

Blue(30)

Assorted(21)

Manila(17)

Green(16)

Navy(15)

Yellow(13)

Purple(12)

Neon Green(11)

Light Blue(10)

Ivory(9)

Neon Magenta(9)

Neon Yellow(8)

Dark Blue(7)

Chartreuse(6)

Pacific Blue(6)

Maroon(5)

Orange(5)

Gold(3)

Bright Assorted(3)

Bright White(2)

Kraft(2)

Translucent(2)

Gray(2)

Dark Red(2)

Pink(1)

Semi Clear(1)

Diamond Clear(1)

Non-glare(1)

Magenta(1)

Aqua(1)

Neon(1)

Matte White(1)

Multi-colored(1)

Navy Blue(1)

Kraft Brown(1)

Coral(1)

Neon Red(1)

Royal Blue(1)

Buff(1)

Gold Metallic Border(1)

 
Binder Capacity

1"(60)

1 1/2"(43)

2"(43)

3"(42)

1/2"(20)

4"(18)

5"(15)

 
Size

Letter(504)

Legal(10)

A8(7)

Tabloid(5)

A7(1)

 
Recycled

No(647)

Yes(453)

 
Sheet Size

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

2" x 3 1/2"(14)

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

3 1/2" x 2"(5)

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

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

8 1/2" x 11"(4)

11" Width x 17" Length(3)

4" x 6"(3)

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

1"(2)

3 1/2" x 11"(2)

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

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

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

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

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

9" Width x 11" Length(2)

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

3" x 5"(1)

1" x 3"(1)

9" Width x 12" Length(1)

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

1" Length(1)

1 1/2" Length(1)

2" Length(1)

 
 
 

© 2019-2020 Innovative Copy Products, All Rights Reserved