Column Layout Grid for Product Listing

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! :)

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')');

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:-)

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:<br />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. :)

Hi mayleine:-)Thank you very very much for your answer:-)It is all working now:clap:I 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:-)

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

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:-)

attachment:-)

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?:-)

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.

I can understand u,even though i don't work at night,but i have 2 small kids so some night are sleepless for us :-)max value is 12,but as u can see from my pic, they are all shown in one column in the center...hm by the way why in the center of the page?:)

For all the other questions, i think it's just a matter of changing the values under the Configuration> Product Listing.

I don't want to deprive you that joy of finding the answer on your own. :) :D

thanks i will look around the settings:-)

Just looked in admin,everything looks fine there,I guess I have to edit stylesheet file.I have found code in css file,which relates to listing:
.productListing{
border:none;
border-top:1px dashed #21303c;
}
.productListing-odd{
margin-bottom:5px;
border:1px solid #EEE;
padding:3px 3px;
background:#F9FAFC;

}
.productListing-even{
margin-bottom:5px;
border:1px solid #EEE;
padding:3px 3px;
}
.productListing-rowheading{
height:25px;
background:#21303c;
color:#FFF;
font-weight:bold;

}

.productListing-heading{
vertical-align:middle;
}
.productListing-heading a,.productListing-heading a:link,.productListing-heading a:visited{
color:#FFF;

    text-decoration:none;

}
productListing-heading a:hover,.productListing-heading a:active{
color:#FFF;

    text-decoration:underline;

}

.specialsListBoxContents{
margin-top:15px;
font-size:12px;

    float:left;

}
.current{
font-weight:bold;
color:#FFF;
background:#21303c;

}

I just wanted to ask maybe anyone knows how can I make price look bold and my columns look fine,not just 1 column in the middle of the page(setting in admin:columns 3,products per page:12)...and where(which file can I find "Help
Product Image
ITEM DETAILS-
Price" from the header of the listing...

TIA

Sorry for so many uestions...how can I make all products,new products and on sale product listings look columlar as well?

Thanks:-)

I ran into the same issue and have gotten it cleared up some. with the debugging activated (enable_error_logging.php) found Division by 0 ....includes/classes/split_page_results.php on line 76

$this->number_of_pages = ceil($this->number_of_rows / $this->number_of_rows_per_page);

so this was in Configuration: Product Listing:
Product Listing - Layout Style columns
Product Listing - Columns Per Row 4

changed to
Product Listing - Columns Per Row 3

and it corrected the error and products showing again as they should. if I increase the per row to greater then 3 I get the SQL error.
still learning of the various options for display and not sure why can't have more then 3 columns, the images are large and 3 is ok for now till I get more comfortable with mod.

hope this helps someone else that sees the above
1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-0, 0' at line 7
in:

sql error.

fashions

bromleysid:

Hi Thank you.

Im trying to figure out how to remove the spaces between the price and title lookign for the <br>s, which file is it in?

i know i'm quoting a super old post, but i ran into this too and thought i would share my way around it. no idea if it's the best way to go, but it worked for me, and i did it all in css.

first i added a new line in my css-

.centerBoxContentsProducts br{
	display:none;
}

that got rid of all the brakes, but made the other bits in the class=centerBoxContentsProducts line up.
however, lucky for me, all of the fields in the center box have their own classes, so it was just a matter of making a second entry in my css file-

.normalprice,.productSalePrice,.etcetera{
	display:block;
}

and it all behaved how i wanted, no extra spaces between lines.

i'm pretty new to all of this though, there may very well be a better way to go around it. i just wanted a way to do it without going into the php.

see it in action here if you like-dellortodirect.com

kobra:

Add this entry to your stylesheet.css file and adjust as desired

.listingProductImage {
margin: 2em 0em 0em 0em;
}

Hi,
I'm happy about the way my images display on my column grid, but I've been trying to change the font size and color of the price to my h3 style. I can only change both the product model and the price, but not the price by itself.

Some help, please?

Hello,

I am having an odd problem. I installed the mod, and it works and shows great only and only if I have at least two products in a category. But, if I have only one product in a category, it shows as though I wouldn't have installed the mod, like if I were using the zencart default product listing.

Any ideas?

THanks

@ekon79 - Do you have a url where it can be seen.

Normally when you have only one product in a category, instead of the product showing as a listing in a category, you would normally go straight to that product page instead of the product listing page.