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` = "11427") 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 '%Sparco' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Sparco' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Sparco' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Sparco"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Sparco"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Sparco"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Sparco"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Sparco' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Sparco',`category_4` ='Sparco') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Sparco,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Sparco', `pinfo`.`desc_title`)) DESC

Currently Filtered by


Sparco

Refine Search

  GO
 
Category

Standard Ring Binders(26)

Clipboards(25)

Letter, Legal & Jr. Pads(19)

Transparent & Invisible Tapes(19)

Bubble Wraps(18)

Memo / Subject Notebooks(18)

Scissors(17)

Single-part Computer Paper(16)

Filler Papers(14)

Presentation / View Binders(12)

Multipurpose Labels(12)

Title Stamps(12)

Flags(11)

Stretch Wrap & Dispensers(11)

Adhesive Note Pads(10)

Pocket Portfolios/Folders(10)

Coin Wrappers, Bill Straps & Trays(9)

Bubble Mailers(9)

Sheet Protectors(8)

Key Boxes & Cabinets(7)

Copy & Multi-use Colored Paper(7)

Multi-part Computer Paper(7)

Utility Knives & Cutters(7)

Moisteners(7)

TYVEK & Tear-Resistant Envelopes(6)

Binding Spines & Strips(6)

Tickets(6)

Shipping Tape Dispensers(6)

Hand Trucks & Dollies(6)

Cash Boxes(6)

Index Cards(6)

Utility Knife Replacement Blades(5)

Packaging Tapes(5)

Packing List/Invoice Enclosed Envelopes(5)

Packing Paper(5)

Copy & Multi-use White Paper(5)

Traditional Stamps(4)

Binding Covers(4)

Shipping & Moving Boxes(4)

Magnifiers(4)

Board Erasers(3)

Tally Counters(3)

Pad Folios(3)

Counterfeit Currency Detectors(3)

Stamp Pad Ink(3)

Packaging Tape(3)

Glitters(3)

Desktop Hole Punches(3)

Large Format/Catalog Envelopes(3)

Dry-Erase Boards(2)

Tape Dispensers(2)

Green Hanging Folders(2)

Portfolios(2)

Vinyl/Plastic Pockets & Sleeves(2)

Audio Tapes(2)

Custom Stamps(2)

Stamp Creators(2)

Storage Boxes & Containers(2)

Video Cassettes(2)

Luggage Carts(2)

All-Purpose Glues(2)

Copier/Laser/Inkjet Index Dividers(2)

Telephone Message Books & Pads(2)

Interdepartmental Envelopes(2)

Heavy-Duty Hole Punches(2)

Letter Openers(1)

Top Tab Fastener Folders(1)

Padded Mailers(1)

Numbering Stamps(1)

Stamp Pads(1)

Safety Tapes(1)

Rubber Bands(1)

Coin Envelopes(1)

Business Envelopes(1)

Craft Supplies(1)

Food Storage Bags/Wraps(1)

Self-Inking Stamps(1)

Poly Envelopes(1)

Desktop Organizers(1)

Staple Removers(1)

Report Covers(1)

Waste Containers & Accessories(1)

Paper Folders(1)

Rulers & Yardsticks(1)

Art Paper Rolls and Sheets(1)

Compass(1)

Punch Heads(1)

Laminating Supplies(1)

Heavy-Duty Staplers(1)

Magnetic Push Pins(1)

Paper Rolls(1)

Cash Counters(1)

Masking Tapes(1)

Protractors and Triangles(1)

Photo Tape(1)

Desktop Staplers(1)

Cash Drawers(1)

Color Hanging Folders(1)

 
Brand

Sparco(424)

Business Source(60)

Lorell(2)

 
Color

Black(67)

White(66)

Clear(65)

Gray(25)

Kraft(18)

Red(17)

Blue(16)

Yellow(14)

Assorted(14)

Green(13)

Silver(11)

Green Bar(8)

Brown(8)

Smoke(6)

Orange(5)

Navy(3)

Pink(3)

Dark Blue(3)

Stainless Steel(3)

Violet(3)

Gold(2)

Black/Gray(2)

Non-glare(2)

Light Blue(2)

Apple Green(2)

Chrome(2)

Neon Green(2)

Neon Orange(2)

Neon Pink(2)

Putty(2)

Canary(1)

Natural(1)

Goldenrod(1)

Ivory(1)

Multicolor(1)

Transparent(1)

Neon Assorted(1)

Assorted Pastel(1)

Pastel Assorted(1)

Pastel(1)

Blue Bar(1)

Tan(1)

Charcoal Gray(1)

Brown Kraft(1)

Purple(1)

 
Brightness

92(5)

 
Size

6" Length(1)

 
Binder Capacity

3"(9)

2"(6)

1 1/2"(6)

1"(6)

4"(5)

1/2"(3)

5"(3)

 
Size

Letter(95)

Legal(5)

Jr.Legal(4)

Ledger/Tabloid(1)

A4(1)

A5(1)

Statement(1)

 
Recycled

No(383)

Yes(35)

 
Sheet Size

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

8 1/2" x 11"(31)

8" x 10 1/2"(17)

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

9" Width x 12" Length(10)

14 7/8" x 11"(6)

5" x 8"(5)

6" x 4"(3)

4" x 6"(3)

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

8 1/2" x 14"(3)

3" x 5"(2)

7 1/2" x 10"(1)

6 13/16" x 4 3/4"(1)

7" x 4 1/4"(1)

9 1/2" x 5 1/2"(1)

12" x 8 1/2"(1)

13 7/8" x 11"(1)

11" x 14 7/8"(1)

8 17/64" x 5 27/32"(1)

5" Width x 7" Length(1)

8 17/64" x 11 11/16"(1)

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

5 1/4" Width x 11" Length(1)

6" Width x 9" Length(1)

14 7/8" x 8 1/2"(1)

15" x 11"(1)

11" x 17"(1)

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

2 1/4" x 90 ft(1)

11" Width x 14" Length(1)

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

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

 
 
 

© 2019-2020 Penn Office Products, Inc., All Rights Reserved