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') 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(489)

Labels(289)

Binders(265)

File Inserts/Tabs(45)

Name Badge Kits(36)

Tags(32)

Sheet Protectors(30)

Markers(28)

Business Cards(20)

Pocket Folders(18)

Highlighters(18)

Greeting Cards(14)

Media Labeling(14)

Adhesives/Glues(11)

Tent Cards(8)

File Jackets/Sleeves/Wallets(6)

Report Covers(5)

Binder Spine Inserts(4)

Hole Reinforcements(4)

Office Paper(3)

Binder Pockets(3)

Media Sleeves(2)

Laminator Supplies(2)

Art Paper(2)

Photo Albums(2)

Pens(2)

Filler Paper(1)

Label Applicators(1)

Sheet Lifters(1)

Label Holders(1)

Board Erasers(1)

Card File Refills(1)

Magnetic Printable Sheets(1)

Desktop File Folder Sorters(1)

Index Cards(1)

 
Brand

Avery(1361)

 
Height

1 1/2"(18)

1"(11)

11"(5)

1 3/4"(3)

11 1/4"(2)

11 3/4"(1)

10 1/2"(1)

13/16"(1)

1 1/4"(1)

3"(1)

7/16"(1)

12 7/8"(1)

 
Color(s)

Black(93)

White(86)

Clear(42)

Blue(25)

Red(23)

Manila(17)

Navy Blue(14)

Assorted(13)

Green(11)

Assorted Primary(9)

Purple(7)

Assorted Neon(7)

Assorted Pastel(6)

Pacific Blue(6)

Light Blue(6)

Chartreuse(6)

Burgundy(4)

Maroon(4)

Fluorescent Yellow(3)

Semi-Clear(3)

Yellow/Red(3)

Assorted Metallic(2)

Assorted Patterns(2)

Periwinkle(2)

Yellow(2)

Gray(2)

Olive Green(2)

Fluorescent Assorted(2)

Manila/White(1)

Red/Black(1)

Light Pink(1)

Coral(1)

Assorted Dots(1)

Translucent Clear(1)

Fluorescent Green(1)

Fluorescent Blue(1)

Fluorescent Pink(1)

Fluorescent Orange(1)

Fluorescent Purple(1)

Matte White(1)

Black/White Damask(1)

Aqua(1)

 
Depth

11 1/2"(1)

1 7/8"(1)

 
Quantity

40 per pack(4)

20 per pack(4)

100 per pack(2)

30 per pack(1)

50 per pack(1)

250 per pack(1)

375 per pack(1)

 
Size

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

8 1/2 x 11(4)

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

1 1/4 dia.(3)

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

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

Letter(2)

9" x 12"(2)

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

3 1/4 x 1 15/16(1)

2 x 3 1/2(1)

3 1/2 x 2(1)

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

2 3/4 x 1 11/16(1)

1 3/4 x 1 3/32(1)

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

2 1/4 dia.(1)

 
Refillable

Nonrefillable(2)

 
Closure

Fold-Over Flap(1)

 
Diameter

1/4"(4)

 
Binder Sheet Size

11 x 8 1/2(248)

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

14 x 8 1/2(5)

11 x 17(4)

 
Binder Style

View(170)

Non-View(94)

Easel(1)

 
Paper Color(s)

White(20)

Ivory(9)

Matte White(5)

Uncoated White(4)

Textured Uncoated White(2)

Glossy White(1)

Embossed Matte Ivory(1)

 
Hole-Punched

3-Hole Punched(2)

 
 
 

© 2019-2020 Desert West Office Supply, All Rights Reserved