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_27` AS `crp` ON `crp`.`sku`=`pinfo`.`sku` 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` 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 WHERE ((`desc_short` like 'genuine joe' OR `desc_long` like 'genuine joe' OR `desc_title` like 'genuine joe' OR `keywords` like 'genuine joe' OR `category_1` like 'genuine joe' OR `category_2` like 'genuine joe' OR `category_3` like 'genuine joe' OR `category_4` like 'genuine joe' OR `manufacturer_name` like 'genuine joe' OR `color` like 'genuine joe') OR (MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('+(>genuine>genuines)+(>joe>joes)' IN BOOLEAN MODE) OR MATCH(`desc_short`, `desc_long`, `desc_title`, `keywords`, `category_1`, `category_2`, `category_3`, `category_4`, `manufacturer_name`, `color`) AGAINST('"genuine joe"' IN BOOLEAN MODE) OR (`pinfo`.`sku` like '%genuine joe%' OR `pinfo`.`sku` like '%genuinejoe%' OR (FIND_IN_SET('genuine joe', REPLACE(`keywords`,' ;', ',')) OR FIND_IN_SET('genuine joe', REPLACE(`keywords`,'; ', ',')) OR FIND_IN_SET('genuine joe', REPLACE(`keywords`,';', ',')) OR FIND_IN_SET('genuine joe', REPLACE(`keywords`,' ,', ',')) OR FIND_IN_SET('genuine joe', REPLACE(`keywords`,', ', ','))) ) OR (CASE WHEN `pinfo`.`vendor`=2 THEN `pinfo`.`desc_long` like 'genuine joe' ELSE `pinfo`.`desc_title` like 'genuine joe' END))) AND `pinfo`.`status` IN ('active','discontinued','out_of_stock') 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 `pinfo`.`sku` LIKE '%genuine joe' THEN 1 ELSE 0 END DESC, CASE WHEN MATCH(`desc_short`) AGAINST ('genuine +joe' IN BOOLEAN MODE) THEN 1 ELSE 0 END DESC, CASE WHEN `pinfo`.`vendor`=2 THEN IF(MATCH(`desc_long`, `manufacturer_name`, `color`) AGAINST ('+genuine +joe' IN BOOLEAN MODE),4,0) ELSE CASE WHEN MATCH (`keywords`) AGAINST ('"genuine joe"' IN BOOLEAN MODE) AND MATCH (`desc_title`) AGAINST ('"genuine joe"' IN BOOLEAN MODE) THEN 4 ELSE IF(MATCH (`desc_title`) AGAINST ('"genuine joe"' IN BOOLEAN MODE),3,IF(MATCH (`keywords`) AGAINST ('"genuine joe"' IN BOOLEAN MODE),2,IF(MATCH(`desc_title`, `manufacturer_name`, `color`) AGAINST ('+genuine +joe' IN BOOLEAN MODE),1,0))) END END DESC,CASE WHEN IF(`pinfo`.`vendor`=2,`category_3` ='joe',`category_4` ='joe') THEN 1 ELSE 0 END DESC, CASE WHEN `desc_short` LIKE 'joe,%' THEN 1 ELSE 0 END DESC, SUBSTR(`pinfo`.`desc_title`, 1, LOCATE('joe', `pinfo`.`desc_title`)) DESC

Currently Filtered by

Keyword

Genuine Joe

Refine Search

  GO
 
Category Filter

Mops & Mop Refills(126)

Trash Bags & Liners(79)

Cups & Mugs(64)

Waste Containers & Accessories(31)

Floor & Carpet Cleaner Accessories(31)

Plates(26)

Urinal Screens & Deodorizers(25)

Indoor Mats(25)

Cutlery(23)

Brooms & Sweepers(22)

Liquid Soap / Sanitizer Dispensers(20)

Paper Towels(19)

Anti-Fatigue Mats(19)

Hand Soaps/Cleaners(19)

Cleaning Wipes(17)

Brushes & Dusters(17)

Table Covers/Skirts(16)

Food Storage Bags/Wraps(16)

Multipurpose Cleaners(14)

Bathroom Tissues(14)

Poles & Handles(13)

Cups & Mugs Accessories(12)

Dust Pans(11)

Air Fresheners/Sanitizers(11)

Sweeteners(10)

Glass Cleaners(10)

Spray Bottles(9)

Dishwashing Detergents & Liquids(9)

Dust Mop Frames(8)

Beverage Straws & Stir Sticks(8)

Cleaning Equipment Parts & Accessories(8)

Sprayer Parts & Accessories(7)

Paper Towel Dispensers(7)

Hand Sanitizers(7)

Buckets(6)

Bowls(6)

Smoking Receptacles(5)

Safety/Caution Signs(5)

Deodorizers(5)

Duster Refills(4)

Paper Napkins(4)

Specialty Cleaners/Lubricants(4)

Carafes & Airpots(4)

Hairnets(4)

Outdoor Mats(4)

Sponges & Scouring Pads(3)

Facial Tissues(3)

Creamers(3)

Floor & Carpet Cleaners(3)

Bathroom Tissue Dispensers(3)

Recycling Bins(3)

Toilet Seats(2)

Safety Gear(2)

Plungers(2)

Fall Protection Equipments(2)

Toilet Bowl Cleaners(2)

Board Cleaners & Wipes(2)

Aprons(2)

Bathroom Cleaners(2)

Air Freshener/Sanitizers Dispensers(2)

Foil & Wraps(2)

Tool Kits(2)

Reusable Towels(2)

Toilet Seat Covers(2)

Furniture Polish(2)

Janitorial Cloths & Wipes(2)

Restroom Mats(1)

Spot & Stain Removers(1)

Janitorial Carts(1)

Liquid Soap/Hand Sanitizers Stands(1)

Squeegees/Scrapers(1)

Tape Measures(1)

Dispenser Accessories(1)

Tool Storage & Organization(1)

Wall Racks(1)

Skin Wipes(1)

Towelettes(1)

Water Filters & Purifying Dispensers(1)

Laundry Detergents(1)

 
Brand

Genuine Joe(857)

Genuine Joe Solutions(8)

 
Color

White(230)

Black(120)

Clear(78)

Blue(78)

Natural(67)

Gray(38)

Brown(33)

Green(31)

Yellow(30)

Orange(22)

Silver(21)

Red(18)

Stainless Steel(16)

Assorted(16)

Translucent(15)

Purple(8)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Amber(4)

Pink(4)

Chocolate(4)

Charcoal Black(3)

Transparent(3)

Aqua Marine(2)

Dark Blue(2)

Aluminum(2)

Black Marble(2)

Gray Marble(2)

Salt Pepper(2)

Turquoise(2)

Light Brown(2)

Multi(2)

Chrome(2)

Green Tint(2)

Blue Frost(1)

Nickel(1)

Kraft(1)

Granite(1)

Bronze(1)

Light Blue(1)

Oak(1)

Woodgrain(1)

Aqua(1)

Champagne(1)

Warm White(1)

 
Recycled

No(681)

Yes(89)

 
Height

0.4"(10)

30"(4)

24"(4)

29.2"(3)

2.5"(3)

13.5"(3)

29"(2)

15"(2)

48"(2)

34"(2)

3.8"(2)

14.5"(2)

6.8"(2)

14"(2)

7.3"(2)

37.4"(2)

10.5"(2)

21"(2)

4.6"(2)

38"(2)

8.2"(2)

32"(2)

4.5"(2)

3.4"(1)

5.5"(1)

4.3"(1)

40"(1)

31.5"(1)

50"(1)

3.3"(1)

1.8"(1)

6"(1)

35"(1)

12"(1)

19.9"(1)

5.9"(1)

8.5"(1)

10.4"(1)

57.5"(1)

10.3"(1)

44.5"(1)

36"(1)

15.5"(1)

33"(1)

10.9"(1)

 
Depth

2.8"(6)

11"(4)

4.3"(3)

15.4"(2)

10.5"(2)

11.5"(2)

14"(2)

4.1"(2)

24"(2)

5.5"(1)

1.6"(1)

13"(1)

10"(1)

15.2"(1)

12.3"(1)

10.3"(1)

27.3"(1)

20.5"(1)

4"(1)

3"(1)

 
Size

12" Wide(6)

48" Width x 5" Depth(4)

7.75" Length(4)

24" Width x 5" Depth(3)

36" Width x 5" Depth(3)

18" Width x 25" Depth(2)

18" Width x 5" Depth(2)

5.50" Length(2)

16" Wide(2)

24" Width x 25" Depth(1)

5" Width x 36" Length(1)

4" Width x 4" Length(1)

 
Diameter

7"(4)

14.8"(3)

17.5"(2)

18"(2)

3"(1)

1"(1)

20"(1)

16.5"(1)

13"(1)

 
 
 

© 2020-2021 Hi Tech Office Products, All Rights Reserved