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

Trash Bags & Liners(64)

Cups & Mugs(60)

Floor & Carpet Cleaner Accessories(30)

Indoor Mats(26)

Urinal Screens & Deodorizers(25)

Plates & Bowls(24)

Cleaning Wipes(23)

Cutlery(23)

Brooms & Sweepers(22)

Liquid Soap / Sanitizer Dispensers(21)

Multipurpose Cleaners(19)

Hand Soaps/Cleaners(19)

Waste Containers & Accessories(19)

Anti-Fatigue Mats(17)

Paper Towels(17)

Bathroom Tissues(15)

Poles & Handles(15)

Table Covers/Skirts(14)

Hand Sanitizers(13)

Air Fresheners/Sanitizers(13)

Cups & Mugs Accessories(12)

Brushes & Dusters(12)

Food Storage Bags/Wraps(10)

Glass Cleaners(10)

Sweeteners(10)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Carafes & Airpots(9)

Dust Pans(9)

Cleaning Equipment Parts & Accessories(8)

Paper Towel Dispensers(7)

Sprayer Parts & Accessories(7)

Floor & Carpet Cleaners(6)

Creamers(6)

Beverage Straws & Stir Sticks(6)

Outdoor Mats(6)

Dust Mop Frames(6)

Safety/Caution Signs(5)

Gloves(5)

Buckets(4)

Smoking Receptacles(4)

Hairnets(4)

Duster Refills(4)

Cup Dispensers/Organizers(4)

Breakroom Organizers(4)

Paper Napkins(4)

Specialty Cleaners/Lubricants(3)

Dispenser Accessories(3)

Skin Wipes(3)

Board Cleaners & Wipes(2)

Sponges & Scouring Pads(2)

Janitorial Cloths & Wipes(2)

Recycling Bins(2)

Safety Gear(2)

Toilet Seats(2)

Toilet Bowl Cleaners(2)

Bathroom Cleaners(2)

Plungers(2)

Furniture Polish(2)

Toilet Seat Covers(2)

Facial Tissues(2)

Air Freshener/Sanitizers Dispensers(2)

Water Filters & Purifying Dispensers(2)

Aprons(2)

Reusable Towels(2)

Laundry Detergents(1)

Spot & Stain Removers(1)

Bathroom Tissue Dispensers(1)

Tool Kits(1)

Hand Trucks & Dollies(1)

Foil & Wraps(1)

Ladders & Step Stools(1)

Janitorial Carts(1)

Pliers(1)

Janitorial Organizers(1)

Beverage Dispensers/Coolers(1)

Towelettes(1)

Wall Racks(1)

Restroom Mats(1)

Brand

Genuine Joe(834)

Genuine Joe Solutions(12)

Color

White(229)

Black(121)

Natural(73)

Blue(72)

Clear(68)

Brown(39)

Green(37)

Gray(30)

Yellow(27)

Orange(24)

Red(21)

Stainless Steel(18)

Silver(17)

Translucent(14)

Charcoal(6)

Purple(6)

Dark Blue(6)

Metallic(5)

Charcoal Gray(5)

Chocolate(4)

Amber(4)

Dark Green(3)

Assorted(3)

Transparent(3)

Maroon(2)

Black Marble(2)

Multi(2)

Aqua Marine(2)

Green Tint(2)

Pink(2)

Gray Marble(2)

Charcoal Black(2)

Salt Pepper(2)

Turquoise(2)

Warm White(1)

Champagne(1)

Blue Frost(1)

Steel Gray(1)

Aqua(1)

Chrome(1)

Bronze(1)

Aluminum(1)

Kraft(1)

Oak(1)

Smoke(1)

Woodgrain(1)

Nickel(1)

Size

7.75" Length(4)

48" Width x 5" Depth(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

16" Wide(2)

5.50" Length(2)

18" Width x 5" Depth(2)

12" Wide(2)

18" Width x 25" Depth(2)

5" Width x 36" Length(1)

24" Width x 25" Depth(1)

Recycled

No(652)

Yes(101)

Price Range

$0-$499.99(845)

$500-$999.99(3)

$1000-$1499.99(2)

$3500-$3999.99(1)

$4000-$4499.99(1)

To  GO

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

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