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 CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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

Presentation / View Binders(151)

Mailing & Address Labels(147)

Standard Ring Binders(97)

Pre-printed Index Dividers(79)

Multipurpose Labels(71)

Index Dividers(66)

ID & Specialty Labels(60)

Copier/Laser/Inkjet Index Dividers(57)

Top Tab Accessories(40)

Insertable Tab Index Dividers(30)

Sheet Protectors(28)

Name Badges/Systems(24)

Permanent Markers(23)

Filing Labels & Systems(19)

Shipping Tags(19)

Business Cards(17)

Plain Tab Index Dividers(17)

Legal Index Dividers(16)

Index Tabs & Page Markers(16)

Pocket Portfolios/Folders(14)

Report Covers(12)

Media Labels(11)

Tank-Style Highlighters(11)

Portfolios(11)

Marking Tags(10)

Stamp Pads(9)

Glue Sticks & Pens(8)

Dry Erase Markers(8)

Tent & Placement Cards(7)

Labels(7)

Pin Fed Labels(6)

Postcards(6)

Medical Labels(6)

Binder Pockets(6)

Pen-Style Highlighters(5)

Legal Binders(4)

Hole Reinforcements(4)

Note Cards(4)

Name Badge Holders(4)

Color Hanging Folders(4)

Safety/Caution Signs(4)

Poly Jackets(3)

Label Printer Labels(3)

Spine Inserts & Labels(3)

Iron-On Transfers(3)

Postage Meter Labels(2)

Business Card Refills(2)

Gel Ink Pens(2)

Card File Refills(2)

Stamp Pad Ink(2)

CD/DVD Case Inserts(2)

Key Tags(2)

Tab Inserts(2)

Laminating Supplies(2)

Wallets(1)

Ticket Holders(1)

Index Cards(1)

Hanging Accessories(1)

Sheet Lifters(1)

Tickets(1)

Easel Binders(1)

Photo Album Refill Pages(1)

Data Index Dividers(1)

Dividers(1)

Seals(1)

Stickers(1)

Filler Papers(1)

Desk Calendar Refills(1)

Greeting Cards(1)

Magnet Sheets(1)

Dry-Erase Boards(1)

Hooks & Hangers(1)

Repair Tags(1)

Inventory Forms & Tags(1)

ID Cards(1)

Brand

Avery®(1173)

Avery®(7)

PRES-a-ply(6)

Marks-A-Lot(2)

Avery(1)

Color

White(375)

Black(104)

Clear(76)

Red(41)

Blue(32)

Assorted(23)

Green(17)

Manila(17)

Navy(15)

Yellow(14)

Purple(12)

Neon Green(11)

Light Blue(10)

Neon Magenta(9)

Ivory(9)

Neon Yellow(8)

Dark Blue(8)

Chartreuse(6)

Pacific Blue(6)

Maroon(5)

Orange(5)

Burgundy(3)

Dark Red(3)

Gold(3)

Bright Assorted(3)

Translucent(2)

Gray(2)

Multi-colored(2)

Kraft(2)

Bright White(2)

Pink(2)

Gold Metallic Border(1)

Non-glare(1)

Semi Clear(1)

Magenta(1)

Diamond Clear(1)

Aqua(1)

Neon Red(1)

Royal Blue(1)

Buff(1)

Coral(1)

Floral(1)

Matte White(1)

Navy Blue(1)

Kraft Brown(1)

Neon(1)

Binder Capacity

1"(68)

1 1/2"(45)

3"(43)

2"(43)

4"(19)

1/2"(19)

5"(16)

Size

Letter(523)

Legal(10)

A8(7)

Tabloid(7)

A7(1)

A4(1)

Recycled

No(697)

Yes(470)

Price Range

$0-$499.99(1181)

$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