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)

Liquid Soap / Sanitizer Dispensers(21)

Multipurpose Cleaners(21)

Urinal Screens & Deodorizers(20)

Waste Containers & Accessories(19)

Hand Soaps/Cleaners(18)

Anti-Fatigue Mats(17)

Paper Towels(16)

Air Fresheners/Sanitizers(15)

Poles & Handles(15)

Table Covers/Skirts(14)

Bathroom Tissues(13)

Hand Sanitizers(13)

Brushes & Dusters(12)

Cleaning Equipment Parts & Accessories(12)

Cups & Mugs Accessories(11)

Dust Pans(11)

Glass Cleaners(11)

Food Storage Bags/Wraps(10)

Sweeteners(10)

Carafes & Airpots(10)

Dishwashing Detergents & Liquids(9)

Spray Bottles(9)

Gloves(9)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Outdoor Mats(6)

Creamers(6)

Floor & Carpet Cleaners(6)

Dust Mop Frames(6)

Beverage Straws & Stir Sticks(5)

Buckets(5)

Duster Refills(4)

Paper Napkins(4)

Hairnets(4)

Smoking Receptacles(4)

Safety/Caution Signs(4)

Cup Dispensers/Organizers(4)

Breakroom Organizers(4)

Tool Kits(3)

Specialty Cleaners/Lubricants(3)

Bathroom Cleaners(3)

Recycling Bins(3)

Dispenser Accessories(3)

Janitorial Cloths & Wipes(2)

Board Cleaners & Wipes(2)

Safety Gear(2)

Toilet Seats(2)

Sponges & Scouring Pads(2)

Restroom Mats(2)

Skin Wipes(2)

Plungers(2)

Furniture Polish(2)

Toilet Seat Covers(2)

Ladders & Step Stools(2)

Facial Tissues(2)

Toilet Bowl Cleaners(2)

Aprons(2)

Reusable Towels(2)

Laundry Detergents(1)

Bathroom Tissue Dispensers(1)

Spot & Stain Removers(1)

Air Freshener/Sanitizers Dispensers(1)

Hand Trucks & Dollies(1)

Foil & Wraps(1)

Storage Boxes & Containers(1)

Janitorial Carts(1)

Pliers(1)

Tool Storage & Organization(1)

Beverage Dispensers/Coolers(1)

Towelettes(1)

Wall Racks(1)

Water Filters & Purifying Dispensers(1)

 
Brand

Genuine Joe(850)

Genuine Joe Solutions(11)

 
Color

White(231)

Black(125)

Natural(75)

Blue(73)

Clear(68)

Brown(39)

Green(37)

Gray(37)

Yellow(26)

Orange(24)

Red(23)

Silver(19)

Stainless Steel(19)

Translucent(14)

Dark Blue(8)

Charcoal(6)

Charcoal Gray(5)

Metallic(5)

Purple(4)

Chocolate(4)

Amber(4)

Transparent(3)

Assorted(3)

Dark Green(3)

Salt Pepper(2)

Gray Marble(2)

Maroon(2)

Aqua Marine(2)

Green Tint(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(661)

Yes(100)

 
 
 

© 2018-2019 Browns Office Centre, All Rights Reserved