chrometweaks.org

What is the best free personal iPage web hosting service?

Click Here To View All Answers...


Got a question... What is the best free personal iPage web hosting service? Thanks for any comment. Another quick question... Is there a way to setup the display order of the products in the store?..

Comments (8)

Good question... I dunno what is the answer to that question. I'll do some Googling and get back to you if I find an useful answer. You should email the people at iPage as they probably know..

Comment #1

Dax,.

Nope. Sorry. Haven't come across a contrib to do that..

Ed..

Comment #2

We have the same problem in our store and once I get more accustomed with that I'm going to write a mod to fix it..

One thing you can try is setting the dates of the items entered further back in time to the ones you want to display on that front page...

Comment #3

@dax, I wanted to do somethign a little different from you and that was to choose if I wanted to display or not to display items on the new products page..

I added a new field to the products table, a 1 digit char field where I put N for no if I didnt want it displayed..

If you open this file \catalog\includes\modules\new_products.php.

On line 21 is the following line.

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

At the end of the two "$new_products_query = " statements I added my field and select contrainst (and p.products_dspInFront <> 'N' ) before the Order By bit..

"....and p.products_dspInFront <> 'N' order by p.products_date_added desc limit "MAX_DISPLAY_NEW_PRODUCTS);".

My guess is that you can insert your own sort field instead and use a new ORDER BY command to disaply the records as you wish..

Hope that helps...

Comment #4

I think I found it, but now what.......

Okay.. I found the contribution for sorting products and installed it fine like I said..

Now for the products_new.php page.... This is the part where is lists and sorts the products....

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,p.products_sort_order, m.manufacturers_name from "TABLE_PRODUCTS" p left join "TABLE_MANUFACTURERS" m on (p.manufacturers_id = m.manufacturers_id), "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '"(int)$languages_id"' order by p.products_date_added DESC, pd.products_name";.

If I edit this line......

$products_new_query_raw = "select p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id,p.products_sort_order, m.manufacturers_name from " ..

And.

Order by p.products_date_added DESC, pd.products_name.

To look at the sort column that is in the same products table.

Order by p.products_sort_order DESC";.

Then you would think it would sort by my sort order right?.

Well.. it doesn't.

Anyone have any grains of wisdom?.

Thanks.

Dax..

Comment #5

Okay.. so maybe I am clueless here...

I mean I thought that products_new was the page that was appearing in the center of the index page and calling the items in that center box..

I guess I was wrong. because,.

Products_new.php.

And.

The default homepage.

Are different..

So infact.. it does work the way I modified it..

NOWWWWW... to find the code for the images on the index page.....

Sorry if I seem link I am ranting..

Dax..

Comment #6

I FOUND IT!!!!.

Was looking for products_new.php when I should have been looking for new_products.php.

Changed them both and now it works like a charm..

Hope that helps the next person and keeps them from pulling their hair out too!!!.

Changed line.

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_sort_order asc.

Limit "MAX_DISPLAY_NEW_PRODUCTS);.

} else {.

$new_products_query = tep_db_query("select distinct 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, "TABLE_PRODUCTS_TO_CATEGORIES" p2c, "TABLE_CATEGORIES" c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '"(int)$new_products_category_id"' and p.products_status = '1'.

Order by p.products_sory_order asc.

Limit "MAX_DISPLAY_NEW_PRODUCTS);..

Comment #7

Sorry daxcastro but isn't that exactly what I told you to look for??..

Comment #8

Probably...but since I am not a php person, I am sure I just misunderstood. I am really more of a graphic designer you can stumle through code than an actual person who can program or write php. LOL..

Thanks for your help nontheless..

Dax..

Comment #9


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