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 (`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 `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

Manufacturer

Genuine Joe

Refine Search

  GO
 
Category

Mops & Mop Refills(132)

Cups & Mugs(66)

Trash Bags & Liners(64)

Floor & Carpet Cleaner Accessories(36)

Waste Containers & Accessories(29)

Brooms & Sweepers(28)

Indoor Mats(28)

Plates(26)

Cutlery(23)

Urinal Screens & Deodorizers(23)

Liquid Soap / Sanitizer Dispensers(22)

Hand Soaps/Cleaners(19)

Anti-Fatigue Mats(17)

Paper Towels(16)

Cleaning Wipes(15)

Brushes & Dusters(15)

Poles & Handles(15)

Multipurpose Cleaners(14)

Table Covers/Skirts(14)

Bathroom Tissues(13)

Cleaning Equipment Parts & Accessories(13)

Hand Sanitizers(13)

Cups & Mugs Accessories(12)

Air Fresheners/Sanitizers(11)

Dust Pans(11)

Glass Cleaners(10)

Sweeteners(10)

Food Storage Bags/Wraps(10)

Carafes & Airpots(9)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Dust Mop Frames(8)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Gloves(6)

Creamers(6)

Beverage Straws & Stir Sticks(6)

Bowls(6)

Deodorizers(5)

Safety/Caution Signs(5)

Breakroom Organizers(4)

Outdoor Mats(4)

Hairnets(4)

Specialty Cleaners/Lubricants(4)

Paper Napkins(4)

Smoking Receptacles(4)

Duster Refills(4)

Buckets(4)

Recycling Bins(3)

Floor & Carpet Cleaners(3)

Dispenser Accessories(3)

Bathroom Tissue Dispensers(3)

Board Cleaners & Wipes(2)

Fall Protection Equipments(2)

Safety Gear(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Sponges & Scouring Pads(2)

Aprons(2)

Toilet Bowl Cleaners(2)

Plungers(2)

Toilet Seats(2)

Tool Kits(2)

Toilet Seat Covers(2)

Furniture Polish(2)

Facial Tissues(2)

Reusable Towels(2)

Cup Dispensers/Organizers(2)

Janitorial Cloths & Wipes(2)

Ladders & Step Stools(1)

Janitorial Carts(1)

Foil & Wraps(1)

Spot & Stain Removers(1)

Laundry Detergents(1)

Tool Storage & Organization(1)

Towelettes(1)

Water Filters & Purifying Dispensers(1)

Skin Wipes(1)

Wall Racks(1)

Tape Measures(1)

Restroom Mats(1)

Pliers(1)

 
Brand

Genuine Joe(868)

Genuine Joe Solutions(11)

 
Color

White(222)

Black(127)

Blue(78)

Natural(74)

Clear(70)

Brown(42)

Gray(37)

Green(35)

Yellow(29)

Orange(22)

Red(21)

Stainless Steel(19)

Silver(19)

Assorted(16)

Translucent(14)

Purple(8)

Dark Blue(7)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Amber(4)

Maroon(4)

Chocolate(4)

Charcoal Black(3)

Transparent(3)

Gray Marble(2)

Black Marble(2)

Salt Pepper(2)

Aqua Marine(2)

Green Tint(2)

Chrome(2)

Turquoise(2)

Multi(2)

Pink(2)

Light Brown(2)

Aqua(1)

Woodgrain(1)

Champagne(1)

Steel Gray(1)

Kraft(1)

Granite(1)

Warm White(1)

Blue Frost(1)

Nickel(1)

Bronze(1)

Aluminum(1)

Oak(1)

 
Size

12" Wide(6)

7.75" Length(4)

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

24" Width x 5" Depth(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(688)

Yes(87)

 
 
 

© 2019-2020 LOP Office Supply, All Rights Reserved