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

Standard Ring Binders(62)

Pocket Portfolios/Folders(30)

Mailing & Address Labels(30)

Business Envelopes(27)

Large Format/Catalog Envelopes(23)

Rubber Bands(23)

Adhesive Note Pads(21)

Sheet Protectors(21)

Privacy Filters(21)

Top Tab Manila Folders(20)

Plain Tab Index Dividers(20)

Index Dividers(19)

Laminating Supplies(19)

Clasp Envelopes(18)

Memo / Subject Notebooks(16)

Binder Clips(16)

Storage Boxes & Containers(16)

Report Covers(16)

Clipboards(15)

Top Tab Fastener Folders(14)

Copier/Laser/Inkjet Index Dividers(13)

Top Tab Colored Folders(13)

Desktop Staplers(12)

Ticket Holders(12)

Book Rings(12)

Desktop Hole Punches(11)

Bulldog Clips(11)

Expanding Pockets(11)

Poly Jackets(11)

Paper Clips(10)

Transparent & Invisible Tapes(10)

Easel Pads(10)

TYVEK & Tear-Resistant Envelopes(9)

Paper Rolls(9)

Insertable Tab Index Dividers(9)

Desktop Organizers(9)

Calculator & Register Rolls(9)

Interior Folders(8)

Manila Jackets(8)

Masking Tapes(8)

Name Badge Holders(8)

Steno Pads(7)

Expanding Files(7)

Receipt Books(7)

Copy & Multi-use White Paper(7)

Top Tab Accessories(7)

Ballpoint Stick Pens(7)

Inkjet Paper(7)

Pre-printed Index Dividers(6)

Laminating Machines(6)

Filing Labels & Systems(6)

Paper Fasteners(6)

Air Dusters(6)

Index Cards(6)

Binder Pockets(6)

Portfolios(6)

Glue Sticks & Pens(6)

Green Hanging Folders(6)

Classification Folders (Paper Stock)(6)

Letter, Legal & Jr. Pads(6)

Filament Tape(5)

Letter Trays(5)

Hanging Box Bottom Folders(5)

Interdepartmental Envelopes(5)

Coin Envelopes(5)

End Tab Fastener Folders(5)

Push Pins(4)

Desktop File Sorters(4)

Packaging Tapes(4)

Name Badges/Systems(4)

Binding Index Dividers(4)

Rulers & Yardsticks(4)

Bookends(4)

Heavy-Duty Staplers(4)

Shredder Bags(3)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Hanging Folder Frames(3)

Poly Envelopes(3)

End Tab Folders(3)

Punch Heads(3)

Ballpoint Retractable Pens(2)

Duct Tapes(2)

Catalog Racks(2)

Staples(2)

Hanging Accessories(2)

Color Hanging Folders(2)

CD/DVD Labels(2)

Letter Openers(2)

Sales Forms & Refills(2)

Wallets(2)

Legal Index Dividers(2)

Desktop Copyholders(2)

Wood Pencils(2)

Double-Sided Tapes(1)

Color Jackets(1)

Multi-part Computer Paper(1)

Magazine Files(1)

Electric Hole Punches(1)

Paper Clip Holders(1)

Filler Papers(1)

Thermal Fax Paper(1)

Scissors(1)

Staple Removers(1)

Call Bells(1)

Cross-Cut/Confetti-Cut Shredders(1)

Packaging Tape(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Copyholders(1)

Telephone Stands & Holders(1)

Packing List/Invoice Enclosed Envelopes(1)

Pencil Holders(1)

Index Tabs & Page Markers(1)

Medical File Folders(1)

Glare/Radiation Filters(1)

Shipping Tape Dispensers(1)

Sheet Lifters(1)

Tape Dispensers(1)

End Tab Classification Folders(1)

Screen Protectors(1)

Hanging Pockets(1)

Specialty Staplers(1)

Brand

Business Source(1009)

Color

White(184)

Black(162)

Clear(95)

Silver(50)

Red(40)

Green(28)

Manila(28)

Blue(25)

Yellow(25)

Assorted(24)

Brown(22)

Brown Kraft(20)

Crepe(19)

Kraft(14)

Dark Blue(14)

Navy(10)

Gray(9)

Redrope(7)

Orange(7)

Purple(6)

Light Blue(6)

Multi(6)

Burgundy(6)

Standard Green(6)

Chrome(5)

Tan(5)

Natural(4)

Putty(4)

Bright White(4)

Non-glare(3)

Pastel(2)

Semi Clear(2)

Bright Red(2)

Smoke(2)

Neon(2)

Stainless Steel(2)

Clear Front(2)

Neon Pink(2)

Neon Green(2)

Neon Yellow(2)

Ebony(1)

Teal(1)

Crystal(1)

Graphite(1)

Wood Grain(1)

Brightness

92(7)

96(6)

Binder Capacity

1"(33)

1 1/2"(32)

2"(26)

3"(23)

1/2"(17)

5"(12)

4"(8)

Size

Letter(312)

Legal(43)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

Recycled

No(728)

Yes(224)

Price Range

$0-$499.99(1016)

$7500-$7999.99(1)

$8500-$8999.99(1)

To  GO

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

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