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)

Transparent & Invisible Tapes(19)

Bubble Wraps(18)

Scissors(15)

Standard Ring Binders(15)

Single-part Computer Paper(15)

Memo / Subject Notebooks(14)

Filler Papers(14)

Letter, Legal & Jr. Pads(13)

Multipurpose Labels(12)

Stretch Wrap & Dispensers(11)

Flags(11)

Title Stamps(11)

Coin Wrappers, Bill Straps & Trays(9)

Bubble Mailers(9)

Pocket Portfolios/Folders(9)

Utility Knives & Cutters(7)

Copy & Multi-use Colored Paper(7)

Key Boxes & Cabinets(7)

Presentation / View Binders(7)

Cash Boxes(6)

Hand Trucks & Dollies(6)

Tickets(6)

Binding Spines & Strips(6)

Moisteners(6)

Packing Paper(5)

Packing List/Invoice Enclosed Envelopes(5)

Packaging Tapes(5)

Shipping Tape Dispensers(5)

Utility Knife Replacement Blades(5)

Multi-part Computer Paper(5)

Magnifiers(4)

Binding Covers(4)

Desktop Hole Punches(3)

Counterfeit Currency Detectors(3)

Glitters(3)

Packaging Tape(3)

Board Erasers(3)

Sheet Protectors(3)

Shipping & Moving Boxes(3)

Traditional Stamps(3)

Tally Counters(3)

Pad Folios(3)

Stamp Pad Ink(3)

Video Cassettes(2)

Storage Boxes & Containers(2)

Luggage Carts(2)

Vinyl/Plastic Pockets & Sleeves(2)

All-Purpose Glues(2)

Green Hanging Folders(2)

Custom Stamps(2)

Stamp Creators(2)

Index Cards(2)

Dry-Erase Boards(2)

Telephone Message Books & Pads(2)

Tape Dispensers(2)

Self-Inking Stamps(1)

Padded Mailers(1)

Numbering Stamps(1)

Craft Supplies(1)

Photo Tape(1)

Portfolios(1)

Stamp Pads(1)

Food Storage Bags/Wraps(1)

Cash Drawers(1)

Paper Rolls(1)

Magnetic Push Pins(1)

Copy & Multi-use White Paper(1)

Staple Removers(1)

Desktop Organizers(1)

Rubber Bands(1)

Letter Openers(1)

Top Tab Fastener Folders(1)

Rulers & Yardsticks(1)

Protractors and Triangles(1)

Paper Folders(1)

Copier/Laser/Inkjet Index Dividers(1)

Compass(1)

Cash Counters(1)

Safety Tapes(1)

Art Paper Rolls and Sheets(1)

Heavy-Duty Hole Punches(1)

Waste Containers & Accessories(1)

Punch Heads(1)

 
Brand

Sparco(339)

Business Source(60)

Lorell(2)

 
Color

Clear(58)

Black(55)

White(47)

Gray(23)

Red(15)

Blue(15)

Kraft(13)

Assorted(13)

Green(11)

Silver(10)

Yellow(9)

Green Bar(7)

Smoke(6)

Brown(6)

Orange(4)

Pink(3)

Stainless Steel(3)

Navy(3)

Violet(3)

Neon Green(2)

Neon Orange(2)

Black/Gray(2)

Gold(2)

Non-glare(2)

Apple Green(2)

Chrome(2)

Neon Pink(2)

Charcoal Gray(1)

Putty(1)

Transparent(1)

Light Blue(1)

Natural(1)

Blue Bar(1)

Canary(1)

Ivory(1)

Goldenrod(1)

Multicolor(1)

 
Brightness

92(1)

 
Binder Capacity

4"(5)

2"(4)

3"(4)

1 1/2"(3)

1"(3)

5"(2)

1/2"(1)

 
Recycled

No(305)

Yes(32)

 
Height

12.5"(10)

12"(4)

29.5"(2)

12 3/5"(2)

3.8"(2)

10"(2)

14"(2)

2.9"(1)

3.9"(1)

11 3/4"(1)

20.2"(1)

7.9"(1)

11"(1)

0.6"(1)

47"(1)

6.1"(1)

4.3"(1)

20.1"(1)

2.5"(1)

1.3"(1)

50"(1)

3.2"(1)

35"(1)

38.3"(1)

32"(1)

1000 ft(1)

2.1"(1)

0.5"(1)

15"(1)

9.8"(1)

3.4"(1)

12.1"(1)

2.3"(1)

4"(1)

2"(1)

17.1"(1)

 
Depth

0.1"(10)

3"(3)

7.8"(2)

12"(2)

4.9"(2)

2.6"(1)

6"(1)

18"(1)

20"(1)

30"(1)

7.5"(1)

13"(1)

15.8"(1)

29"(1)

13.8"(1)

60"(1)

9.9"(1)

36"(1)

26"(1)

8.3"(1)

15"(1)

10.5"(1)

11"(1)

 
Size

6" Length(1)

 
Refillable

Yes(5)

 
Diameter

8.5"(3)

3"(1)

 
 
 

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