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

Standard Ring Binders(42)

Mailing & Address Labels(28)

Business Envelopes(27)

Pocket Portfolios/Folders(26)

Large Format/Catalog Envelopes(24)

Adhesive Note Pads(22)

Plain Tab Index Dividers(22)

Laminating Supplies(20)

Clasp Envelopes(20)

Rubber Bands(19)

Top Tab Manila Folders(18)

Storage Boxes & Containers(16)

Memo / Subject Notebooks(16)

Sheet Protectors(16)

Binder Clips(14)

Top Tab Colored Folders(13)

Ticket Holders(12)

Desktop Staplers(12)

Insertable Tab Index Dividers(11)

Easel Pads(10)

Filing Labels & Systems(10)

Transparent & Invisible Tapes(9)

TYVEK & Tear-Resistant Envelopes(9)

Calculator & Register Rolls(9)

Index Dividers(8)

Paper Clips(8)

Manila Jackets(8)

Report Covers(8)

Clipboards(8)

Interior Folders(8)

Glue Sticks & Pens(8)

Top Tab Accessories(7)

Ballpoint Stick Pens(7)

Receipt Books(7)

Hole Punches(7)

Copy & Multi-use White Paper(7)

Laminating Machines(7)

Portfolios(6)

Expanding Pockets(6)

Index Cards(6)

Letter, Legal & Jr. Pads(6)

Heavy-Duty Staplers(6)

Green Hanging Folders(6)

Name Badges/Systems(6)

Hanging Box Bottom Folders(5)

Rulers & Yardsticks(5)

Coin Envelopes(5)

Masking Tapes(5)

Steno Pads(4)

Letter Trays(4)

Binding Index Dividers(4)

Interdepartmental Envelopes(4)

Staples(4)

Paper Rolls(4)

Binder Pockets(3)

Packing List/Invoice Enclosed Envelopes(3)

CD/DVD Labels(3)

Packaging Tapes(3)

Electric/Battery Operated Staplers(3)

Hole Reinforcements(2)

Sales Forms & Refills(2)

Catalog Racks(2)

Bookends(2)

Staple Removers(2)

Heavy-Duty Hole Punches(2)

Ballpoint Retractable Pens(2)

Punch Heads(2)

Push Pins(2)

Legal Index Dividers(2)

Desktop Organizers(2)

Wood Pencils(2)

Inkjet Paper(1)

Scissors(1)

Multi-part Computer Paper(1)

Magazine Files(1)

Desktop File Sorters(1)

Tank-Style Highlighters(1)

Name Badge Holders(1)

Letter Openers(1)

Pencil Holders(1)

Electric Hole Punches(1)

Luggage Accessories(1)

Tape Dispensers(1)

Index Tabs & Page Markers(1)

Filler Papers(1)

Packaging Tape(1)

Color Jackets(1)

Sheet Lifters(1)

Shipping Tape Dispensers(1)

Specialty Staplers(1)

Brand

Business Source(726)

Color

White(148)

Black(105)

Clear(65)

Red(29)

Manila(28)

Brown Kraft(22)

Assorted(20)

Silver(19)

Yellow(19)

Crepe(19)

Green(17)

Blue(15)

Kraft(14)

Dark Blue(10)

Gray(8)

Navy(8)

Brown(7)

Burgundy(6)

Purple(6)

Tan(6)

Standard Green(6)

Redrope(6)

Bright White(4)

Chrome(4)

Putty(4)

Non-glare(3)

Orange(3)

Pastel(2)

Clear Front(2)

Neon Yellow(2)

Neon(2)

Neon Green(2)

Neon Pink(2)

Semi Clear(2)

Light Blue(1)

Smoke(1)

Wood Grain(1)

Brightness

92(7)

Binder Capacity

1"(25)

2"(19)

3"(18)

1 1/2"(17)

1/2"(8)

5"(7)

4"(7)

Size

Letter(186)

Legal(30)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

Recycled

No(496)

Yes(152)

Price Range

$0-$499.99(738)

$6000-$6499.99(1)

$6500-$6999.99(1)

To  GO

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

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