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_12` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` 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

Brands

Avery

Refine Search

  GO
Category

Mailing & Address Labels(153)

Presentation / View Binders(148)

Standard Ring Binders(91)

Pre-printed Index Dividers(89)

ID & Specialty Labels(77)

Multipurpose Labels(77)

Index Dividers(72)

Legal Index Dividers(69)

Copier/Laser/Inkjet Index Dividers(55)

Name Badges/Systems(35)

Top Tab Accessories(35)

Insertable Tab Index Dividers(29)

Sheet Protectors(28)

Filing Labels & Systems(19)

Business Cards(18)

Shipping Tags(17)

Plain Tab Index Dividers(16)

Index Tabs & Page Markers(13)

Report Covers(12)

Portfolios(11)

Media Labels(11)

Marking Tags(11)

Glue Sticks & Pens(10)

Postcards(8)

Tent & Placement Cards(7)

Medical Labels(6)

Binder Pockets(6)

Pin Fed Labels(6)

Labels(6)

Pocket Portfolios/Folders(5)

Note Cards(4)

Safety/Caution Signs(4)

Iron-On Transfers(4)

Name Badge Holders(4)

Spine Inserts & Labels(4)

Legal Binders(4)

Hole Reinforcements(4)

Color Hanging Folders(4)

Hanging Accessories(3)

Label Printer Labels(3)

Key Tags(2)

Tab Inserts(2)

Laminating Supplies(2)

Poly Jackets(2)

CD/DVD Case Inserts(2)

Card File Refills(2)

Postage Meter Labels(2)

Poly Envelopes(2)

Business Card Refills(2)

Business Card Holders(1)

Ticket Holders(1)

Sheet Lifters(1)

Brochure Paper(1)

Desktop Organizers(1)

Wallets(1)

Seals(1)

Hooks & Hangers(1)

Index Cards(1)

Stickers(1)

ID Cards(1)

Inventory Forms & Tags(1)

Dividers(1)

Data Index Dividers(1)

Easel Binders(1)

Photo Album Refill Pages(1)

Magnet Sheets(1)

Greeting Cards(1)

Filler Papers(1)

Dry-Erase Boards(1)

Repair Tags(1)

Permanent Markers(1)

Tickets(1)

Brand

Avery®(1219)

Color

White(390)

Black(96)

Clear(81)

Red(40)

Blue(33)

Green(20)

Neon Green(19)

Manila(17)

Assorted(15)

Neon Magenta(15)

Neon Yellow(15)

Navy(14)

Yellow(14)

Purple(13)

Ivory(10)

Light Blue(10)

Silver(9)

Dark Blue(8)

Orange(8)

Chartreuse(6)

Pacific Blue(6)

Diamond Clear(5)

Gold(5)

Matte White(5)

Maroon(5)

Bright White(4)

Bright Assorted(3)

Semi Clear(2)

Gray(2)

Navy Blue(2)

Aqua(2)

Kraft(2)

Frosted Clear(2)

Dark Red(2)

Crystal Clear(1)

Neon Red(1)

Buff(1)

Royal Blue(1)

Pink(1)

Transparent(1)

Pastel Blue(1)

Non-glare(1)

Kraft Brown(1)

Magenta(1)

Coral(1)

Pearlized Ivory(1)

Multi-colored(1)

Gold Metallic Border(1)

Binder Capacity

1"(64)

2"(44)

1 1/2"(43)

3"(40)

1/2"(21)

5"(16)

4"(16)

Size

Letter(582)

Legal(13)

A8(7)

Tabloid(5)

Statement(1)

Half-letter(1)

A7(1)

Recycled

No(701)

Yes(498)

Price Range

$0-$99.99 (1178)

$100-$199.99 (26)

$200-$299.99 (5)

$300-$399.99 (7)

$400-$499.99 (3)

To  GO

 
 
1%
Searching for your Best Results.....
loading results
 

© 2020-2021 JD Office Products, All Rights Reserved