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

Presentation / View Binders(105)

Standard Ring Binders(77)

Clipboards(45)

Pocket Portfolios/Folders(30)

Mailing & Address Labels(30)

Business Envelopes(27)

Rubber Bands(24)

Large Format/Catalog Envelopes(23)

Privacy Filters(22)

Adhesive Note Pads(21)

Laminating Supplies(21)

Plain Tab Index Dividers(20)

Sheet Protectors(20)

Top Tab Manila Folders(20)

Index Dividers(19)

Clasp Envelopes(18)

Binder Clips(16)

Memo / Subject Notebooks(16)

Top Tab Fastener Folders(16)

Report Covers(16)

Storage Boxes & Containers(16)

Desktop Hole Punches(13)

Copier/Laser/Inkjet Index Dividers(13)

Top Tab Colored Folders(13)

Ticket Holders(12)

Book Rings(12)

Bulldog Clips(11)

Poly Jackets(11)

Expanding Pockets(11)

Easel Pads(10)

Desktop Staplers(10)

Transparent & Invisible Tapes(10)

Desktop Organizers(10)

Paper Rolls(10)

Insertable Tab Index Dividers(9)

Calculator & Register Rolls(9)

Paper Clips(9)

TYVEK & Tear-Resistant Envelopes(9)

Manila Jackets(8)

Masking Tapes(8)

Green Hanging Folders(8)

Name Badge Holders(8)

Interior Folders(8)

Laminating Machines(7)

Expanding Files(7)

Receipt Books(7)

Top Tab Accessories(7)

Ballpoint Stick Pens(7)

Steno Pads(7)

Copy & Multi-use White Paper(7)

Inkjet Paper(7)

Portfolios(6)

Pre-printed Index Dividers(6)

Filing Labels & Systems(6)

Air Dusters(6)

Binder Pockets(6)

Paper Fasteners(6)

Classification Folders (Paper Stock)(6)

Index Cards(6)

Letter, Legal & Jr. Pads(6)

Letter Trays(5)

Coin Envelopes(5)

Hanging Box Bottom Folders(5)

End Tab Fastener Folders(5)

Glue Sticks & Pens(5)

Interdepartmental Envelopes(5)

Name Badges/Systems(5)

Filament Tape(5)

Heavy-Duty Staplers(4)

Bookends(4)

Binding Index Dividers(4)

Packaging Tapes(4)

Wallets(4)

Push Pins(4)

Desktop File Sorters(4)

Cross-Cut/Confetti-Cut Shredders(3)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Shredder Bags(3)

Hanging Folder Frames(3)

Poly Envelopes(3)

Letter Openers(3)

End Tab Folders(3)

Rulers & Yardsticks(3)

Punch Heads(3)

Packing List/Invoice Enclosed Envelopes(2)

Color Hanging Folders(2)

Hanging Accessories(2)

Staple Removers(2)

Duct Tapes(2)

Staples(2)

Sales Forms & Refills(2)

Digital Projectors(2)

Ballpoint Retractable Pens(2)

Desktop Copyholders(2)

Wood Pencils(2)

Legal Index Dividers(2)

CD/DVD Labels(2)

Catalog Racks(2)

Laser Toner Cartridges(2)

Call Bells(1)

Thermal Fax Paper(1)

Scissors(1)

Moisteners(1)

Color Jackets(1)

Business Card Refills(1)

Magnetic Push Pins(1)

Paper Clip Holders(1)

Double-Sided Tapes(1)

Multi-part Computer Paper(1)

Magazine Files(1)

End Tab Classification Folders(1)

Specialty Staplers(1)

Copyholders(1)

Tape Dispensers(1)

Pencil Holders(1)

Telephone Stands & Holders(1)

Index Tabs & Page Markers(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Glare/Radiation Filters(1)

Sheet Lifters(1)

Screen Protectors(1)

Board Erasers(1)

Hanging Pockets(1)

Packaging Tape(1)

Vinyl/Plastic Pockets & Sleeves(1)

Shipping Tape Dispensers(1)

Medical File Folders(1)

 
Brand

Business Source(1091)

 
Color

White(192)

Black(181)

Clear(103)

Silver(57)

Red(46)

Manila(30)

Green(29)

Blue(29)

Yellow(26)

Assorted(25)

Brown(24)

Brown Kraft(20)

Crepe(19)

Navy(14)

Dark Blue(14)

Kraft(14)

Smoke(8)

Light Blue(8)

Redrope(7)

Gray(7)

Orange(7)

Burgundy(6)

Standard Green(6)

Multi(6)

Tan(6)

Purple(5)

Natural(5)

Bright White(4)

Neon Pink(4)

Putty(4)

Neon Green(4)

Chrome(4)

Neon Yellow(2)

Stainless Steel(2)

Neon(2)

Pastel(2)

Neon Orange(2)

Clear Front(2)

Violet(2)

Black Graphite(2)

Semi Clear(2)

Bright Red(2)

Non-glare(2)

Ebony(1)

Wood Grain(1)

Crystal(1)

Graphite(1)

Teal(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(40)

1 1/2"(36)

2"(31)

3"(28)

1/2"(18)

4"(14)

5"(14)

 
Size

Letter(347)

Legal(46)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(794)

Yes(232)

 
Sheet Size

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

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

8 1/2" x 11"(10)

9" Width x 12" Length(10)

6" x 9"(7)

27" x 34"(6)

11" Width x 17" Length(6)

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

8 1/2" x 14"(4)

6" Width x 9" Length(3)

4" x 6"(3)

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

3" x 5"(3)

5" Width x 3" Length(3)

25" x 30"(3)

3" x 165 ft(3)

2 1/4" x 150 ft(3)

2 1/4" x 165 ft(2)

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

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

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

36" x 150 ft(2)

24" x 150 ft(2)

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

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

5" x 8"(2)

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

8" x 5"(2)

3 1/8" x 230 ft(2)

6" Width x 4" Length(2)

8" Width x 5" Length(2)

2 1/4" x 90 ft(1)

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

2 1/4" x 55 ft(1)

4 19/64" x 127 ft(1)

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

1 3/4" x 155 ft(1)

20" x 34"(1)

3 1/8" x 273 ft(1)

9" Width x 13" Length(1)

8 1/2" x 98 ft(1)

6" x 9 1/2"(1)

4" Width x 6" Length(1)

3" Width x 5" Length(1)

4" x 8"(1)

11" Width x 14" Length(1)

2 1/4" x 85 ft(1)

11" x 17"(1)

8 1/2" Width(1)

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

2 1/4" x 126 ft(1)

2 3/4" x 165 ft(1)

1 29/64" x 150 ft(1)

2 1/4" x 80 ft(1)

42" x 150 ft(1)

36" x 300 ft(1)

3" x 90 ft(1)

 
 
 

© 2019-2020 Panola Paper Co, All Rights Reserved