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

Partition & Panel Systems(9)

Soap Dispensers(9)

Mailroom Markers(7)

Chairs/Stools(7)

Stamps(7)

Hand Dryers(7)

Inks & Toners(6)

Utility Drawers(5)

Table Accessories(5)

Self-Stick Pads(4)

Pens(4)

Clips/Clamps(3)

First Aid Kit Refills(3)

Partition & Panel Systems Hardware(3)

Table Bases/Legs(3)

Toilet & Urinal Deodorizers(3)

Markers(3)

Reception Seating & Sofas(3)

Shelving Units/Bookcases(3)

File Jackets/Sleeves/Wallets(2)

Paper Pads/Note Pads(2)

Workstation Mobile Device Mounts & Stands(2)

Resin Chairs(2)

Storage Cabinets(2)

Sit-Stand Desks(2)

Sentence Strips(2)

Desks(2)

Staple Removers(2)

Crayons(2)

Tables(2)

Office Chair(2)

Staplers(2)

Highlighters(2)

Binders(2)

Labels(1)

Bottled Water(1)

Scissors(1)

File Fasteners(1)

Carts & Organizers(1)

Scouring Pads & Sticks(1)

Barriers(1)

Adhesives/Glues(1)

Credenzas(1)

Keyboard Drawers/Platforms(1)

Packing Tapes(1)

Classroom Management(1)

Personal Soaps(1)

Staples(1)

Mouthwash(1)

Laundry Detergents(1)

Art Boards(1)

Residential Chair(1)

Envelopes/Mailers(1)

Clipboards(1)

Hanging File Folders(1)

File Folders(1)

Document Holders(1)

Stickers(1)

Handles & Braces(1)

Floor Dusters & Accessories(1)

Label Maker Supplies(1)

Sponges(1)

Coffee Makers(1)

Casters & Glides(1)

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

Pumps(1)

Agility(1)

Office Paper(1)

Skateboards(1)

Workstation Monitor Mounts & Stands(1)

Accessories(1)

Mixers/Blenders(1)

Other(1)

Toilet Tissues(1)

Hand Sanitizers(1)

Indoor/Outdoor(1)

Plastic Baseballs(1)

Scooter Sports(1)

Tossing and Target Games(1)

Clothing Protection(1)

Coat Lockers(1)

Storage Units(1)

Beach Balls(1)

Brand

OFFICE STAR PRODUCTS(30)

Universal(20)

Pacon(9)

SunWorks(8)

HON(7)

Champion Sports(6)

HP(6)

Pilot(6)

Safco(5)

Boardwalk(5)

Xstamper(5)

First Aid Only(4)

Swingline(3)

Crayola(3)

Fellowes(3)

Alera(2)

Avery(2)

Tide(1)

Johnson & Johnson(1)

Victor(1)

Pendaflex(1)

Quartet(1)

Paper Mate(1)

EXPO(1)

Smead(1)

Quality Park(1)

Trodat(1)

Scotch-Brite PROFESSIONAL(1)

Creativity Street(1)

ACCUSTAMP2(1)

Brother P-Touch(1)

BIC(1)

Westcott(1)

Arrow(1)

Hammermill(1)

Scott(1)

3M(1)

Nestle Waters(1)

Scotch(1)

Post-it Notes Super Sticky(1)

Post-it Notes(1)

Oxford(1)

Color

Gray(7)

Espresso|67564e(5)

Cherry|DE3163(4)

Maple|b98e61(4)

Black|000000(4)

Coal(3)

Blue|0000FF(2)

Urban Walnut(2)

Natural|FFFFFF(2)

Clear(2)

Gray/White(1)

Translucent Clear/Silver(1)

Orange|FFA500(1)

Black/White(1)

Charcoal|36454F(1)

(1)

Mahogany|C04000(1)

Putty|efead7(1)

Light Grey|808080(1)

Height

3"(2)

9.5"(1)

11.75"(1)

8.75"(1)

6.1"(1)

6.08"(1)

Color(s)

Black(6)

Assorted(5)

White(3)

Black/Silver(2)

Silver(2)

Magenta(2)

Clear(2)

Assorted Pastel(2)

Yellow(2)

Clear/Orange(1)

Red Fiber(1)

Satin Chrome(1)

Brown(1)

Bright White(1)

Steel(1)

Jaipur Collection(1)

Red; White(1)

Natural(1)

Assorted;Assorted Bright Color Design(1)

Cyan(1)

Yellow/Green(1)

Marrakesh Collection(1)

Dark Blue(1)

Width

24"(3)

11.25"(1)

14.75"(1)

9.25"(1)

1.88"(1)

13"(1)

3.6"(1)

3.67"(1)

0.31"(1)

15.13"(1)

4"(1)

Depth

13"(1)

11.38"(1)

5"(1)

Size

1.88" x 60 yds(1)

Letter(1)

Legal(1)

16"(1)

Packing Type

Box(1)

Pump Bottle(1)

Bottle(1)

Can(1)

Packet(1)

Overall Width

30"(2)

42"(2)

38"(1)

23.5"(1)

48"(1)

36"(1)

28.5"(1)

24"(1)

47.63"(1)

Overall Depth

21.5"(2)

2.5"(1)

8"(1)

64"(1)

19.75"(1)

23.63"(1)

Flavor

Cool Mint(1)

Spring Water(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

Silver(1)

Black(1)

Binder Sheet Size

11 x 8.5(2)

Binder Style

View(2)

Beverage Type

Water(1)

Opening

Open End(1)

Clip Capacity

1.25"(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)

Safco Runtz Series(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

© 2021-2022 United Supply Corp, All Rights Reserved