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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` LEFT JOIN `dealer_special` AS `ds` ON `ds`.`sku`=`pinfo`.`sku` AND CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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 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` WHERE `pinfo`.`best_seller`>0 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 `best_seller` DESC

Best Sellers

Currently Filtered by

Best Sellers

Refine Search

  GO
Category

Ink/Toner Cartridges(415)

Pens/Markers/Highlighters(82)

Notes & Flags(75)

File Folders(73)

Labels(53)

Binders(34)

Mailers & Envelopes(32)

Tab Indexes(30)

Printing Media(30)

Staplers(28)

Art/Writing Pads & Sheets(26)

combbind(24)

Batteries(22)

Cups & Mugs(18)

Binding Covers(16)

Kitchen Utensils(14)

Stands & Equipment Cabinets(13)

Pins & Clamps(13)

Shipping & Storage Boxes/Tanks(13)

Adhesive Tapes(13)

Copy & Multi-use White Paper(11)

Tissues & Napkins(11)

Household Cleaners(10)

Staples(9)

Creamers(9)

Printing Drums(9)

Pencils(8)

Chairs & Seating(7)

Kitchenware(7)

Board Erasers & Correctors(6)

Filing/Binding Accessories(5)

Lamination Sheets & Cartridges(5)

Medications & Treatments(5)

Forms & Record Keeping(4)

coil(4)

Coil(4)

Correction Tapes(4)

Wrist/Mouse Pads(4)

Racks & Organizers(4)

Clipboards(4)

Pointing Devices(4)

Laminating Supplies(3)

Armoires & Cabinets(3)

Printing Kits(3)

Miscellaneous Kits(3)

Tape Dispensers(3)

Combbind(3)

Desktop Staplers(3)

Hole Punch(3)

Scissors(3)

Band-Aids & Bandages(2)

Surge Suppressors/Protectors(2)

Wastebaskets & Trash Cans(2)

Indoor/Outdoor Heaters(2)

Printer Ink/Toner Refills & Waste Collectors(2)

Staple Removers(2)

Headsets/Earsets(2)

Erase Boards/Films(2)

Glass Cleaners(2)

Soaps & Sanitizers(2)

Skin Wipes(2)

Mounting Kits(2)

Keyboard/Keypad & Pointing Device Kits(2)

Hand Soaps/Cleaners(2)

Calendar Desk Pads(2)

Optical Media(1)

Tally Counters(1)

Calculators(1)

Erasers(1)

Pens(1)

Moistening Pads(1)

Beverages(1)

Notes & Flags Dispensers(1)

Media Holders(1)

Ergonomic Supports(1)

First Aid Kits(1)

Pencil Sharpeners(1)

Photo & Business Cards Albums(1)

Holders(1)

Hooks & Hangers(1)

Keyboards & Keypads(1)

Printer Parts & Components(1)

Fusers(1)

Hand Sanitizers(1)

Liquid Soap / Sanitizer Dispensers(1)

Furniture Collection(1)

Brand

HP(410)

Business Source(122)

Avery®(85)

Post-it®(58)

Smead(46)

Brother(38)

Pilot(28)

Lorell(26)

Dixie(25)

Pentel(24)

BIC(22)

Genuine Joe(19)

Duracell(16)

TOPS(14)

MAX(13)

Quality Park(12)

Bostitch(12)

Swingline(12)

Hammermill(11)

Sparco(11)

Bankers Box(10)

Fellowes(9)

Coffee-Mate(8)

Mead(8)

Scotch(8)

Sharpie(7)

Acco(7)

Logitech(6)

Energizer(6)

Compucessory(6)

Kleenex(6)

Zebra Pen(5)

C-Line(5)

Integra(5)

Expo(4)

Lysol(4)

Highland(4)

Duck Brand(3)

Clorox(3)

First Aid Only(3)

Saunders(3)

Professional Lysol(2)

Plantronics(2)

3M(2)

PerfecTouch(2)

Advil(2)

Southworth(2)

SICURIX(1)

Verbatim(1)

Neenah(1)

Sharp Calculators(1)

Boise(1)

Sealed Air(1)

Navigator(1)

Windex®(1)

Tombow(1)

Puffs(1)

Tylenol(1)

Motrin(1)

International Delight(1)

Aleve(1)

Compact(1)

Adams(1)

X-Acto(1)

PURELL®(1)

Cardinal(1)

Pacon(1)

SanPellegrino(1)

Rediform(1)

Color

White(175)

Black(91)

Clear(42)

Assorted(36)

Blue(33)

Yellow(26)

Silver(20)

Green(19)

Red(19)

Manila(19)

Canary Yellow(14)

Gray(10)

Kraft(9)

Purple(7)

Redrope(5)

Pink(5)

Standard Green(4)

Orange(3)

Matte Clear(3)

Brown(3)

Coffee Haze(2)

Canary(2)

Beige(2)

Neon(2)

Pastel(2)

Diamond Clear(2)

Brown Kraft(2)

Aqua(2)

Dark Blue(2)

Lime(1)

Bright Blue(1)

Bright Green(1)

Bright White(1)

Goldenrod(1)

Aluminum(1)

Off White(1)

Dark Brown(1)

Ivory(1)

Putty(1)

Assorted Neon(1)

Assorted Pastel(1)

PINK(1)

Magenta(1)

Light Blue(1)

Earth Red(1)

Graphite(1)

Light Gray(1)

Smoke(1)

Orchid Purple(1)

Pearl(1)

Bright Pink(1)

Brightness

100(3)

98(3)

96(1)

97(1)

92(1)

Size

5.88" Length(1)

Size Supported

3" Width x 3" Length Note(1)

Binder Capacity

1"(8)

3"(7)

2"(5)

1/2"(5)

1 1/2"(4)

4"(3)

5"(2)

Size

Letter(136)

Legal(15)

Jr.Legal(4)

Ledger(2)

Ledger/Tabloid(2)

Tabloid(1)

A8(1)

Recycled

No(486)

Yes(168)

Price Range

$0-$499.99(1223)

$500-$999.99(13)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CleanAir Granite Office

© 2020-2021 Granite Office, LLC, All Rights Reserved