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','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 '%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(80)

File Folders(77)

Envelopes/Mailers(76)

Boards(60)

Classification Folders(49)

Clips/Clamps(44)

Pens(40)

Stamps(38)

Index Dividers(38)

Labels(34)

File Jackets/Sleeves/Wallets(28)

Hanging File Folders(27)

Roll Paper(26)

Office Paper(25)

Rubber Bands(25)

Markers(24)

Pocket Folders(24)

File Boxes(23)

Report Covers(23)

Packing Tape(22)

Self-Stick Pads(21)

Index Cards(21)

Clipboards(21)

Computer Printout Paper(19)

Page Flags(17)

Stretch Films(17)

Tapes(16)

Highlighters(16)

Desktop File Folder Sorters(13)

Clocks(11)

Laminator Supplies(11)

Card Holders(11)

Frames(11)

Staplers(10)

Easels(10)

Sheet Protectors(10)

Hanging File Systems(10)

Pencils(10)

Adhesives/Glues(10)

Name Badge Kits(9)

Scissors(8)

Correction Tapes(8)

Desktop Supplies Organizers(7)

File Fasteners(7)

Rulers(6)

Partition & Panel Accessories(6)

Bookends(6)

Signs & Sign Holders(6)

Moisteners(5)

Document Holders(5)

Pad Folios(5)

Shredder Bags(5)

Hanging File Frames(4)

Drawer Organizers(4)

Magazine Files(4)

Cash Bags(4)

Filler Paper(4)

Pencil Cups(4)

Punches(4)

Push Pins(3)

Memo Sheets(3)

Awards & Certificates(3)

Staple Removers(3)

Erasers(3)

Forms(3)

Desktop Stands(3)

Binder Pockets(3)

Cash Drawers/Boxes/Trays(2)

Staples(2)

Key Organizers(2)

Laminators(2)

Letter Openers(2)

Transparency Films(2)

Towels & Wipes(2)

File Inserts/Tabs(2)

Letters, Numbers & Symbols(2)

Tape Dispensers(2)

Hanging File Folder Racks(2)

Waste Receptacles(1)

Cases(1)

Film Dispensers(1)

Hangers/Hooks(1)

Nameplates(1)

Calendar Bases(1)

Board Erasers(1)

Desktop Sorting Racks/Space Savers(1)

Cleaners & Detergents(1)

Art Paper(1)

Card File Refills(1)

Greeting Cards(1)

Pencil & Crayon Sharpeners(1)

Call Bells(1)

Shredder Lubricants(1)

Copyholders(1)

 
Brand

Universal(1351)

 
Color

Black(1)

 
Height

8.5"(14)

11"(10)

6"(10)

10"(8)

2.5"(6)

7"(6)

12"(6)

1.75"(5)

12.5"(4)

2"(4)

2.75"(4)

5"(4)

9"(4)

11.5"(3)

13.5"(3)

3"(2)

10.88"(2)

2.4"(2)

10.75"(2)

12 1/4"(2)

4"(2)

9.45"(2)

10.13"(2)

11.88"(2)

4.5"(2)

7.5"(2)

12.63"(2)

12.38"(1)

28"(1)

10.5"(1)

3 1/2"(1)

4 3/8"(1)

3.75"(1)

11.75"(1)

9.75"(1)

0.75"(1)

12.75"(1)

9 1/2"(1)

11 1/4"(1)

14 1/2"(1)

36 1/2"(1)

13 1/8"(1)

13"(1)

14.13"(1)

11.63"(1)

1.13"(1)

5.38"(1)

2.13"(1)

1.38"(1)

6.75"(1)

8.13"(1)

5.13"(1)

9.63"(1)

1.25"(1)

9.25"(1)

5.63"(1)

18.25" to 39.38"(1)

11 1/2"(1)

8.75"(1)

11.25"(1)

 
Color(s)

Black(87)

Clear(87)

White(76)

Brown Kraft(23)

Assorted(20)

Silver(15)

Yellow(15)

Manila(12)

Redrope(11)

Blue(10)

Brown(9)

Natural Kraft(5)

Assorted Pastel(5)

Vintage Bronze(5)

Beige(5)

Light Brown Kraft(5)

Translucent Black(4)

Kraft/Green(4)

Fluorescent Yellow(4)

Charcoal(3)

Black/Gray(3)

Black/Blue(2)

Gray(2)

Fluorescent Pink(2)

Red(2)

Steel(2)

Fluorescent Blue(2)

Silver/White(2)

Aluminum(2)

Assorted Bright(2)

Fluorescent Orange(2)

Fluorescent Green(2)

Green(2)

Assorted Neon(2)

Black/Graphite/Red(1)

Clear/Black(1)

Navy(1)

Burgundy(1)

Walnut(1)

Mahogany(1)

Black/Clear(1)

Clear/Blue(1)

Metallic Blue/Steel Gray(1)

Woodgrain(1)

Translucent Blue(1)

Black/White(1)

Blue;Clear(1)

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

Black/Steel Gray(1)

Semi-Opaque Black(1)

 
Depth

4.75"(4)

1.75"(4)

5.75"(4)

2"(3)

8.25"(3)

15"(3)

3.38"(3)

3"(3)

9"(3)

5.25"(3)

4"(3)

1.13"(3)

1.63"(3)

11.88"(2)

13"(2)

14.63"(2)

1.33"(2)

0.4"(2)

25.5"(2)

1.5"(2)

10.5"(2)

4.13"(2)

10"(2)

6"(2)

6.78"(1)

22"(1)

12.5"(1)

7/8"(1)

1 3/4"(1)

11"(1)

18"(1)

17"(1)

3.5"(1)

14.25"(1)

7.75"(1)

9.13"(1)

3/4"(1)

3 1/2"(1)

3.25"(1)

4.25"(1)

1.81"(1)

5"(1)

2 3/4"(1)

13.63"(1)

2 1/2"(1)

7"(1)

2.5"(1)

8.13"(1)

12.38"(1)

1.25"(1)

0.25"(1)

9.25"(1)

3.63"(1)

14.13"(1)

10.88"(1)

2.88"(1)

10.25"(1)

3 1/8"(1)

5.5"(1)

8.5"(1)

7.5"(1)

5.38"(1)

8"(1)

10.13"(1)

13.5"(1)

11.75"(1)

 
Size

Letter(17)

1 x 1.75(11)

Legal(10)

1.88" x 54.6 yds(7)

24 mm x 54.8 m(6)

48 mm x 54.8 m(5)

1.88" x 110 yds(5)

1.88" x 60 yds(4)

18 mm x 54.8 m(4)

9 x 11.5(3)

0.5 x 1.75(3)

0.75" x 36 yds(2)

8.5 x 11(2)

0.5" x 36 yds(2)

0.75" x 83.33 ft(2)

5.5 x 3.5(1)

1"(1)

6.5 x 4.38(1)

2.13 x 3.38(1)

2"(1)

2.5 x 4.25(1)

3.5 x 6.5(1)

3.75 x 2.25(1)

18 x 12(1)

9 x 14.5(1)

3.75 x 3.88(1)

0.75" x 25 ft(1)

11 x 8.5(1)

8 x 10(1)

1.5 x 2(1)

4 x 6(1)

0.5 x 2(1)

 
Packing Type

Stick(8)

Spray Bottle(1)

Bottle(1)

Cartridge(1)

 
Overall Width

5.5"(1)

5.75"(1)

6.5"(1)

9.38"(1)

 
Overall Depth

6.75"(1)

5.75"(1)

6.5"(1)

4"(1)

 
Ink Color(s)

Red(15)

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

Blue(10)

Black(1)

 
Closure

Self-Adhesive(33)

Gummed(30)

Lift-Off Lid(13)

Clasp/Gummed(11)

Zipper(6)

Two Flaps(4)

Pull Drawer(4)

Open Top(2)

Latch(2)

Snap(1)

Elastic(1)

String & Button(1)

Resealable Self-Adhesive(1)

 
Diameter

4.38"(3)

3.38"(2)

13"(2)

2.5"(1)

8.75"(1)

11.75"(1)

4.13"(1)

6.5"(1)

0.63"; 1"; 1.63"(1)

0.75"; 1.25"; 1.5"(1)

26"(1)

18"(1)

28"(1)

 
Expansion

2"(6)

1.5"(3)

0.5"(2)

Flat(2)

1"(2)

4"(1)

 
Base Color

Charcoal(1)

 
Binder Sheet Size

11 x 8.5(120)

11 x 17(6)

9.5 x 11(2)

14.88 x 11(2)

 
Binder Style

View(67)

Non-View(63)

 
Envelope/Mailer Type

Cushioned/Media(1)

 
Envelope Size

6 x 10(1)

 
Opening

Open End(52)

Open Side(24)

 
Clip Capacity

0.5"(8)

1.25"(7)

1/2"(3)

0.75"(2)

0.4"(1)

 
Envelope/Mailer Interior Dimensions

5 x 9(1)

 
Paper Color(s)

Blue;Pink;White(1)

Pink(1)

Gray;Pink(1)

White(1)

 
 
 

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