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)

Top Tab Manila Folders(20)

Sheet Protectors(20)

Index Dividers(19)

Clasp Envelopes(18)

Storage Boxes & Containers(16)

Binder Clips(16)

Report Covers(16)

Memo / Subject Notebooks(16)

Top Tab Fastener Folders(16)

Top Tab Colored Folders(13)

Desktop Hole Punches(13)

Copier/Laser/Inkjet Index Dividers(13)

Ticket Holders(12)

Book Rings(12)

Expanding Pockets(11)

Poly Jackets(11)

Bulldog Clips(11)

Paper Rolls(10)

Desktop Staplers(10)

Desktop Organizers(10)

Transparent & Invisible Tapes(10)

Easel Pads(10)

Calculator & Register Rolls(9)

Paper Clips(9)

TYVEK & Tear-Resistant Envelopes(9)

Insertable Tab Index Dividers(9)

Name Badge Holders(8)

Green Hanging Folders(8)

Interior Folders(8)

Masking Tapes(8)

Manila Jackets(8)

Top Tab Accessories(7)

Expanding Files(7)

Laminating Machines(7)

Receipt Books(7)

Ballpoint Stick Pens(7)

Inkjet Paper(7)

Steno Pads(7)

Copy & Multi-use White Paper(7)

Letter, Legal & Jr. Pads(6)

Portfolios(6)

Paper Fasteners(6)

Air Dusters(6)

Index Cards(6)

Filing Labels & Systems(6)

Pre-printed Index Dividers(6)

Classification Folders (Paper Stock)(6)

Binder Pockets(6)

Glue Sticks & Pens(5)

End Tab Fastener Folders(5)

Name Badges/Systems(5)

Filament Tape(5)

Hanging Box Bottom Folders(5)

Coin Envelopes(5)

Interdepartmental Envelopes(5)

Letter Trays(5)

Push Pins(4)

Bookends(4)

Packaging Tapes(4)

Binding Index Dividers(4)

Wallets(4)

Desktop File Sorters(4)

Heavy-Duty Staplers(4)

Cross-Cut/Confetti-Cut Shredders(3)

Electric/Battery Operated Staplers(3)

Shredder Bags(3)

Note Cards(3)

Hanging Folder Frames(3)

Letter Openers(3)

Poly Envelopes(3)

End Tab Folders(3)

Rulers & Yardsticks(3)

Punch Heads(3)

Sales Forms & Refills(2)

Digital Projectors(2)

Ballpoint Retractable Pens(2)

Duct Tapes(2)

Staples(2)

Staple Removers(2)

Packing List/Invoice Enclosed Envelopes(2)

Laser Toner Cartridges(2)

CD/DVD Labels(2)

Legal Index Dividers(2)

Catalog Racks(2)

Desktop Copyholders(2)

Wood Pencils(2)

Color Hanging Folders(2)

Hanging Accessories(2)

Magazine Files(1)

Color Jackets(1)

Paper Clip Holders(1)

Moisteners(1)

Double-Sided Tapes(1)

Multi-part Computer Paper(1)

Business Card Refills(1)

Magnetic Push Pins(1)

Call Bells(1)

Sheet Lifters(1)

Thermal Fax Paper(1)

Scissors(1)

Hanging Pockets(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Copyholders(1)

Index Tabs & Page Markers(1)

Telephone Stands & Holders(1)

Tape Dispensers(1)

Pencil Holders(1)

Medical File Folders(1)

Glare/Radiation Filters(1)

Vinyl/Plastic Pockets & Sleeves(1)

Shipping Tape Dispensers(1)

Packaging Tape(1)

End Tab Classification Folders(1)

Screen Protectors(1)

Board Erasers(1)

Specialty Staplers(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)

Kraft(14)

Dark Blue(14)

Light Blue(8)

Smoke(8)

Redrope(7)

Gray(7)

Orange(7)

Standard Green(6)

Tan(6)

Burgundy(6)

Multi(6)

Purple(5)

Natural(5)

Putty(4)

Neon Green(4)

Bright White(4)

Chrome(4)

Neon Pink(4)

Black Graphite(2)

Bright Red(2)

Semi Clear(2)

Clear Front(2)

Neon(2)

Neon Orange(2)

Violet(2)

Pastel(2)

Non-glare(2)

Neon Yellow(2)

Stainless Steel(2)

Ebony(1)

Graphite(1)

Teal(1)

Wood Grain(1)

Crystal(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(40)

1 1/2"(36)

2"(31)

3"(28)

1/2"(18)

5"(14)

4"(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)

25" x 30"(3)

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

3" x 5"(3)

2 1/4" x 150 ft(3)

5" Width x 3" Length(3)

6" Width x 9" Length(3)

3" x 165 ft(3)

4" x 6"(3)

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

2 1/4" x 165 ft(2)

3 1/8" x 230 ft(2)

8" Width x 5" Length(2)

5" x 8"(2)

8" x 5"(2)

6" Width x 4" Length(2)

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

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

4 19/64" x 127 ft(1)

3" x 90 ft(1)

2 1/4" x 55 ft(1)

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

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

2 1/4" x 90 ft(1)

1 3/4" x 155 ft(1)

3" Width x 5" Length(1)

4" x 8"(1)

11" Width x 14" Length(1)

4" Width x 6" Length(1)

6" x 9 1/2"(1)

2 1/4" x 80 ft(1)

9" Width x 13" Length(1)

8 1/2" x 98 ft(1)

3 1/8" x 273 ft(1)

2 1/4" x 85 ft(1)

42" x 150 ft(1)

36" x 300 ft(1)

11" x 17"(1)

1 29/64" x 150 ft(1)

2 3/4" x 165 ft(1)

8 1/2" Width(1)

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

2 1/4" x 126 ft(1)

20" x 34"(1)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved