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

Trash Bags & Liners(64)

Cups & Mugs(53)

Indoor Mats(26)

Floor & Carpet Cleaner Accessories(26)

Cutlery(23)

Plates & Bowls(22)

Brooms & Sweepers(22)

Cleaning Wipes(21)

Urinal Screens & Deodorizers(20)

Liquid Soap / Sanitizer Dispensers(19)

Waste Containers & Accessories(19)

Multipurpose Cleaners(17)

Anti-Fatigue Mats(17)

Hand Soaps/Cleaners(16)

Paper Towels(15)

Poles & Handles(14)

Table Covers/Skirts(14)

Bathroom Tissues(12)

Cups & Mugs Accessories(12)

Carafes & Airpots(11)

Cleaning Equipment Parts & Accessories(11)

Hand Sanitizers(10)

Air Fresheners/Sanitizers(10)

Spray Bottles(9)

Food Storage Bags/Wraps(9)

Dust Pans(9)

Sweeteners(8)

Brushes & Dusters(8)

Dust Mop Frames(6)

Paper Towel Dispensers(6)

Sprayer Parts & Accessories(6)

Glass Cleaners(6)

Outdoor Mats(6)

Beverage Straws & Stir Sticks(5)

Cup Dispensers/Organizers(4)

Breakroom Organizers(4)

Smoking Receptacles(4)

Hairnets(4)

Paper Napkins(4)

Dishwashing Detergents & Liquids(4)

Duster Refills(4)

Specialty Cleaners/Lubricants(4)

Buckets(4)

Recycling Bins(3)

Creamers(3)

Safety/Caution Signs(3)

Floor & Carpet Cleaners(3)

Sponges & Scouring Pads(2)

Board Cleaners & Wipes(2)

Ladders & Step Stools(2)

Plungers(2)

Air Freshener/Sanitizers Dispensers(2)

Aprons(2)

Safety Gear(2)

Toilet Seats(2)

Restroom Mats(2)

Bathroom Cleaners(2)

Reusable Towels(2)

Janitorial Cloths & Wipes(2)

Tool Kits(2)

Facial Tissues(2)

Skin Wipes(2)

Furniture Polish(2)

Toilet Seat Covers(2)

Trash Bags & Cans(1)

Wall Racks(1)

Tool Storage & Organization(1)

Hand Trucks & Dollies(1)

Towelettes(1)

Laundry Detergents(1)

Janitorial Carts(1)

Beverage Dispensers/Coolers(1)

Foil & Wraps(1)

Dispenser Accessories(1)

Storage Boxes & Containers(1)

Gloves(1)

Brand

Genuine Joe(766)

Genuine Joe Solutions(7)

Color

White(218)

Black(113)

Natural(70)

Clear(64)

Blue(61)

Gray(36)

Brown(34)

Green(33)

Orange(21)

Stainless Steel(19)

Red(18)

Yellow(17)

Silver(16)

Translucent(14)

Charcoal(6)

Charcoal Gray(5)

Metallic(4)

Chocolate(4)

Transparent(3)

Assorted(3)

Dark Green(3)

Maroon(2)

Salt Pepper(2)

Green Tint(2)

Black Marble(2)

Gray Marble(2)

Gold(2)

Charcoal Black(2)

Turquoise(2)

Multi(2)

Pink(2)

Oak(1)

Smoke(1)

Champagne(1)

Chrome(1)

Aqua(1)

Bronze(1)

Kraft(1)

Blue Frost(1)

Steel Gray(1)

Nickel(1)

Warm White(1)

Stainless Steel Finish(1)

Aluminum(1)

Size

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

7.75" Length(3)

24" Width x 5" Depth(3)

5.50" Length(2)

23" Length x 5.75" Diameter(2)

16" Wide(2)

18" Width x 5" Depth(2)

12" Wide(2)

18" Width x 25" Depth(2)

24" Width x 25" Depth(1)

50" Length x 32" Width(1)

13.25" Height - 18.50" Width - Stool(1)

13" Height - Stool(1)

5" Width x 36" Length(1)

Recycled

No(510)

Yes(57)

Price Range

$0-$499.99(776)

$500-$999.99(3)

$1000-$1499.99(2)

To  GO

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

© 2017-2018 Granite Office, LLC, All Rights Reserved