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

Trash Bags & Liners(64)

Cups & Mugs(53)

Floor & Carpet Cleaner Accessories(38)

Indoor Mats(26)

Brooms & Sweepers(22)

Cutlery(20)

Multipurpose Cleaners(19)

Cleaning Wipes(19)

Anti-Fatigue Mats(17)

Waste Containers & Accessories(17)

Plates & Bowls(17)

Paper Towels(16)

Hand Sanitizers(15)

Hand Soaps/Cleaners(14)

Bathroom Tissues(14)

Liquid Soap / Sanitizer Dispensers(12)

Cups & Mugs Accessories(11)

Air Fresheners/Sanitizers(11)

Poles & Handles(10)

Glass Cleaners(10)

Food Storage Bags/Wraps(10)

Urinal Screens & Deodorizers(10)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Carafes & Airpots(9)

Brushes & Dusters(9)

Dust Pans(9)

Sweeteners(9)

Gloves(7)

Table Covers/Skirts(7)

Outdoor Mats(6)

Floor & Carpet Cleaners(6)

Cleaning Equipment Parts & Accessories(6)

Sprayer Parts & Accessories(6)

Creamers(5)

Buckets(5)

Smoking Receptacles(4)

Beverage Straws & Stir Sticks(4)

Recycling Bins(4)

Paper Napkins(4)

Dust Mop Frames(4)

Paper Towel Dispensers(4)

Duster Refills(4)

Specialty Cleaners/Lubricants(4)

Dispenser Accessories(3)

Bathroom Cleaners(3)

Breakroom Organizers(2)

Facial Tissues(2)

Air Freshener/Sanitizers Dispensers(2)

Cup Dispensers/Organizers(2)

Ladders & Step Stools(2)

Tool Kits(2)

Hairnets(2)

Safety/Caution Signs(2)

Skin Wipes(2)

Toilet Bowl Cleaners(2)

Bathroom Tissue Dispensers(2)

Furniture Polish(2)

Board Cleaners & Wipes(2)

Toilet Seat Covers(2)

Spot & Stain Removers(1)

Laundry Detergents(1)

Plungers(1)

Sponges & Scouring Pads(1)

Aprons(1)

Safety Gear(1)

Toilet Seats(1)

Janitorial Cloths & Wipes(1)

Tool Storage & Organization(1)

Wall Racks(1)

Pliers(1)

Foil & Wraps(1)

Hand Trucks & Dollies(1)

Towelettes(1)

Reusable Towels(1)

Restroom Mats(1)

Water Filters & Purifying Dispensers(1)

Beverage Dispensers/Coolers(1)

Storage Boxes & Containers(1)

Janitorial Carts(1)

 
Brand

Genuine Joe(746)

Genuine Joe Solutions(8)

 
Color

White(201)

Black(109)

Natural(69)

Clear(68)

Blue(60)

Brown(33)

Green(32)

Gray(24)

Orange(21)

Yellow(21)

Red(21)

Silver(17)

Stainless Steel(14)

Translucent(14)

Charcoal(6)

Dark Blue(6)

Charcoal Gray(5)

Purple(4)

Amber(4)

Chocolate(4)

Assorted(3)

Metallic(3)

Dark Green(3)

Transparent(3)

Pink(3)

Aqua Marine(2)

Black Marble(2)

Gray Marble(2)

Maroon(2)

Green Tint(2)

Light Blue(2)

Charcoal Black(2)

Salt Pepper(2)

Turquoise(2)

Steel Gray(1)

Gold(1)

Chrome(1)

Multi(1)

Kraft(1)

Aqua(1)

Bronze(1)

Aluminum(1)

Oak(1)

Smoke(1)

Nickel(1)

Champagne(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(2)

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

24" Width x 25" Depth(1)

5" Width x 36" Length(1)

 
Recycled

No(494)

Yes(61)

 
 
 

© 2018-2019 LOP Office Supply, All Rights Reserved