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

Standard Ring Binders(61)

Mailing & Address Labels(30)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Large Format/Catalog Envelopes(23)

Adhesive Note Pads(21)

Sheet Protectors(20)

Laminating Supplies(19)

Rubber Bands(19)

Top Tab Manila Folders(18)

Plain Tab Index Dividers(18)

Clasp Envelopes(18)

Storage Boxes & Containers(16)

Binder Clips(16)

Report Covers(16)

Memo / Subject Notebooks(16)

Top Tab Colored Folders(13)

Clipboards(13)

Desktop Staplers(12)

Ticket Holders(12)

Easel Pads(10)

Transparent & Invisible Tapes(10)

Index Dividers(9)

Calculator & Register Rolls(9)

TYVEK & Tear-Resistant Envelopes(9)

Desktop Hole Punches(9)

Insertable Tab Index Dividers(9)

Paper Clips(8)

Interior Folders(8)

Manila Jackets(8)

Copy & Multi-use White Paper(7)

Steno Pads(7)

Top Tab Accessories(7)

Expanding Pockets(7)

Ballpoint Stick Pens(7)

Receipt Books(7)

Masking Tapes(7)

Inkjet Paper(7)

Air Dusters(6)

Glue Sticks & Pens(6)

Green Hanging Folders(6)

Laminating Machines(6)

Portfolios(6)

Letter, Legal & Jr. Pads(6)

Index Cards(6)

Filing Labels & Systems(6)

Coin Envelopes(5)

Hanging Box Bottom Folders(5)

Binding Index Dividers(4)

Bookends(4)

Letter Trays(4)

Interdepartmental Envelopes(4)

Rulers & Yardsticks(4)

Paper Rolls(4)

Heavy-Duty Staplers(4)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Packaging Tapes(3)

Catalog Racks(2)

Staples(2)

Desktop Organizers(2)

Push Pins(2)

Ballpoint Retractable Pens(2)

CD/DVD Labels(2)

Sales Forms & Refills(2)

Legal Index Dividers(2)

Name Badges/Systems(2)

Wood Pencils(2)

Punch Heads(2)

Scissors(1)

Sheet Lifters(1)

Multi-part Computer Paper(1)

Filler Papers(1)

Color Jackets(1)

Shipping Tape Dispensers(1)

Staple Removers(1)

Desktop File Sorters(1)

Packaging Tape(1)

Index Tabs & Page Markers(1)

Packing List/Invoice Enclosed Envelopes(1)

Tank-Style Highlighters(1)

Tape Dispensers(1)

Specialty Staplers(1)

Electric Hole Punches(1)

Pencil Holders(1)

Binder Pockets(1)

Letter Openers(1)

Magazine Files(1)

Brand

Business Source(837)

Color

White(166)

Black(147)

Clear(79)

Red(31)

Silver(28)

Manila(28)

Assorted(21)

Brown Kraft(20)

Crepe(19)

Yellow(19)

Green(18)

Blue(15)

Kraft(14)

Dark Blue(14)

Brown(13)

Gray(9)

Navy(8)

Redrope(7)

Burgundy(6)

Purple(6)

Multi(6)

Standard Green(6)

Tan(6)

Chrome(5)

Putty(4)

Bright White(4)

Orange(4)

Non-glare(3)

Light Blue(3)

Bright Red(2)

Semi Clear(2)

Neon Pink(2)

Neon(2)

Pastel(2)

Clear Front(2)

Neon Yellow(2)

Neon Green(2)

Teal(1)

Smoke(1)

Wood Grain(1)

Crystal(1)

Brightness

92(7)

96(6)

Binder Capacity

1"(30)

1 1/2"(26)

2"(21)

3"(18)

1/2"(15)

5"(7)

4"(7)

Size

Letter(227)

Legal(30)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

Recycled

No(610)

Yes(171)

Price Range

$0-$499.99(928)

$7000-$7499.99(1)

$8000-$8499.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