Get list of all product in home page without module

[vahidafshari]

Hi Dears

I want to show list of all my product (just name linked to product page & product image) in my home page without any modules. Can i use classic SQL query to show that? or there is a better way to show.

I using prestashop 1.5

[vekia]

without module it will be hard to achieve what you want. Almost impossible. there are two possibilities:

1) own module

2) modification of homefeatured module

[vahidafshari]

I don't know why but homefeatured module dos'nt work for me.How can i modification this one?

[vekia]

you need to attach all products to "home" category, then increase number of displayed products in module configuration page

[vahidafshari]

i've done it but still dosen't work

[vekia]

you use default theme? have you changed something in the core? or in module files?

[vahidafshari]

I'm using leometro theme.I back to defult theme but problem still there

Edited September 16, 2013 by vahidafshari (see edit history)

[vekia]

what you see in front office? yo usee "no products" message or something?

[vahidafshari]

  On 9/16/2013 at 9:44 AM, vekia said:

what you see in front office? yo usee "no products" message or something?

Yes, "no product" message (of course in persian lang!)

[vahidafshari]

any solution?

[vekia]

unfortunately, in this case is hard to say whats going on there.

are you able to edit the module .php file? 

if so, try to change category and also use var_dump in the variable with fetched products from database

the problem is probably with core, or with cache (have you tried to clear cache?)