Where are prices stored in the DB? I thought I had located it but didn't.

[markputt]

Hello all.

 

I'm using prestashop 1.6.

 

All the prices for my products are basically the same.  Right now they are $5.00.  I want to change all these prices to $3.00.

So, I used MySQL Workbench and I went into the MySQL database to change these prices.   I thought I had found the proper location in the DB.  I thought it was the ps_product table.  I changed the prices there but it had no affect on the prices when I went back and looked at them in the Dashboard or online.   Are the prices also stored in another location?

 

Any help at all would be appreciated.

 

 

Thanks

Mark.

[tdr170]

ps_product

ps_product_shop

 

 

These 2 locations have product prices.

[markputt]

Thank you very much for the responses.