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

Manufacturer

Currently Filtered by

Manufacturer

Avery

Refine Search

  GO
Category

Mailing & Address Labels(143)

Presentation / View Binders(136)

Standard Ring Binders(87)

Pre-printed Index Dividers(78)

Multipurpose Labels(66)

Index Dividers(62)

ID & Specialty Labels(60)

Copier/Laser/Inkjet Index Dividers(49)

Top Tab Accessories(33)

Insertable Tab Index Dividers(30)

Sheet Protectors(27)

Name Badges/Systems(24)

Permanent Markers(20)

Filing Labels & Systems(19)

Shipping Tags(18)

Business Cards(17)

Plain Tab Index Dividers(16)

Legal Index Dividers(16)

Index Tabs & Page Markers(13)

Report Covers(12)

Portfolios(11)

Marking Tags(10)

Media Labels(9)

Dry Erase Markers(8)

Stamp Pads(8)

Tent & Placement Cards(7)

Glue Sticks & Pens(7)

Postcards(6)

Medical Labels(6)

Labels(5)

Pin Fed Labels(5)

Binder Pockets(5)

Pocket Portfolios/Folders(4)

Note Cards(4)

Hole Reinforcements(4)

Legal Binders(4)

Safety/Caution Signs(4)

Name Badge Holders(4)

Color Hanging Folders(4)

Spine Inserts & Labels(3)

Iron-On Transfers(3)

Label Printer Labels(3)

Business Card Refills(2)

Gel Ink Pens(2)

Tab Inserts(2)

Card File Refills(2)

Postage Meter Labels(2)

Tank-Style Highlighters(2)

Poly Jackets(2)

CD/DVD Case Inserts(2)

Key Tags(2)

Laminating Supplies(2)

Stamp Pad Ink(2)

Pen-Style Highlighters(2)

Index Cards(1)

Wallets(1)

Sheet Lifters(1)

Hanging Accessories(1)

Ticket Holders(1)

Stickers(1)

Repair Tags(1)

Inventory Forms & Tags(1)

Filler Papers(1)

Photo Album Refill Pages(1)

Dividers(1)

Easel Binders(1)

Hooks & Hangers(1)

Tickets(1)

Data Index Dividers(1)

Seals(1)

Magnet Sheets(1)

Greeting Cards(1)

Dry-Erase Boards(1)

ID Cards(1)

Brand

Avery®(1078)

Avery®(10)

PRES-a-ply(5)

Marks-A-Lot(1)

Color

White(351)

Black(93)

Clear(73)

Red(39)

Blue(30)

Assorted(20)

Manila(17)

Navy(15)

Green(15)

Purple(12)

Yellow(12)

Neon Green(11)

Light Blue(9)

Ivory(9)

Neon Magenta(9)

Neon Yellow(8)

Pacific Blue(6)

Chartreuse(6)

Dark Blue(6)

Maroon(5)

Orange(5)

Bright Assorted(3)

Gold(3)

Kraft(2)

Dark Red(2)

Translucent(2)

Bright White(2)

Magenta(1)

Neon(1)

Gold Metallic Border(1)

Pink(1)

Semi Clear(1)

Diamond Clear(1)

Non-glare(1)

Aqua(1)

Coral(1)

Neon Red(1)

Royal Blue(1)

Buff(1)

Floral(1)

Kraft Brown(1)

Gray(1)

Multi-colored(1)

Navy Blue(1)

Matte White(1)

Binder Capacity

1"(60)

2"(42)

1 1/2"(40)

3"(38)

1/2"(17)

4"(16)

5"(15)

Size

Letter(478)

Legal(10)

A8(7)

Tabloid(5)

A7(1)

A4(1)

Recycled

No(636)

Yes(437)

Price Range

$0-$499.99(1086)

$500-$999.99(8)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved