Banner1 Banner1
 
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_36` 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` = "11414") 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 '%GenuineJoe' THEN 1 ELSE 0 END DESC, 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

Currently Filtered by


Genuine Joe

Refine Search

  GO
 
Category

Mops & Mop Refills(129)

Trash Bags & Liners(68)

Cups & Mugs(66)

Floor & Carpet Cleaner Accessories(31)

Plates(26)

Brooms & Sweepers(23)

Cutlery(23)

Indoor Mats(23)

Liquid Soap / Sanitizer Dispensers(21)

Urinal Screens & Deodorizers(19)

Paper Towels(19)

Waste Containers & Accessories(19)

Anti-Fatigue Mats(17)

Bathroom Tissues(15)

Cleaning Wipes(14)

Hand Soaps/Cleaners(14)

Multipurpose Cleaners(14)

Table Covers/Skirts(14)

Poles & Handles(13)

Cups & Mugs Accessories(12)

Dust Pans(11)

Brushes & Dusters(11)

Air Fresheners/Sanitizers(11)

Cleaning Equipment Parts & Accessories(11)

Hand Sanitizers(10)

Food Storage Bags/Wraps(10)

Glass Cleaners(10)

Sweeteners(10)

Dishwashing Detergents & Liquids(9)

Sprayers(9)

Carafes & Airpots(7)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Dust Mop Frames(6)

Beverage Straws & Stir Sticks(6)

Bowls(6)

Smoking Receptacles(5)

Gloves(5)

Buckets(5)

Safety/Caution Signs(4)

Outdoor Mats(4)

Duster Refills(4)

Paper Napkins(4)

Breakroom Organizers(4)

Hairnets(4)

Facial Tissues(3)

Specialty Cleaners/Lubricants(3)

Dispenser Accessories(3)

Floor & Carpet Cleaners(3)

Recycling Bins(3)

Creamers(3)

Aprons(2)

Plungers(2)

Toilet Seat Covers(2)

Fall Protection Equipments(2)

Board Cleaners & Wipes(2)

Toilet Bowl Cleaners(2)

Safety Gear(2)

Janitorial Cloths & Wipes(2)

Bathroom Cleaners(2)

Furniture Polish(2)

Cup Dispensers/Organizers(2)

Sponges & Scouring Pads(2)

Reusable Towels(2)

Bathroom Tissue Dispensers(2)

Toilet Seats(2)

Air Freshener/Sanitizers Dispensers(1)

Spot & Stain Removers(1)

Tool Kits(1)

Restroom Mats(1)

Water Filters & Purifying Dispensers(1)

Towelettes(1)

Skin Wipes(1)

Wall Racks(1)

Tool Storage & Organization(1)

Tape Measures(1)

Foil & Wraps(1)

Deodorizers(1)

Ladders & Step Stools(1)

Janitorial Carts(1)

Laundry Detergents(1)

 
Brand

Genuine Joe(811)

Genuine Joe Solutions(12)

 
Color

White(217)

Black(123)

Natural(70)

Blue(69)

Clear(67)

Brown(35)

Green(29)

Yellow(28)

Gray(28)

Orange(19)

Silver(18)

Stainless Steel(18)

Red(18)

Assorted(16)

Translucent(15)

Purple(6)

Charcoal(6)

Dark Blue(6)

Metallic(5)

Charcoal Gray(5)

Chocolate(4)

Amber(4)

Charcoal Black(3)

Transparent(3)

Maroon(2)

Aqua Marine(2)

Aluminum(2)

Black Marble(2)

Gray Marble(2)

Salt Pepper(2)

Green Tint(2)

Turquoise(2)

Multi(2)

Pink(2)

Blue Frost(1)

Nickel(1)

Kraft(1)

Granite(1)

Bronze(1)

Light Brown(1)

Oak(1)

Woodgrain(1)

Warm White(1)

Aqua(1)

Champagne(1)

Chrome(1)

Steel Gray(1)

 
Size

12" Wide(6)

48" Width x 5" Depth(4)

7.75" Length(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

18" Width x 25" Depth(2)

18" Width x 5" Depth(2)

5.50" Length(2)

16" Wide(2)

24" Width x 25" Depth(1)

5" Width x 36" Length(1)

 
Recycled

No(634)

Yes(89)

 
 
 

© 2020-2021 Legal Name, All Rights Reserved