chrometweaks.org

What is the best free web iPage hosting service with FPE(front page) support ?

Click Here To View All Answers...


First question I have is What is the best free web iPage hosting service with FPE(front page) support ? Many thanks for any comment. My 2nd question... Hi.

I have over 1000 products on my iPage site and I want to delete about 200 of them. The problem I have is that they all have very similar product descriptions. Is there any way that I can have the Product code coming up as well as the product description..

I hope I have explained myself correctly. :?.

Thanks in Advance..

Alex..

Comments (48)

That's a good question. I'm not sure what is the answer to that question. I'll do some investigation and get back to you if I find an decent answer. You should email the people at iPage as they probably could assist you..

Comment #1

Hi Jim.

Thanks for your reply but I am not great with PHP and am only just leraning SQL, would you be able to tell me where I should call info from and where I should place it so that it displays it on the page..

Thanks.

Alex..

Comment #2

Linda McGrath has a contribution that will allow you to sort the products in admin by model number instead of description and so on and so forth. I do not remember the contributions name though...

Comment #3

In admin/categories.php starting at approx line 807 should be.

   $products_count = 0;.

   if (isset($HTTP_GET_VARS['search'])) {.

     $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and pd.products_name like '%"tep_db_input($search)"%' order by pd.products_name");.

   } else {.

     $products_query = tep_db_query("select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = '"(int)$current_category_id"' order by pd.products_name");.

   }.

Add p.product_model to the beginning of the list like so.

   $products_count = 0;.

   if (isset($HTTP_GET_VARS['search'])) {.

     $products_query = tep_db_query("select p.products_model, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, p2c.categories_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and pd.products_name like '%"tep_db_input($search)"%' order by pd.products_name");.

   } else {.

     $products_query = tep_db_query("select p.products_model, p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd, "TABLE_PRODUCTS_TO_CATEGORIES" p2c where p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' and p.products_id = p2c.products_id and p2c.categories_id = '"(int)$current_category_id"' order by pd.products_name");.

   }.

Then starting at approx. line 968 should be.

     default:.

       if ($rows > 0) {.

         if (isset($cInfo) && is_object($cInfo)) { // category info box contents.

           $heading[] = array('text' => '<b>'$cInfo->categories_name'</b>');.

           $contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&cID='$cInfo->categories_id'&action=edit_category')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&cID='$cInfo->categories_id'&action=delete_category')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a> <a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&cID='$cInfo->categories_id'&action=move_category')'">'tep_image_button('button_move.gif', IMAGE_MOVE)'</a>');.

           $contents[] = array('text' => '<br>'TEXT_DATE_ADDED' 'tep_date_short($cInfo->date_added));.

           if (tep_not_null($cInfo->last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED' 'tep_date_short($cInfo->last_modified));.

           $contents[] = array('text' => '<br>'tep_info_image($cInfo->categories_image, $cInfo->categories_name, HEADING_IMAGE_WIDTH, HEADING_IMAGE_HEIGHT)'<br>'$cInfo->categories_image);.

           $contents[] = array('text' => '<br>'TEXT_SUBCATEGORIES' '$cInfo->childs_count'<br>'TEXT_PRODUCTS' '$cInfo->products_count);.

         } elseif (isset($pInfo) && is_object($pInfo)) { // product info box contents.

           $heading[] = array('text' => '<b>'tep_get_products_name($pInfo->products_id, $languages_id)'</b>');.

           $contents[] = array('align' => 'center', 'text' => '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$pInfo->products_id'&action=new_product')'">'tep_image_button('button_edit.gif', IMAGE_EDIT)'</a> <a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$pInfo->products_id'&action=delete_product')'">'tep_image_button('button_delete.gif', IMAGE_DELETE)'</a> <a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$pInfo->products_id'&action=move_product')'">'tep_image_button('button_move.gif', IMAGE_MOVE)'</a> <a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$pInfo->products_id'&action=copy_to')'">'tep_image_button('button_copy_to.gif', IMAGE_COPY_TO)'</a>');.

           $contents[] = array('text' => '<br>'TEXT_PRODUCTS_MODEL' '$pInfo->products_model);.

           $contents[] = array('text' => '<br>'TEXT_DATE_ADDED' 'tep_date_short($pInfo->products_date_added));.

           if (tep_not_null($pInfo->products_last_modified)) $contents[] = array('text' => TEXT_LAST_MODIFIED' 'tep_date_short($pInfo->products_last_modified));.

           if (date('Y-m-d') < $pInfo->products_date_available) $contents[] = array('text' => TEXT_DATE_AVAILABLE' 'tep_date_short($pInfo->products_date_available));.

           $contents[] = array('text' => '<br>'tep_info_image($pInfo->products_image, $pInfo->products_name, SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT)'<br>'$pInfo->products_image);.

           $contents[] = array('text' => '<br>'TEXT_PRODUCTS_PRICE_INFO' '$currencies->format($pInfo->products_price)'<br>'TEXT_PRODUCTS_QUANTITY_INFO' '$pInfo->products_quantity);.

           $contents[] = array('text' => '<br>'TEXT_PRODUCTS_AVERAGE_RATING' 'number_format($pInfo->average_rating, 2)'%');.

         }.

Between lines 981 and 982 add.

           $contents[] = array('text' => '<br>'TEXT_PRODUCTS_MODEL' '$pInfo->products_model);.

And that should do it...

Comment #4

Hi Jim.

Thanks for taking the time to help me on this issue. I have changed the code as you said however this only brings up the products_model code on the individual product box on the right hand side. I was hoping I could get it so that I could have the products_models running down my list of products next to the products_description or instead of the products_description..

Thanks.

Alex..

Comment #5

If you want the product model to show up with the products description.

Go to admin side of store.

Admin>configuration>product listing and enable "display product model".

HTH.

The_Bear..

Comment #6

Hi Pierre.

I want it to show in the admin section not in the catalog section..

Thanks.

Alex..

Comment #7

Sorry about that, I misunderstood what you were looking for..

Still editing the admin/categories.php file:.

Starting at appox line 765, should be.

               <td class="dataTableHeadingContent"><?php echo TABLE_HEADING_CATEGORIES_PRODUCTS; ?></td>.

               <td class="dataTableHeadingContent" align="center"><?php echo TABLE_HEADING_STATUS; ?></td>.

Add the following line between those two.

               <td class="dataTableHeadingContent">&nbsp;</td>.

Starting at appox line 836, should be.

               <td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$products['products_id']'&action=new_product_preview&read=only')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$products['products_name']; ?></td>.

               <td class="dataTableContent" align="center">.

Add the following line between those two.

               <td class="dataTableContent"><?php echo '<a href="'tep_href_link(FILENAME_CATEGORIES, 'cPath='$cPath'&pID='$products['products_id']'&action=new_product_preview&read=only')'">'tep_image(DIR_WS_ICONS'preview.gif', ICON_PREVIEW)'</a>&nbsp;'$products['products_model']; ?></td>.

And that should do it...

Comment #8

Hi, I followed this and now have two preview columns , one before the description and one after. Any help would be great. A model # column in the admin would be really useful to me...

Comment #9

Hi.

I have over 1000 products on my iPage site and I want to delete about 200 of them. The problem I have is that they all have very similar product descriptions. Is there any way that I can have the Product code coming up as well as the product description..

I hope I have explained myself correctly. :?.

Thanks in Advance..

Alex..

Comment #10

You will need to edit the admin/categories.php file to include the products_model field...

Comment #11


This question was taken from a support group/message board and re-posted here so others can learn from it.