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_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','out_of_stock') 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(98)

Standard Ring Binders(62)

Mailing & Address Labels(30)

Pocket Portfolios/Folders(30)

Business Envelopes(27)

Large Format/Catalog Envelopes(23)

Rubber Bands(23)

Privacy Filters(22)

Adhesive Note Pads(21)

Laminating Supplies(21)

Plain Tab Index Dividers(20)

Clipboards(20)

Top Tab Manila Folders(20)

Sheet Protectors(19)

Index Dividers(19)

Clasp Envelopes(18)

Binder Clips(16)

Storage Boxes & Containers(16)

Report Covers(16)

Top Tab Fastener Folders(15)

Memo / Subject Notebooks(15)

Top Tab Colored Folders(13)

Copier/Laser/Inkjet Index Dividers(13)

Book Rings(12)

Ticket Holders(12)

Bulldog Clips(11)

Poly Jackets(11)

Expanding Pockets(11)

Desktop Staplers(10)

Desktop Hole Punches(10)

Easel Pads(10)

Transparent & Invisible Tapes(10)

Manila Jackets(9)

TYVEK & Tear-Resistant Envelopes(9)

Insertable Tab Index Dividers(9)

Paper Rolls(9)

Paper Clips(9)

Masking Tapes(8)

Desktop Organizers(8)

Interior Folders(8)

Name Badge Holders(8)

Ballpoint Stick Pens(7)

Expanding Files(7)

Top Tab Accessories(7)

Receipt Books(7)

Steno Pads(7)

Calculator & Register Rolls(7)

Copy & Multi-use White Paper(7)

Inkjet Paper(7)

Laminating Machines(7)

Portfolios(6)

Filing Labels & Systems(6)

Pre-printed Index Dividers(6)

Binder Pockets(6)

Air Dusters(6)

Paper Fasteners(6)

Pressboard Classification Folders(6)

Letter, Legal & Jr. Pads(6)

Index Cards(6)

Green Hanging Folders(6)

Hanging Box Bottom Folders(5)

Glue Sticks & Pens(5)

Filament Tape(5)

Interdepartmental Envelopes(5)

End Tab Fastener Folders(5)

Letter Trays(5)

Coin Envelopes(5)

Name Badges/Systems(5)

Bookends(4)

Wallets(4)

Binding Index Dividers(4)

Packaging Tapes(4)

Desktop File Sorters(4)

Heavy-Duty Staplers(4)

Push Pins(4)

Shredder Bags(3)

Note Cards(3)

Electric/Battery Operated Staplers(3)

Cross-Cut/Confetti-Cut Shredders(3)

Hanging Folder Frames(3)

Punch Heads(3)

End Tab Folders(3)

Rulers & Yardsticks(3)

Poly Envelopes(3)

CD/DVD Labels(2)

Digital Projectors(2)

Duct Tapes(2)

Ballpoint Retractable Pens(2)

Sales Forms & Refills(2)

Letter Openers(2)

Staples(2)

Laser Toner Cartridges(2)

Hanging Accessories(2)

Desktop Copyholders(2)

Wood Pencils(2)

Legal Index Dividers(2)

Color Hanging Folders(2)

Paper Clip Holders(1)

Moisteners(1)

Tape Dispensers(1)

Scissors(1)

Staple Removers(1)

Thermal Fax Paper(1)

Call Bells(1)

Business Card Refills(1)

Double-Sided Tapes(1)

Multi-part Computer Paper(1)

Catalog Racks(1)

End Tab Classification Folders(1)

Specialty Staplers(1)

Color Jackets(1)

Sheet Lifters(1)

Shipping Tape Dispensers(1)

Packaging Tape(1)

Hanging Pockets(1)

Screen Protectors(1)

Glare/Radiation Filters(1)

Telephone Stands & Holders(1)

Copyholders(1)

Magnetic Tape(1)

Tank-Style Highlighters(1)

Pencil Holders(1)

Packing List/Invoice Enclosed Envelopes(1)

Index Tabs & Page Markers(1)

Medical File Folders(1)

 
Brand

Business Source(1023)

 
Color

White(185)

Black(157)

Clear(97)

Silver(54)

Red(44)

Manila(30)

Green(28)

Blue(27)

Yellow(25)

Brown(24)

Assorted(22)

Brown Kraft(20)

Crepe(19)

Kraft(14)

Dark Blue(14)

Navy(11)

Orange(7)

Gray(7)

Redrope(7)

Light Blue(7)

Burgundy(6)

Multi(6)

Standard Green(6)

Tan(5)

Purple(5)

Putty(4)

Chrome(4)

Natural(4)

Bright White(4)

Smoke(2)

Neon Pink(2)

Neon Green(2)

Neon Yellow(2)

Bright Red(2)

Pastel(2)

Clear Front(2)

Semi Clear(2)

Stainless Steel(2)

Neon(2)

Black Graphite(2)

Teal(1)

Non-glare(1)

Graphite(1)

Crystal(1)

Assorted Pastel(1)

Wood Grain(1)

Ebony(1)

Assorted Neon(1)

 
Brightness

92(7)

96(6)

 
Binder Capacity

1"(37)

1 1/2"(33)

2"(27)

3"(24)

1/2"(17)

5"(12)

4"(9)

 
Size

Letter(339)

Legal(45)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(754)

Yes(204)

 
Sheet Size

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

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

8 1/2" x 11"(9)

6" x 9"(7)

27" x 34"(6)

11" Width x 17" Length(6)

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

8 1/2" x 14"(4)

2 1/4" x 150 ft(3)

25" x 30"(3)

3" x 165 ft(3)

3" x 5"(3)

5" Width x 3" Length(3)

4" x 6"(3)

8" x 5"(2)

24" x 150 ft(2)

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

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

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

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

6" Width x 4" Length(2)

8" Width x 5" Length(2)

5" x 8"(2)

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

36" x 150 ft(2)

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

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

2 1/4" x 165 ft(2)

3 1/8" x 230 ft(2)

6" Width x 9" Length(2)

1 3/4" x 155 ft(1)

4 19/64" x 127 ft(1)

2 1/4" x 55 ft(1)

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

9" Width x 13" Length(1)

8 1/2" x 98 ft(1)

6" x 9 1/2"(1)

4" Width x 6" Length(1)

3" Width x 5" Length(1)

4" x 8"(1)

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

3 1/8" x 273 ft(1)

2 1/4" x 80 ft(1)

2 1/4" x 85 ft(1)

8 1/2" Width(1)

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

20" x 34"(1)

11" x 17"(1)

2 1/4" x 126 ft(1)

36" x 300 ft(1)

42" x 150 ft(1)

3" x 90 ft(1)

 
 
 

© 2020-2021 Swaim Office Products, All Rights Reserved