Help I screwed up the prices interferring with the Database

[Andrew Watson]

I recently built an online school uniform shop for my parents.

 

I put in about 80 products with a bunch of atribute (a toatal of 500 all up) before I notice the currency was wrong.

 

I found when I changed the currency all my prices changed. So I looked on this forum and follewd a suggestion form a forum member to update the prices through mysql.

 

I did something like:

UPDATE  fph_product_attribute set price =price*1.28292849811840

 

but I din't know I had to also update:   fph_product_attribute_shop (or it might have been the other way around).

 

Anyway. I got the prices right for the school uniforms as you can see here:

http://www.distributorsdirect.co.nz

 

Find your way to a product and it appears correctly. The price is right.

 

But here is my problem: When you click an item and then go to the item description and look at the price, the correct price flashes quickly correct and then changes to an incorrect price.

 

If you add the item to the checkout, then it appears correct in the checkout.

 

I think I need to copy the fph_product_attribute_shop "price" directly over to the ph_product_attribute "price"  something like that. Help would be appreciated.

Edited December 29, 2014 by Andrew Watson (see edit history)

[Andrew Watson]

It's ok. I fixed it.

 

It turns out that the price that the product changed to was the USD price. So once I discovered that I just made New Zealand dollars my default and turned off USD and all my pricing was correct. So I'll just leave this here in case that helps.