Jump to content

Help I screwed up the prices interferring with the Database


Recommended Posts

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 by Andrew Watson (see edit history)
Link to comment
Share on other sites

×
×
  • Create New...