Questions and Need Help

[ryanfc]

I am almost done with adding osCommerce to a current clients site but have a few questions. The client really wants this cart to be simple and the main reason I am moving to oscommerce is to simplify adding products to the database and simplyfing the user end on purchasing a product. So here is what I am looking for help on.

 

First I want to get rid of the right column. I have already moved the boxes I want from that side to the left side, but I want that whole column gone and to have the center column with the products to span to where the current right column ends. Everytime I try and just delete the right column the center column content disappears also when i load the page into a browser. So what lines do I need to delete to get rid of the right column.

 

Second I want all products listed on the home page, but I want each product Category to have its own box. I want it to look much like it does when you select a category from the top right box, but I want the description added below the Product name. The product descriptions will never be that long so I am not worried about that.

 

 

Hopefully this all makes sense and someone can help me with the changes I am trying to make. Thank you for your help.

[ryanfc]

Sorry forgot to attach link for site.

 

http://www.storytellin.com/catalog

 

Also I did figure out how to remove right column. So I just need help with showing all products on the home page.

[ryanfc]

I found this contribution http://www.oscommerce.com/community/contri...ow+all+products

 

but I don't want users to have to click on anything. I just want the home page to list all products with each category in its own box or a big orange cell in between each category which has a text header saying what category it is now. Hopefully this all make sense. Thank you for any help I receive.

[ryanfc]

So can anyone help me with this?

[jasonabc]

To remove the right column you have to remove this piece of code from all of the files in the root directory. A search and replace will make light work of this:

 

<td width="<?php echo BOX_WIDTH; ?>" valign="top"><table border="0" width="<?php echo BOX_WIDTH; ?>" cellspacing="0" cellpadding="2">

<!-- right_navigation //-->

<?php require(DIR_WS_INCLUDES . 'column_right.php'); ?>

<!-- right_navigation_eof //-->

</table></td>

[bill110]

Try this for all the products

http://www.oscommerce.com/community/contributions,4770

You will need to hack for descriptions.

There is a contribution for descriptions in product listing.

I think this is it

http://www.oscommerce.com/community/contri...ct+descriptions

It will need to hacked into the other code

[ryanfc]

I am very close to having what I want for this page. I took that mod you linked me and changed the table to appear the way I want (thank you very much). It still needs a few changes such as size and stuff to make it look good, but here is the main problem I have. I really want it to put each category in its own box or at least group them together with items in the same category with a place I can put a fairly large header. You can see what the current store looks like here with the items in categories http://storytellin.com/storytellingresources.php. I really need to do it this way as I need the DVD's on top with the Fantasy, Fairytales DVD to be the first thing you see. So I want it to organize the tables on the home page in the same order I have put the items in the left Category box. Can anyone help me alter the code to do this. Thank you.

 

 

 

<?php
/*
 $Id: our_products.php,v 1.0 2006/12/28 18:49:58 hpdl Exp $

 osCommerce, Open Source E-Commerce Solutions
 [url="http://www.oscommerce.com"]http://www.oscommerce.com[/url]
 coded by Bill110 
 Copyright © 2006 osCommerce

 Released under the GNU General Public License
*/
?>
<!-- our_products //-->
<?php
 $info_box_contents = array();
 $info_box_contents[] = array('text' => TABLE_HEADING_OUR_PRODUCTS);

 new infoBoxHeading($info_box_contents, false, false) ;

     $new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id  where products_status = '1' order by p.products_id desc limit " . MAX_DISPLAY_NEW_PRODUCTS);

 $info_box_contents = array();

  while ($new_products = tep_db_fetch_array($new_products_query)) {
   $new_products['products_name'] = tep_get_products_name($new_products['products_id']);
$sql = 'SELECT `products_description` FROM `products_description` WHERE products_id ='.$new_products['products_id'].' && language_id='.(int)$languages_id;
$description_query = tep_db_query($sql);
$description = mysql_fetch_array($description_query, MYSQL_ASSOC);        
$description['products_description'] = substr($description['products_description'], 0, 1000);


$description['products_description'] = ereg_replace("(Array)", "", $description['products_description']);


   $info_box_contents[] = array('align' => 'center',
                                          'params' => 'class="smallText" width="33%" valign="top"',
                                          'text' => '<table width="100%" border="0">
 <tr>
   <td width="100" rowspan="2" align="left" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a></td>
   <td width="100%" height="20" align="left" valign="top" class="ourProducts">'. $new_products['products_name'] . '</td>
   <td width="40" rowspan="2" align="center" valign="middle" class="smallText">' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '<br>
   <br>' . '</td>
   <td width="80" rowspan="2" align="center" valign="middle" class="smallText">' . '<a href="' . tep_href_link(FILENAME_DEFAULT, tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $new_products['products_id']) . '">' . tep_image_button('button_buy_now.gif', IMAGE_BUTTON_IN_CART) . '</a></td>
 </tr>
 <tr>
   <td width="100%" align="left" valign="top" class="smallText">' . strip_tags($description['products_description']) .'</td>
 </tr>
</table>
</td></tr><tr>');


 }

 new contentBox($info_box_contents);
?>
<!-- our_products_eof //-->

[ryanfc]

sorry to bump this up but I am under deadline and could really use some help. thank you.