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)

Memo / Subject Notebooks(18)

Bubble Wraps(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)

Bubble Mailers(9)

Coin Wrappers, Bill Straps & Trays(9)

Sheet Protectors(8)

Moisteners(7)

Copy & Multi-use Colored Paper(7)

Utility Knives & Cutters(7)

Key Boxes & Cabinets(7)

Multi-part Computer Paper(7)

Binding Spines & Strips(6)

Hand Trucks & Dollies(6)

Index Cards(6)

Cash Boxes(6)

Tickets(6)

TYVEK & Tear-Resistant Envelopes(6)

Shipping Tape Dispensers(6)

Packing Paper(5)

Packaging Tapes(5)

Packing List/Invoice Enclosed Envelopes(5)

Copy & Multi-use White Paper(5)

Utility Knife Replacement Blades(5)

Shipping & Moving Boxes(4)

Binding Covers(4)

Magnifiers(4)

Traditional Stamps(4)

Large Format/Catalog Envelopes(3)

Tally Counters(3)

Stamp Pad Ink(3)

Counterfeit Currency Detectors(3)

Packaging Tape(3)

Glitters(3)

Board Erasers(3)

Desktop Hole Punches(3)

Pad Folios(3)

Interdepartmental Envelopes(2)

Dry-Erase Boards(2)

Vinyl/Plastic Pockets & Sleeves(2)

Video Cassettes(2)

Portfolios(2)

Green Hanging Folders(2)

Audio Tapes(2)

Heavy-Duty Hole Punches(2)

Storage Boxes & Containers(2)

Stamp Creators(2)

Telephone Message Books & Pads(2)

All-Purpose Glues(2)

Copier/Laser/Inkjet Index Dividers(2)

Custom Stamps(2)

Tape Dispensers(2)

Luggage Carts(2)

Desktop Organizers(1)

Top Tab Fastener Folders(1)

Color Hanging Folders(1)

Craft Supplies(1)

Report Covers(1)

Padded Mailers(1)

Numbering Stamps(1)

Letter Openers(1)

Rubber Bands(1)

Stamp Pads(1)

Food Storage Bags/Wraps(1)

Self-Inking Stamps(1)

Staple Removers(1)

Laminating Supplies(1)

Paper Folders(1)

Art Paper Rolls and Sheets(1)

Protractors and Triangles(1)

Waste Containers & Accessories(1)

Cash Counters(1)

Business Envelopes(1)

Cash Drawers(1)

Poly Envelopes(1)

Rulers & Yardsticks(1)

Coin Envelopes(1)

Magnetic Push Pins(1)

Paper Rolls(1)

Photo Tape(1)

Masking Tapes(1)

Safety Tapes(1)

Compass(1)

Punch Heads(1)

Heavy-Duty Staplers(1)

Desktop Staplers(1)

 
Brand

Sparco(424)

Business Source(60)

Lorell(2)

 
Color

Black(67)

White(66)

Clear(65)

Gray(25)

Kraft(18)

Red(17)

Blue(16)

Assorted(14)

Yellow(14)

Green(13)

Silver(11)

Green Bar(8)

Brown(8)

Smoke(6)

Orange(5)

Stainless Steel(3)

Dark Blue(3)

Violet(3)

Navy(3)

Pink(3)

Chrome(2)

Black/Gray(2)

Gold(2)

Putty(2)

Neon Green(2)

Neon Orange(2)

Neon Pink(2)

Apple Green(2)

Light Blue(2)

Non-glare(2)

Assorted Pastel(1)

Charcoal Gray(1)

Pastel Assorted(1)

Pastel(1)

Tan(1)

Neon Assorted(1)

Purple(1)

Transparent(1)

Brown Kraft(1)

Natural(1)

Blue Bar(1)

Canary(1)

Ivory(1)

Goldenrod(1)

Multicolor(1)

 
Brightness

92(5)

 
Size

6" Length(1)

 
Binder Capacity

3"(9)

1"(6)

2"(6)

1 1/2"(6)

4"(5)

5"(3)

1/2"(3)

 
Size

Letter(95)

Legal(5)

Jr.Legal(4)

Statement(1)

A5(1)

A4(1)

Ledger/Tabloid(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)

8 1/2" x 14"(3)

4" x 6"(3)

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

6" x 4"(3)

3" x 5"(2)

13 7/8" x 11"(1)

11" x 14 7/8"(1)

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

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

7" x 4 1/4"(1)

7 1/2" x 10"(1)

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

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

12" x 8 1/2"(1)

5" Width x 7" Length(1)

2 1/4" x 90 ft(1)

11" Width x 14" Length(1)

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

6" Width x 9" Length(1)

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

11" x 17"(1)

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

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

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

15" x 11"(1)

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

 
 
 

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