SELECT `pinfo`.`sku`,`pinfo`.`vendor`, 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_12` 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 `pinfo`.`sku` IN (SELECT `sku` FROM `dealer_best_seller` `dsp` WHERE `dsp`.`type`='featured') 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_cost`=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 `best_seller` DESC

Currently Filtered by

Featured

Refine Search

  GO
Category Filter

Art Paper(13)

Hand Sanitizer Accessories(11)

Soap Dispensers(9)

Partition & Panel Systems(8)

Chairs/Stools(7)

Mailroom Markers(7)

Hand Dryers(7)

Stamps(7)

Table Accessories(6)

Inks & Toners(6)

Utility Drawers(5)

Pens(4)

Self-Stick Pads(4)

Partition & Panel Systems Hardware(3)

Markers(3)

First Aid Kit Refills(3)

Table Bases/Legs(3)

Reception Seating & Sofas(3)

Clips/Clamps(3)

Shelving Units/Bookcases(3)

File Jackets/Sleeves/Wallets(2)

Paper Pads/Note Pads(2)

Sit-Stand Desks(2)

Storage Cabinets(2)

Resin Chairs(2)

Workstation Mobile Device Mounts & Stands(2)

Staple Removers(2)

Sentence Strips(2)

Desks(2)

Staplers(2)

Highlighters(2)

Crayons(2)

Binders(2)

Tables(2)

Toilet & Urinal Deodorizers(2)

Office Chair(2)

Dividers(2)

Scissors(1)

Carts & Organizers(1)

File Fasteners(1)

Barriers(1)

Keyboard Drawers/Platforms(1)

Document Holders(1)

Adhesives/Glues(1)

Credenzas(1)

Scouring Pads & Sticks(1)

Packing Tapes(1)

Personal Soaps(1)

Staples(1)

Laundry Detergents(1)

Envelopes/Mailers(1)

Art Boards(1)

Residential Chair(1)

Panels/Partitions(1)

Clipboards(1)

Hanging File Folders(1)

File Folders(1)

Labels(1)

Workstation Monitor Mounts & Stands(1)

Handles & Braces(1)

Floor Dusters & Accessories(1)

Label Maker Supplies(1)

Sponges(1)

Coffee Makers(1)

Pumps(1)

Casters & Glides(1)

School Supplies(1)

CPR Masks(1)

Towel Dispensers(1)

Pliers & Cutters(1)

Signs & Sign Holders(1)

Maintenance & Breakroom(1)

Dough & Dough Tools(1)

Staplers & Riveters(1)

Agility(1)

Scooter Sports(1)

Office Paper(1)

Skateboards(1)

Accessories(1)

Mixers/Blenders(1)

Other(1)

Toilet Tissues(1)

Stickers(1)

Hand Sanitizers(1)

Tossing and Target Games(1)

Plastic Baseballs(1)

Clothing Protection(1)

Storage Units(1)

Indoor/Outdoor(1)

Coat Lockers(1)

Beach Balls(1)

Brand

OFFICE STAR PRODUCTS(31)

Universal(20)

Pacon(9)

SunWorks(8)

HON(7)

Champion Sports(6)

Pilot(6)

HP(6)

Xstamper(5)

Safco(5)

Boardwalk(4)

First Aid Only(4)

Fellowes(3)

Crayola(3)

Swingline(3)

Avery(2)

Alera(2)

Tide(1)

Victor(1)

Pendaflex(1)

Trodat(1)

EXPO(1)

Smead(1)

Quality Park(1)

Paper Mate(1)

Quartet(1)

Post-it Notes Super Sticky(1)

Brother P-Touch(1)

Creativity Street(1)

BIC(1)

Arrow(1)

Westcott(1)

ACCUSTAMP2(1)

Hammermill(1)

Scotch(1)

3M(1)

Scotch-Brite PROFESSIONAL(1)

Post-it Notes(1)

Scott(1)

Oxford(1)

Color

Gray(7)

Maple|b98e61(5)

Espresso|67564e(5)

Cherry|DE3163(4)

Black|000000(4)

Coal(3)

Blue|0000FF(2)

Urban Walnut(2)

Natural|FFFFFF(2)

Gray/White(1)

Black/White(1)

Translucent Clear/Silver(1)

Clear(1)

Orange|FFA500(1)

Charcoal|36454F(1)

(1)

Mahogany|C04000(1)

Putty|efead7(1)

Light Grey|808080(1)

Recycled

No(1)

Height

3"(2)

28"(1)

11.75"(1)

9.5"(1)

6.08"(1)

8.75"(1)

6.1"(1)

Color(s)

Black(6)

Assorted(5)

Magenta(2)

White(2)

Clear(2)

Silver(2)

Black/Silver(2)

Assorted Pastel(2)

Yellow(2)

Clear/Orange(1)

Red Fiber(1)

Satin Chrome(1)

Brown(1)

Bright White(1)

Steel(1)

Floral Fantasy Collection(1)

Red; White(1)

Natural(1)

Assorted;Assorted Bright Color Design(1)

Cyan(1)

Yellow/Green(1)

Playful Primaries Collection(1)

Dark Blue(1)

Width

24"(3)

14.75"(1)

30"(1)

9.25"(1)

1.88"(1)

11.25"(1)

3.6"(1)

3.67"(1)

0.31"(1)

15.13"(1)

4"(1)

13"(1)

Depth

8"(1)

13"(1)

11.38"(1)

5"(1)

Size

1.88" x 60 yds(1)

Letter(1)

Legal(1)

16"(1)

Packing Type

Box(1)

Can(1)

Packet(1)

Overall Width

42"(2)

38"(1)

23.5"(1)

48"(1)

36"(1)

28.5"(1)

24"(1)

30"(1)

47.63"(1)

Overall Depth

21.5"(2)

2.5"(1)

64"(1)

19.75"(1)

23.63"(1)

Ink Color(s)

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

Black; Blue; Red; Blue/Red(1)

Blue/Red(1)

Closure

Self-Adhesive(1)

Base Color

Black(1)

Binder Sheet Size

11 x 8.5(2)

Binder Style

View(2)

Opening

Open End(1)

Clip Capacity

1.25"(1)

Application/Usage

Cashier Stand(1)

Personal Desk(1)

Teller Window(1)

Service Counter(1)

Reception Station(1)

Bank(1)

Retailer(1)

Office(1)

Colored Material Type

Wax(1)

Crown Size

0.5"(3)

Flap Type

Square(1)

Layouts Available

324(1)

800(1)

323(1)

OEM/Compatible

OEM(6)

Compatible(3)

Pad Length

11.75"(1)

16"(1)

Physical Form

Powder(1)

Series Name

HON Verse´ Series(4)

Safco Impromptu(2)

Fellowes Office Suites(2)

Victor DCX700 High Rise Collection(1)

Fellowes Lotus(1)

Sheet Ruling Size

11/32"(1)

1 1/2"(1)

Sheet/Roll Size

9 x 12(9)

12 x 18(2)

20 x 30(1)

48" x 50 ft(1)

8.5 x 11(1)

Staple Remover Type

Jaw(1)

Heavy-Duty(1)

Tab Type

Top Tab(1)

Text/Label Colors

Black Print on Yellow Tape(1)

 
 
Searching for your Best Results.....
Loading...
 
AbilityOne Distributor HP Qualified Supplies Partner

© 2022-2023 United Supply Corp, All Rights Reserved