Banner1 Banner1
 
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_26` 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(64)

Standard Ring Binders(63)

Mailing & Address Labels(32)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Large Format/Catalog Envelopes(25)

Laminating Supplies(24)

Clasp Envelopes(23)

Sheet Protectors(21)

Adhesive Note Pads(21)

Rubber Bands(19)

Plain Tab Index Dividers(18)

Report Covers(18)

Top Tab Manila Folders(18)

Storage Boxes & Containers(16)

Memo / Subject Notebooks(16)

Binder Clips(16)

Clipboards(13)

Top Tab Colored Folders(13)

Desktop Staplers(12)

Ticket Holders(12)

Index Dividers(12)

Insertable Tab Index Dividers(11)

Easel Pads(10)

Transparent & Invisible Tapes(10)

TYVEK & Tear-Resistant Envelopes(9)

Calculator & Register Rolls(9)

Desktop Hole Punches(9)

Interior Folders(8)

Paper Clips(8)

Masking Tapes(8)

Manila Jackets(8)

Filing Labels & Systems(7)

Steno Pads(7)

Top Tab Accessories(7)

Inkjet Paper(7)

Copy & Multi-use White Paper(7)

Ballpoint Stick Pens(7)

Expanding Pockets(7)

Receipt Books(7)

Laminating Machines(7)

Green Hanging Folders(6)

Index Cards(6)

Portfolios(6)

Letter, Legal & Jr. Pads(6)

Glue Sticks & Pens(6)

Air Dusters(6)

Rulers & Yardsticks(5)

Coin Envelopes(5)

Hanging Box Bottom Folders(5)

Heavy-Duty Staplers(5)

Name Badges/Systems(5)

Letter Trays(4)

Paper Rolls(4)

Binding Index Dividers(4)

Bookends(4)

Interdepartmental Envelopes(4)

Catalog Racks(3)

CD/DVD Labels(3)

Note Cards(3)

Packaging Tapes(3)

Electric/Battery Operated Staplers(3)

Packing List/Invoice Enclosed Envelopes(3)

Staples(3)

Sales Forms & Refills(2)

Desktop Organizers(2)

Staple Removers(2)

Specialty Staplers(2)

Push Pins(2)

Laser Toner Cartridges(2)

Punch Heads(2)

Hole Reinforcements(2)

Binder Pockets(2)

Ballpoint Retractable Pens(2)

Legal Index Dividers(2)

Wood Pencils(2)

Scissors(1)

Shipping Tape Dispensers(1)

Sheet Lifters(1)

Tank-Style Highlighters(1)

Multi-part Computer Paper(1)

Filler Papers(1)

Color Jackets(1)

Vinyl/Plastic Pockets & Sleeves(1)

Name Badge Holders(1)

Pencil Holders(1)

Packaging Tape(1)

Tape Dispensers(1)

Index Tabs & Page Markers(1)

Electric Hole Punches(1)

Letter Openers(1)

Desktop File Sorters(1)

Luggage Accessories(1)

Magazine Files(1)

 
Brand

Business Source(810)

 
Color

White(165)

Black(123)

Clear(76)

Red(31)

Manila(29)

Brown Kraft(24)

Assorted(20)

Yellow(19)

Crepe(19)

Green(18)

Silver(17)

Blue(14)

Dark Blue(14)

Kraft(14)

Gray(12)

Brown(11)

Tan(9)

Navy(8)

Redrope(7)

Burgundy(6)

Multi(6)

Standard Green(6)

Purple(6)

Putty(4)

Chrome(4)

Bright White(4)

Orange(4)

Light Blue(3)

Non-glare(3)

Bright Red(2)

Semi Clear(2)

Neon(2)

Clear Front(2)

Neon Pink(2)

Neon Green(2)

Neon Yellow(2)

Pastel(2)

Wood Grain(1)

Teal(1)

Smoke(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(32)

1 1/2"(26)

2"(21)

3"(18)

1/2"(15)

5"(7)

4"(7)

 
Size

Letter(229)

Legal(30)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(612)

Yes(174)

 
Sheet Size

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

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

8 1/2" x 11"(10)

6" x 9"(7)

27" x 34"(6)

11" Width x 17" Length(6)

8 1/2" x 14"(4)

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

4" x 6"(4)

3" x 5"(3)

2 1/4" x 150 ft(3)

25" x 30"(3)

3" x 165 ft(3)

5" Width x 3" Length(3)

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

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

6" Width x 4" Length(2)

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

8" x 5"(2)

5" x 8"(2)

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

8" Width x 5" 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)

24" x 150 ft(2)

6" Width x 9" Length(2)

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

3" Width x 5" Length(1)

4" x 8"(1)

4" Width x 6" Length(1)

6" x 9 1/2"(1)

4 19/64" x 127 ft(1)

3" x 90 ft(1)

2 1/4" x 55 ft(1)

3 1/8" x 230 ft(1)

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

8 1/2" Width(1)

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

11" x 17"(1)

1 3/4" x 155 ft(1)

36" x 300 ft(1)

42" x 150 ft(1)

1 29/64" x 150 ft(1)

20" x 34"(1)

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

2 1/4" x 126 ft(1)

2 1/4" x 165 ft(1)

2 3/4" x 165 ft(1)

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

 
 
 

© 2018-2019 Browns Office Centre, All Rights Reserved