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

Standard Ring Binders(41)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Mailing & Address Labels(27)

Large Format/Catalog Envelopes(24)

Plain Tab Index Dividers(22)

Adhesive Note Pads(21)

Rubber Bands(19)

Top Tab Manila Folders(18)

Laminating Supplies(18)

Clasp Envelopes(18)

Report Covers(16)

Storage Boxes & Containers(16)

Sheet Protectors(15)

Memo / Subject Notebooks(14)

Top Tab Colored Folders(13)

Binder Clips(12)

Desktop Staplers(12)

Ticket Holders(12)

Easel Pads(10)

Clipboards(10)

Insertable Tab Index Dividers(9)

TYVEK & Tear-Resistant Envelopes(9)

Interior Folders(8)

Calculator & Register Rolls(8)

Paper Clips(8)

Transparent & Invisible Tapes(8)

Manila Jackets(8)

Desktop Hole Punches(7)

Top Tab Accessories(7)

Inkjet Paper(7)

Ballpoint Stick Pens(7)

Receipt Books(7)

Filing Labels & Systems(6)

Letter, Legal & Jr. Pads(6)

Green Hanging Folders(6)

Laminating Machines(6)

Index Cards(6)

Glue Sticks & Pens(6)

Portfolios(6)

Expanding Pockets(6)

Index Dividers(5)

Coin Envelopes(5)

Steno Pads(5)

Copy & Multi-use White Paper(5)

Hanging Box Bottom Folders(5)

Paper Rolls(4)

Interdepartmental Envelopes(4)

Heavy-Duty Staplers(4)

Binding Index Dividers(4)

Letter Trays(4)

Electric/Battery Operated Staplers(3)

Rulers & Yardsticks(3)

Packaging Tapes(3)

Masking Tapes(3)

Desktop Organizers(2)

Legal Index Dividers(2)

Catalog Racks(2)

Name Badges/Systems(2)

Ballpoint Retractable Pens(2)

Staples(2)

Heavy-Duty Hole Punches(2)

Punch Heads(2)

Push Pins(2)

CD/DVD Labels(2)

Wood Pencils(2)

Sales Forms & Refills(2)

Bookends(2)

Color Jackets(1)

Multi-part Computer Paper(1)

Scissors(1)

Staple Removers(1)

Shipping Tape Dispensers(1)

Packing List/Invoice Enclosed Envelopes(1)

Index Tabs & Page Markers(1)

Sheet Lifters(1)

Tape Dispensers(1)

Specialty Staplers(1)

Electric Hole Punches(1)

Packaging Tape(1)

Binder Pockets(1)

Letter Openers(1)

Pencil Holders(1)

Magazine Files(1)

Desktop File Sorters(1)

Tank-Style Highlighters(1)

 
Brand

Business Source(695)

Turbon(1)

 
Color

White(144)

Black(103)

Clear(58)

Manila(28)

Red(26)

Brown Kraft(20)

Crepe(19)

Assorted(19)

Yellow(17)

Green(16)

Silver(15)

Kraft(14)

Blue(13)

Dark Blue(11)

Brown(9)

Gray(8)

Navy(8)

Purple(6)

Redrope(6)

Burgundy(6)

Standard Green(6)

Chrome(4)

Putty(4)

Orange(4)

Bright White(4)

Non-glare(3)

Light Blue(3)

Tan(3)

Semi Clear(2)

Neon Pink(2)

Bright Red(2)

Pastel(2)

Clear Front(2)

Neon(2)

Neon Yellow(2)

Neon Green(2)

Wood Grain(1)

Teal(1)

Smoke(1)

 
Brightness

96(6)

92(5)

 
Binder Capacity

1"(24)

2"(19)

3"(18)

1 1/2"(17)

1/2"(8)

5"(7)

4"(7)

 
Size

Letter(189)

Legal(29)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(483)

Yes(126)

 
Sheet Size

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

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

8 1/2" x 11"(9)

27" x 34"(6)

11" Width x 17" Length(6)

6" x 9"(5)

25" x 30"(3)

2 1/4" x 150 ft(3)

5" Width x 3" Length(3)

8 1/2" x 14"(3)

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

36" x 150 ft(2)

8" x 5"(2)

24" x 150 ft(2)

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

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

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

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

8" Width x 5" Length(2)

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

6" Width x 9" Length(2)

3 1/2" Width x 5 1/8" 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)

3 1/8" x 230 ft(1)

2 1/4" x 55 ft(1)

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

3" x 5"(1)

4" x 6"(1)

5" x 8"(1)

8 1/10" Width x 10 4/5" 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)

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

2 1/4" x 126 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 1/4" x 165 ft(1)

2 3/4" x 165 ft(1)

20" x 34"(1)