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)

Portfolios(6)

Heavy-Duty Staplers(6)

Green Hanging Folders(6)

Expanding Pockets(6)

Name Badges/Systems(6)

Letter, Legal & Jr. Pads(6)

Index Cards(6)

Hanging Box Bottom Folders(5)

Rulers & Yardsticks(5)

Coin Envelopes(5)

Masking Tapes(5)

Laminating Machines(5)

Binding Index Dividers(4)

Steno Pads(4)

Paper Rolls(4)

Letter Trays(4)

Staples(4)

Interdepartmental Envelopes(4)

Electric/Battery Operated Staplers(3)

Binder Pockets(3)

Packaging Tapes(3)

Packing List/Invoice Enclosed Envelopes(3)

CD/DVD Labels(3)

Foot Rests(2)

Staple Removers(2)

Hole Reinforcements(2)

Catalog Racks(2)

Bookends(2)

Punch Heads(2)

Desktop Organizers(2)

Push Pins(2)

Sales Forms & Refills(2)

Legal Index Dividers(2)

Ballpoint Retractable Pens(2)

Heavy-Duty Hole Punches(2)

Wood Pencils(2)

Multi-part Computer Paper(1)

Inkjet Paper(1)

Desktop File Sorters(1)

Scissors(1)

Magazine Files(1)

Sheet Lifters(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)

Tank-Style Highlighters(1)

Shipping Tape Dispensers(1)

Specialty Staplers(1)

Brand

Business Source(726)

Color

White(148)

Black(107)

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

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)

Size

Assorted(1)

#33 - 3.50" Length x 0.13"(1)

#32 - 3" Length x 0.13"(1)

#62 - 2.50" Length x 0.25"(1)

#64 - 3.25" Length x 0.25"(1)

#84 - 3.50" Length x 0.50"(1)

#8 - 0.88" Length x 62.5 mil(1)

#73 - 3" Length x 0.38"(1)

#31 - 2.50" Length x 0.13"(1)

#30 - 2" Length x 50 mil(1)

#117B - 7" Length x 0.13"(1)

#107 - 7" Length x 0.63"(1)

#105 - 5" Length x 0.63"(1)

#12 - 1.75" Length x 1.06"(1)

#14 - 2" Length x 62.5 mil(1)

#19 - 3.50" Length x 62.5 mil(1)

#18 - 3" Length x 62.5 mil(1)

#16 - 2.50" Length x 62.5 mil(1)

#10 - 1.25" Length x 62.5 mil(1)

Binder Capacity

1"(25)

2"(19)

3"(18)

1 1/2"(17)

1/2"(8)

5"(7)

4"(7)

Size

Letter(176)

Legal(26)

Tabloid(6)

Recycled

No(499)

Yes(150)

Price Range

$0-$499.99(726)

$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