chrometweaks.org

Anyone who might tell me which web hosting service is better, iPage or Surpass Hosting?

Click Here To View All Answers...


My 1st question is: Anyone who might tell me which web hosting service is better, iPage or Surpass Hosting? Thanks in advance for any answer or 2. Another question on my mind: Hi Every one,.

I would like to display the price as follow.

Rather than the standard price listing like.

Original price cross out and next to that the sale price..

I think I found the code that display the the sales price. Some one please help me to display the way I want???? Please.

<?php.

} else {.

  $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

  $product_info = tep_db_fetch_array($product_info_query);.

  tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

  if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

    $products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

  } else {.

    $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

  }.

  if (tep_not_null($product_info['products_model'])) {.

    $products_name = $product_info['products_name']'<br><span class="smallText">['$product_info['products_model']']</span>';.

  } else {.

    $products_name = $product_info['products_name'];.

  }.

?>..

Comments (78)

I would like to know the answer too. Anyone here know what is the right answer. I'll do some poking around and get back to you if I got an anything. You should email the people at iPage as they probably know..

Comment #1

Funny you mention the "special price" not working with EZ. I just started working on coding that contrib last night. Completely re-writing it (again) to work with "specials" and "customer discount" contrib. Trying to rewrite customer discount contrib to take the extra discount off the special price..

Should be ready in about 3 days from now. If I didn't have this other darned job (12 hour shifts...), I could work on it all the time....

It doesn't create a whole new pricing system, just displays prices and savings and creates a new mysql entry for you to store this new number. Are you looking to pull them from somewhere else?.

Is there ne thing else ne one wants to see go into it?.

Noel..

Comment #2

Hey Noel,.

Well, I am just curious, why are you trying to create a whole new table when the information already present to you???.

All I want to do is just seprate the listed price and speical price thatz all.

I am not trying to do anything fancy!!! thanks..

Comment #3

Try this and see if it's what you are wanting, this is almost the same exact way that I have my prices listed..

Find:.

Replace with:..

Comment #4

IC, you are talking about using the specials area..

EZ is for a whole new field, you can then input what the going rate is, then your price. Completely separate from the specials price, that isn't even taken into account. I don't want to have everything in the store on special and have the list price be my normal price. For the above to work, you need to have the product on special..

Is that what you were asking in the first place, I misunderstood due to lack on information...

Comment #5

HELLO jmoore04,.

Wow! it's worked perfect!!! thanks a MILLION......................

Comment #6

So did we ever get a fix so that EZier fields works with specials? I just used the built-in 'Specials' feature for the first time and I see on my main page, it shows the Special prices and my former price as $000.00 lol..

Comment #7

Hi Every one,.

I would like to display the price as follow.

Rather than the standard price listing like.

Original price cross out and next to that the sale price..

I think I found the code that display the the sales price. Some one please help me to display the way I want???? Please.

<?php.

} else {.

  $product_info_query = tep_db_query("select p.products_id, pd.products_name, pd.products_description, p.products_model, p.products_quantity, p.products_image, pd.products_url, p.products_price, p.products_tax_class_id, p.products_date_added, p.products_date_available, p.manufacturers_id from "TABLE_PRODUCTS" p, "TABLE_PRODUCTS_DESCRIPTION" pd where p.products_status = '1' and p.products_id = '"(int)$HTTP_GET_VARS['products_id']"' and pd.products_id = p.products_id and pd.language_id = '"(int)$languages_id"'");.

  $product_info = tep_db_fetch_array($product_info_query);.

  tep_db_query("update "TABLE_PRODUCTS_DESCRIPTION" set products_viewed = products_viewed+1 where products_id = '"(int)$HTTP_GET_VARS['products_id']"' and language_id = '"(int)$languages_id"'");.

  if ($new_price = tep_get_products_special_price($product_info['products_id'])) {.

    $products_price = '<s>'$currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']))'</s> <span class="productSpecialPrice">'$currencies->display_price($new_price, tep_get_tax_rate($product_info['products_tax_class_id']))'</span>';.

  } else {.

    $products_price = $currencies->display_price($product_info['products_price'], tep_get_tax_rate($product_info['products_tax_class_id']));.

  }.

  if (tep_not_null($product_info['products_model'])) {.

    $products_name = $product_info['products_name']'<br><span class="smallText">['$product_info['products_model']']</span>';.

  } else {.

    $products_name = $product_info['products_name'];.

  }.

?>..

Comment #8

HI fl70,.

I already tried the "EZ New Fields" module. This module do not work with the existing "special" Module. This module create a whole new pricing system, Which I don't want..

All I want is take the existing price system and display the regular price.

And the discount price!.

Thanks..

Comment #9


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