product prices not showing on product page

**Dumb_Question** · 03-05-2006, 01:15 PM

ok...looks like i fixed it for the time being...i uploaded the backup file...and that worked.....looks like the price is not showing because of the quantity pricebreak mod that the programmer installed...

I guess for the time being i would have to live without quantity pricebreak...

**bkpie** · 03-06-2006, 05:53 PM

Dumb_question

Could you upload your backup product_info.tpl template (the one that is working) so I can do a compare with winmerge to see where mine is messing up? Thanks

**Dumb_Question** · 03-06-2006, 06:32 PM

I checked it with beyond compare.......
it is the coded added by "Kerul" that is messing it up...just do a search for "Kerul" in the previous post ...you should find it at two places..this is the code that he added for "separet pricing "..mod

**met00** · 03-06-2006, 10:11 PM

here is the offending code, right?

Code:

/Added by Kerul
if&#40;isset&#40;$customer_group_id&#41;&#41;&#123;
  $scustomer_group_price_query = tep_db_query&#40;"select customers_group_price from " . TABLE_PRODUCTS_GROUPS . " where products_id = '" . &#40;int&#41;$HTTP_GET_VARS&#91;'products_id'&#93;. "' and customers_group_id = '" . $customer_group_id . "'"&#41;;
  if &#40;$scustomer_group_price = tep_db_fetch_array&#40;$scustomer_group_price_query&#41;&#41; &#123;
    $products_price = $scustomer_group_price&#91;'customers_group_price'&#93;;
  &#125;
&#125;
else&#123;

$pf->loadProduct&#40;&#40;int&#41;$HTTP_GET_VARS&#91;'products_id'&#93;, &#40;int&#41;$languages_id&#41;;
$products_price=$pf->getPriceString&#40;&#41;;
&#125;

//End by Kerul

okay, let's see what he is going...
1a) if there is a customer group the
2a) query the database and get the group price for the product
3a) if there was a record returned, replace the price with the price from that record
1b) else
2b) use a non-existant class (to this point I don't see where "pf -> loadproduct" may live) to overwrite the price
1c) end if

Then, just after that he comments out everything that has to do with pricing, from special to seperate price per customer.

A simple fix that should allow you to keep the code you have in place would be to remove the 2b code and then move the 1c to a point AFTER the end of his commented out code and then uncomment the code he commented out.

This would run his mod and then, if not his mod, would run the old code for setting price. This would clean up the code removing the class function that he inserted to replace the code that did function.

Now, since I don't know the mod, or what it does, it may be redundant with some of the code that is commented out and there may be some small portion of the Seperate Price Per Customer that may need to be commented out, but the portion on setting the price from the default method should be kept (and not replaced with some class->function call that may not work).

Good luck.

**spottedhaggis** · 03-24-2006, 01:45 PM

ok so I have renamed the fallback template folder and uploaded the stock OSCMAX v2 one again, stil have the same problem, and as I have not modified the shop files in any way at all I have to assume my problem is in the database.

I added a product and this item also shows the exact same issue, so surely this has to be the database? Right?

**spottedhaggis** · 03-24-2006, 04:21 PM

Looks like my issue was somewhere inside the configuration table, no idea where. I created a new database, ran the standard mysql script for OSCMAX inside the new DB, rana compare on the old OSC and new created db, did the changes, and copied accross a select few tables from the OSC to the OSCMAX.

Address_book
Categories
Categories_description
Customers
Customer_info
ORders
Orders_products
Orders Total
Products
Products_description
Products_options
Product_options_values
Product_options_values_to_Products_options
Products_stock
Products_to_categories
Zones (I have uk counties in zones)

I then went to the shop and found I had errors regards the cache so I copied the cache folder accross, solved that issue

Now everything is in the new db, customers come up no errors, products no errors, everything is nearly perfect

My prices display in the shop as they should be, however I have a $ instead of a £

I have cereated the uk currency and set it to default but it remains dollars

IF I edit the USD one to UK I lose the prices.

lol, anyone know where I am missing something here, prices ok but in Dollars and needs to be pounds.