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)

Top Tab Manila Folders(20)

Clipboards(20)

Adhesive Note Pads(20)

Sheet Protectors(20)

Index Dividers(19)

Clasp Envelopes(16)

Storage Boxes & Containers(16)

Memo / Subject Notebooks(16)

Report Covers(16)

Binder Clips(15)

Top Tab Fastener Folders(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)

Insertable Tab Index Dividers(9)

Paper Rolls(9)

Calculator & Register Rolls(9)

Desktop Organizers(9)

Transparent & Invisible Tapes(9)

TYVEK & Tear-Resistant Envelopes(9)

Name Badge Holders(8)

Manila Jackets(8)

Masking Tapes(8)

Expanding Pockets(7)

Expanding Files(7)

Laminating Machines(7)

Receipt Books(7)

Interior Folders(7)

Ballpoint Stick Pens(7)

Paper Clips(7)

Inkjet Paper(7)

Copy & Multi-use White Paper(7)

Portfolios(6)

Paper Fasteners(6)

Index Cards(6)

Steno Pads(6)

Filing Labels & Systems(6)

Binder Pockets(6)

Classification Folders (Paper Stock)(6)

Pre-printed Index Dividers(6)

Name Badges/Systems(5)

Hanging Box Bottom Folders(5)

Filament Tape(5)

Interdepartmental Envelopes(5)

End Tab Fastener Folders(5)

Air Dusters(5)

Glue Sticks & Pens(5)

Desktop File Sorters(4)

Packaging Tapes(4)

Push Pins(4)

Heavy-Duty Staplers(4)

Top Tab Accessories(4)

Bookends(4)

Wallets(4)

Binding Index Dividers(4)

Letter Trays(4)

Punch Heads(3)

Rulers & Yardsticks(3)

Poly Envelopes(3)

Coin Envelopes(3)

Electric/Battery Operated Staplers(3)

Hanging Folder Frames(3)

Note Cards(3)

Green Hanging Folders(3)

Cross-Cut/Confetti-Cut Shredders(3)

Shredder Bags(3)

End Tab Folders(3)

Letter, Legal & Jr. Pads(3)

Sales Forms & Refills(2)

Color Hanging Folders(2)

Digital Projectors(2)

Duct Tapes(2)

Catalog Racks(2)

Hanging Accessories(2)

Laser Toner Cartridges(2)

Legal Index Dividers(2)

Packing List/Invoice Enclosed Envelopes(2)

Letter Openers(2)

Wood Pencils(2)

Ballpoint Retractable Pens(2)

Desktop Copyholders(2)

CD/DVD Labels(2)

Staple Removers(1)

Medical File Folders(1)

Vinyl/Plastic Pockets & Sleeves(1)

Staples(1)

Scissors(1)

Hanging Pockets(1)

Multi-part Computer Paper(1)

Business Card Refills(1)

Double-Sided Tapes(1)

Glare/Radiation Filters(1)

Magazine Files(1)

Call Bells(1)

End Tab Classification Folders(1)

Sheet Lifters(1)

Paper Clip Holders(1)

Index Tabs & Page Markers(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Screen Protectors(1)

Moisteners(1)

Tape Dispensers(1)

Color Jackets(1)

Specialty Staplers(1)

Shipping Tape Dispensers(1)

Copyholders(1)

Pencil Holders(1)

Packaging Tape(1)

Thermal Fax Paper(1)

Telephone Stands & Holders(1)

 
Brand

Business Source(998)

 
Color

White(185)

Black(156)

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)

Tan(6)

Burgundy(6)

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

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

Legal(42)

Tabloid(6)

Jr.Legal(1)

Ledger/Tabloid(1)

 
Recycled

No(715)

Yes(218)

 
Sheet Size

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

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