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_2` 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(114)

Paper Pads/Note Pads(71)

File Folders(66)

Envelopes/Mailers(66)

Boards(60)

Classification Folders(48)

Index Dividers(38)

Pens(37)

Labels(32)

Clips/Clamps(30)

File Jackets/Sleeves/Wallets(27)

Stamps(26)

Markers(24)

Pocket Folders(24)

Report Covers(23)

Hanging File Folders(22)

Packing Tape(22)

Roll Paper(21)

File Boxes(21)

Index Cards(21)

Office Paper(19)

Clipboards(19)

Computer Printout Paper(18)

Rubber Bands(18)

Self-Stick Pads(17)

Page Flags(17)

Highlighters(15)

Tapes(13)

Desktop File Folder Sorters(13)

Stretch Films(12)

Clocks(11)

Laminator Supplies(10)

Adhesives/Glues(10)

Staplers(10)

Easels(10)

Hanging File Systems(10)

Frames(9)

Name Badge Kits(9)

Sheet Protectors(9)

Pencils(8)

Card Holders(8)

Desktop Supplies Organizers(7)

Scissors(7)

Correction Tapes(7)

Signs & Sign Holders(6)

Partition & Panel Accessories(6)

Rulers(6)

File Fasteners(5)

Bookends(5)

Shredder Bags(5)

Moisteners(5)

Filler Paper(4)

Pad Folios(4)

Document Holders(4)

Magazine Files(4)

Pencil Cups(4)

Drawer Organizers(4)

Hanging File Frames(4)

Cash Bags(4)

Forms(3)

Erasers(3)

Memo Sheets(3)

Binder Pockets(3)

Push Pins(3)

Desktop Stands(3)

Awards & Certificates(3)

Cash Drawers/Boxes/Trays(2)

Key Organizers(2)

Punches(2)

Laminators(2)

Towels & Wipes(2)

Staple Removers(2)

File Inserts/Tabs(2)

Hanging File Folder Racks(2)

Letter Openers(2)

Letters, Numbers & Symbols(2)

Board Erasers(1)

Desktop Sorting Racks/Space Savers(1)

Film Dispensers(1)

Tape Dispensers(1)

Cases(1)

Art Paper(1)

Transparency Films(1)

Staples(1)

Pencil & Crayon Sharpeners(1)

Hangers/Hooks(1)

Card File Refills(1)

Nameplates(1)

Waste Receptacles(1)

Greeting Cards(1)

Call Bells(1)

Shredder Lubricants(1)

Calendar Bases(1)

Cleaners & Detergents(1)

Copyholders(1)

 
Brand

Universal(1209)

 
Color

Black(1)

 
Height

8.5"(13)

11"(10)

6"(9)

10"(8)

7"(6)

12"(6)

2.5"(6)

1.75"(5)

12.5"(4)

2"(4)

5"(4)

13.5"(3)

11.5"(3)

2.75"(3)

9"(3)

4.5"(2)

7.5"(2)

4"(2)

11.88"(2)

10.75"(2)

9.45"(2)

2.4"(2)

10.13"(2)

3"(2)

12.63"(2)

11.75"(1)

10.88"(1)

9 1/2"(1)

11 1/4"(1)

10.5"(1)

13 1/8"(1)

12 1/4"(1)

0.75"(1)

14 1/2"(1)

8.75"(1)

11 1/2"(1)

3.75"(1)

12.75"(1)

5.63"(1)

12.38"(1)

9.75"(1)

1.25"(1)

13"(1)

28"(1)

18.25" to 39.38"(1)

9.25"(1)

2.13"(1)

9.63"(1)

5.13"(1)

14.13"(1)

1.13"(1)

1.38"(1)

11.25"(1)

6.75"(1)

8.13"(1)

11.63"(1)

5.38"(1)

 
Color(s)

Black(82)

Clear(77)

White(71)

Assorted(20)

Brown Kraft(17)

Silver(13)

Redrope(11)

Yellow(11)

Manila(11)

Blue(10)

Brown(7)

Natural Kraft(5)

Assorted Pastel(5)

Beige(5)

Vintage Bronze(5)

Kraft/Green(4)

Translucent Black(4)

Light Brown Kraft(4)

Black/Gray(3)

Charcoal(3)

Fluorescent Yellow(3)

Aluminum(2)

Red(2)

Black/Blue(2)

Silver/White(2)

Green(2)

Fluorescent Green(2)

Assorted Neon(2)

Fluorescent Orange(2)

Assorted Bright(2)

Fluorescent Pink(2)

Fluorescent Blue(2)

Clear/Black(1)

Steel(1)

Navy(1)

Burgundy(1)

Walnut(1)

Mahogany(1)

Black/Clear(1)

Woodgrain(1)

Clear/Blue(1)

Black/White(1)

Semi-Opaque Black(1)

Blue;Clear(1)

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

Black/Steel Gray(1)

Translucent Blue(1)

Black/Graphite/Red(1)

Metallic Blue/Steel Gray(1)

 
Depth

1.75"(4)

4.75"(4)

9"(3)

2"(3)

1.13"(3)

5.75"(3)

4"(3)

3.38"(3)

15"(3)

1.63"(3)

5.25"(3)

3"(3)

25.5"(2)

4.13"(2)

11.88"(2)

10"(2)

14.63"(2)

13"(2)

0.4"(2)

1.33"(2)

8.25"(2)

1.5"(2)

6"(2)

10.5"(2)

5"(1)

2 1/2"(1)

4.25"(1)

3.25"(1)

1.81"(1)

14.25"(1)

6.78"(1)

17"(1)

18"(1)

7.75"(1)

3.5"(1)

11"(1)

1 3/4"(1)

7/8"(1)

12.5"(1)

22"(1)

0.25"(1)

13.63"(1)

14.13"(1)

2.5"(1)

3 1/8"(1)

8.5"(1)

8.13"(1)

12.38"(1)

9.13"(1)

9.25"(1)

3.63"(1)

7"(1)

2.88"(1)

10.88"(1)

10.25"(1)

5.5"(1)

11.75"(1)

7.5"(1)

5.38"(1)

1.25"(1)

10.13"(1)

13.5"(1)

8"(1)

 
Size

Letter(16)

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)

0.5 x 1.75(3)

9 x 11.5(2)

8.5 x 11(2)

0.5" x 36 yds(2)

3.5 x 6.5(1)

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)

0.75" x 36 yds(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)

Blue(10)

Black(1)

 
Closure

Self-Adhesive(32)

Gummed(28)

Lift-Off Lid(11)

Zipper(6)

Clasp/Gummed(5)

Two Flaps(4)

Pull Drawer(4)

Open Top(2)

Latch(2)

Elastic(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"(5)

1.5"(3)

0.5"(2)

Flat(2)

1"(2)

4"(1)

 
Base Color

Charcoal(1)

 
Binder Sheet Size

11 x 8.5(103)

11 x 17(6)

9.5 x 11(2)

14.88 x 11(2)

11 x 8 1/2(1)

 
Binder Style

Non-View(60)

View(54)

 
Opening

Open End(44)

Open Side(22)

 
Clip Capacity

0.5"(8)

1.25"(5)

1/2"(3)

0.75"(2)

0.4"(1)

 
Paper Color(s)

Blue;Pink;White(1)

Pink(1)

Gray;Pink(1)

White(1)

 
 
 

© 2020-2021 ISEOP, All Rights Reserved