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)

Laser Toner Cartridges(30)

Pocket Portfolios/Folders(30)

Business Envelopes(29)

Mailing & Address Labels(28)

Clasp Envelopes(25)

Large Format/Catalog Envelopes(25)

Plain Tab Index Dividers(22)

Adhesive Note Pads(22)

Laminating Supplies(20)

Rubber Bands(19)

Top Tab Manila Folders(18)

Sheet Protectors(16)

Storage Boxes & Containers(16)

Memo / Subject Notebooks(16)

Binder Clips(14)

Top Tab Colored Folders(13)

Ticket Holders(12)

Desktop Staplers(12)

Insertable Tab Index Dividers(11)

Easel Pads(10)

Filing Labels & Systems(10)

Report Covers(10)

Transparent & Invisible Tapes(9)

Hole Punches(9)

Calculator & Register Rolls(9)

TYVEK & Tear-Resistant Envelopes(9)

Index Dividers(8)

Paper Clips(8)

Manila Jackets(8)

Interior Folders(8)

Glue Sticks & Pens(8)

Clipboards(8)

Top Tab Accessories(7)

Receipt Books(7)

Ballpoint Stick Pens(7)

Copy & Multi-use White Paper(7)

Laminating Machines(7)

Index Cards(6)

Letter, Legal & Jr. Pads(6)

Green Hanging Folders(6)

Heavy-Duty Staplers(6)

Expanding Pockets(6)

Name Badges/Systems(6)

Portfolios(6)

Coin Envelopes(5)

Hanging Box Bottom Folders(5)

Rulers & Yardsticks(5)

Masking Tapes(5)

Interdepartmental Envelopes(4)

Paper Rolls(4)

Steno Pads(4)

Staples(4)

Binding Index Dividers(4)

Letter Trays(4)

CD/DVD Labels(3)

Packing List/Invoice Enclosed Envelopes(3)

Electric/Battery Operated Staplers(3)

Packaging Tapes(3)

Binder Pockets(3)

Bookends(2)

Desktop Organizers(2)

Heavy-Duty Hole Punches(2)

Staple Removers(2)

Hole Reinforcements(2)

Push Pins(2)

Sales Forms & Refills(2)

Punch Heads(2)

Legal Index Dividers(2)

Catalog Racks(2)

Wood Pencils(2)

Ballpoint Retractable Pens(2)

Inkjet Paper(1)

Multi-part Computer Paper(1)

Scissors(1)

Magazine Files(1)

Electric Hole Punches(1)

Luggage Accessories(1)

Letter Openers(1)

Packaging Tape(1)

Shipping Tape Dispensers(1)

Tank-Style Highlighters(1)

Index Tabs & Page Markers(1)

Vinyl/Plastic Pockets & Sleeves(1)

Pencil Holders(1)

Sheet Lifters(1)

Color Jackets(1)

Specialty Staplers(1)

Tape Dispensers(1)

Filler Papers(1)

Name Badge Holders(1)

Desktop File Sorters(1)

 
Brand

Business Source(776)

Turbon(1)

 
Color

White(151)

Black(106)

Clear(69)

Manila(29)

Red(29)

Brown Kraft(25)

Assorted(21)

Silver(20)

Yellow(20)

Crepe(19)

Green(18)

Blue(15)

Kraft(14)

Gray(11)

Dark Blue(10)

Navy(8)

Brown(7)

Burgundy(7)

Purple(6)

Redrope(6)

Standard Green(6)

Tan(6)

Bright White(4)

Chrome(4)

Orange(4)

Putty(4)

Non-glare(3)

Semi Clear(2)

Neon(2)

Clear Front(2)

Pastel(2)

Neon Yellow(2)

Neon Pink(2)

Neon Green(2)

Wood Grain(1)

Teal(1)

Light Blue(1)

Smoke(1)

 
Brightness

92(7)

 
Binder Capacity

1"(25)

2"(19)

3"(18)

1 1/2"(17)

1/2"(8)

5"(7)

4"(7)

 
Size

Letter(193)

Legal(30)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(516)

Yes(153)

 
Sheet Size

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

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

8 1/2" x 11"(10)

11" Width x 17" Length(6)

27" x 34"(6)

8 1/2" x 14"(4)

6" x 9"(4)

25" x 30"(3)

3" x 1980"(3)

5" Width x 3" Length(3)

2 1/4" x 1800"(3)

4" x 6"(3)

8" x 5"(2)

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

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

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

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

8" Width x 5" Length(2)

6" Width x 4" Length(2)

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

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

3" x 5"(2)

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

4 19/64" x 1524"(1)

3" x 1080"(1)

2 1/4" x 660"(1)

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

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

5" x 8"(1)

3 1/8" x 2760"(1)

1 3/4" x 1860"(1)

6" Width x 9" Length(1)

8 1/2" Width(1)

4" x 8"(1)

3" Width x 5" Length(1)

6" x 9 1/2"(1)

4" Width x 6" Length(1)

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

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

1 29/64" x 1800"(1)

11" x 17"(1)

2 3/4" x 1980"(1)

2 1/4" x 1980"(1)

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

2 1/4" x 1512"(1)

20" x 34"(1)

 
 
 

© 2017-2018 LOP Office Supply, All Rights Reserved