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 `pinfo`.`sku` IN (SELECT `sku` FROM `dealer_special` `dsp` WHERE `dsp`.`expiration_date` >= CURDATE() AND (`dsp`.`status`='active' OR `dsp`.`status`='discontinued') ORDER BY `dsp`.`pick_order`) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock','spl_call_for_price') 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 '%' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('""' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('""' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('""' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('""' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='',`category_4` ='') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE ',%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Specials Items

Refine Search

  GO
 
Category Filter

Binder Clips(4)

Low-Density Trash Bags(4)

Index Cards(4)

Adhesive Note Pads(3)

Correction Tapes(3)

Cleaning Wipes(2)

Transparent & Invisible Tapes(2)

Permanent Markers(2)

Glue(2)

Insertable Tab Index Dividers(2)

Office Paper(2)

Staples(2)

Moisteners(2)

Gloves(2)

Correction Fluids(2)

Pens(2)

Lanyards(2)

Candy, Gum & Mints(1)

Facial Tissues(1)

Reporting & Stenography Pads(1)

First Aid Kits(1)

First Aid Kits & Supplies(1)

Rulers(1)

Antiseptic Wipes/Pads(1)

Crafting Tape(1)

Business Card Holders(1)

Pencil Leads(1)

Pen-Style Highlighters(1)

Calculators(1)

Toilet Tissues(1)

Safety Masks(1)

Paper Towels(1)

Board Erasers(1)

Erasers(1)

Hand Soaps(1)

Hand Soaps/Cleaners(1)

Rulers & Yardsticks(1)

Manual Pencil Sharpeners(1)

Highlighters(1)

Tape Dispensers(1)

Presentation / View Binders(1)

Letter Openers(1)

Rubber Bands(1)

Glue Sticks & Pens(1)

Calculator & Register Rolls(1)

Ballpoint Stick Pens(1)

Tape Measures(1)

Clipboards(1)

Scissors(1)

Staple Removers(1)

Coffee Filters(1)

Knives & Multi-Purpose Tools(1)

Eye Protection(1)

Chalks(1)

Crayons(1)

Hand Sanitizers(1)

File Folders(1)

 
Brand

Business Source(25)

Special Buy(5)

Integra(5)

BIC(4)

Genuine Joe(3)

SICURIX(2)

Universal(2)

Boardwalk(2)

Oxford(2)

Medline(2)

Sparco(2)

Officemate(1)

Pentel(1)

Pilot(1)

Westcott(1)

Sharpie(1)

Sharp(1)

Swingline(1)

Tombow(1)

The Pencil Grip(1)

Handi-Bag(1)

Scotch(1)

Kleenex(1)

Mead(1)

LifeSavers(1)

Avery(1)

Johnson & Johnson Red Cross(1)

Clean Cut(1)

Elmer's(1)

Prang(1)

Crayola(1)

MCR Safety(1)

Softsoap(1)

COSCO(1)

Clorox(1)

BUNN(1)

Baumgartens(1)

Earthsense Commercial(1)

 
Color

White(1)

 
Binder Capacity

1/2"(1)

 
Recycled

No(44)

Yes(1)

 
Packing Type

Bottle(2)

Stick(1)

Pump Bottle(1)

Bag(1)

 
Refillable

No(1)

 
Closure

Drawstring(1)

Tie(1)

Flap-Tie(1)

 
 
 

© 2023-2024 Hi Tech Office Products, All Rights Reserved