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

Currently Filtered by


Universal

Refine Search

  GO
 
Category Filter

Binders(103)

Paper Pads/Note Pads(69)

Boards(59)

File Folders(59)

Envelopes/Mailers(57)

Classification Folders(41)

Pens(38)

Stamps(33)

Clips/Clamps(33)

Index Dividers(31)

Labels(29)

Pocket Folders(24)

Markers(23)

Report Covers(23)

Index Cards(20)

Hanging File Folders(20)

Packing Tape(20)

Computer Printout Paper(20)

File Jackets/Sleeves/Wallets(20)

Roll Paper(20)

Clipboards(19)

Page Flags(17)

Office Paper(15)

File Boxes(15)

Frames(14)

Tapes(14)

Desktop File Folder Sorters(14)

Rubber Bands(12)

Pencils(12)

Clocks(11)

Stretch Films(10)

Laminator Supplies(10)

Easels(10)

Adhesives/Glues(10)

Highlighters(10)

Hanging File Systems(9)

Card Holders(9)

Self-Stick Pads(8)

Staplers(8)

Name Badge Kits(8)

Desktop Supplies Organizers(7)

Scissors(7)

Partition & Panel Accessories(6)

Bookends(6)

Pad Folios(6)

Signs & Sign Holders(6)

Rulers(6)

Document Holders(5)

Shredder Bags(5)

Transparency Films(4)

File Fasteners(4)

Moisteners(4)

Cash Bags(4)

Filler Paper(4)

Pencil Cups(4)

Magazine Files(4)

Correction Tapes(4)

Drawer Organizers(4)

Sheet Protectors(4)

Forms(3)

Desktop Stands(3)

Push Pins(3)

Binder Pockets(3)

Awards & Certificates(3)

Memo Sheets(3)

Erasers(3)

Key Organizers(2)

Bags(2)

Staple Removers(2)

File Inserts/Tabs(2)

Letters, Numbers & Symbols(2)

Punches(2)

Laminators(2)

Letter Openers(2)

Hanging File Folder Racks(2)

Cash Drawers/Boxes/Trays(2)

Hanging File Frames(2)

Towels & Wipes(2)

Film Dispensers(1)

Tape Dispensers(1)

Staples(1)

Shredder Lubricants(1)

Waste Receptacles(1)

Desktop Sorting Racks/Space Savers(1)

Nameplates(1)

Hangers/Hooks(1)

Call Bells(1)

Copyholders(1)

Calendar Bases(1)

Cases(1)

Cleaners & Detergents(1)

Pencil & Crayon Sharpeners(1)

Card File Refills(1)

Art Paper(1)

Board Erasers(1)

 
Brand

Universal(1133)

 
Color

Black(1)

 
Height

11"(29)

8"(12)

6"(12)

10 1/2"(11)

8 1/2"(11)

10"(9)

9"(9)

5"(9)

12"(7)

2 1/2"(6)

7"(6)

9 3/4"(6)

1 3/4"(5)

34"(4)

2"(4)

11 3/4"(4)

2 3/4"(4)

12 1/2"(4)

12 1/4"(3)

11 1/2"(3)

9 1/2"(3)

11 1/4"(2)

10 1/8"(2)

4"(2)

9.45"(2)

10 3/4"(2)

4 1/2"(2)

2.4"(2)

10 7/8"(2)

11 7/8"(2)

3"(2)

13 1/2"(2)

7 1/2"(2)

22"(2)

36 1/2"(1)

14"(1)

3 3/4"(1)

13 1/8"(1)

20 1/2"(1)

3/4"(1)

1"(1)

14 1/2"(1)

24 3/8"(1)

6 3/4"(1)

1 1/4"(1)

12 3/4"(1)

13"(1)

28"(1)

9 5/8"(1)

5 5/8"(1)

1 3/8"(1)

1 1/8"(1)

18 1/4" to 39 3/8"(1)

9 1/4"(1)

8 1/8"(1)

11 5/8"(1)

5 1/8"(1)

5 3/8"(1)

14 1/8"(1)

2 1/8"(1)

12 3/8"(1)

8 3/4"(1)

 
Color(s)

Black(114)

White(87)

Clear(68)

Manila(32)

Assorted(24)

Red(21)

Blue(18)

Beige(16)

Yellow(16)

Brown Kraft(13)

Standard Green(11)

Royal Blue(11)

Kraft(9)

Silver(8)

Brown(8)

Burgundy(7)

Green(7)

Light Blue(7)

Redrope(6)

Navy Blue(5)

Violet(5)

Vintage Bronze(5)

Light Brown(4)

Translucent Black(4)

Charcoal(3)

Black/Gray(3)

Natural Kraft(3)

Violet/Light Violet(2)

Aluminum(2)

Fluorescent Yellow(2)

Bright Green(2)

White/Red(2)

Silver/White(2)

Black/Blue(2)

Fluorescent Orange(2)

Black; Blue; Green; Purple; White; Yellow(1)

Walnut(1)

Mahogany(1)

Navy(1)

Woodgrain(1)

Clear/Blue(1)

Black/White(1)

Semi-Opaque Black(1)

Clear/Black(1)

Blue;Clear(1)

Black/Clear(1)

Orange(1)

Fluorescent Pink(1)

Blue/Light Blue(1)

Bright Green/Light Green(1)

Red/Light Red(1)

Fluorescent Blue(1)

Black/Steel Gray(1)

Assorted Pastel(1)

Yellow/Light Yellow(1)

Fluorescent Green(1)

Metallic Blue/Steel Gray(1)

Translucent Blue(1)

 
Depth

1 3/4"(6)

5 3/4"(4)

2"(4)

4 3/4"(4)

1 5/8"(3)

8 1/4"(3)

15"(3)

1 1/8"(3)

4"(3)

9"(3)

3 3/8"(3)

6"(3)

5 1/4"(3)

3"(3)

13"(2)

14 5/8"(2)

10"(2)

0.4"(2)

2 1/2"(2)

9 1/8"(2)

4 1/8"(2)

3/4"(2)

1 1/2"(2)

11 7/8"(2)

10 1/2"(2)

1.33"(2)

14 1/4"(1)

17"(1)

7/8"(1)

11"(1)

18"(1)

22"(1)

5"(1)

5 1/2"(1)

3 1/2"(1)

25 1/2"(1)

7 3/4"(1)

6 7/8"(1)

4 1/4"(1)

12 1/2"(1)

3.15"(1)

3 1/4"(1)

8"(1)

9 1/4"(1)

3 5/8"(1)

14 1/8"(1)

12 3/8"(1)

8 1/8"(1)

1 1/4"(1)

1/4"(1)

8 1/2"(1)

7"(1)

10 1/4"(1)

10 1/8"(1)

13 1/2"(1)

2 7/8"(1)

5 3/8"(1)

7 1/2"(1)

11 3/4"(1)

1 13/16"(1)

13 5/8"(1)

 
Size

Letter(72)

Legal(68)

1" x 1 3/4"(11)

48 mm x 54.8 m(8)

48 mm x 50 m(7)

24 mm x 54.8 m(6)

18 mm x 54.8 m(4)

48 mm x 100 m(4)

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

1/2" x 1296"(2)

8 1/2" x 11"(2)

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

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

9 x 14 1/2(1)

9 x 11 1/2(1)

3/4" x 1296"(1)

3/4" x 300"(1)

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

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

2"(1)

1/2" x 2"(1)

1"(1)

Ball Size: 3"(1)

12(1)

3/4" x 1000"(1)

105(1)

33(1)

30(1)

62(1)

84(1)

3 1/2 x 6 1/2(1)

16(1)

14(1)

10(1)

18(1)

11" x 8 1/2"(1)

8" x 10"(1)

1 1/2" x 2"(1)

4" x 6"(1)

107(1)

 
Packing Type

Stick(8)

Bottle(1)

Spray Bottle(1)

 
Refillable

Nonrefillable(39)

No(5)

Yes(5)

Refillable(3)

Non-Refillable(2)

 
Overall Width

9 3/8"(1)

6 1/2"(1)

5 3/4"(1)

5 1/2"(1)

 
Overall Depth

4"(1)

6 1/2"(1)

5 3/4"(1)

6 3/4"(1)

 
Ink Color(s)

Red(12)

Blue(10)

Black; Blue; Green; Red; Violet(10)

Black(1)

 
Closure

Self-Adhesive(31)

Gummed(21)

Lift-Off Lid(8)

Zipper(6)

Clasp/Gummed(4)

Drawer(3)

Snap(2)

Latch(2)

String and Button(1)

Resealable Self-Adhesive(1)

Snap-On Lid(1)

Elastic(1)

 
Diameter

4 3/8"(3)

13"(2)

3 3/8"(2)

28"(1)

18"(1)

26"(1)

3/4"; 1 1/4"; 1 1/2"(1)

6 1/2"(1)

2 1/2"(1)

8 3/4"(1)

11 3/4"(1)

4 1/8"(1)

5/8"; 1"; 1 5/8"(1)

 
Expansion

No(44)

2"(39)

3/4"(34)

1"(10)

3"(9)

Flat(2)

2 in(2)

1 1/2"(1)

3 1/2"(1)

1/2"(1)

1 1/2 in(1)

4 in(1)

 
Base Color

Charcoal(1)

 
Binder Sheet Size

11 x 8 1/2(93)

11 x 17(6)

14 7/8 x 11(2)

9 1/2 x 11(2)

 
Binder Style

Non-View(58)

View(45)

 
Envelope/Mailer Type

Catalog/Booklet(32)

Business/Trade(16)

Cushioned/Media(4)

Coin(4)

Interoffice(1)

 
Envelope Size

10 x 13(11)

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

9 x 12(7)

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

3 7/8 x 8 7/8(3)

6 x 9(3)

12 x 16(2)

6 1/2 x 9 1/2(2)

10 1/2 x 16(2)

9 1/2 x 12 1/2(2)

12 x 15 1/2(1)

11 1/2 x 14 1/2(1)

8 1/2 x 12(1)

6 x 10(1)

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

7 1/2 x 10 1/2(1)

10 x 15(1)

12 x 9(1)

12 1/2 x 9 1/2(1)

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

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

3 1/2 x 6 1/2(1)

 
Opening

Open End(41)

Open Side(16)

 
Clip Capacity

1/2"(11)

1 1/4"(5)

3/4"(2)

2/5"(1)

 
Envelope/Mailer Interior Dimensions

9 1/2 x 15(2)

5 x 9(1)

7 1/2 x 11(1)

 
Paper Color(s)

White(49)

Green(4)

Assorted(3)

Pink(3)

Canary(3)

Ivory(2)

Blue(2)

Orchid(2)

Gray(2)

Blue;Pink;White(1)

Gray;Pink(1)

 
 
 

© 2019-2020 Gateway Business Products, All Rights Reserved