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

Standard Ring Binders(42)

Pocket Portfolios/Folders(30)

Business Envelopes(29)

Mailing & Address Labels(29)

Laser Toner Cartridges(27)

Clasp Envelopes(25)

Laminating Supplies(24)

Large Format/Catalog Envelopes(24)

Plain Tab Index Dividers(22)

Adhesive Note Pads(22)

Report Covers(20)

Rubber Bands(19)

Top Tab Manila Folders(18)

Storage Boxes & Containers(16)

Sheet Protectors(16)

Memo / Subject Notebooks(14)

Binder Clips(13)

Top Tab Colored Folders(13)

Ticket Holders(12)

Desktop Staplers(12)

Insertable Tab Index Dividers(11)

Easel Pads(10)

Filing Labels & Systems(10)

Clipboards(10)

TYVEK & Tear-Resistant Envelopes(9)

Manila Jackets(8)

Calculator & Register Rolls(8)

Desktop Hole Punches(8)

Interior Folders(8)

Index Dividers(8)

Paper Clips(8)

Transparent & Invisible Tapes(8)

Top Tab Accessories(7)

Ballpoint Stick Pens(7)

Receipt Books(7)

Inkjet Paper(7)

Copy & Multi-use White Paper(7)

Laminating Machines(7)

Letter, Legal & Jr. Pads(6)

Portfolios(6)

Expanding Pockets(6)

Green Hanging Folders(6)

Name Badges/Systems(6)

Glue Sticks & Pens(6)

Index Cards(6)

Rulers & Yardsticks(5)

Hanging Box Bottom Folders(5)

Coin Envelopes(5)

Heavy-Duty Staplers(5)

Steno Pads(5)

Paper Rolls(4)

Interdepartmental Envelopes(4)

Catalog Racks(4)

Masking Tapes(4)

Binding Index Dividers(4)

Letter Trays(4)

Staples(4)

Punch Heads(3)

Binder Pockets(3)

Electric/Battery Operated Staplers(3)

CD/DVD Labels(3)

Packing List/Invoice Enclosed Envelopes(3)

Packaging Tapes(3)

Staple Removers(2)

Sales Forms & Refills(2)

Desktop Organizers(2)

Bookends(2)

Heavy-Duty Hole Punches(2)

Hole Reinforcements(2)

Legal Index Dividers(2)

Push Pins(2)

Wood Pencils(2)

Ballpoint Retractable Pens(2)

Specialty Staplers(2)

Multi-part Computer Paper(1)

Desktop File Sorters(1)

Magazine Files(1)

Scissors(1)

Tank-Style Highlighters(1)

Pencil Holders(1)

Letter Openers(1)

Name Badge Holders(1)

Electric Hole Punches(1)

Luggage Accessories(1)

Tape Dispensers(1)

Vinyl/Plastic Pockets & Sleeves(1)

Color Jackets(1)

Filler Papers(1)

Sheet Lifters(1)

Shipping Tape Dispensers(1)

Index Tabs & Page Markers(1)

Packaging Tape(1)

 
Brand

Business Source(786)

Turbon(1)

 
Color

White(154)

Black(110)

Clear(71)

Red(30)

Manila(29)

Brown Kraft(25)

Assorted(22)

Yellow(20)

Crepe(19)

Silver(19)

Green(17)

Blue(15)

Kraft(14)

Gray(13)

Dark Blue(12)

Brown(9)

Navy(8)

Purple(6)

Burgundy(6)

Redrope(6)

Standard Green(6)

Tan(6)

Light Blue(4)

Bright White(4)

Putty(4)

Chrome(4)

Orange(4)

Non-glare(3)

Semi Clear(2)

Neon Pink(2)

Bright Red(2)

Neon(2)

Neon Green(2)

Clear Front(2)

Neon Yellow(2)

Pastel(2)

Wood Grain(1)

Smoke(1)

Teal(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(25)

2"(19)

3"(18)

1 1/2"(17)

1/2"(8)

5"(7)

4"(7)

 
Size

Letter(203)

Legal(30)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(538)

Yes(131)

 
Sheet Size

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

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

8 1/2" x 11"(10)

27" x 34"(6)

11" Width x 17" Length(6)

6" x 9"(5)

8 1/2" x 14"(4)

25" x 30"(3)

2 1/4" x 150 ft(3)

5" Width x 3" Length(3)

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

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

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

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

6" Width x 4" Length(2)

8" Width x 5" Length(2)

8" x 5"(2)

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

24" x 150 ft(2)

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

36" x 150 ft(2)

4" x 6"(2)

6" Width x 9" Length(2)

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

3" x 165 ft(2)

1 3/4" x 155 ft(1)

6" x 9 1/2"(1)

4" Width x 6" Length(1)

4" x 8"(1)

3" Width x 5" Length(1)

3" x 5"(1)

5" x 8"(1)

3" x 90 ft(1)

4 19/64" x 127 ft(1)

2 1/4" x 55 ft(1)

3 1/8" x 230 ft(1)

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

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

11" x 17"(1)

2 1/4" x 126 ft(1)

2 1/4" x 165 ft(1)

36" x 300 ft(1)

42" x 150 ft(1)

20" x 34"(1)

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

1 29/64" x 150 ft(1)

8 1/2" Width(1)

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

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

2 3/4" x 165 ft(1)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved