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)

Cleaning Wipes(22)

Plates & Bowls(22)

Brooms & Sweepers(22)

Urinal Screens & Deodorizers(20)

Multipurpose Cleaners(20)

Waste Containers & Accessories(19)

Liquid Soap / Sanitizer Dispensers(19)

Anti-Fatigue Mats(17)

Hand Soaps/Cleaners(16)

Air Fresheners/Sanitizers(15)

Paper Towels(15)

Glass Cleaners(14)

Table Covers/Skirts(14)

Poles & Handles(14)

Bathroom Tissues(13)

Cups & Mugs Accessories(12)

Carafes & Airpots(11)

Cleaning Equipment Parts & Accessories(11)

Hand Sanitizers(10)

Food Storage Bags/Wraps(10)

Spray Bottles(9)

Brushes & Dusters(9)

Dust Pans(9)

Sweeteners(8)

Dishwashing Detergents & Liquids(7)

Outdoor Mats(6)

Dust Mop Frames(6)

Paper Towel Dispensers(6)

Sprayer Parts & Accessories(6)

Beverage Straws & Stir Sticks(5)

Specialty Cleaners/Lubricants(5)

Breakroom Organizers(4)

Smoking Receptacles(4)

Floor & Carpet Cleaners(4)

Cup Dispensers/Organizers(4)

Paper Napkins(4)

Buckets(4)

Duster Refills(4)

Hairnets(4)

Safety/Caution Signs(3)

Recycling Bins(3)

Creamers(3)

Bathroom Cleaners(3)

Sponges & Scouring Pads(2)

Furniture Polish(2)

Toilet Seats(2)

Toilet Seat Covers(2)

Plungers(2)

Air Freshener/Sanitizers Dispensers(2)

Ladders & Step Stools(2)

Aprons(2)

Skin Wipes(2)

Safety Gear(2)

Board Cleaners & Wipes(2)

Facial Tissues(2)

Restroom Mats(2)

Reusable Towels(2)

Tool Kits(2)

Janitorial Cloths & Wipes(2)

Laundry Detergents(1)

Trash Bags & Cans(1)

Janitorial Carts(1)

Towelettes(1)

Spot & Stain Removers(1)

Toilet Bowl Cleaners(1)

Beverage Dispensers/Coolers(1)

Gloves(1)

Foil & Wraps(1)

Hand Trucks & Dollies(1)

Tool Storage & Organization(1)

Wall Racks(1)

Dispenser Accessories(1)

Storage Boxes & Containers(1)

Brand

Genuine Joe(792)

Genuine Joe Solutions(9)

Color

White(227)

Black(113)

Natural(70)

Blue(69)

Clear(66)

Gray(36)

Green(34)

Brown(34)

Yellow(23)

Orange(21)

Stainless Steel(19)

Red(18)

Silver(16)

Translucent(14)

Charcoal(6)

Charcoal Gray(5)

Chocolate(4)

Metallic(4)

Assorted(3)

Transparent(3)

Dark Green(3)

Salt Pepper(2)

Gold(2)

Gray Marble(2)

Black Marble(2)

Pink(2)

Maroon(2)

Dark Blue(2)

Multi(2)

Green Tint(2)

Amber(2)

Charcoal Black(2)

Turquoise(2)

Aqua(1)

Aqua Marine(1)

Smoke(1)

Purple(1)

Champagne(1)

Steel Gray(1)

Stainless Steel Finish(1)

Warm White(1)

Chrome(1)

Kraft(1)

Blue Frost(1)

Bronze(1)

Aluminum(1)

Nickel(1)

Oak(1)

Size

48" Width x 5" Depth(4)

36" Width x 5" Depth(3)

7.75" Length(3)

24" Width x 5" Depth(3)

23" Length x 5.75" Diameter(2)

16" Wide(2)

5.50" Length(2)

12" Wide(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(57)

Price Range

$0-$499.99(800)

$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