Column Layout for Product Listing Page

My site is http://outdoorsinteriors.com. I don't want to install the column grid layout mod as I do not want anything changed in my database running sql or changes to my admin. I'd like to modify the files manually to get a column layout of 3 or 4 columns by 5 or 6 rows. Similar to how "New Products" displays on the main page. If anyone could include detail instructions on the files I would need to change. Thank you for all your help.

OI

The column grid layout mod is rather straight forward to install. You shouldn't run into any problems.

You only need to add the sql that comes with the module....
Make a backup first as this is always advised

You are adding to the DB anytime a new product is added, a new customer signs up, a new order is placed...

Let me ask this......If I use both the .PHP files as my default loaded into my template folders can you tell me how I could "force" the PRODUCT_LISTING_LAYOUT_STYLE == 'columns' to always be set at "columns"?

Then I would not even need to run the SQL.

Thanks OI

You can look at the if case in the module files that look for the admin setting toggle and adjust as needed But a lot of work to avoid a simple sql add

Thanks Kobra I appreciate your reply. Basically there are two files 1. tpl_modules_product_listing.php and 2. product_listing.php.

In the tpl_modules_product_listing.php there is this line of code below. My thought is if I can just put a variable in somewhere at the top to always force PRODUCT_LISTING_LAYOUT_STYLE to always equal "columns" then I would only need to enter that in this one file and that should carry over to the product_listing.php. Do you know the code I would need to enter to force this?

Thanks OI

Do you have something against installing the sql file?
I have been using this mod for a while and once you set it up once you forget about it. You can adjust how many columns to display in the admin. To set the columns all you have to do is adjust the count of product to display in the box for example if you want to have 4 columns and 4 rows that adds up to 16 products, so you will need to set the maximum number of products in the box to 16.

Thanks for responding back.....yes I have one database that I use and don't want to take any chances on breaking my production site or making any changes to the admin. I'd just like to find a way to force the variable as I mentioned in previous post. I do have another copy of my store running for testing purposes only, but uses my same production database. I don't want to create anohter DB due to restrictions from my host.

I really appreciate your help.....

Thanks again

OI

OutdoorsInteriors:

I don't want to create anohter DB due to restrictions from my host.
I would say it was time to seek another host that provides tools to support your online business!!!
OutdoorsInteriors:

I have one database that I use and don't want to take any chances on breaking my production site or making any changes to the admin
As I previously posted, there are changes being made on a continuing basis
KoBra:

Make a backup first as this is always advised

You are adding to the DB anytime a new product is added, a new customer signs up, a new order is placed...

No time right now to seek another host, but would just like to know what changes I would have to make to get column layout but not using the mod.

Thanks All

OI

No time right now to seek another host, but would just like to know what changes I would have to make to get column layout but not using the mod.
I posted the file(s) that you would need to change.
I do not have the time to validate the exact code alterations that would be required for something that will not benefit the community at large.