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

Standard Ring Binders(61)

Mailing & Address Labels(31)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Laminating Supplies(24)

Large Format/Catalog Envelopes(24)

Index Dividers(22)

Sheet Protectors(22)

Rubber Bands(22)

Adhesive Note Pads(21)

Plain Tab Index Dividers(20)

Report Covers(18)

Clasp Envelopes(18)

Top Tab Manila Folders(18)

Memo / Subject Notebooks(16)

Binder Clips(16)

Storage Boxes & Containers(16)

Clipboards(13)

Copier/Laser/Inkjet Index Dividers(13)

Top Tab Colored Folders(13)

Book Rings(12)

Desktop Staplers(12)

Ticket Holders(12)

Expanding Pockets(11)

Easel Pads(10)

Transparent & Invisible Tapes(10)

Insertable Tab Index Dividers(10)

Desktop Hole Punches(10)

Calculator & Register Rolls(9)

TYVEK & Tear-Resistant Envelopes(9)

Desktop Organizers(9)

Paper Clips(8)

Interior Folders(8)

Manila Jackets(8)

Masking Tapes(8)

Ballpoint Stick Pens(7)

Filing Labels & Systems(7)

Top Tab Accessories(7)

Steno Pads(7)

Inkjet Paper(7)

Copy & Multi-use White Paper(7)

Laminating Machines(7)

Receipt Books(7)

Binder Pockets(6)

Air Dusters(6)

Portfolios(6)

Glue Sticks & Pens(6)

Green Hanging Folders(6)

Index Cards(6)

Paper Fasteners(6)

Pre-printed Index Dividers(6)

Letter, Legal & Jr. Pads(6)

Name Badges/Systems(5)

Hanging Box Bottom Folders(5)

Letter Trays(5)

Coin Envelopes(5)

Interdepartmental Envelopes(5)

Desktop File Sorters(4)

Rulers & Yardsticks(4)

Bookends(4)

Paper Rolls(4)

Binding Index Dividers(4)

Push Pins(4)

Heavy-Duty Staplers(4)

Catalog Racks(3)

Packaging Tapes(3)

Note Cards(3)

Shredder Bags(3)

Electric/Battery Operated Staplers(3)

Hanging Folder Frames(3)

Poly Jackets(3)

Poly Envelopes(3)

Punch Heads(3)

Packing List/Invoice Enclosed Envelopes(3)

Letter Openers(2)

Staple Removers(2)

Sales Forms & Refills(2)

Staples(2)

Laser Toner Cartridges(2)

Filament Tape(2)

Ballpoint Retractable Pens(2)

Specialty Staplers(2)

Legal Index Dividers(2)

CD/DVD Labels(2)

Wood Pencils(2)

Electric Hole Punches(1)

Magazine Files(1)

Filler Papers(1)

Paper Clip Holders(1)

Call Bells(1)

Thermal Fax Paper(1)

Scissors(1)

Cross-Cut/Confetti-Cut Shredders(1)

Multi-part Computer Paper(1)

Sheet Lifters(1)

Tank-Style Highlighters(1)

Expanding Files(1)

Medical File Folders(1)

Index Tabs & Page Markers(1)

Tape Dispensers(1)

Pencil Holders(1)

Luggage Accessories(1)

End Tab Fastener Folders(1)

Packaging Tape(1)

Hole Reinforcements(1)

Shipping Tape Dispensers(1)

Vinyl/Plastic Pockets & Sleeves(1)

End Tab Folders(1)

Color Jackets(1)

 
Brand

Business Source(990)

 
Color

White(184)

Black(163)

Clear(104)

Silver(50)

Red(35)

Manila(29)

Assorted(25)

Yellow(21)

Green(21)

Brown Kraft(20)

Crepe(19)

Blue(19)

Brown(14)

Kraft(14)

Dark Blue(14)

Gray(11)

Navy(10)

Tan(7)

Redrope(7)

Purple(6)

Burgundy(6)

Light Blue(6)

Multi(6)

Standard Green(6)

Putty(5)

Chrome(5)

Orange(4)

Bright White(4)

Natural(3)

Non-glare(3)

Bright Red(2)

Clear Front(2)

Neon(2)

Smoke(2)

Neon Green(2)

Pastel(2)

Stainless Steel(2)

Neon Pink(2)

Neon Yellow(2)

Semi Clear(2)

Teal(1)

Ebony(1)

Platinum(1)

Wood Grain(1)

Crystal(1)

Graphite(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(32)

1 1/2"(30)

2"(24)

3"(22)

1/2"(17)

5"(11)

4"(8)

 
Size

Letter(285)

Legal(31)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(738)

Yes(188)

 
Sheet Size

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

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

8 1/2" x 11"(10)

6" x 9"(7)

11" Width x 17" Length(6)

27" x 34"(6)

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

8 1/2" x 14"(4)

4" x 6"(4)

3" x 165 ft(3)

25" x 30"(3)

3" x 5"(3)

2 1/4" x 150 ft(3)

5" Width x 3" Length(3)

24" x 150 ft(2)

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)

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

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

2 1/4" x 165 ft(2)

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

8" Width x 5" Length(2)

5" x 8"(2)

6" Width x 9" Length(2)

6" Width x 4" Length(2)

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

8" x 5"(2)

3 1/8" x 230 ft(2)

3" x 90 ft(1)

4 19/64" x 127 ft(1)

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

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

2 1/4" x 55 ft(1)

1 29/64" x 150 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 3/4" x 155 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)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved