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` = "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(130)

Paper Pads/Note Pads(81)

File Folders(77)

Envelopes/Mailers(77)

Boards(60)

Classification Folders(49)

Clips/Clamps(44)

Pens(41)

Index Dividers(38)

Stamps(38)

Labels(35)

File Jackets/Sleeves/Wallets(28)

Hanging File Folders(27)

Roll Paper(26)

Office Paper(26)

Rubber Bands(25)

Markers(24)

Pocket Folders(24)

File Boxes(23)

Report Covers(23)

Packing Tape(22)

Index Cards(21)

Clipboards(21)

Self-Stick Pads(21)

Computer Printout Paper(21)

Stretch Films(18)

Page Flags(17)

Highlighters(17)

Tapes(16)

Frames(15)

Desktop File Folder Sorters(14)

Pencils(12)

Card Holders(11)

Clocks(11)

Laminator Supplies(11)

Hanging File Systems(10)

Easels(10)

Staplers(10)

Adhesives/Glues(10)

Sheet Protectors(10)

Name Badge Kits(9)

Correction Tapes(8)

Scissors(8)

File Fasteners(7)

Desktop Supplies Organizers(7)

Pad Folios(6)

Bookends(6)

Rulers(6)

Partition & Panel Accessories(6)

Signs & Sign Holders(6)

Document Holders(5)

Moisteners(5)

Shredder Bags(5)

Cash Bags(4)

Punches(4)

Transparency Films(4)

Drawer Organizers(4)

Filler Paper(4)

Hanging File Frames(4)

Magazine Files(4)

Pencil Cups(4)

Staple Removers(4)

Forms(3)

Binder Pockets(3)

Awards & Certificates(3)

Desktop Stands(3)

Erasers(3)

Memo Sheets(3)

Push Pins(3)

Staples(2)

Letter Openers(2)

Cash Drawers/Boxes/Trays(2)

Hanging File Folder Racks(2)

Key Organizers(2)

Bags(2)

Laminators(2)

Letters, Numbers & Symbols(2)

Towels & Wipes(2)

Tape Dispensers(2)

File Inserts/Tabs(2)

Calendar Bases(1)

Film Dispensers(1)

Shredder Lubricants(1)

Card File Refills(1)

Call Bells(1)

Copyholders(1)

Waste Receptacles(1)

Board Erasers(1)

Cleaners & Detergents(1)

Pencil & Crayon Sharpeners(1)

Cases(1)

Hangers/Hooks(1)

Greeting Cards(1)

Desktop Sorting Racks/Space Savers(1)

Art Paper(1)

Nameplates(1)

 
Brand

Universal(1373)

 
Color

Black(1)

 
Height

11"(29)

8"(14)

8 1/2"(14)

6"(12)

9"(11)

10 1/2"(11)

5"(9)

10"(9)

12"(7)

11 3/4"(7)

2 1/2"(6)

9 3/4"(6)

34"(6)

7"(6)

1 3/4"(5)

2 3/4"(4)

12 1/2"(4)

11 1/2"(4)

2"(4)

14"(3)

9 1/2"(3)

12 1/4"(3)

10 3/4"(2)

11 1/4"(2)

10 1/8"(2)

4"(2)

9.45"(2)

4 1/2"(2)

22"(2)

10 7/8"(2)

24 3/8"(2)

11 7/8"(2)

3"(2)

13 1/2"(2)

7 1/2"(2)

2.4"(2)

4 3/8"(1)

3 1/2"(1)

30"(1)

36 1/2"(1)

3 3/4"(1)

1"(1)

14 1/2"(1)

20 1/2"(1)

8 1/8"(1)

1 1/4"(1)

12 3/4"(1)

13"(1)

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

28"(1)

9 5/8"(1)

5 5/8"(1)

1 3/8"(1)

1 1/8"(1)

9 1/4"(1)

2 1/8"(1)

5 1/8"(1)

8 3/4"(1)

3/4"(1)

11 5/8"(1)

6 3/4"(1)

12 3/8"(1)

14 1/8"(1)

5 3/8"(1)

13 1/8"(1)

 
Color(s)

Black(137)

White(115)

Clear(88)

Manila(47)

Beige(29)

Assorted(28)

Brown Kraft(22)

Yellow(22)

Red(21)

Blue(19)

Standard Green(15)

Royal Blue(12)

Redrope(11)

Kraft(10)

Brown(10)

Silver(8)

Light Blue(7)

Green(7)

Burgundy(7)

Navy Blue(5)

Assorted Pastel(5)

Vintage Bronze(5)

Violet(5)

Light Brown(5)

Translucent Black(4)

Fluorescent Yellow(4)

Charcoal(3)

Natural Kraft(3)

Black/Gray(3)

White/Red(2)

Red/Light Red(2)

Black/Blue(2)

Gray(2)

Aluminum(2)

Silver/White(2)

Assorted Neon(2)

Assorted Bright(2)

Violet/Light Violet(2)

Fluorescent Orange(2)

Bright Green(2)

Fluorescent Green(2)

Yellow/Light Yellow(2)

Blue/Light Blue(2)

Fluorescent Blue(2)

Fluorescent Pink(2)

Semi-Opaque Black(1)

Woodgrain(1)

Clear/Blue(1)

Navy(1)

Walnut(1)

Mahogany(1)

Clear/Black(1)

Blue;Clear(1)

Black/Graphite/Red(1)

Bright Green/Light Green(1)

Black/Steel Gray(1)

Metallic Blue/Steel Gray(1)

Green/Light Green(1)

Orange(1)

Translucent Blue(1)

Orange/Light Orange(1)

Black/Clear(1)

Black/White(1)

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

 
Depth

1 3/4"(6)

4 3/4"(4)

2"(4)

5 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)

3 1/2"(2)

10"(2)

13"(2)

10 1/2"(2)

14 5/8"(2)

2 1/2"(2)

11 7/8"(2)

0.4"(2)

3/4"(2)

1.33"(2)

1 1/2"(2)

4 1/8"(2)

25 1/2"(2)

9 1/8"(2)

17"(1)

22"(1)

11"(1)

7/8"(1)

14 1/4"(1)

18"(1)

7 3/4"(1)

4 1/4"(1)

12 1/2"(1)

5"(1)

3 1/4"(1)

6 7/8"(1)

3.15"(1)

2 3/4"(1)

5 1/2"(1)

8"(1)

12 3/8"(1)

9 1/4"(1)

3 5/8"(1)

8 1/8"(1)

8 1/2"(1)

1 1/4"(1)

1/4"(1)

3 1/8"(1)

14 1/8"(1)

7"(1)

10 1/8"(1)

13 1/2"(1)

2 7/8"(1)

5 3/8"(1)

7 1/2"(1)

10 1/4"(1)

11 3/4"(1)

1 13/16"(1)

13 5/8"(1)

 
Size

Letter(105)

Legal(76)

1" x 1 3/4"(11)

48 mm x 54.8 m(9)

48 mm x 50 m(7)

24 mm x 54.8 m(6)

48 mm x 100 m(5)

18 mm x 54.8 m(4)

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

18(2)

16(2)

9 x 11 1/2(2)

3/4" x 1000"(2)

1/2" x 1296"(2)

8 1/2" x 11"(2)

3/4" x 1296"(2)

19(2)

33(2)

32(2)

54(2)

64(2)

117(2)

1"(1)

3/4" x 300"(1)

12(1)

1/2" x 2"(1)

9 x 14 1/2(1)

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

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

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

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

2"(1)

4" x 6"(1)

105(1)

107(1)

Ball Size: 3"(1)

84(1)

62(1)

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

10(1)

8" x 10"(1)

1 1/2" x 2"(1)

30(1)

14(1)

11" x 8 1/2"(1)

 
Packing Type

Stick(8)

Bottle(1)

Spray Bottle(1)

 
Refillable

Nonrefillable(42)

No(5)

Yes(4)

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(15)

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

Blue(10)

Black(1)

 
Closure

Self-Adhesive(34)

Gummed(30)

Lift-Off Lid(12)

Clasp/Gummed(11)

Zipper(6)

String and Button(4)

Drawer(4)

Latch(2)

Snap(2)

String & Button(1)

Snap-On Lid(1)

Elastic(1)

Resealable Self-Adhesive(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(62)

2"(48)

3/4"(46)

1"(10)

3"(9)

1/2"(2)

Flat(2)

1 1/2"(2)

2 in(2)

3 1/2"(1)

1 1/2 in(1)

4 in(1)

 
Base Color

Charcoal(1)

 
Binder Sheet Size

11 x 8 1/2(120)

11 x 17(6)

14 7/8 x 11(2)

9 1/2 x 11(2)

 
Binder Style

View(67)

Non-View(63)

 
Envelope/Mailer Type

Catalog/Booklet(41)

Business/Trade(24)

Cushioned/Media(6)

Coin(4)

Interoffice(2)

 
Envelope Size

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

10 x 13(14)

9 x 12(9)

6 x 9(4)

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

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

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

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

10 1/2 x 16(2)

8 1/2 x 12(2)

6 x 10(2)

12 x 15 1/2(2)

12 x 16(2)

10 x 15(2)

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

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

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

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

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

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

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

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

12 x 9(1)

 
Opening

Open End(53)

Open Side(24)

 
Clip Capacity

1/2"(11)

1 1/4"(7)

3/4"(2)

2/5"(1)

 
Envelope/Mailer Interior Dimensions

5 x 9(2)

9 1/2 x 15(2)

7 1/2 x 11(2)

 
Paper Color(s)

White(57)

Canary(6)

Green(5)

Assorted(3)

Pink(3)

Blue(3)

Ivory(2)

Gray(2)

Orchid(2)

Gray;Pink(1)

Blue;Pink;White(1)

 
 
 

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