Banner1 Banner1
 
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_1` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 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 `pinfo`.`sku` LIKE '%BusinessSource' THEN 1 ELSE 0 END DESC, 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

Currently Filtered by

Manufacturer

Business Source

Refine Search

  GO
 
Category

Standard Ring Binders(61)

Presentation / View Binders(59)

Pocket Portfolios/Folders(30)

Mailing & Address Labels(29)

Business Envelopes(27)

Large Format/Catalog Envelopes(24)

Adhesive Note Pads(21)

Laminating Supplies(19)

Sheet Protectors(19)

Rubber Bands(19)

Plain Tab Index Dividers(18)

Clasp Envelopes(18)

Top Tab Manila Folders(18)

Storage Boxes & Containers(16)

Report Covers(16)

Binder Clips(14)

Memo / Subject Notebooks(14)

Top Tab Colored Folders(13)

Desktop Staplers(12)

Clipboards(12)

Ticket Holders(12)

Easel Pads(10)

TYVEK & Tear-Resistant Envelopes(9)

Desktop Hole Punches(9)

Index Dividers(9)

Insertable Tab Index Dividers(9)

Calculator & Register Rolls(8)

Interior Folders(8)

Paper Clips(8)

Transparent & Invisible Tapes(8)

Manila Jackets(8)

Top Tab Accessories(7)

Inkjet Paper(7)

Receipt Books(7)

Steno Pads(7)

Ballpoint Stick Pens(7)

Letter, Legal & Jr. Pads(6)

Air Dusters(6)

Index Cards(6)

Green Hanging Folders(6)

Glue Sticks & Pens(6)

Expanding Pockets(6)

Portfolios(6)

Laminating Machines(6)

Filing Labels & Systems(6)

Coin Envelopes(5)

Hanging Box Bottom Folders(5)

Masking Tapes(5)

Copy & Multi-use White Paper(5)

Heavy-Duty Staplers(4)

Letter Trays(4)

Interdepartmental Envelopes(4)

Paper Rolls(4)

Binding Index Dividers(4)

Bookends(4)

Packaging Tapes(3)

Note Cards(3)

Rulers & Yardsticks(3)

Electric/Battery Operated Staplers(3)

Staples(2)

Catalog Racks(2)

Desktop Organizers(2)

Push Pins(2)

Name Badges/Systems(2)

Punch Heads(2)

Sales Forms & Refills(2)

Legal Index Dividers(2)

CD/DVD Labels(2)

Wood Pencils(2)

Ballpoint Retractable Pens(2)

Scissors(1)

Shipping Tape Dispensers(1)

Multi-part Computer Paper(1)

Color Jackets(1)

Sheet Lifters(1)

Electric Hole Punches(1)

Staple Removers(1)

Pencil Holders(1)

Index Tabs & Page Markers(1)

Packaging Tape(1)

Packing List/Invoice Enclosed Envelopes(1)

Tank-Style Highlighters(1)

Specialty Staplers(1)

Tape Dispensers(1)

Desktop File Sorters(1)

Binder Pockets(1)

Letter Openers(1)

Magazine Files(1)

 
Brand

Business Source(742)

 
Color

White(151)

Black(115)

Clear(63)

Red(29)

Manila(28)

Brown Kraft(20)

Crepe(19)

Assorted(19)

Green(18)

Yellow(17)

Silver(15)

Kraft(14)

Dark Blue(14)

Blue(13)

Brown(10)

Navy(8)

Gray(8)

Burgundy(6)

Redrope(6)

Multi(6)

Purple(6)

Standard Green(6)

Tan(5)

Putty(4)

Bright White(4)

Orange(4)

Chrome(4)

Non-glare(3)

Light Blue(3)

Semi Clear(2)

Bright Red(2)

Pastel(2)

Neon(2)

Neon Pink(2)

Clear Front(2)

Neon Yellow(2)

Neon Green(2)

Wood Grain(1)

Smoke(1)

Teal(1)

 
Brightness

96(6)

92(5)

 
Binder Capacity

1"(29)

1 1/2"(26)

2"(19)

3"(18)

1/2"(13)

5"(7)

4"(7)

 
Size

Letter(212)

Legal(29)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(553)

Yes(169)

 
Sheet Size

8 1/2" Width x 11" Length(170)

8 1/2" Width x 14" Length(26)

8 1/2" x 11"(9)

6" x 9"(7)

27" x 34"(6)

11" Width x 17" Length(6)

5" Width x 3" Length(3)

2 1/4" x 150 ft(3)

8 1/2" x 14"(3)

9" Width x 12 1/2" Length(3)

25" x 30"(3)

8" x 5"(2)

36" x 150 ft(2)

24" x 150 ft(2)

3 1/2" Width x 5 1/8" Length(2)

4 1/8" Width x 7" Length(2)

8 1/2" x 11 3/4"(2)

8 3/8" Width x 10 1/4" Length(2)

5 1/2" Width x 8 1/2" Length(2)

4" x 6"(2)

3" x 5"(2)

8 1/2" Width x 12" Length(2)

6" Width x 9" Length(2)

9" Width x 15 1/2" Length(2)

5" x 8"(2)

8" Width x 5" Length(2)

6" Width x 4" Length(2)

3" x 165 ft(2)

4 19/64" x 127 ft(1)

3" x 90 ft(1)

2 1/4" x 55 ft(1)

3 1/8" x 230 ft(1)

8 1/10" Width x 10 4/5" Length(1)

8 1/8" Width x 11" Length(1)

36" x 300 ft(1)

8 1/2" Width(1)

8 1/2" Width x 5 1/2" Length(1)

4" x 8"(1)

3" Width x 5" Length(1)

6" x 9 1/2"(1)

4" Width x 6" Length(1)

2 1/4" x 126 ft(1)

2 1/4" x 165 ft(1)

42" x 150 ft(1)

11" x 17"(1)

1 3/4" x 155 ft(1)

1 29/64" x 150 ft(1)

2 3/4" x 165 ft(1)

20" x 34"(1)

 
 
 

© 2018-2019 Penn Office Products, Inc., All Rights Reserved