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

Duster & Mops Refills(121)

Bags(91)

Cups & Mugs(66)

Household Cleaners(62)

Mats(54)

Tissues & Napkins(51)

Brooms & Brushes(45)

Kitchenware(36)

Cleaning Pads(33)

Wastebaskets & Trash Cans(32)

Soaps & Sanitizers(27)

Urinal Screens/Deodorizers(24)

Kitchen Utensils(23)

Soap Dispensers(20)

Poles & Handles(17)

Lids(16)

Furniture Covers & Sheets(16)

Air Fresheners & Sanitizers(15)

Cleaning Equipment Parts & Components(11)

Tissue & Napkin Dispensers(10)

Dust Pans(10)

Sweeteners(10)

Sprayer Parts & Components(10)

Vacuum Flasks(9)

Mops(9)

Broom & Mop Frames(8)

Straws & Stir Sticks(8)

Safety Gears(6)

Racks & Organizers(6)

Miscellaneous Devices(6)

Sprayers(5)

Buckets(5)

Sign & Name Plates(5)

Dispenser Accessories(4)

Creamers(4)

Aprons(2)

Plungers(2)

Holders(2)

Sponges & Absorbents(2)

Board Erasers & Correctors(2)

Air Freshener Dispensers(2)

Gloves(2)

Packing Wraps & Insulations(2)

Carts & Trolleys(2)

Toilet Seat Covers(2)

Miscellaneous Kits(2)

Water & Beverage Dispensers(1)

Rulers & Tape Measures(1)

Tools(1)

Tool Kits(1)

Faceplates & Mounting Boxes(1)

 
Brand

Genuine Joe(890)

Genuine Joe Solutions(12)

 
Color

White(230)

Black(133)

Clear(78)

Blue(77)

Natural(72)

Brown(41)

Gray(38)

Green(34)

Yellow(30)

Orange(23)

Silver(22)

Red(19)

Stainless Steel(19)

Assorted(16)

Translucent(15)

Purple(8)

Charcoal(6)

Metallic(5)

Charcoal Gray(5)

Chocolate(4)

Maroon(4)

Amber(4)

Dark Blue(4)

Transparent(3)

Charcoal Black(3)

Black Marble(2)

Aluminum(2)

Aqua Marine(2)

Gray Marble(2)

Salt Pepper(2)

Green Tint(2)

Chrome(2)

Pink(2)

Multi(2)

Light Brown(2)

Turquoise(2)

Blue Frost(1)

Light Blue(1)

Champagne(1)

Aqua(1)

Oak(1)

Woodgrain(1)

Warm White(1)

Bronze(1)

Granite(1)

Kraft(1)

Nickel(1)

Steel Gray(1)

 
Recycled

No(704)

Yes(93)

 
Height

0.4"(10)

30"(4)

24"(4)

29.2"(3)

2.5"(3)

13.5"(3)

12"(3)

37.4"(2)

7.3"(2)

29"(2)

3.8"(2)

48"(2)

14"(2)

6.5"(2)

4.3"(2)

15"(2)

14.5"(2)

6.8"(2)

34"(2)

10.5"(2)

21"(2)

4.6"(2)

38"(2)

8.2"(2)

32"(2)

4.5"(2)

3.3"(1)

3.4"(1)

5.5"(1)

50"(1)

40"(1)

1.8"(1)

35"(1)

31.5"(1)

6"(1)

11.5"(1)

19.9"(1)

5.9"(1)

8.5"(1)

10.4"(1)

36"(1)

15.5"(1)

33"(1)

10.9"(1)

 
Depth

2.8"(6)

11"(4)

4.3"(3)

10.5"(2)

11.5"(2)

14"(2)

4.1"(2)

24"(2)

15.4"(2)

4.5"(2)

15.2"(1)

5.5"(1)

1.6"(1)

13"(1)

10"(1)

10.3"(1)

12.6"(1)

12.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)

 
Flavor

Hazelnut(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