Updated Prices In Database But Not Reflecting On Site

[ocpistol]

I updated prices on a few thousand products through the database but on the site it is still listing all the previous prices.

I have tried clearing cache, resetting server, and modifying a product. None of these have had it show the price from the database.

 

I updated the prices in field ps_product.

 

anyone have any ideas?

[gabdara]

If you use combinations, prices are defined in ps_product_attribute and the product will use first the price of the default combination.

[Kaprylo]

I don't have combinations and I can't change the prices it just does't let me.

Also I can't even update my order status to shipped etc.

this started after 1 jan,

[ocpistol]

I checked and those tables are empty in  ps_product_attribute. But I was looking through the tables and found ps_product_shop has information filled in for all of my products. I am not using multishop is there a way to disable this?

Edited January 4, 2016 by ocpistol (see edit history)

[gabdara]

To disable multishop see BO > Preferences > General > Enable Multistore.

[vekia]

 

 

I updated prices on a few thousand products through the database

 

what tables you modified?

[ocpistol]

I modified ps_product.

 

I have it disabled in there but it is still using the price off that other table.

[coradyne]

I have the same problem. After I updated the prices of some of my products, some were updated correctly and some weren't. In ps_product all the prices were updated correctly, but in ps_product_shop some weren't. And the site displays the prices from ps_product_shop instead of the ones in ps_product, although I too have disabled multistore.