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_27` 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 Filter

Presentation / View Binders(64)

Standard Ring Binders(33)

Business Envelopes(24)

Large Format/Catalog Envelopes(20)

Rubber Bands(20)

Mailing & Address Labels(18)

Clasp Envelopes(15)

Adhesive Note Pads(15)

Top Tab Fastener Folders(15)

Index Dividers(14)

Privacy Filters(14)

Top Tab Manila Folders(14)

Copier/Laser/Inkjet Index Dividers(12)

Top Tab Colored Folders(11)

Binder Clips(11)

Expanding Pockets(10)

Storage Boxes & Containers(10)

TYVEK & Tear-Resistant Envelopes(9)

Manila Jackets(8)

Desktop Hole Punches(8)

Pocket Portfolios/Folders(8)

Paper Rolls(8)

Memo / Subject Notebooks(8)

Interior Folders(7)

Desktop Organizers(7)

Sheet Protectors(7)

Bulldog Clips(7)

Ballpoint Stick Pens(7)

Expanding Files(7)

Pressboard Classification Folders(6)

Air Dusters(6)

Insertable Tab Index Dividers(6)

Paper Fasteners(6)

Paper Clips(6)

Letter, Legal & Jr. Pads(6)

Clipboards(6)

Index Cards(6)

Portfolios(6)

Pre-printed Index Dividers(6)

Report Covers(6)

Masking Tapes(5)

Book Rings(5)

Laminating Supplies(5)

Copy & Multi-use White Paper(5)

Poly Jackets(5)

Hanging Box Bottom Folders(5)

Plain Tab Index Dividers(5)

Green Hanging Folders(5)

End Tab Fastener Folders(5)

Calculator & Register Rolls(4)

Easel Pads(4)

Filament Tape(4)

Steno Pads(4)

Transparent & Invisible Tapes(4)

Filing Labels & Systems(4)

Desktop File Sorters(4)

Interdepartmental Envelopes(4)

Coin Envelopes(4)

End Tab Folders(3)

Hanging Folder Frames(3)

Shredder Bags(3)

Desktop Staplers(3)

Rulers & Yardsticks(3)

Glue Sticks & Pens(2)

Hanging Accessories(2)

Bookends(2)

Duct Tapes(2)

Desktop Copyholders(2)

Wood Pencils(2)

Letter Openers(2)

Staples(2)

Push Pins(2)

Top Tab Accessories(2)

Wallets(2)

Ballpoint Retractable Pens(2)

Packaging Tapes(2)

Moisteners(1)

Double-Sided Tapes(1)

Call Bells(1)

Heavy-Duty Staplers(1)

Color Hanging Folders(1)

Thermal Fax Paper(1)

Cross-Cut/Confetti-Cut Shredders(1)

Binder Pockets(1)

Poly Envelopes(1)

Staple Removers(1)

Scissors(1)

Name Badges/Systems(1)

Punch Heads(1)

End Tab Classification Folders(1)

Telephone Stands & Holders(1)

Glare/Radiation Filters(1)

Screen Protectors(1)

Pencil Holders(1)

Name Badge Holders(1)

Tape Dispensers(1)

Hanging Pockets(1)

Packing List/Invoice Enclosed Envelopes(1)

Paper Clip Holders(1)

Tank-Style Highlighters(1)

Magnetic Tape(1)

Copyholders(1)

Shipping Tape Dispensers(1)

Sales Forms & Refills(1)

CD/DVD Labels(1)

Letter Trays(1)

Medical File Folders(1)

 
Brand

Business Source(630)

 
Color

White(130)

Black(95)

Silver(34)

Clear(32)

Red(28)

Manila(23)

Blue(20)

Yellow(17)

Green(17)

Brown(16)

Assorted(16)

Brown Kraft(16)

Crepe(16)

Kraft(13)

Dark Blue(8)

Multi(6)

Redrope(6)

Standard Green(6)

Light Blue(5)

Natural(4)

Orange(3)

Gray(3)

Navy(3)

Tan(3)

Neon(2)

Stainless Steel(2)

Putty(1)

Purple(1)

Semi Clear(1)

Graphite(1)

Non-glare(1)

Chrome(1)

Wood Grain(1)

Ebony(1)

Neon Green(1)

Pastel(1)

Assorted Pastel(1)

Smoke(1)

Bright White(1)

 
Brightness

92(5)

 
Binder Capacity

1"(22)

3"(19)

2"(18)

1 1/2"(16)

5"(8)

1/2"(7)

4"(7)

 
Recycled

No(457)

Yes(148)

 
Height

10"(19)

11"(11)

14 3/4"(7)

11 3/4"(7)

14"(5)

6"(5)

9"(4)

9 1/2"(4)

48"(2)

10.3"(2)

3"(2)

38"(1)

12.3"(1)

12"(1)

19"(1)

1.9"(1)

6.5"(1)

4.5"(1)

6.1"(1)

12.75"(1)

11.69"(1)

10.06"(1)

8.5"(1)

5.3"(1)

2"(1)

15"(1)

2.8"(1)

 
Depth

6"(6)

24"(4)

15"(3)

12"(2)

23.3"(2)

7.8"(1)

18"(1)

9.5"(1)

13.4"(1)

22"(1)

17"(1)

14"(1)

4.8"(1)

2"(1)

14.4"(1)

5.5"(1)

4.1"(1)

5.4"(1)

10"(1)

 
Refillable

No(2)

 
Diameter

3.4"(1)

 
Clip Capacity

0.50"(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved