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 (`manufacturer_id` = "1700297") 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

Manufacturer

Sparco

Refine Search

  GO
 
Category

Presentation / View Binders(51)

Clipboards(27)

Letter, Legal & Jr. Pads(20)

Transparent & Invisible Tapes(20)

Rubber Bands(19)

Bubble Wraps(18)

Memo / Subject Notebooks(17)

Scissors(17)

Single-part Computer Paper(16)

Top Tab Fastener Folders(16)

Copier/Laser/Inkjet Index Dividers(14)

Filler Papers(14)

Dry-Erase Boards(13)

Title Stamps(13)

Poly Jackets(12)

Multipurpose Labels(12)

Bulldog Clips(12)

Shipping & Moving Boxes(12)

Book Rings(12)

Stretch Wrap & Dispensers(11)

Flags(11)

Pocket Portfolios/Folders(10)

Expanding Files(10)

Index Dividers(10)

Coin Wrappers, Bill Straps & Trays(9)

Bubble Mailers(9)

Desktop Organizers(8)

Name Badge Holders(8)

Cork/Fabric Bulletin Boards(8)

Moisteners(8)

Key Boxes & Cabinets(7)

Color Hanging Folders(7)

Copy & Multi-use Colored Paper(7)

Multi-part Computer Paper(7)

Utility Knives & Cutters(7)

End Tab Fastener Folders(7)

Paper Rolls(7)

Tickets(6)

Paper Fasteners(6)

Binding Spines & Strips(6)

Standard Ring Binders(6)

Pre-printed Index Dividers(6)

Color Jackets(6)

Cash Boxes(6)

Hand Trucks & Dollies(6)

Packaging Tapes(6)

Binder Pockets(5)

Poly Envelopes(5)

Packing Paper(5)

Sheet Protectors(5)

Utility Knife Replacement Blades(5)

Traditional Stamps(5)

Packing List/Invoice Enclosed Envelopes(5)

Filament Tape(5)

Shipping Tape Dispensers(4)

Expanding Pockets(4)

Paper Clips(4)

Binding Covers(4)

End Tab Folders(4)

Index Cards(4)

Classification Folders (Paper Stock)(4)

Magnifiers(4)

Top Tab Colored Folders(4)

Wallets(4)

Plain Tab Index Dividers(3)

Tally Counters(3)

Desktop Copyholders(3)

Top Tab Manila Folders(3)

Numbering Stamps(3)

End Tab Classification Folders(3)

Hanging Folder Frames(3)

Stamp Pad Ink(3)

Board Erasers(3)

Packaging Tape(3)

Heavy-Duty Hole Punches(3)

Desktop File Sorters(3)

Glitters(3)

Wall Files, Pockets & Accessories(3)

Pad Folios(3)

Binder Clips(3)

Copy & Multi-use White Paper(3)

Push Pins(3)

Counterfeit Currency Detectors(3)

Duct Tapes(2)

Masking Tapes(2)

Letter Openers(2)

Stamp Creators(2)

Telephone Message Books & Pads(2)

Punch Heads(2)

Thermal Fax Paper(2)

Luggage Carts(2)

Hanging Accessories(2)

Name Badges/Systems(2)

Tape Dispensers(2)

Green Hanging Folders(2)

Staple Removers(2)

Custom Stamps(2)

Vinyl/Plastic Pockets & Sleeves(2)

All-Purpose Glues(2)

Desktop Hole Punches(2)

Storage Boxes & Containers(2)

Double-Sided Tapes(1)

Food Storage Bags/Wraps(1)

Dry-Erase Kits/Holders(1)

Self-Inking Stamps(1)

Stamp Pads(1)

Craft Supplies(1)

Hanging Pockets(1)

Art Paper Rolls and Sheets(1)

Interdepartmental Envelopes(1)

Waste Containers & Accessories(1)

Safety Tapes(1)

Call Bells(1)

Protractors and Triangles(1)

Business Card Refills(1)

Data Index Dividers(1)

Rulers & Yardsticks(1)

Paper Clip Holders(1)

Cash Drawers(1)

Copyholders(1)

Letter Trays(1)

Drawer Organizers(1)

Photo Tape(1)

Magnetic Tape(1)

Magnetic Card Holders & Cards(1)

Cash Counters(1)

Paper Folders(1)

Compass(1)

Padded Mailers(1)

 
Brand

Sparco(741)

 
Color

Clear(89)

Black(82)

White(81)

Silver(48)

Red(31)

Blue(31)

Kraft(25)

Gray(25)

Manila(22)

Green(21)

Brown(21)

Assorted(20)

Natural(19)

Yellow(18)

Green Bar(8)

Smoke(8)

Navy(6)

Light Blue(5)

Stainless Steel(5)

Orange(5)

Pink(3)

Chrome(3)

Violet(3)

Gold(2)

Neon Pink(2)

Neon Orange(2)

Apple Green(2)

Neon Green(2)

Black/Gray(2)

Multi(1)

Ebony(1)

Crystal(1)

Charcoal Gray(1)

Non-glare(1)

Light Gray(1)

Canary(1)

Transparent(1)

Aqua(1)

Purple(1)

Blue Bar(1)

Goldenrod(1)

Standard Green(1)

Multicolor(1)

Ivory(1)

Putty(1)

 
Brightness

92(3)

 
Size

6" Length(1)

 
Size Supported

27" Drawer Legal Size(1)

27" Drawer Letter Size(1)

Letter Size(1)

 
Binder Capacity

1"(11)

3"(10)

2"(10)

1 1/2"(10)

5"(7)

4"(7)

1/2"(3)

 
Size

Letter(167)

Legal(25)

Jr.Legal(6)

Statement(1)

A4(1)

A5(1)

 
Recycled

No(556)

Yes(105)

 
Sheet Size

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

8 1/2" x 11"(24)

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

8" x 10 1/2"(16)

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

9" Width x 12" Length(10)

5" x 8"(6)

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

14 7/8" x 11"(5)

8 1/2" x 14"(4)

9 1/2" Width x 11 3/4" Length(4)

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

6" x 4"(3)

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

4" x 6"(2)

6" Width x 9" Length(2)

3" x 5"(2)

2 1/4" x 90 ft(2)

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

9 1/2" x 11"(2)

13 7/8" x 11"(2)

8" Width x 10" Length(2)

11" x 14 7/8"(1)

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

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

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

2 1/4" x 165 ft(1)

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

7 1/2" x 10"(1)

12" x 8 1/2"(1)

7" x 4 1/4"(1)

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

8 1/2" x 164 ft(1)

15" x 11"(1)

8 1/2" x 98 ft(1)

9" Width x 13" Length(1)

2 1/4" x 80 ft(1)

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

5" Width x 7" Length(1)

3 1/8" x 273 ft(1)

3 1/8" x 230 ft(1)

7" x 9"(1)

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

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

2 1/4" x 85 ft(1)

 
 
 

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