0

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


Avery

Refine Search

  GO
 
Category Filter

Index Dividers(560)

Labels(357)

Binders(306)

Legal Index Dividers(279)

File Inserts/Tabs(46)

Tags(39)

Sheet Protectors(38)

Name Badge Kits(36)

Markers(27)

Business Cards(22)

Presentation / View Binders(18)

Pocket Folders(18)

Highlighters(17)

Greeting Cards(16)

Media Labeling(15)

ID & Specialty Labels(12)

Pocket Portfolios/Folders(11)

Adhesives/Glues(11)

Multipurpose Labels(10)

Report Covers(8)

Tent Cards(8)

Binder Pockets(7)

Mailing & Address Labels(6)

Medical Labels(6)

File Jackets/Sleeves/Wallets(6)

Insertable Tab Index Dividers(5)

Hole Reinforcements(4)

Office Paper(3)

Pre-printed Index Dividers(3)

Binder Spine Inserts(3)

Marking Tags(2)

Art Paper(2)

Name Badges/Systems(2)

Pens(2)

Media Sleeves(2)

Laminator Supplies(2)

Photo Albums(2)

Name Badge Holders(2)

Tag Fasteners(2)

Business Card Refills(2)

Card File Refills(2)

Label Holders(1)

Desktop File Folder Sorters(1)

Sheet Lifters(1)

Top Tab Accessories(1)

Tab Indexes(1)

Index Cards(1)

Inventory Forms & Tags(1)

Board Erasers(1)

Media Labels(1)

Permanent Markers(1)

Postcards(1)

Label Applicators(1)

Filler Paper(1)

Tent & Placement Cards(1)

Tickets(1)

Standard Ring Binders(1)

Dry-Erase Boards(1)

Label Printer Labels(1)

Pen-Style Highlighters(1)

Glue Sticks & Pens(1)

Magnetic Printable Sheets(1)

Iron-On Transfers(1)

Specialty Paper(1)

Hanging File Systems(1)

Spine Inserts & Labels(1)

 
Brand

Avery(1559)

Avery®(385)

 
Color

White(48)

Clear(11)

Black(8)

Assorted(5)

Matte White(3)

Blue(2)

Red(2)

Green(1)

Diamond Clear(1)

Yellow(1)

Gray(1)

Multi-colored(1)

Light Blue(1)

Dark Blue(1)

Buff(1)

Kraft(1)

Orange(1)

Semi Clear(1)

 
Binder Capacity

1"(5)

3"(3)

1/2"(2)

1 1/2"(2)

2"(2)

4"(2)

 
Recycled

Yes(296)

No(88)

 
Height

1.5"(17)

1"(11)

11"(6)

1.75"(3)

11.25"(2)

0.81"(2)

3 1/2"(2)

5 1/2"(2)

8 1/2"(1)

4"(1)

2 1/6"(1)

3"(1)

12.88"(1)

11 3/4"(1)

10.5"(1)

11 1/4"(1)

 
Color(s)

Clear(43)

White(30)

Manila(20)

Assorted(17)

Black(13)

Blue(10)

Assorted Primary(9)

Assorted Neon(8)

Assorted Pastel(6)

Semi-Clear(5)

Navy Blue(4)

Green(4)

Fluorescent Yellow(3)

Red(3)

Maroon(2)

White/Blue Circle(2)

White/Dimensions(2)

Assorted Metallic(2)

Yellow(2)

Olive Green(2)

Dark Blue(2)

Light Pink(1)

Light Blue(1)

Red/Black(1)

Assorted Dots(1)

Assorted Patterns(1)

Assorted Geometric(1)

Periwinkle(1)

Pink(1)

Translucent Clear(1)

Fluorescent Purple(1)

Gray(1)

Green/Off White(1)

Chartreuse(1)

Manila/White(1)

Fluorescent Orange(1)

Fluorescent Green(1)

Fluorescent Blue(1)

Fluorescent Pink(1)

Tech Circles(1)

White/Digital Smoke(1)

Bright Floral/Orange(1)

Damask/Light Blue(1)

Floral/Navy(1)

Matte White(1)

 
Depth

1/4"(1)

11.5"(1)

 
Quantity

20 per pack(1)

40 per pack(1)

 
Size

4.75 x 2.38(8)

Letter(5)

4 3/4 x 2 3/8(3)

3.75 x 1.78(3)

6.25 x 3.13(3)

9 x 12(2)

8 1/2 x 11(2)

2.75 x 1.38(2)

5.25 x 2.63(2)

1.25" dia.(2)

2 1/4 dia.(1)

1 1/2 x 1 1/2(1)

2 x 1 1/4(1)

2 x 3 1/2(1)

6 1/4 x 3 1/8(1)

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

3 1/4 x 1 5/8(1)

1 1/4 dia.(1)

4.25 x 2.13(1)

3.25 x 1.63(1)

4 1/4 x 2 1/8(1)

1 3/32 x 3/4(1)

1 1/2 x 15/16(1)

1.75 x 1.09(1)

2.75 x 1.69(1)

3.25 x 1.94(1)

3.5 x 2(1)

 
Packing Type

Stick(11)

 
Closure

Fold-Over Flap(1)

 
Diameter

0.25"(3)

 
Binder Sheet Size

11 x 8.5(243)

11 x 8 1/2(39)

8.5 x 5.5(8)

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

11 x 17(5)

14 x 8 1/2(3)

14 x 8.5(2)

 
Binder Style

View(187)

Non-View(118)

Easel(1)

 
Paper Color(s)

White(23)

Ivory(9)

Matte White(5)

Uncoated White(4)

Textured Uncoated White(2)

Textured Matte White(1)

Embossed Matte Ivory(1)

Glossy White(1)

 
Hole-Punched

3-Hole Punched(2)

 
 
 

© 2020-2021 Service Office Supplies, All Rights Reserved