aee156 Posted September 24, 2014 Share Posted September 24, 2014 Hello, I used SQL to raise my prices of one supplier by 30%. In the sql I see the wholesale and retail is correct, but the changes are not being updated on the website for some reason?? I also did a sql command to update a supplier and in the sql I see the changes but they will not reflect on the website. Is there some sort of update or recompile that needs to be done? I am using 1.6 version. Link to comment Share on other sites More sharing options...
Dh42 Posted September 24, 2014 Share Posted September 24, 2014 Are you using a caching module? Also are you working on the right table? The prices are not really in the ps_product table, they are in the ps_product_shop table. Link to comment Share on other sites More sharing options...
vekia Posted September 24, 2014 Share Posted September 24, 2014 it's worth to note that if your products have got special prices, change you made will not affect these products (with special prices) Link to comment Share on other sites More sharing options...
aee156 Posted September 24, 2014 Author Share Posted September 24, 2014 Thanks! That totally makes sense, however, I have another problem now, Im using this query, UPDATE `ps_product_shop` SET price = price * 1.40 WHERE id_supplier = 2; but now there is no table for the supplier in the ps_product_shop table. Do you know what the query would be to increase my prices for just supplier id 2? Link to comment Share on other sites More sharing options...
Recommended Posts