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)

Liquid Soap / Sanitizer Dispensers(19)

Waste Containers & Accessories(17)

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)

Floor & Carpet Cleaners(4)

Smoking Receptacles(4)

Breakroom Organizers(4)

Cup Dispensers/Organizers(4)

Paper Napkins(4)

Buckets(4)

Duster Refills(4)

Hairnets(4)

Safety/Caution Signs(3)

Trash Bags & Cans(3)

Recycling Bins(3)

Bathroom Cleaners(3)

Creamers(3)

Sponges & Scouring Pads(2)

Toilet Seat Covers(2)

Board Cleaners & Wipes(2)

Toilet Seats(2)

Safety Gear(2)

Air Freshener/Sanitizers Dispensers(2)

Ladders & Step Stools(2)

Aprons(2)

Plungers(2)

Skin Wipes(2)

Furniture Polish(2)

Restroom Mats(2)

Reusable Towels(2)

Tool Kits(2)

Facial Tissues(2)

Janitorial Cloths & Wipes(2)

Janitorial Carts(1)

Laundry Detergents(1)

Spot & Stain Removers(1)

Towelettes(1)

Wall Racks(1)

Toilet Bowl Cleaners(1)

Dispenser Accessories(1)

Foil & Wraps(1)

Gloves(1)

Hand Trucks & Dollies(1)

Beverage Dispensers/Coolers(1)

Tool Storage & Organization(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