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_12` 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 `pinfo`.`sku` IN (SELECT `sku` FROM `dealer_special` `dsp` WHERE `dsp`.`expiration_date` >= '2020-07-14' AND (`dsp`.`status`='active' OR `dsp`.`status`='discontinued') ORDER BY `dsp`.`pick_order`) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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

Refine Search

  GO
Category

Hand Soaps/Cleaners(20)

Hand Sanitizers(11)

Multipurpose Cleaners(9)

Disinfectants(8)

Examination Gloves(6)

Gloves(5)

Safety Masks(5)

Cutlery(5)

Liquid Soap / Sanitizer Dispensers(4)

Paper Towels(4)

Air Purifier/Humidifier Filters(2)

Cleaning Wipes(2)

Bathroom Tissues(2)

Task Chairs(2)

Safety Gear(2)

Water(2)

Facial Tissues(2)

Bathroom Cleaners(1)

Desktop Risers(1)

Medical Disinfectants & Cleaners(1)

Management/Mid-Back Chairs(1)

Executive/High Back Chairs(1)

Rulers & Yardsticks(1)

Eye Protection(1)

Spray Bottles(1)

Bathroom Tissue Dispensers(1)

Transparent & Invisible Tapes(1)

First Aid Kits & Supplies(1)

Soap Dispensers(1)

Scissors(1)

Desktop Organizers(1)

Desktop Staplers(1)

Thermometers/Probe Covers(1)

Brand

Genuine Joe(14)

Lorell(9)

Clorox(8)

Method(6)

Business Source(5)

Dial(4)

ProGuard(4)

Medline(4)

Softsoap(4)

Gojo®(3)

Lysol(2)

Chemco(2)

Windex®(2)

Bounty(2)

Microban Professional(2)

Pure Life(2)

KIK(2)

Kleenex(2)

Dear Derm(2)

Smart Choice(2)

Enviro Care(1)

Sparkle ps(1)

Livi(1)

Dial« Professional(1)

Seventh Generation(1)

Professional Lysol(1)

Dial Complete(1)

DiversaMed(1)

First Aid Only(1)

PURELL®(1)

Georgia-Pacific(1)

Protected Chef(1)

Cool Breeze(1)

PDI(1)

Spray Alert(1)

Marcal(1)

Curad(1)

Anjieshu(1)

Raw(1)

Scott(1)

Sweet Carefor(1)

Sourcingpartner(1)

Color

White(26)

Clear(24)

Green(7)

Black(5)

Yellow(5)

Orange(4)

Multi(3)

Silver(2)

Natural(2)

Cream(2)

Blue(2)

Gold(2)

Pink(2)

Lavender(2)

Dove Gray(1)

Smoke Gray(1)

Stainless Steel(1)

Smoke(1)

Size

55-63" Adjustable Stand with 11"w x 13"h Weighted Base(1)

Recycled

No(62)

Yes(5)

Price Range

$0-$499.99 (105)

$500-$999.99 (1)

$1500-$1999.99 (1)

To  GO

 
 
1%
Searching for your Best Results.....
loading results
 

© 2020-2021 JD Office Products, All Rights Reserved