Jump to content



Photo
- - - - -

how to display specials price


This topic has been archived. This means that you cannot reply to this topic.
8 replies to this topic

#1   justinswa

justinswa
  • Members
  • 100 posts

Posted 22 February 2012 - 00:15

Hello,

OSC 2.2Rc2a

I can set up specials discounts in admin and the reduced price shows in red with the original price scored out when you look you look at the product details in product_info.php. Great. However, if you look at the product summary anywhere else - within its category or withing the specials category, only the original and not the reduced price shows. Anybody with any ideas how I can display the special price here as well?

Thanks

#2   justinswa

justinswa
  • Members
  • 100 posts

Posted 22 February 2012 - 16:28

worth a bump.... Does anybody else have this problem or is it only me?

#3   justinswa

justinswa
  • Members
  • 100 posts

Posted 23 February 2012 - 08:31

Just me here I guess. Hello.....hello.....hello. Very echoy.

#4   mhsuffolk

mhsuffolk
  • Members
  • 154 posts

Posted 23 February 2012 - 11:26

I think it is only you as my RC2a store shows the reduced prices with the original scored out in every location that the products price appears, tables specials screen etc

Sorry but I have no answer to your problem

Martin
OsC 2.3.3.4 PHP 5.4.21 MySQL 5.1.73-cll Apache 2.2.25

#5   justinswa

justinswa
  • Members
  • 100 posts

Posted 23 February 2012 - 18:38

I think it is only you as my RC2a store shows the reduced prices with the original scored out in every location that the products price appears, tables specials screen etc

Sorry but I have no answer to your problem

Martin


Thank you for confirming my suspicions. I have a feeling that this may have gone wrong when I changed everything to make the site php 5.3 compatible. Just have to try and find out why which will be a bit more complicated.....

#6   mhsuffolk

mhsuffolk
  • Members
  • 154 posts

Posted 23 February 2012 - 19:02

Your problem could be here in

catalog/includes/functions/general.php

Find

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status");

Replace with

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status = 1");

This is listed in the update document as a Bug

Martin
OsC 2.3.3.4 PHP 5.4.21 MySQL 5.1.73-cll Apache 2.2.25

#7   justinswa

justinswa
  • Members
  • 100 posts

Posted 23 February 2012 - 21:31

Your problem could be here in

catalog/includes/functions/general.php

Find


$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status");

Replace with

$product_query = tep_db_query("select specials_new_products_price from " . TABLE_SPECIALS . "
where products_id = '" . (int)$product_id . "' and status = 1");

This is listed in the update document as a Bug

Martin


Thanks, that was worth a try but didn't work. Could you tell me where you saw the bug reported please?

#8   mhsuffolk

mhsuffolk
  • Members
  • 154 posts

Posted 23 February 2012 - 21:54

It is in the upgrade guide from 2.2 to 2.3.0

This can be found in the complete download for 2.3.1 here

http://www.oscommerc...ions/oscommerce
OsC 2.3.3.4 PHP 5.4.21 MySQL 5.1.73-cll Apache 2.2.25

#9   justinswa

justinswa
  • Members
  • 100 posts

Posted 24 February 2012 - 22:10

Martin, thanks for your help. Have now resolved this. I had an addon that caused the problem. There are so many addons and hacks to this installation that there's hardly any original code left. I always try and annotate my hack so I can remind myself what I have done but the addons are not always well commented...