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)

Markers(10)

Pens(7)

Soap Dispensers(6)

Inks & Toners(6)

Table Accessories(6)

Utility Drawers(5)

Chairs/Stools(5)

Self-Stick Pads(4)

Clips/Clamps(3)

Table Bases/Legs(3)

Shelving Units/Bookcases(3)

Toilet & Urinal Deodorizers(3)

Reception Seating & Sofas(3)

Paper Pads/Note Pads(2)

Staple Removers(2)

Tables(2)

File Jackets/Sleeves/Wallets(2)

Binders(2)

Sentence Strips(2)

Water(2)

Scissors(2)

Storage Cabinets(2)

Office Chair(2)

Staplers(2)

Sponges(2)

Partition & Panel Systems(2)

Highlighters(2)

Residential Chair(1)

Art Boards(1)

Labels(1)

File Fasteners(1)

Carts & Organizers(1)

Paint Supplies(1)

Packing Tape(1)

Envelopes/Mailers(1)

File Folders(1)

Spacing Disks(1)

Cleaners & Detergents(1)

Clipboards(1)

Hanging File Folders(1)

Staples(1)

Keyboard Drawers/Platforms(1)

Pumps(1)

Apparel(1)

Stamps(1)

Crayons(1)

Casters & Glides(1)

Mop & Broom Handles(1)

Staple Guns(1)

Label Maker Supplies(1)

Dust Mop Frames(1)

Coat Lockers(1)

First Aid Kit Refills(1)

Signs & Sign Holders(1)

Hand Dryers(1)

Adhesives/Glues(1)

Credenzas(1)

Toilet Tissues(1)

Towels & Wipes(1)

Hand Sanitizers(1)

Office Paper(1)

Maintenance & Breakroom(1)

Document Holders(1)

Brand

OFFICE STAR PRODUCTS(31)

Universal(20)

Pacon(9)

SunWorks(8)

HP(6)

Pilot(6)

Boardwalk(5)

Crayola(3)

Swingline(3)

First Aid Only(2)

Avery(2)

uni-ball(2)

Paper Mate(2)

Scott(2)

Alera(2)

Tide(1)

Pendaflex(1)

Quartet(1)

Weiler(1)

Smead(1)

EXPO(1)

Quality Park(1)

Oxford(1)

Post-it Notes Super Sticky(1)

HON(1)

Champion Sports(1)

Brother P-Touch(1)

BIC(1)

Westcott(1)

Arrow(1)

Creativity Street(1)

ACCUSTAMP2(1)

Scotch(1)

Nestle Waters(1)

Scotch-Brite PROFESSIONAL(1)

Post-it Notes(1)

Hammermill(1)

Deer Park(1)

Color

Espresso|67564e(5)

Maple|b98e61(5)

Cherry|DE3163(4)

Black|000000(3)

Coal(3)

Urban Walnut(2)

Blue|0000FF(1)

Charcoal|36454F(1)

Translucent Clear/Silver(1)

Putty|efead7(1)

(1)

Gray(1)

Natural|FFFFFF(1)

Mahogany|C04000(1)

Light Grey|808080(1)

Height

3"(2)

9.5"(1)

11.75"(1)

8 3/4"(1)

6.1"(1)

6 2/25"(1)

Color(s)

Black(5)

White(4)

Assorted(3)

Magenta(2)

Silver(2)

Yellow(2)

Clear(2)

Assorted Pastel(2)

Brown(1)

Clear/Orange(1)

Satin Chrome(1)

Steel(1)

Fluorescent Yellow(1)

Fluorescent Green(1)

Red Fiber(1)

Marrakesh Collection(1)

Assorted;Assorted Bright Color Design(1)

Red;White(1)

Natural(1)

24 Assorted(1)

Cyan(1)

Dark Blue(1)

Yellow/Green(1)

Jaipur Collection(1)

Bright White(1)

Width

24"(3)

14.75"(1)

9.25"(1)

1.88"(1)

11/1/4"(1)

3.6"(1)

3 2/3"(1)

10 1/10"(1)

4"(1)

Depth

5"(1)

Size

1.88" x 60 yds(1)

Letter(1)

Legal(1)

Packing Type

Bottle(2)

Box(1)

Can(1)

Packet(1)

Refillable

No(2)

Yes(1)

Overall Width

38"(1)

48"(1)

28 1/2"(1)

47 5/8"(1)

Overall Depth

64"(1)

60"(1)

19 3/4"(1)

23 5/8"(1)

Flavor

Spring Water(1)

Ink Color(s)

Blue(2)

Blue Black(1)

Blue/Red(1)

Closure

Self-Adhesive(1)

Base Color

Black(1)

Binder Sheet Size

11 x 8.5(2)

Binder Style

View(2)

Beverage Type

Water(2)

Opening

Open End(1)

Clip Capacity

1 1/4"(1)

Applicable Material

Fabric(1)

Application

Laundry Detergent(1)

Hand Washing;Washrooms(1)

Bare Floors(1)

Book/Pad Binding Edge

Top(2)

Book/Pad Binding Type

Taped(1)

Wirebound(1)

Book/Pad Sheet Color(s)

White(2)

Book/Pad Sheet Size

8.5 x 11.75(1)

24 x 16(1)

Book/Pad Subjects/Sections

1(2)

Color Family

Multicolor(14)

Black(8)

White(7)

Blue(6)

Red(4)

Yellow(3)

Silver(2)

Green(2)

Manila(2)

Clear(2)

Orange(1)

Purple(1)

Crown Size

0.5"(3)

Flap Type

Square(1)

Interpack Quantity Description

30/Sheet, 100 Sheets/Box(1)

Market Indicator (Cartridge Number)

HP 972A(4)

HP 935XL(1)

HP 934XL(1)

OEM/Compatible

OEM(6)

Paper Basis Weight (lb)

58 lb(8)

50 lb(2)

10 lb(2)

76 lb(1)

20 lb(1)

Paper/Media Color(s)

Assorted(3)

White(2)

Violet(1)

Blue(1)

Yellow(1)

Orange(1)

Red(1)

Cream Manila(1)

Turquoise(1)

Canary(1)

Black(1)

Physical Form

Powder(1)

Series Name

HON Verse´ Series(1)

Sheet Basis Weight (lb)

16 lb(1)

15 lb(1)

Sheet Ruling Color(s)

Blue(2)

Sheet Ruling Size

3/8"(1)

1 1/2"(1)

Sheet Ruling Type

Wide/Legal(1)

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

Sheets per Book/Pad

50(1)

25(1)

Special Features

Box(2)

Translucent Barrels(2)

Box-Value Pack -- Stock up and save!(1)

Optima 20-Detachable staple remover, low-staple indicator light and adjustable depth guide (six AA batteries - sold separately).(1)

Top-Print Front-Printed "Packing List/Invoice Enclosed." Large, clear window under printing allows shipping papers to show through and serves as address label.(1)

Value Pack-Pack of three.(1)

11 pt. Manila(1)

Complete-Prong base and compressor.(1)

Address Labels(1)

Pastel Assortment-Three pads each of Pastel Green, Pastel Blue, Pastel Pink and Yellow.(1)

Pastel Assortment-Two pads of Pastel Pink as well as one pad each of Pastel Blue, Pastel Green and Yellow.(1)

Washes 80 Loads(1)

Medium(1)

Xtra Life Ballpoint(1)

Back-Mounted Rings-Textured clear cover; pages lie flat.(1)

Standard-For 36" to 48" tops.(1)

Tuck Box(1)

Classic Colors-Black, blue, brown, gray, green, orange, pink, red, violet and yellow.(1)

1 1/2" Handwritting-Practice Rule(1)

Four-Ply-Value Pack -- Stock up and save!(1)

C-Fold Towels, 100% Recycled Hand Towels(1)

For Unitized and First Aid Stations(1)

Rectangular Top(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

© 2020-2021 United Supply Corp, All Rights Reserved