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_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

Pre-printed Index Dividers(196)

Mailing & Address Labels(169)

Presentation / View Binders(165)

Standard Ring Binders(121)

Legal Index Dividers(121)

Copier/Laser/Inkjet Index Dividers(99)

Multipurpose Labels(78)

Index Dividers(65)

ID & Specialty Labels(45)

Top Tab Accessories(43)

Insertable Tab Index Dividers(39)

Sheet Protectors(33)

Name Badges/Systems(24)

Permanent Markers(23)

Shipping Tags(22)

Business Cards(21)

Filing Labels & Systems(20)

Media Labels(18)

Plain Tab Index Dividers(18)

Labels(14)

Report Covers(14)

Marking Tags(14)

Glue Sticks & Pens(12)

Tank-Style Highlighters(12)

Portfolios(11)

Stamp Pads(11)

Pin Fed Labels(11)

Index Tabs & Page Markers(10)

Dry Erase Markers(8)

Pen-Style Highlighters(7)

Tent & Placement Cards(7)

Name Badge Holders(6)

Note Cards(6)

Pocket Portfolios/Folders(6)

Postcards(6)

Spine Inserts & Labels(5)

Binder Pockets(5)

Color Hanging Folders(4)

Hole Reinforcements(4)

Legal Binders(4)

Poly Jackets(3)

Dry-Erase Boards(3)

Iron-On Transfers(3)

Label Printer Labels(3)

Hanging Accessories(3)

Laminating Supplies(2)

Gel Ink Pens(2)

Card File Refills(2)

Binding Index Dividers(2)

Tab Inserts(2)

Key Tags(2)

Postage Meter Labels(2)

Business Card Refills(2)

Photo Album Refill Pages(2)

Tag Fasteners(2)

Stamp Pad Ink(2)

CD/DVD Case Inserts(2)

Poly Envelopes(2)

Desktop Organizers(1)

Wallets(1)

Ticket Holders(1)

Brochure Paper(1)

Sheet Lifters(1)

Medical Labels(1)

Business Card Holders(1)

Hooks & Hangers(1)

Data Index Dividers(1)

Easel Binders(1)

Dividers(1)

Stickers(1)

Seals(1)

Filler Papers(1)

Desk Calendar Refills(1)

Magnet Sheets(1)

ID Cards(1)

Greeting Cards(1)

Inventory Forms & Tags(1)

Repair Tags(1)

Index Cards(1)

 
Brand

Avery(1545)

PRES-a-ply(13)

Marks-A-Lot(1)

 
Color

White(398)

Black(113)

Clear(92)

Red(44)

Blue(42)

Assorted(26)

Green(24)

Manila(21)

Navy(19)

Purple(18)

Neon Green(15)

Yellow(11)

Light Blue(11)

Neon Magenta(10)

Neon Yellow(10)

Ivory(8)

Orange(7)

Dark Blue(7)

Pacific Blue(6)

Chartreuse(6)

Gray(5)

Maroon(5)

Gold(4)

Burgundy(3)

Dark Red(3)

Bright White(3)

Non-glare(2)

Navy Blue(2)

Multi-colored(2)

Pink(2)

Pearl Ivory(2)

Silver(2)

Translucent(2)

Floral(2)

Diamond Clear(1)

Semi Clear(1)

Magenta(1)

Coral(1)

Royal Blue(1)

Buff(1)

Aqua(1)

Kraft(1)

Kraft Brown(1)

Matte White(1)

 
Binder Capacity

1"(79)

2"(53)

1 1/2"(49)

3"(47)

1/2"(20)

5"(19)

4"(19)

 
Size

Letter(812)

Legal(14)

Tabloid(12)

A8(8)

Half-letter(3)

A7(1)

A4(1)

Statement(1)

 
Recycled

Yes(763)

No(742)

 
Sheet Size

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

2" x 3 1/2"(18)

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

11" Width x 17" Length(6)

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

8 1/2" x 11"(5)

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

3 1/2" x 2"(5)

4" x 6"(3)

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

9" Width x 12" Length(2)

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

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

1"(2)

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

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

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

1/2" Length(1)

1" Length(1)

3" Length(1)

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

2" Length(1)

1 1/2" Length(1)

8 17/64" Width x 11 11/16" Length(1)

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

3 1/2" x 11"(1)

3" x 5"(1)

3 3/4" x 1 7/16"(1)

4" Width x 6" Length(1)

 
 
 

© 2017-2018 2M Office Supplies, All Rights Reserved