marcellinho Posted February 13, 2013 Share Posted February 13, 2013 Hi, I couldn´t find what´s the difference between ps_product and ps_product_shop in MySQL database and where are they used. When I´m creating new products or importing them via import, all of them are written to both tables or how is it working exactly? Thanks for help. Mck Link to comment Share on other sites More sharing options...
vekia Posted February 13, 2013 Share Posted February 13, 2013 if you've got multistore feature turned to on, and if you've got many shops based on one engine you can define shop for which product belongs. if you've got two shops, id_shop defines shop for which product belongs 1 Link to comment Share on other sites More sharing options...
marcellinho Posted February 16, 2013 Author Share Posted February 16, 2013 Thanks a lot, I´ve got it now! Link to comment Share on other sites More sharing options...
wanegain Posted October 15, 2013 Share Posted October 15, 2013 Thanks for the info. However I wonder why prices (price, unity, wholesale_price, etc.) appear in both ps_product_shop and ps_product tables ? They seem to have exactly the same values if I have a unique shop. If I make changes to one product page on the admin, it seems to affect both of these tables. Why isn't there only one field for the price ? I need to make massive changes to my products : I want to change all the prices without taxes, and reduce them all because I applied the wrong tax in the first place. I saw that if I just set a different tax in the admin it just recalculates the price with taxes. However, in my case, the final price is right and it's the price without taxes that needs to be changes. Since I did not find an automatic way to specify it and do it on the admin, I decided I'd write a php script to directly change it on the database. But when I looked at it I completely misunderstood which fields exactly I should change. In both tables ? In one table ? In many other tables ? Is there either : - a module out there (free ?) that allows me to do that maybe ? - or a graph/scheme/document that shows exactly where each field in the product page is related to which field(s) in the database ? THANKS A LOT Link to comment Share on other sites More sharing options...
vekia Posted October 15, 2013 Share Posted October 15, 2013 Thanks for the info. However I wonder why prices (price, unity, wholesale_price, etc.) appear in both ps_product_shop and ps_product tables ? They seem to have exactly the same values if I have a unique shop. If I make changes to one product page on the admin, it seems to affect both of these tables. Why isn't there only one field for the price ? it's because you can define different prices in different shops, this is why if you have got only one shop (it mean that you don't use multistore) it will affect two tables. 1 Link to comment Share on other sites More sharing options...
wanegain Posted October 15, 2013 Share Posted October 15, 2013 thanks for your answer. can you confirm there is no way to update the tax rate and specify that it's the price without tax that needs to be updated, instead of the price with tax ? Link to comment Share on other sites More sharing options...
Recommended Posts