chrometweaks.org

iPage Hosting account problem involving FTP?

Click Here To View All Answers...


Quick question: iPage Hosting account problem involving FTP? Hoping for any response. Another question I got... Hay,.

When you make a new product it comes in de default as a new product, that's normal BUT can you manipulate this so a older product stays there and the new one is only to see in de Categories and not in the default page???.

Grt Bugs..

Comments (108)

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

Comment #1

Thanks for the tip,.

I think that this is the part than must be chants, I have trite it but it will not work!.

I think this piece must be deferent....

= '1' order by p.products_date_added desc limit " ..

Can you help me farther....

Sorry if my English is not so good!!!.

Grt. Bugs.

If ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {.

$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_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);..

Comment #2

Here is one example this is order by product id note that the only change is to the part after order by and remember that there are two instances of this in the file one controls the specials and the other the products not on special..

I used a modified version of this code to fix items in place and alsoused a modified version of each of the featured products contributions to fix specific items.

If ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {.

$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);..

Comment #3

I have tried it out but is do not what I want. I have now put them for now as products for next month..

You can se it on.

Http://www.lichtmark...kel/default.php.

I don't want them in the 3 items on the page!..

Comment #4

Only the problem is now you can not order them.....

Comment #5

What do you want as maybe the best course for you is to remove the new products box and install a featured products contribution, but without knowing exactly what it is that you want I can only guess as to what a resolve would be, also I gave but one example of manipulation of that bit of code there are many ways to skin a cat...

Comment #6

Hello Steve,.

When you have 3 products display on de index page (in the center of the page) as last inserted products and than make a new one in the admin then one of the 3 products disappear and the new one is displayed, that is what I want to chance. When it is a product white or whiteout a picture... I don't want that on the index page but only in the categories..

I hope that what I have written clear is?.

Thanks grt Arie..

Comment #7

This would require a rewrite of the code to include an if else statement to check whether or not an image is available for the product and if no image then do not show else show..

I think you may be better with a contribution for featured products, this allows you to choose the exact product from the categories of your choice to be displayed and for how long they are to be displayed..

An example but modified can be seen here where the upper products are featured and chosen.

Click..

Comment #8

I will look at this in a short time! Thanks for all the help!.

Grt. Arie..

Comment #9

I know this is a little off track but you seem to know about featured products - I am trying to get my featured products (MODULES_NEW_PRODUCTS) to display random specials instead. Any ideas where I can find how to do this? I have modified the code to show specials as I want them but I need it to be randomised and the tep_random function only allows for one product...any help would be most appreciated. contributions doesnt seem to hold the answer...

Comment #10

Hay,.

When you make a new product it comes in de default as a new product, that's normal BUT can you manipulate this so a older product stays there and the new one is only to see in de Categories and not in the default page???.

Grt Bugs..

Comment #11

Yes well sort of you can manipulate what is shown or you could install one of the contributions for featured products..

Look at the sort order by date part of the code in catalog/includes/modules/new_products.php this part of the code can be changed to show other methods than date by such as product_id name manufacturer category random ascending descending etc...

Comment #12


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