Total:$0.00

QUICK VIEW 0
 

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

Standard Ring Binders(77)

Clipboards(45)

Pocket Portfolios/Folders(30)

Mailing & Address Labels(29)

Business Envelopes(26)

Rubber Bands(24)

Large Format/Catalog Envelopes(22)

Adhesive Note Pads(21)

Privacy Filters(21)

Top Tab Manila Folders(20)

Sheet Protectors(19)

Laminating Supplies(19)

Index Dividers(19)

Clasp Envelopes(17)

Report Covers(16)

Top Tab Fastener Folders(16)

Storage Boxes & Containers(16)

Binder Clips(16)

Plain Tab Index Dividers(15)

Memo / Subject Notebooks(14)

Copier/Laser/Inkjet Index Dividers(13)

Top Tab Colored Folders(13)

Desktop Hole Punches(12)

Book Rings(12)

Ticket Holders(12)

Expanding Pockets(11)

Bulldog Clips(11)

Poly Jackets(11)

Easel Pads(10)

Paper Rolls(10)

Transparent & Invisible Tapes(10)

TYVEK & Tear-Resistant Envelopes(9)

Insertable Tab Index Dividers(9)

Desktop Staplers(9)

Desktop Organizers(9)

Paper Clips(9)

Name Badge Holders(8)

Manila Jackets(8)

Masking Tapes(8)

Interior Folders(8)

Top Tab Accessories(7)

Receipt Books(7)

Steno Pads(7)

Ballpoint Stick Pens(7)

Calculator & Register Rolls(7)

Inkjet Paper(7)

Expanding Files(7)

Filing Labels & Systems(6)

Air Dusters(6)

Laminating Machines(6)

Paper Fasteners(6)

Pre-printed Index Dividers(6)

Green Hanging Folders(6)

Pressboard Classification Folders(6)

Binder Pockets(6)

Letter, Legal & Jr. Pads(6)

Portfolios(6)

Index Cards(6)

Filament Tape(5)

Hanging Box Bottom Folders(5)

End Tab Fastener Folders(5)

Glue Sticks & Pens(5)

Copy & Multi-use White Paper(5)

Interdepartmental Envelopes(5)

Coin Envelopes(4)

Push Pins(4)

Name Badges/Systems(4)

Binding Index Dividers(4)

Wallets(4)

Letter Trays(4)

Desktop File Sorters(4)

Heavy-Duty Staplers(4)

Bookends(4)

Packaging Tapes(4)

Note Cards(3)

Cross-Cut/Confetti-Cut Shredders(3)

Electric/Battery Operated Staplers(3)

Shredder Bags(3)

Hanging Folder Frames(3)

Poly Envelopes(3)

End Tab Folders(3)

Letter Openers(3)

Rulers & Yardsticks(3)

Hanging Accessories(2)

Duct Tapes(2)

Ballpoint Retractable Pens(2)

Punch Heads(2)

CD/DVD Labels(2)

Digital Projectors(2)

Sales Forms & Refills(2)

Desktop Copyholders(2)

Staples(2)

Wood Pencils(2)

Legal Index Dividers(2)

Staple Removers(2)

Paper Clip Holders(1)

Color Jackets(1)

Tape Dispensers(1)

Scissors(1)

Sheet Lifters(1)

Moisteners(1)

Thermal Fax Paper(1)

Call Bells(1)

Magnetic Push Pins(1)

Double-Sided Tapes(1)

Multi-part Computer Paper(1)

Catalog Racks(1)

End Tab Classification Folders(1)

Specialty Staplers(1)

Copyholders(1)

Pencil Holders(1)

Index Tabs & Page Markers(1)

Packing List/Invoice Enclosed Envelopes(1)

Telephone Stands & Holders(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Glare/Radiation Filters(1)

Shipping Tape Dispensers(1)

Screen Protectors(1)

Board Erasers(1)

Hanging Pockets(1)

Packaging Tape(1)

Color Hanging Folders(1)

Vinyl/Plastic Pockets & Sleeves(1)

Medical File Folders(1)

 
Brand

Business Source(1055)

 
Color

White(184)

Black(174)

Clear(99)

Silver(57)

Red(45)

Manila(30)

Green(27)

Blue(27)

Yellow(25)

Assorted(24)

Brown(24)

Brown Kraft(19)

Crepe(19)

Navy(14)

Dark Blue(14)

Kraft(14)

Smoke(8)

Light Blue(8)

Redrope(7)

Gray(7)

Burgundy(6)

Multi(6)

Orange(6)

Standard Green(6)

Purple(5)

Natural(5)

Tan(5)

Bright White(4)

Putty(4)

Neon Pink(4)

Neon Green(4)

Chrome(3)

Stainless Steel(2)

Neon Yellow(2)

Bright Red(2)

Semi Clear(2)

Black Graphite(2)

Violet(2)

Clear Front(2)

Neon Orange(2)

Neon(2)

Pastel(2)

Crystal(1)

Non-glare(1)

Graphite(1)

Wood Grain(1)

Teal(1)

Ebony(1)

 
Brightness

96(6)

92(5)

 
Binder Capacity

1"(40)

1 1/2"(36)

2"(31)

3"(28)

1/2"(18)

4"(14)

5"(14)

 
Size

Letter(337)

Legal(44)

Tabloid(6)

Jr.Legal(2)

Ledger/Tabloid(1)

 
Recycled

No(771)

Yes(223)

 
Sheet Size

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

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

9" Width x 12" Length(10)

6" x 9"(7)

8 1/2" x 11"(7)

11" Width x 17" Length(6)

27" x 34"(6)

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

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

3" x 165 ft(3)

3" x 5"(3)

5" Width x 3" Length(3)

8 1/2" x 14"(3)

2 1/4" x 150 ft(3)

25" x 30"(3)

6" Width x 9" Length(3)

4" x 6"(3)

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

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

8" Width x 5" Length(2)

5" x 8"(2)

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

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

8" x 5"(2)

36" x 150 ft(2)

6" Width x 4" Length(2)

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

24" x 150 ft(2)

3 1/8" x 230 ft(2)

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

2 1/4" x 165 ft(2)

3 1/8" x 273 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)

11" Width x 14" Length(1)

2 1/4" x 80 ft(1)

2 1/4" x 90 ft(1)

42" x 150 ft(1)

8 1/10" Width x 10 4/5" Length(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)

2 1/4" x 126 ft(1)

11" x 17"(1)

1 3/4" x 155 ft(1)

36" x 300 ft(1)

3" x 90 ft(1)

 
 
 

© 2020-2021 Houdal Corporation, All Rights Reserved