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 CASE WHEN ds.type='hot deals' THEN `ds`.`expiration_date` >= CURDATE() else CURDATE() BETWEEN `ds`.`start_date` AND `ds`.`expiration_date` END 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` = "1701438") 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 ('genuinejoe' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+genuinejoe' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"genuinejoe"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"genuinejoe"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"genuinejoe"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"genuinejoe"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+genuinejoe' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='genuinejoe',`category_4` ='genuinejoe') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'genuinejoe,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('genuinejoe', `pinfo`.`desc_title`)) DESC

Manufacturer

Currently Filtered by

Manufacturer

Genuine Joe

Refine Search

  GO
Category

Mops & Mop Refills(119)

Trash Bags & Liners(64)

Cups & Mugs(63)

Floor & Carpet Cleaner Accessories(28)

Indoor Mats(28)

Urinal Screens & Deodorizers(24)

Cutlery(23)

Plates(23)

Brooms & Sweepers(23)

Liquid Soap / Sanitizer Dispensers(21)

Cleaning Wipes(19)

Waste Containers & Accessories(19)

Hand Soaps/Cleaners(19)

Multipurpose Cleaners(18)

Anti-Fatigue Mats(17)

Paper Towels(16)

Poles & Handles(15)

Bathroom Tissues(14)

Table Covers/Skirts(14)

Hand Sanitizers(13)

Brushes & Dusters(12)

Cups & Mugs Accessories(12)

Air Fresheners/Sanitizers(11)

Sweeteners(10)

Dust Pans(10)

Glass Cleaners(10)

Food Storage Bags/Wraps(10)

Carafes & Airpots(9)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Cleaning Equipment Parts & Accessories(8)

Sprayer Parts & Accessories(7)

Gloves(7)

Paper Towel Dispensers(7)

Beverage Straws & Stir Sticks(6)

Floor & Carpet Cleaners(6)

Creamers(6)

Dust Mop Frames(6)

Bowls(5)

Outdoor Mats(5)

Breakroom Organizers(4)

Buckets(4)

Duster Refills(4)

Hairnets(4)

Smoking Receptacles(4)

Paper Napkins(4)

Safety/Caution Signs(4)

Specialty Cleaners/Lubricants(3)

Recycling Bins(3)

Cup Dispensers/Organizers(3)

Dispenser Accessories(3)

Fall Protection Equipments(2)

Board Cleaners & Wipes(2)

Toilet Seats(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Toilet Bowl Cleaners(2)

Aprons(2)

Safety Gear(2)

Plungers(2)

Sponges & Scouring Pads(2)

Tool Kits(2)

Bathroom Tissue Dispensers(2)

Furniture Polish(2)

Toilet Seat Covers(2)

Skin Wipes(2)

Reusable Towels(2)

Janitorial Cloths & Wipes(2)

Facial Tissues(2)

Water Filters & Purifying Dispensers(2)

Ladders & Step Stools(2)

Laundry Detergents(1)

Spot & Stain Removers(1)

Janitorial Carts(1)

Tape Measures(1)

Wall Racks(1)

Towelettes(1)

Tool Storage & Organization(1)

Restroom Mats(1)

Pliers(1)

Foil & Wraps(1)

Brand

Genuine Joe(837)

Genuine Joe Solutions(11)

Color

White(221)

Black(123)

Natural(73)

Blue(71)

Clear(70)

Brown(38)

Green(34)

Gray(32)

Yellow(27)

Orange(23)

Red(22)

Silver(19)

Stainless Steel(18)

Translucent(14)

Assorted(10)

Dark Blue(8)

Purple(6)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Amber(4)

Chocolate(4)

Dark Green(3)

Transparent(3)

Salt Pepper(2)

Gray Marble(2)

Charcoal Black(2)

Aqua Marine(2)

Black Marble(2)

Green Tint(2)

Pink(2)

Maroon(2)

Multi(2)

Turquoise(2)

Smoke(1)

Champagne(1)

Woodgrain(1)

Aqua(1)

Granite(1)

Steel Gray(1)

Warm White(1)

Chrome(1)

Kraft(1)

Blue Frost(1)

Bronze(1)

Aluminum(1)

Nickel(1)

Oak(1)

Size

7.75" Length(4)

48" Width x 5" Depth(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

12" Wide(3)

16" Wide(2)

5.50" Length(2)

18" Width x 5" Depth(2)

18" Width x 25" Depth(2)

5" Width x 36" Length(1)

24" Width x 25" Depth(1)

Recycled

No(651)

Yes(98)

Price Range

$0-$499.99(843)

$500-$999.99(3)

$1000-$1499.99(2)

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