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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` 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 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

Manufacturer

Currently Filtered by

Manufacturer

Sparco

Refine Search

  GO
Category

Bubble Wraps(18)

Transparent & Invisible Tapes(18)

Single-part Computer Paper(16)

Clipboards(14)

Multipurpose Labels(12)

Title Stamps(11)

Scissors(11)

Stretch Wrap & Dispensers(11)

Flags(11)

Letter, Legal & Jr. Pads(10)

Memo / Subject Notebooks(10)

Pocket Portfolios/Folders(9)

Coin Wrappers, Bill Straps & Trays(9)

Bubble Mailers(9)

Presentation / View Binders(9)

Filler Papers(8)

Shipping & Moving Boxes(8)

Copy & Multi-use Colored Paper(7)

Key Boxes & Cabinets(7)

Cash Boxes(6)

Tickets(6)

Standard Ring Binders(6)

Utility Knives & Cutters(6)

Hand Trucks & Dollies(6)

Moisteners(6)

Multi-part Computer Paper(5)

Packaging Tapes(5)

Packing Paper(5)

Binding Spines & Strips(5)

Packing List/Invoice Enclosed Envelopes(5)

Utility Knife Replacement Blades(5)

Binding Covers(4)

Magnifiers(4)

Stamp Pad Ink(3)

Heavy-Duty Hole Punches(3)

Pad Folios(3)

Packaging Tape(3)

Glitters(3)

Counterfeit Currency Detectors(3)

Shipping Tape Dispensers(3)

Video Cassettes(2)

Stamp Creators(2)

Custom Stamps(2)

Dry-Erase Boards(2)

Sheet Protectors(2)

Vinyl/Plastic Pockets & Sleeves(2)

Audio Tapes(2)

Storage Boxes & Containers(2)

Luggage Carts(2)

Tally Counters(2)

All-Purpose Glues(2)

Index Cards(2)

Telephone Message Books & Pads(2)

Waste Containers & Accessories(1)

Push Pins(1)

Stamp Pads(1)

Tape Dispensers(1)

Craft Supplies(1)

Self-Inking Stamps(1)

End Tab Classification Folders(1)

Protractors and Triangles(1)

Traditional Stamps(1)

Numbering Stamps(1)

Food Storage Bags/Wraps(1)

Art Paper Rolls and Sheets(1)

Padded Mailers(1)

Paper Rolls(1)

Paper Folders(1)

Desktop Organizers(1)

Copier/Laser/Inkjet Index Dividers(1)

Compass(1)

Rubber Bands(1)

Cash Counters(1)

Safety Tapes(1)

Board Erasers(1)

Letter Openers(1)

Cash Drawers(1)

Photo Tape(1)

Staple Removers(1)

Brand

Sparco(355)

Color

Clear(53)

White(46)

Black(43)

Gray(22)

Kraft(18)

Blue(12)

Red(12)

Assorted(11)

Green(10)

Silver(8)

Yellow(8)

Brown(7)

Green Bar(7)

Orange(4)

Smoke(3)

Navy(3)

Pink(3)

Stainless Steel(3)

Gold(2)

Chrome(2)

Apple Green(2)

Violet(2)

Natural(1)

Putty(1)

Non-glare(1)

Manila(1)

Charcoal Gray(1)

Ivory(1)

Neon Pink(1)

Neon Green(1)

Neon Orange(1)

Blue Bar(1)

Light Blue(1)

Transparent(1)

Goldenrod(1)

Canary(1)

Multicolor(1)

Size

6" Length(1)

Binder Capacity

2"(3)

1 1/2"(3)

4"(3)

5"(2)

1"(2)

3"(2)

Size

Letter(47)

Statement(1)

Legal(1)

Recycled

No(263)

Yes(25)

Price Range

$0-$99.99(297)

$100-$199.99(50)

$200-$299.99(5)

$300-$399.99(3)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved