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 (`manufacturer_id` = "1701658") AND `pinfo`.`status` IN ('active','discontinued') 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 MATCH(`desc_short`) AGAINST ('businesssource' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+businesssource' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"businesssource"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"businesssource"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"businesssource"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"businesssource"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+businesssource' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='businesssource',`category_4` ='businesssource') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'businesssource,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('businesssource', `pinfo`.`desc_title`)) DESC

Manufacturer

Currently Filtered by

Manufacturer

Business Source

Refine Search

  GO
Category

Presentation / View Binders(105)

Standard Ring Binders(77)

Clipboards(45)

Mailing & Address Labels(30)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Rubber Bands(24)

Large Format/Catalog Envelopes(23)

Sheet Protectors(22)

Laminating Supplies(22)

Privacy Filters(22)

Adhesive Note Pads(21)

Plain Tab Index Dividers(20)

Top Tab Manila Folders(20)

Index Dividers(19)

Clasp Envelopes(18)

Memo / Subject Notebooks(16)

Storage Boxes & Containers(16)

Top Tab Fastener Folders(16)

Report Covers(16)

Binder Clips(16)

Desktop Hole Punches(14)

Copier/Laser/Inkjet Index Dividers(13)

Top Tab Colored Folders(13)

Ticket Holders(12)

Book Rings(12)

Expanding Pockets(11)

Bulldog Clips(11)

Poly Jackets(11)

Desktop Staplers(11)

Paper Rolls(10)

Desktop Organizers(10)

Transparent & Invisible Tapes(10)

Easel Pads(10)

Calculator & Register Rolls(9)

Paper Clips(9)

TYVEK & Tear-Resistant Envelopes(9)

Insertable Tab Index Dividers(9)

Name Badge Holders(8)

Green Hanging Folders(8)

Interior Folders(8)

Masking Tapes(8)

Manila Jackets(8)

Ballpoint Stick Pens(7)

Expanding Files(7)

Laminating Machines(7)

Receipt Books(7)

Top Tab Accessories(7)

Inkjet Paper(7)

Steno Pads(7)

Letter, Legal & Jr. Pads(6)

Portfolios(6)

Index Cards(6)

Paper Fasteners(6)

Filing Labels & Systems(6)

Pre-printed Index Dividers(6)

Binder Pockets(6)

Classification Folders (Paper Stock)(6)

Filament Tape(5)

End Tab Fastener Folders(5)

Copy & Multi-use White Paper(5)

Name Badges/Systems(5)

Hanging Box Bottom Folders(5)

Coin Envelopes(5)

Interdepartmental Envelopes(5)

Letter Trays(5)

Glue Sticks & Pens(5)

Binding Index Dividers(4)

Push Pins(4)

Wallets(4)

Heavy-Duty Staplers(4)

Packaging Tapes(4)

Desktop File Sorters(4)

Bookends(4)

Packing List/Invoice Enclosed Envelopes(3)

Cross-Cut/Confetti-Cut Shredders(3)

Note Cards(3)

Shredder Bags(3)

Electric/Battery Operated Staplers(3)

Hanging Folder Frames(3)

Punch Heads(3)

Poly Envelopes(3)

Rulers & Yardsticks(3)

Letter Openers(3)

End Tab Folders(3)

Air Dusters(3)

Sales Forms & Refills(2)

Duct Tapes(2)

Staple Removers(2)

Hanging Accessories(2)

Catalog Racks(2)

Color Hanging Folders(2)

Digital Projectors(2)

Staples(2)

Ballpoint Retractable Pens(2)

Wood Pencils(2)

CD/DVD Labels(2)

Laser Toner Cartridges(2)

Legal Index Dividers(2)

Desktop Copyholders(2)

Multi-part Computer Paper(1)

Double-Sided Tapes(1)

Color Jackets(1)

Magazine Files(1)

Business Card Refills(1)

Moisteners(1)

Paper Clip Holders(1)

Scissors(1)

Call Bells(1)

Sheet Lifters(1)

Magnetic Push Pins(1)

Thermal Fax Paper(1)

Hanging Pockets(1)

Medical File Folders(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Index Tabs & Page Markers(1)

Telephone Stands & Holders(1)

Pencil Holders(1)

Tape Dispensers(1)

Copyholders(1)

Glare/Radiation Filters(1)

Vinyl/Plastic Pockets & Sleeves(1)

Shipping Tape Dispensers(1)

Packaging Tape(1)

End Tab Classification Folders(1)

Screen Protectors(1)

Board Erasers(1)

Specialty Staplers(1)

Brand

Business Source(1088)

Sparco(4)

Color

White(190)

Black(183)

Clear(105)

Silver(57)

Red(46)

Manila(30)

Blue(29)

Green(29)

Yellow(26)

Assorted(25)

Brown(24)

Brown Kraft(20)

Crepe(19)

Kraft(14)

Navy(14)

Dark Blue(14)

Gray(8)

Light Blue(8)

Smoke(8)

Orange(7)

Redrope(7)

Tan(7)

Standard Green(6)

Burgundy(6)

Purple(5)

Natural(5)

Putty(4)

Neon Pink(4)

Chrome(4)

Neon Green(4)

Bright White(4)

Multi(3)

Non-glare(3)

Black Graphite(2)

Bright Red(2)

Semi Clear(2)

Clear Front(2)

Stainless Steel(2)

Pastel(2)

Neon(2)

Neon Orange(2)

Neon Yellow(2)

Violet(2)

Teal(1)

Graphite(1)

Ebony(1)

Crystal(1)

Wood Grain(1)

Brightness

96(6)

92(5)

Binder Capacity

1"(40)

1 1/2"(36)

2"(31)

3"(28)

1/2"(18)

5"(14)

4"(14)

Size

Letter(348)

Legal(45)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

Recycled

No(795)

Yes(232)

Price Range

$0-$499.99(1091)

$500-$999.99(1)

To  GO

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

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