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

Clipboards(26)

Transparent & Invisible Tapes(20)

Letter, Legal & Jr. Pads(20)

Memo / Subject Notebooks(18)

Bubble Wraps(18)

Scissors(17)

Single-part Computer Paper(16)

Top Tab Fastener Folders(16)

Rubber Bands(15)

Filler Papers(14)

Title Stamps(13)

Multipurpose Labels(12)

Shipping & Moving Boxes(12)

Flags(11)

Stretch Wrap & Dispensers(11)

Pocket Portfolios/Folders(10)

Expanding Files(10)

Bubble Mailers(9)

Coin Wrappers, Bill Straps & Trays(9)

Moisteners(8)

Utility Knives & Cutters(7)

Key Boxes & Cabinets(7)

Copy & Multi-use Colored Paper(7)

Color Hanging Folders(7)

End Tab Fastener Folders(7)

Multi-part Computer Paper(7)

Cash Boxes(6)

Binding Spines & Strips(6)

Color Jackets(6)

Tickets(6)

Standard Ring Binders(6)

Hand Trucks & Dollies(6)

Traditional Stamps(5)

Packing Paper(5)

Packaging Tapes(5)

Packing List/Invoice Enclosed Envelopes(5)

Utility Knife Replacement Blades(5)

Binding Covers(4)

Wallets(4)

Classification Folders (Paper Stock)(4)

Shipping Tape Dispensers(4)

Sheet Protectors(4)

Expanding Pockets(4)

Magnifiers(4)

Index Cards(4)

Top Tab Colored Folders(4)

End Tab Folders(4)

Tally Counters(3)

Numbering Stamps(3)

End Tab Classification Folders(3)

Counterfeit Currency Detectors(3)

Glitters(3)

Top Tab Manila Folders(3)

Board Erasers(3)

Copy & Multi-use White Paper(3)

Stamp Pad Ink(3)

Packaging Tape(3)

Pad Folios(3)

Heavy-Duty Hole Punches(3)

Paper Rolls(2)

Tape Dispensers(2)

Stamp Creators(2)

Hanging Accessories(2)

Custom Stamps(2)

Vinyl/Plastic Pockets & Sleeves(2)

Dry-Erase Boards(2)

Luggage Carts(2)

Green Hanging Folders(2)

All-Purpose Glues(2)

Telephone Message Books & Pads(2)

Thermal Fax Paper(2)

Poly Envelopes(2)

Letter Openers(2)

Storage Boxes & Containers(2)

Waste Containers & Accessories(1)

Desktop File Sorters(1)

Paper Folders(1)

Craft Supplies(1)

Hanging Pockets(1)

Cash Drawers(1)

Safety Tapes(1)

Rulers & Yardsticks(1)

Protractors and Triangles(1)

Paper Clip Holders(1)

Self-Inking Stamps(1)

Cash Counters(1)

Business Card Refills(1)

Food Storage Bags/Wraps(1)

Stamp Pads(1)

Bulldog Clips(1)

Paper Clips(1)

Magnetic Card Holders & Cards(1)

Desktop Copyholders(1)

Punch Heads(1)

Plain Tab Index Dividers(1)

Staple Removers(1)

Compass(1)

Copier/Laser/Inkjet Index Dividers(1)

Data Index Dividers(1)

Padded Mailers(1)

Desktop Hole Punches(1)

Poly Jackets(1)

Desktop Organizers(1)

Photo Tape(1)

Art Paper Rolls and Sheets(1)

Push Pins(1)

 
Brand

Sparco(575)

 
Color

White(69)

Black(65)

Clear(64)

Red(29)

Blue(26)

Kraft(25)

Gray(24)

Manila(22)

Brown(21)

Green(19)

Assorted(16)

Yellow(16)

Natural(15)

Silver(13)

Green Bar(8)

Smoke(7)

Navy(6)

Light Blue(5)

Orange(5)

Pink(3)

Stainless Steel(3)

Violet(3)

Apple Green(2)

Black/Gray(2)

Gold(2)

Neon Pink(2)

Chrome(2)

Neon Orange(2)

Neon Green(2)

Light Gray(1)

Purple(1)

Charcoal Gray(1)

Aqua(1)

Transparent(1)

Non-glare(1)

Multi(1)

Putty(1)

Goldenrod(1)

Blue Bar(1)

Ivory(1)

Multicolor(1)

Standard Green(1)

Canary(1)

 
Brightness

92(3)

 
Size

6" Length(1)

 
Binder Capacity

3"(10)

2"(10)

1 1/2"(10)

1"(10)

4"(7)

5"(6)

1/2"(3)

 
Size

Letter(135)

Legal(24)

Jr.Legal(6)

Statement(1)

A4(1)

A5(1)

 
Recycled

No(404)

Yes(102)

 
Sheet Size

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

8 1/2" x 11"(24)

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

8" x 10 1/2"(17)

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

14 7/8" x 11"(6)

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)

3" x 5"(2)

2 1/4" x 90 ft(2)

4" x 6"(2)

6" Width x 9" Length(2)

9 1/2" x 11"(2)

13 7/8" x 11"(1)

11" x 14 7/8"(1)

12" x 8 1/2"(1)

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

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

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

7 1/2" x 10"(1)

7" x 4 1/4"(1)

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

15" x 11"(1)

8 1/2" x 164 ft(1)

8 1/2" x 98 ft(1)

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

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

5" Width x 7" Length(1)

7" x 9"(1)

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

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

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

 
 
 

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