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') 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(132)

Trash Bags & Liners(64)

Cups & Mugs(60)

Floor & Carpet Cleaner Accessories(38)

Indoor Mats(26)

Urinal Screens & Deodorizers(25)

Plates & Bowls(24)

Brooms & Sweepers(23)

Cutlery(23)

Cleaning Wipes(22)

Liquid Soap / Sanitizer Dispensers(21)

Waste Containers & Accessories(19)

Hand Soaps/Cleaners(19)

Multipurpose Cleaners(19)

Paper Towels(17)

Anti-Fatigue Mats(17)

Poles & Handles(16)

Bathroom Tissues(15)

Hand Sanitizers(14)

Table Covers/Skirts(14)

Brushes & Dusters(12)

Cups & Mugs Accessories(12)

Dust Pans(11)

Carafes & Airpots(10)

Glass Cleaners(10)

Food Storage Bags/Wraps(10)

Sweeteners(10)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Air Fresheners/Sanitizers(9)

Cleaning Equipment Parts & Accessories(8)

Gloves(7)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Floor & Carpet Cleaners(6)

Dust Mop Frames(6)

Outdoor Mats(6)

Creamers(6)

Beverage Straws & Stir Sticks(5)

Safety/Caution Signs(5)

Buckets(4)

Duster Refills(4)

Hairnets(4)

Cup Dispensers/Organizers(4)

Smoking Receptacles(4)

Breakroom Organizers(4)

Paper Napkins(4)

Recycling Bins(3)

Specialty Cleaners/Lubricants(3)

Dispenser Accessories(3)

Toilet Bowl Cleaners(2)

Bathroom Cleaners(2)

Aprons(2)

Plungers(2)

Safety Gear(2)

Board Cleaners & Wipes(2)

Air Freshener/Sanitizers Dispensers(2)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Tool Kits(2)

Ladders & Step Stools(2)

Toilet Seat Covers(2)

Furniture Polish(2)

Skin Wipes(2)

Reusable Towels(2)

Facial Tissues(2)

Janitorial Cloths & Wipes(2)

Bathroom Tissue Dispensers(1)

Laundry Detergents(1)

Janitorial Carts(1)

Spot & Stain Removers(1)

Pliers(1)

Towelettes(1)

Beverage Dispensers/Coolers(1)

Water Filters & Purifying Dispensers(1)

Wall Racks(1)

Janitorial Organizers(1)

Hand Trucks & Dollies(1)

Restroom Mats(1)

Foil & Wraps(1)

 
Brand

Genuine Joe(845)

Genuine Joe Solutions(12)

 
Color

White(227)

Black(124)

Natural(75)

Blue(73)

Clear(69)

Brown(39)

Green(37)

Gray(33)

Yellow(26)

Orange(25)

Red(22)

Stainless Steel(19)

Silver(18)

Translucent(14)

Dark Blue(6)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Purple(5)

Chocolate(4)

Amber(4)

Transparent(3)

Pink(3)

Assorted(3)

Dark Green(3)

Gray Marble(2)

Black Marble(2)

Maroon(2)

Green Tint(2)

Aqua Marine(2)

Salt Pepper(2)

Light Blue(2)

Turquoise(2)

Multi(2)

Charcoal Black(2)

Aqua(1)

Champagne(1)

Gold(1)

Chrome(1)

Steel Gray(1)

Woodgrain(1)

Aluminum(1)

Blue Frost(1)

Nickel(1)

Bronze(1)

Kraft(1)

Warm White(1)

Oak(1)

Smoke(1)

 
Size

12" Wide(4)

48" Width x 5" Depth(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

7.75" Length(3)

5.50" Length(2)

18" Width x 5" Depth(2)

18" Width x 25" Depth(2)

16" Wide(2)

23" Length x 5.75" Diameter(2)

24" Width x 25" Depth(1)

5" Width x 36" Length(1)

 
Recycled

No(662)

Yes(101)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved