Total:$0.00

QUICK VIEW 0
 

 
 
 
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 (`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_cost`=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(138)

Mailing & Address Labels(126)

Standard Ring Binders(92)

Copier/Laser/Inkjet Index Dividers(85)

Pre-printed Index Dividers(80)

Multipurpose Labels(65)

Top Tab Accessories(40)

ID & Specialty Labels(33)

Insertable Tab Index Dividers(32)

Index Dividers(31)

Sheet Protectors(28)

Shipping Tags(22)

Permanent Markers(21)

Business Cards(19)

Filing Labels & Systems(19)

Plain Tab Index Dividers(17)

Legal Index Dividers(16)

Name Badges/Systems(15)

Marking Tags(12)

Report Covers(12)

Media Labels(12)

Labels(12)

Portfolios(11)

Stamp Pads(11)

Dry Erase Markers(8)

Name Badge Holders(8)

Pin Fed Labels(8)

Index Tabs & Page Markers(7)

Glue Sticks & Pens(7)

Note Cards(6)

Tent & Placement Cards(5)

Pocket Portfolios/Folders(5)

Postcards(5)

Legal Binders(4)

Hole Reinforcements(4)

Binder Pockets(4)

Spine Inserts & Labels(4)

Color Hanging Folders(4)

Dry-Erase Boards(3)

Label Printer Labels(3)

Iron-On Transfers(3)

Poly Jackets(3)

Laminating Supplies(2)

CD/DVD Case Inserts(2)

Gel Ink Pens(2)

Tab Inserts(2)

Card File Refills(2)

Postage Meter Labels(2)

Stamp Pad Ink(2)

Tag Fasteners(2)

Key Tags(2)

Tank-Style Highlighters(2)

Business Card Refills(2)

Filler Papers(1)

Repair Tags(1)

Index Cards(1)

Desk Calendar Refills(1)

Hanging Accessories(1)

Stretch Wrap & Dispensers(1)

Sheet Lifters(1)

Wallets(1)

Medical Labels(1)

Ticket Holders(1)

Inventory Forms & Tags(1)

Greeting Cards(1)

Magnet Sheets(1)

Dividers(1)

Pen-Style Highlighters(1)

Binding Index Dividers(1)

Data Index Dividers(1)

Easel Binders(1)

Hooks & Hangers(1)

CD/DVD Labels(1)

Seals(1)

Stickers(1)

Photo Album Refill Pages(1)

ID Cards(1)

 
Brand

Avery(1083)

PRES-a-ply(2)

Marks-A-Lot(1)

 
Color

White(318)

Black(96)

Clear(67)

Red(37)

Blue(31)

Assorted(23)

Manila(20)

Navy(15)

Green(15)

Purple(12)

Neon Green(11)

Light Blue(9)

Neon Magenta(9)

Yellow(9)

Neon Yellow(8)

Dark Blue(7)

Ivory(7)

Chartreuse(6)

Pacific Blue(6)

Orange(5)

Maroon(4)

Burgundy(4)

Gold(3)

Dark Red(3)

Gray(2)

Multi-colored(2)

Non-glare(2)

Pink(2)

Floral(2)

Navy Blue(2)

Translucent(2)

Bright White(1)

Semi Clear(1)

Magenta(1)

Diamond Clear(1)

Coral(1)

Aqua(1)

Royal Blue(1)

Buff(1)

Kraft(1)

Silver(1)

Matte White(1)

Kraft Brown(1)

Garnet(1)

 
Binder Capacity

1"(62)

2"(41)

1 1/2"(41)

3"(39)

5"(16)

4"(16)

1/2"(16)

 
Size

Letter(493)

Legal(9)

Tabloid(7)

Half-letter(1)

A4(1)

 
Recycled

No(584)

Yes(442)

 
 
 

© 2018-2019 Alpine Office Products Inc., All Rights Reserved