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_1` 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 ((`desc_short` like 'Genuine Joe' OR `desc_long` like 'Genuine Joe' OR `desc_title` like 'Genuine Joe' OR `keywords` like 'Genuine Joe' OR `category_1` like 'Genuine Joe' OR `category_2` like 'Genuine Joe' OR `category_3` like 'Genuine Joe' OR `category_4` like 'Genuine Joe' OR `manufacturer_name` like 'Genuine Joe' OR `color` like 'Genuine Joe') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>Genuine>Genuines)+(>Joe>Joes)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"Genuine Joe"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%Genuine Joe%' OR `pinfo`.`sku` like '%GenuineJoe%' OR (FIND_IN_SET('Genuine Joe', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('Genuine Joe', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('Genuine Joe', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('Genuine Joe', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('Genuine Joe', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'Genuine Joe' ELSE `pinfo`.`desc_title` like 'Genuine Joe' END))) 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 '%Genuine Joe' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('Genuine +Joe' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+Genuine +Joe' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"Genuine Joe"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"Genuine Joe"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"Genuine Joe"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"Genuine Joe"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+Genuine +Joe' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='Joe',`category_4` ='Joe') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'Joe,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('Joe', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Genuine Joe

Refine Search

  GO
 
Category

Mops & Mop Refills(135)

Trash Bags & Liners(75)

Cups & Mugs(66)

Floor & Carpet Cleaner Accessories(36)

Waste Containers & Accessories(31)

Hand Soaps/Cleaners(29)

Indoor Mats(28)

Brooms & Sweepers(28)

Plates(26)

Urinal Screens & Deodorizers(25)

Cutlery(23)

Liquid Soap / Sanitizer Dispensers(22)

Anti-Fatigue Mats(19)

Brushes & Dusters(17)

Cleaning Wipes(17)

Paper Towels(17)

Table Covers/Skirts(16)

Food Storage Bags/Wraps(16)

Poles & Handles(15)

Hand Sanitizers(14)

Multipurpose Cleaners(14)

Cleaning Equipment Parts & Accessories(13)

Bathroom Tissues(13)

Cups & Mugs Accessories(12)

Dust Pans(11)

Air Fresheners/Sanitizers(11)

Glass Cleaners(10)

Sweeteners(10)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Carafes & Airpots(9)

Beverage Straws & Stir Sticks(8)

Dust Mop Frames(8)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Bowls(6)

Creamers(6)

Gloves(6)

Buckets(5)

Deodorizers(5)

Safety/Caution Signs(5)

Breakroom Organizers(4)

Paper Napkins(4)

Outdoor Mats(4)

Smoking Receptacles(4)

Hairnets(4)

Specialty Cleaners/Lubricants(4)

Duster Refills(4)

Floor & Carpet Cleaners(3)

Dispenser Accessories(3)

Sponges & Scouring Pads(3)

Tool Kits(3)

Bathroom Tissue Dispensers(3)

Recycling Bins(3)

Board Cleaners & Wipes(2)

Toilet Bowl Cleaners(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Aprons(2)

Toilet Seat Covers(2)

Plungers(2)

Safety Gear(2)

Toilet Seats(2)

Furniture Polish(2)

Fall Protection Equipments(2)

Foil & Wraps(2)

Reusable Towels(2)

Janitorial Cloths & Wipes(2)

Cup Dispensers/Organizers(2)

Facial Tissues(2)

Water Filters & Purifying Dispensers(2)

Tool Storage & Organization(1)

Spot & Stain Removers(1)

Wall Racks(1)

Janitorial Carts(1)

Towelettes(1)

Squeegees/Scrapers(1)

Ladders & Step Stools(1)

Tape Measures(1)

Skin Wipes(1)

Pliers(1)

Restroom Mats(1)

Liquid Soap/Hand Sanitizers Stands(1)

Laundry Detergents(1)

 
Brand

Genuine Joe(921)

Genuine Joe Solutions(11)

 
Color

White(231)

Black(134)

Clear(86)

Blue(81)

Natural(74)

Gray(42)

Brown(42)

Green(37)

Yellow(29)

Orange(28)

Silver(22)

Red(21)

Stainless Steel(19)

Assorted(16)

Translucent(14)

Purple(8)

Dark Blue(7)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Maroon(4)

Chocolate(4)

Amber(4)

Pink(4)

Transparent(3)

Charcoal Black(3)

Black Marble(2)

Aqua Marine(2)

Gray Marble(2)

Salt Pepper(2)

Green Tint(2)

Multi(2)

Chrome(2)

Light Brown(2)

Turquoise(2)

Blue Frost(1)

Warm White(1)

Light Blue(1)

Champagne(1)

Aqua(1)

Oak(1)

Woodgrain(1)

Bronze(1)

Aluminum(1)

Granite(1)

Kraft(1)

Nickel(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)

4" Width x 4" Length(1)

 
Recycled

No(735)

Yes(87)

 
 
 

© 2020-2021 LOP Office Supply, All Rights Reserved