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)

Poly Jackets(11)

Desktop Staplers(11)

Bulldog Clips(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)

Laminating Machines(7)

Expanding Files(7)

Ballpoint Stick Pens(7)

Receipt Books(7)

Top Tab Accessories(7)

Inkjet Paper(7)

Steno Pads(7)

Portfolios(6)

Letter, Legal & Jr. Pads(6)

Index Cards(6)

Filing Labels & Systems(6)

Paper Fasteners(6)

Air Dusters(6)

Pre-printed Index Dividers(6)

Binder Pockets(6)

Classification Folders (Paper Stock)(6)

Hanging Box Bottom Folders(5)

End Tab Fastener Folders(5)

Interdepartmental Envelopes(5)

Glue Sticks & Pens(5)

Filament Tape(5)

Copy & Multi-use White Paper(5)

Name Badges/Systems(5)

Letter Trays(5)

Coin Envelopes(5)

Packaging Tapes(4)

Push Pins(4)

Heavy-Duty Staplers(4)

Binding Index Dividers(4)

Bookends(4)

Wallets(4)

Desktop File Sorters(4)

Cross-Cut/Confetti-Cut Shredders(3)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Shredder Bags(3)

Hanging Folder Frames(3)

Poly Envelopes(3)

Letter Openers(3)

Packing List/Invoice Enclosed Envelopes(3)

End Tab Folders(3)

Rulers & Yardsticks(3)

Punch Heads(3)

Sales Forms & Refills(2)

Digital Projectors(2)

Duct Tapes(2)

Staple Removers(2)

Staples(2)

Ballpoint Retractable Pens(2)

Laser Toner Cartridges(2)

CD/DVD Labels(2)

Legal Index Dividers(2)

Catalog Racks(2)

Desktop Copyholders(2)

Wood Pencils(2)

Color Hanging Folders(2)

Hanging Accessories(2)

Magazine Files(1)

Color Jackets(1)

Paper Clip Holders(1)

Moisteners(1)

Double-Sided Tapes(1)

Multi-part Computer Paper(1)

Business Card Refills(1)

Magnetic Push Pins(1)

Call Bells(1)

Sheet Lifters(1)

Thermal Fax Paper(1)

Scissors(1)

Hanging Pockets(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Copyholders(1)

Index Tabs & Page Markers(1)

Telephone Stands & Holders(1)

Tape Dispensers(1)

Pencil Holders(1)

Medical File Folders(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(1091)

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)

Tan(7)

Redrope(7)

Standard Green(6)

Multi(6)

Burgundy(6)

Purple(5)

Natural(5)

Putty(4)

Neon Pink(4)

Chrome(4)

Bright White(4)

Neon Green(4)

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

Yes(232)

Price Range

$0-$499.99(1094)

$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