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_13` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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 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` 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 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

Manufacturer

Currently Filtered by

Manufacturer

Genuine Joe

Refine Search

  GO
Category

Mops & Mop Refills(118)

Trash Bags & Liners(64)

Cups & Mugs(56)

Indoor Mats(28)

Floor & Carpet Cleaner Accessories(26)

Brooms & Sweepers(23)

Cutlery(20)

Anti-Fatigue Mats(17)

Waste Containers & Accessories(16)

Paper Towels(16)

Cleaning Wipes(16)

Plates(15)

Urinal Screens & Deodorizers(15)

Hand Soaps/Cleaners(14)

Bathroom Tissues(13)

Hand Sanitizers(13)

Cups & Mugs Accessories(12)

Liquid Soap / Sanitizer Dispensers(12)

Multipurpose Cleaners(11)

Air Fresheners/Sanitizers(11)

Food Storage Bags/Wraps(10)

Spray Bottles(9)

Brushes & Dusters(9)

Glass Cleaners(8)

Table Covers/Skirts(7)

Sweeteners(7)

Dust Pans(7)

Poles & Handles(7)

Sprayer Parts & Accessories(5)

Dishwashing Detergents & Liquids(5)

Creamers(5)

Floor & Carpet Cleaners(4)

Cleaning Equipment Parts & Accessories(4)

Outdoor Mats(4)

Beverage Straws & Stir Sticks(4)

Smoking Receptacles(4)

Carafes & Airpots(4)

Paper Towel Dispensers(4)

Dust Mop Frames(4)

Duster Refills(4)

Bowls(4)

Paper Napkins(4)

Specialty Cleaners/Lubricants(3)

Recycling Bins(3)

Buckets(3)

Dispenser Accessories(3)

Toilet Seat Covers(2)

Cup Dispensers/Organizers(2)

Hairnets(2)

Fall Protection Equipments(2)

Safety/Caution Signs(2)

Board Cleaners & Wipes(2)

Breakroom Organizers(2)

Facial Tissues(2)

Furniture Polish(2)

Bathroom Cleaners(1)

Air Freshener/Sanitizers Dispensers(1)

Laundry Detergents(1)

Safety Gear(1)

Plungers(1)

Spot & Stain Removers(1)

Aprons(1)

Toilet Seats(1)

Bathroom Tissue Dispensers(1)

Toilet Bowl Cleaners(1)

Ladders & Step Stools(1)

Janitorial Organizers(1)

Wall Racks(1)

Tape Measures(1)

Tool Kits(1)

Hand Trucks & Dollies(1)

Skin Wipes(1)

Foil & Wraps(1)

Janitorial Cloths & Wipes(1)

Janitorial Carts(1)

Water Filters & Purifying Dispensers(1)

Reusable Towels(1)

Towelettes(1)

Sponges & Scouring Pads(1)

Brand

Genuine Joe(685)

Genuine Joe Solutions(8)

Color

White(181)

Black(101)

Clear(66)

Natural(62)

Blue(53)

Brown(32)

Green(30)

Orange(20)

Yellow(20)

Gray(19)

Red(18)

Silver(17)

Translucent(14)

Stainless Steel(11)

Assorted(10)

Charcoal(6)

Charcoal Gray(5)

Chocolate(4)

Purple(4)

Dark Green(3)

Transparent(3)

Amber(2)

Charcoal Black(2)

Dark Blue(2)

Maroon(2)

Black Marble(2)

Gray Marble(2)

Turquoise(2)

Green Tint(2)

Metallic(2)

Salt Pepper(2)

Pink(2)

Champagne(1)

Aqua Marine(1)

Aqua(1)

Chrome(1)

Nickel(1)

Kraft(1)

Aluminum(1)

Bronze(1)

Woodgrain(1)

Oak(1)

Multi(1)

Size

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

12" Wide(3)

24" Width x 5" Depth(3)

7.75" Length(2)

16" Wide(2)

5.50" Length(2)

18" Width x 25" Depth(2)

18" Width x 5" Depth(2)

5" Width x 36" Length(1)

24" Width x 25" Depth(1)

Recycled

No(532)

Yes(90)

Price Range

$0-$499.99(691)

$500-$999.99(2)

To  GO

 
 
Searching for your Best Results.....
 
HP Qualified Supplies Partner Salt Lake City Green CNG CleanAir Granite Office

© 2019-2020 Granite Office, LLC, All Rights Reserved