Display Products Only when they have image(s)

Hi,

I am interested in implementing a solution to display the product only if there is an image assigned on it and also there is a value in the weight field.
Can you identify the files from the front end that the list of products is build and that we can add the check

Thanks in advance

Hi Nicolas,

Thanks for the guidance.
I have implemented this with the option of creating a new plugin and using the onBeforeProductListingLoad(&$filters) method.
I have added the new query on the filter $filters[] = 'b.product_weight > 0';

I have tested this and it works. The problem is that it also works in the backend
Can the plugin be restricted to perform this in the front end only?

Thanks

Hi Nikolas,

Thanks for the help once again. It worked
Now regarding the image/no image part which seems a bit more complicated. As explained I want to use the same restriction when the product does not have an image assigned to it (do not show the product, same as weight).

Browsing on the database I can see that images are stored in the "hikashop_file" table with filetype = "product". In addition "file_ref_id" points to the products table. I am guessing I need to do an Inner Join either:
a. In the plugin: Is it possible to return somehow an Inner Join and not only extra condition (Probably not)

b. Somewhere in the view.html.php: Can you suggest the places and maybe the correct way
I am thinking of introducing a new variable "c" in addition to "a" and "b" but I have some difficulties identifiying all the places I need to fill it in

Thanks

Thanks Nikolas,

This worked!