codepage.net Posted January 5, 2013 Share Posted January 5, 2013 Hi all! we are importing products and information, mainly with csv. now we need to change the price on some productgroups and want to do that directly in the database. but the "price" fields in ps_products do not seem to have any effect on the prices that are shown. i tried it aso on a new, manually entered product: Price excluding VAT: 800 800 is being stored in ps_products.price change ps_products.price to 850 Price in the product on the web stays on 800 so, there must be an additional place. i think we looked thru all tables, cleared caches etc and cant figure it out... thx for helping Beat Link to comment Share on other sites More sharing options...
codepage.net Posted January 5, 2013 Author Share Posted January 5, 2013 (edited) geeee. After entering exotic value in the frontend then exporting the database and searching the value, we figured it out. the second table is: ps_product_shop how we could overlook THAT, i dunno... Edited January 5, 2013 by codepage.net (see edit history) Link to comment Share on other sites More sharing options...
Recommended Posts