Column Layout Grid for Product Listing

[mayleine]

hi Ms_X. i got it resolved!! this is how i did it. are you comfortable working on phpmyadmin?

1) i went to phpmyadmin
2) click your zen cart database
3) select the 'zen_configuration' table
4) go to the last page of that table
5) look for the entry that says "Product Listing - Layout Style"
6) on the last column of that entry, you will see something gibberish
7) remove what's in there and change it with

zen_cfg_select_option(array('rows','columns'),


hope that helps! worked for me! :)

[mayleine]

ok, if that is hard to follow, this is the easier way to do it.
use this first command instead of the one from the file we downloaded. it's almost the same as the original, THE ONLY DIFFERENCE is that i changed the DOUBLE QUOTES TO SINGLE QUOTES for the rows and columns. the reason for the gibberish entry was because of that DOUBLE QUOTES.


INSERT INTO configuration (configuration_title, configuration_key, configuration_value,
configuration_description, configuration_group_id, sort_order,
last_modified, date_added, use_function, set_function)
VALUES ('Product Listing - Layout Style', 'PRODUCT_LISTING_LAYOUT_STYLE', 'rows',
'Select the layout style:<br />Each product can be listed in its own row (rows option)
or products can be listed in multiple columns per row (columns option)', '8', '40', NULL,
now(), NULL, 'zen_cfg_select_option(array('rows', 'columns')');

[Ms_X]

Hi mayleine, thanks a lot for your answer:-)I am happy to hear it worked for you. I have tried what you said using phpadmin but the result is still same. In adminof zencart I have all the same as before,just insted of previous text with <br> I have:
zen_cfg_select_option(array('rows','columns')

I have changed two fields in phpadmin:configuration_description and set_function, as you suggested I put there "zen_cfg_select_option(array('rows','columns')"

It is still not working :-(I don't know what would be wrong there though. If you have any suggestions, I will be very thankful:-)And thanks again for writing me about your solution:-)

[mayleine]

Hi Ms_X,

It's not working because the only entry you have to change is the set_function column. no need to change the entry under the configuration_description column. i don't think i said that. if you can get the entry on the configuration_description back to its original entry, good. the replacement entry on the set_function column is:

zen_cfg_select_option(array('rows','columns'),

i notice you left the comma at the end. that comma is very important for the sql command to work. otherwise, it really won't work, that's why you see that on your admin.


PS: in case you don't have a copy of the original entry on the configuration_description column: i checked my phpadmin and here's mine. i can only wish it's the same for both of us.

Select the layout style:&lt;br /&gt;Each product can be listed in its own row (rows option) or products can be listed in multiple columns per row (columns option)

I have another solution if this won't work and that means running the delete command in the file that we downloaded and starting from the very beginning. Instead of using the first entry with the double quotes, change it with the code that I sent.

here's my site and I am now working to get the featured products show like this grid. :)

[Ms_X]

Hi mayleine:-)Thank you very very much for your answer:-)It is all working nowI do not know what would I do without your help:-)
Your website looks very nice to me, I like it,it is good when people do what they enjoy doing:-)All the best with the shop:-) I will try to customise the look of the listing now, like 4 columns by 4 rows:-)

[mayleine]

Yehey, it worked for you!!! Glad to help!!

[Ms_X]

And already I have got some questions:-) How do u make your listing to show 3 columns and 3 rows? 3 columns setting I have found,but for the rows...How can I show the price under the name of the product? ANd the last thing is: on the attachment u can see strange words on top :"Help " and "Product image"...Where can I get rid of these two?...thanks again:-)

[Ms_X]

attachment:-)

[Ms_X]

If I set in Product listing-->Display Product Price/Add to Cart 1 then I see price and Buy now...But I don't want to see buy now...how can I not display it?:-)

[mayleine]

i can probably just answer 1 question right now since i'm already very sleepy coming from a night job, hehe :)

how to set the number of rows? it would depend on the maximum number of products you want to show per page.
Configuration> Maximum Values > Products Listing- Number Per Page

So if you set that value to 9, you'll get 3 rows and 3 columns.