alexk345 Posted June 27, 2015 Share Posted June 27, 2015 hi I see these two tables. I want to know which one is used by prestashop?. I changed price in product_attribute_shop ...price changed in front end. Then what is the use of product_attribute table? Link to comment Share on other sites More sharing options...
Dh42 Posted June 27, 2015 Share Posted June 27, 2015 One is a generic one for the products, the other one is specifically keyed to different shops in a multi shop setup. Link to comment Share on other sites More sharing options...
alexk345 Posted June 27, 2015 Author Share Posted June 27, 2015 cool. Thanks. But multishop is disabled Front end uses product_attribute_shop table for price Link to comment Share on other sites More sharing options...
bellini13 Posted June 27, 2015 Share Posted June 27, 2015 cool. Thanks. But multishop is disabled Front end uses product_attribute_shop table for price Yes, that is correct. Prestashop has moved to using this table, do you have a more specific question? Link to comment Share on other sites More sharing options...
alexk345 Posted June 27, 2015 Author Share Posted June 27, 2015 Reason for asking i am creating my own import code for importing from CSV i want to know which table i have to import the data. I am going through all the tables and saw both these tables have smilar row but one(ps_product_attribute_shop) has less columns. Thats is all Link to comment Share on other sites More sharing options...
bellini13 Posted June 28, 2015 Share Posted June 28, 2015 Data that exists across multiple stores in multi-store would be in the _shop tables. Link to comment Share on other sites More sharing options...
alexk345 Posted June 28, 2015 Author Share Posted June 28, 2015 I figured out. Both needed. One is used for showing front end controls. Shop is used for price. Link to comment Share on other sites More sharing options...
Recommended Posts