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 (`brand_id` = "11409") 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


Business Source

Refine Search

  GO
 
Category

Presentation / View Binders(97)

Standard Ring Binders(60)

Pocket Portfolios/Folders(30)

Mailing & Address Labels(29)

Business Envelopes(26)

Rubber Bands(23)

Privacy Filters(22)

Large Format/Catalog Envelopes(22)

Laminating Supplies(21)

Plain Tab Index Dividers(20)

Adhesive Note Pads(20)

Clipboards(20)

Top Tab Manila Folders(20)

Index Dividers(19)

Sheet Protectors(19)

Storage Boxes & Containers(16)

Report Covers(16)

Memo / Subject Notebooks(16)

Clasp Envelopes(16)

Top Tab Fastener Folders(15)

Binder Clips(15)

Top Tab Colored Folders(13)

Copier/Laser/Inkjet Index Dividers(13)

Ticket Holders(12)

Book Rings(12)

Poly Jackets(11)

Bulldog Clips(11)

Desktop Staplers(10)

Easel Pads(10)

Desktop Hole Punches(10)

TYVEK & Tear-Resistant Envelopes(9)

Insertable Tab Index Dividers(9)

Calculator & Register Rolls(9)

Paper Rolls(9)

Transparent & Invisible Tapes(9)

Manila Jackets(8)

Desktop Organizers(8)

Name Badge Holders(8)

Masking Tapes(8)

Interior Folders(7)

Expanding Pockets(7)

Expanding Files(7)

Receipt Books(7)

Laminating Machines(7)

Paper Clips(7)

Copy & Multi-use White Paper(7)

Inkjet Paper(7)

Ballpoint Stick Pens(7)

Paper Fasteners(6)

Filing Labels & Systems(6)

Pre-printed Index Dividers(6)

Classification Folders (Paper Stock)(6)

Portfolios(6)

Steno Pads(6)

Index Cards(6)

Binder Pockets(6)

End Tab Fastener Folders(5)

Hanging Box Bottom Folders(5)

Filament Tape(5)

Air Dusters(5)

Glue Sticks & Pens(5)

Name Badges/Systems(5)

Interdepartmental Envelopes(5)

Wallets(4)

Push Pins(4)

Bookends(4)

Top Tab Accessories(4)

Desktop File Sorters(4)

Packaging Tapes(4)

Heavy-Duty Staplers(4)

Binding Index Dividers(4)

Letter Trays(4)

Letter, Legal & Jr. Pads(3)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Cross-Cut/Confetti-Cut Shredders(3)

Shredder Bags(3)

Hanging Folder Frames(3)

Green Hanging Folders(3)

Rulers & Yardsticks(3)

Punch Heads(3)

Coin Envelopes(3)

Poly Envelopes(3)

End Tab Folders(3)

Ballpoint Retractable Pens(2)

Sales Forms & Refills(2)

Duct Tapes(2)

Color Hanging Folders(2)

Letter Openers(2)

Catalog Racks(2)

Digital Projectors(2)

Hanging Accessories(2)

CD/DVD Labels(2)

Legal Index Dividers(2)

Laser Toner Cartridges(2)

Wood Pencils(2)

Desktop Copyholders(2)

Staple Removers(1)

Business Card Refills(1)

Scissors(1)

Moisteners(1)

Paper Clip Holders(1)

Telephone Stands & Holders(1)

Staples(1)

Multi-part Computer Paper(1)

Thermal Fax Paper(1)

Call Bells(1)

Tape Dispensers(1)

Index Tabs & Page Markers(1)

Pencil Holders(1)

Double-Sided Tapes(1)

Sheet Lifters(1)

Hanging Pockets(1)

Tank-Style Highlighters(1)

Screen Protectors(1)

Magnetic Tape(1)

Medical File Folders(1)

Glare/Radiation Filters(1)

End Tab Classification Folders(1)

Packaging Tape(1)

Specialty Staplers(1)

Color Jackets(1)

Copyholders(1)

Shipping Tape Dispensers(1)

Vinyl/Plastic Pockets & Sleeves(1)

Packing List/Invoice Enclosed Envelopes(1)

 
Brand

Business Source(994)

 
Color

White(185)

Black(154)

Clear(96)

Silver(51)

Red(44)

Manila(29)

Blue(27)

Green(26)

Assorted(24)

Yellow(24)

Brown(24)

Crepe(19)

Brown Kraft(17)

Dark Blue(13)

Kraft(12)

Navy(11)

Gray(7)

Orange(7)

Light Blue(7)

Burgundy(6)

Tan(5)

Standard Green(5)

Purple(5)

Multi(5)

Bright White(4)

Chrome(4)

Natural(4)

Putty(4)

Redrope(3)

Semi Clear(2)

Smoke(2)

Black Graphite(2)

Bright Red(2)

Neon(2)

Pastel(2)

Stainless Steel(2)

Clear Front(2)

Non-glare(1)

Neon Pink(1)

Teal(1)

Neon Green(1)

Wood Grain(1)

Ebony(1)

Neon Yellow(1)

Crystal(1)

Graphite(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(37)

1 1/2"(31)

2"(27)

3"(24)

1/2"(16)

5"(12)

4"(9)

 
Size

Letter(316)

Legal(42)

Tabloid(6)

Jr.Legal(1)

Ledger/Tabloid(1)

 
Recycled

No(712)

Yes(217)

 
Sheet Size

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

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

8 1/2" x 11"(10)

11" Width x 17" Length(6)

27" x 34"(6)

6" x 9"(6)

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

8 1/2" x 14"(4)

3" x 165 ft(3)

5" Width x 3" Length(3)

25" x 30"(3)

3" x 5"(3)

4" x 6"(3)

2 1/4" x 150 ft(3)

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)

36" x 150 ft(2)

24" x 150 ft(2)

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

2 1/4" x 165 ft(2)

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

8" Width x 5" Length(2)

5" x 8"(2)

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

6" Width x 9" Length(2)

6" Width x 4" Length(2)

3 1/8" x 230 ft(2)

4 19/64" x 127 ft(1)

3" x 90 ft(1)

2 1/4" x 55 ft(1)

8" x 5"(1)

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

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

1 3/4" x 155 ft(1)

3" Width x 5" Length(1)

4" x 8"(1)

3 1/8" x 273 ft(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)

2 1/4" x 85 ft(1)

8 1/2" Width(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 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