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_27` 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 Filter

Clipboards(25)

Standard Ring Binders(20)

Transparent & Invisible Tapes(19)

Bubble Wraps(18)

Memo / Subject Notebooks(17)

Scissors(16)

Letter, Legal & Jr. Pads(15)

Single-part Computer Paper(15)

Filler Papers(14)

Multipurpose Labels(12)

Flags(11)

Stretch Wrap & Dispensers(11)

Title Stamps(10)

Bubble Mailers(9)

Pocket Portfolios/Folders(9)

Coin Wrappers, Bill Straps & Trays(9)

Presentation / View Binders(8)

Adhesive Note Pads(7)

Copy & Multi-use Colored Paper(7)

Key Boxes & Cabinets(7)

Multi-part Computer Paper(7)

Utility Knives & Cutters(7)

Moisteners(6)

Binding Spines & Strips(6)

Cash Boxes(6)

Tickets(6)

Sheet Protectors(6)

Hand Trucks & Dollies(6)

Packing Paper(5)

Packing List/Invoice Enclosed Envelopes(5)

Utility Knife Replacement Blades(5)

Copy & Multi-use White Paper(5)

Shipping Tape Dispensers(5)

Index Cards(5)

Packaging Tapes(5)

Binding Covers(4)

Magnifiers(4)

Shipping & Moving Boxes(4)

Packaging Tape(3)

Stamp Pad Ink(3)

Board Erasers(3)

Desktop Hole Punches(3)

Counterfeit Currency Detectors(3)

Tally Counters(3)

Traditional Stamps(3)

Glitters(3)

Pad Folios(3)

Stamp Creators(2)

Video Cassettes(2)

Custom Stamps(2)

Vinyl/Plastic Pockets & Sleeves(2)

Dry-Erase Boards(2)

Luggage Carts(2)

Green Hanging Folders(2)

Tape Dispensers(2)

All-Purpose Glues(2)

Telephone Message Books & Pads(2)

Storage Boxes & Containers(2)

TYVEK & Tear-Resistant Envelopes(1)

Padded Mailers(1)

Self-Inking Stamps(1)

Rulers & Yardsticks(1)

Food Storage Bags/Wraps(1)

Craft Supplies(1)

Safety Tapes(1)

Paper Folders(1)

Protractors and Triangles(1)

Rubber Bands(1)

Stamp Pads(1)

Numbering Stamps(1)

Letter Openers(1)

Magnetic Push Pins(1)

Top Tab Fastener Folders(1)

Staple Removers(1)

Desktop Organizers(1)

Art Paper Rolls and Sheets(1)

Portfolios(1)

Photo Tape(1)

Paper Rolls(1)

Cash Drawers(1)

Laminating Supplies(1)

Heavy-Duty Hole Punches(1)

Punch Heads(1)

Compass(1)

Waste Containers & Accessories(1)

Copier/Laser/Inkjet Index Dividers(1)

Cash Counters(1)

 
Brand

Sparco(372)

Business Source(60)

Lorell(2)

 
Color

Black(61)

Clear(61)

White(55)

Gray(24)

Blue(15)

Red(15)

Kraft(14)

Assorted(13)

Yellow(12)

Green(11)

Silver(10)

Green Bar(8)

Smoke(6)

Brown(6)

Orange(4)

Pink(3)

Navy(3)

Violet(3)

Stainless Steel(3)

Apple Green(2)

Gold(2)

Non-glare(2)

Black/Gray(2)

Chrome(2)

Neon Orange(2)

Neon Green(2)

Neon Pink(2)

Dark Blue(1)

Pastel Assorted(1)

Charcoal Gray(1)

Natural(1)

Plain White(1)

Pastel(1)

Assorted Pastel(1)

Canary(1)

Neon Assorted(1)

Putty(1)

Transparent(1)

Multicolor(1)

Ivory(1)

Goldenrod(1)

Blue Bar(1)

Light Blue(1)

 
Brightness

92(5)

 
Binder Capacity

3"(6)

2"(5)

4"(5)

1"(4)

1 1/2"(3)

5"(3)

1/2"(2)

 
Recycled

No(335)

Yes(33)

 
Height

12.5"(10)

11"(4)

12"(4)

3.8"(2)

14"(2)

12 3/5"(2)

29.5"(2)

10"(2)

2.9"(1)

3.9"(1)

0.6"(1)

2.5"(1)

4.3"(1)

1.3"(1)

8.5"(1)

20.2"(1)

6.1"(1)

8"(1)

50"(1)

47"(1)

7.9"(1)

12.1"(1)

20.1"(1)

17.1"(1)

2.1"(1)

3.2"(1)

3.4"(1)

2.3"(1)

4"(1)

2"(1)

9.8"(1)

15"(1)

38.3"(1)

35"(1)

32"(1)

1000 ft(1)

0.5"(1)

11 3/4"(1)

 
Depth

0.1"(10)

12"(3)

3"(3)

4.9"(2)

7.8"(2)

7.5"(1)

20"(1)

30"(1)

6"(1)

13"(1)

2.6"(1)

15.8"(1)

11"(1)

9.9"(1)

8.3"(1)

15"(1)

10.5"(1)

26"(1)

36"(1)

29"(1)

13.8"(1)

60"(1)

18"(1)

 
Size

6" Length(1)

 
Refillable

Yes(5)

 
Diameter

8.5"(3)

3"(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved