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_26` 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)

Trash Bags & Liners(64)

Cups & Mugs(59)

Floor & Carpet Cleaner Accessories(38)

Indoor Mats(26)

Plates & Bowls(24)

Cutlery(23)

Brooms & Sweepers(22)

Cleaning Wipes(22)

Urinal Screens & Deodorizers(21)

Liquid Soap / Sanitizer Dispensers(21)

Multipurpose Cleaners(19)

Waste Containers & Accessories(19)

Hand Soaps/Cleaners(18)

Paper Towels(17)

Anti-Fatigue Mats(17)

Poles & Handles(15)

Bathroom Tissues(14)

Hand Sanitizers(14)

Table Covers/Skirts(14)

Brushes & Dusters(12)

Air Fresheners/Sanitizers(12)

Cleaning Equipment Parts & Accessories(12)

Cups & Mugs Accessories(11)

Dust Pans(11)

Carafes & Airpots(10)

Glass Cleaners(10)

Food Storage Bags/Wraps(10)

Sweeteners(10)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Gloves(9)

Sprayer Parts & Accessories(7)

Paper Towel Dispensers(7)

Dust Mop Frames(6)

Outdoor Mats(6)

Creamers(6)

Floor & Carpet Cleaners(6)

Safety/Caution Signs(5)

Beverage Straws & Stir Sticks(5)

Cup Dispensers/Organizers(4)

Breakroom Organizers(4)

Duster Refills(4)

Buckets(4)

Smoking Receptacles(4)

Hairnets(4)

Paper Napkins(4)

Recycling Bins(3)

Tool Kits(3)

Specialty Cleaners/Lubricants(3)

Dispenser Accessories(3)

Safety Gear(2)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Reusable Towels(2)

Toilet Seat Covers(2)

Plungers(2)

Aprons(2)

Toilet Bowl Cleaners(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Furniture Polish(2)

Ladders & Step Stools(2)

Board Cleaners & Wipes(2)

Skin Wipes(2)

Facial Tissues(2)

Janitorial Cloths & Wipes(2)

Water Filters & Purifying Dispensers(1)

Beverage Dispensers/Coolers(1)

Laundry Detergents(1)

Spot & Stain Removers(1)

Towelettes(1)

Bathroom Tissue Dispensers(1)

Wall Racks(1)

Restroom Mats(1)

Foil & Wraps(1)

Hand Trucks & Dollies(1)

Pliers(1)

Janitorial Organizers(1)

Janitorial Carts(1)

 
Brand

Genuine Joe(845)

Genuine Joe Solutions(12)

 
Color

White(227)

Black(124)

Natural(75)

Blue(72)

Clear(69)

Brown(39)

Gray(37)

Green(36)

Yellow(26)

Orange(24)

Red(22)

Stainless Steel(19)

Silver(19)

Translucent(14)

Dark Blue(8)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Amber(4)

Purple(4)

Chocolate(4)

Dark Green(3)

Transparent(3)

Assorted(3)

Salt Pepper(2)

Gray Marble(2)

Green Tint(2)

Maroon(2)

Aqua Marine(2)

Black Marble(2)

Light Blue(2)

Charcoal Black(2)

Multi(2)

Turquoise(2)

Pink(2)

Champagne(1)

Gold(1)

Chrome(1)

Aqua(1)

Warm White(1)

Smoke(1)

Kraft(1)

Nickel(1)

Aluminum(1)

Bronze(1)

Oak(1)

Steel Gray(1)

Blue Frost(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(657)

Yes(100)

 
 
 

© 2018-2019 Browns Office Centre, All Rights Reserved