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 (`category_id` IN ('60026')) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%FoilandWraps' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('FoilandWraps' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+FoilandWraps' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"FoilandWraps"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"FoilandWraps"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"FoilandWraps"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"FoilandWraps"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+FoilandWraps' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='FoilandWraps',`category_4` ='FoilandWraps') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'FoilandWraps,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('FoilandWraps', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Category

Foil And Wraps

Refine Search

  GO
 
Brand

Oxford(44)

Smead(33)

ACCO(31)

Universal(18)

Durable(13)

C-Line(9)

GBC(3)

Avery(2)

Cardinal(2)

AbilityOne(1)

Wilson Jones(1)

 
Country of Origin

US(61)

MX(43)

CN(29)

DE(10)

VN(9)

PL(3)

IN(2)

 
Sheet Size

8.5 x 11(125)

8.5 x 14(11)

11 x 17(10)

8 1/2 x 11(4)

11 x 8.5(4)

14 x 8.5(1)

8 1/2 x 14(1)

 
Sheet Capacity

750(32)

100(30)

500(23)

30(14)

20(9)

80(6)

60(3)

350(1)

135(1)

85(1)

200(1)

150(1)

25(1)

160(1)

120(1)

50(1)

40(1)

 
Fastener Type

Two-Piece Prong Fastener(57)

Two-Prong Metal Fastener(21)

Three-Prong Fastener(19)

Clip Fastener(13)

Prong Fastener(12)

Double-Prong Fastener(5)

Binding Bar(5)

Swing Clip(5)

Spiral Bound(3)

Two-Prong Fastener(2)

Two-Hole Prong Fastener(1)

Three-Prong Fasteners(1)

Sliding Bar(1)

Double Prong Fasteners(1)

Two Prong Metal Fastener(1)

Double-Prong Fasteners(1)

Spring Style Fastener(1)

Grooved Sliding Bar(1)

Flexible Fastener(1)

Ring Fastener(1)

 
Number of Fasteners

1(107)

3(37)

 
Sheet Type

Punched(123)

Unpunched(28)

 
Capacity Range [Max]

3"(58)

0.5"(32)

2"(27)

0.13"(4)

100(3)

0.19"(1)

135(1)

1/2"(1)

 
Cover Material(s)

25-pt. Premium Pressboard(23)

Polypropylene(20)

Pressboard(18)

Vinyl(16)

PRESSTEX(15)

Paper; Polypropylene(15)

PressGuard Coated Pressboard(11)

Paper(10)

20-pt. Pressboard(10)

Plastic(6)

Embossed Leatherette(4)

Economy Vinyl(2)

20-pt. Premium Pressboard(2)

20 pt. Pressboard(2)

ACCOHIDE Plastic(1)

20 pt. PressGuard(1)

Poly(1)

 
Inside Pockets

2(4)

One Back(3)

Eight Interior Pockets(2)

Ten(2)

No(1)

 
Back Cover Color(s)

Black(42)

Red(27)

Dark Blue(17)

Blue(10)

Light Blue(10)

Clear(10)

Assorted(5)

Green(4)

Executive Red(4)

Yellow(3)

Dark Green(3)

Gray(3)

Bright Red(2)

Earth Red(2)

Navy Blue(2)

Graphite(2)

Royal Blue(1)

Purple(1)

Hunter Green(1)

Smoke(1)

Navy(1)

Light Green(1)

Maroon(1)

Bronze(1)

Black/White(1)

Randomly Assorted(1)

White(1)

 
Front Cover Color(s)

Clear(52)

Black(28)

Red(22)

Dark Blue(10)

Light Blue(8)

Blue(5)

Executive Red(4)

Dark Green(3)

Frosted(3)

Yellow(3)

Earth Red(2)

Green(2)

Bright Red(2)

Gray(2)

White(1)

Royal Blue(1)

Purple(1)

Bronze(1)

Assorted(1)

Light Green(1)

Graphite(1)

Smoke(1)

Black/White(1)

Randomly Assorted(1)

Black/Blue(1)

 
Fastener Material

Metal(121)

Steel(9)

Plastic(3)

Elastic(1)

 
Report Cover Quantity

1(91)

25(42)

10(10)

5(7)

50(3)

100(2)

 
Spine Color(s)

Black(41)

Red(26)

Coordinating(15)

Dark Blue(14)

Blue(10)

Light Blue(7)

White(6)

Green(4)

Navy Blue(3)

Dark Green(2)

Executive Red(2)

Bright Red(2)

Graphite(2)

Yellow(2)

Hunter Green(1)

Purple(1)

Royal Blue(1)

Maroon(1)

Black; Dark Blue; Green; Light Blue; Red(1)

Dark Blue; Green; Light Blue; Orange; Red(1)

Gray(1)

Randomly Assorted(1)

Earth Red(1)

Assorted(1)

 
Center To Center

8.5"(47)

2.75"(25)

4.25"(8)

8.75"(4)

2 3/4"(2)

8 1/2"(1)

4 1/4"(1)

 
Business Card Holder

Inside Front Cover(5)

Inside Back(2)

Inside Front Pocket(1)

Inside Back Cover(1)

Inside Cover(1)

 
 
 
 

© 2024-2025 Regal Office Supplies, All Rights Reserved