siddaramesh Posted January 30, 2015 Share Posted January 30, 2015 hi, i'm trying to get one product full details (product id, product name, reference code, all features, description and more ) from mysql database. i don't know which table include all these information, please send me the query for getting full details for each product... please help me it's very important for me... Link to comment Share on other sites More sharing options...
siddaramesh Posted January 30, 2015 Author Share Posted January 30, 2015 (edited) please replay me, i'm waiting for ur answers.... Edited January 30, 2015 by siddaramesh (see edit history) Link to comment Share on other sites More sharing options...
teralite Posted January 30, 2015 Share Posted January 30, 2015 All the info is in ps_product Link to comment Share on other sites More sharing options...
siddaramesh Posted January 30, 2015 Author Share Posted January 30, 2015 All the info is in ps_product product name and product feature's are not there in ps_product table... Link to comment Share on other sites More sharing options...
vekia Posted January 31, 2015 Share Posted January 31, 2015 hi, i'm trying to get one product full details (product id, product name, reference code, all features, description and more ) from mysql database. i don't know which table include all these information, please send me the query for getting full details for each product... please help me it's very important for me... ps_product table and each table with ps_product_ in name Link to comment Share on other sites More sharing options...
PascalVG Posted February 1, 2015 Share Posted February 1, 2015 I expect he also wants the names of the attributes, name of suppliers, etc, not only ID's, so you should also include the tables and needed fields that are linked to from within these ps_product_XX files... Nemo has an article that makes some start with this: http://nemops.com/prestashop-export-products/#.VM57RVWUc_M Not fully complete, but gives you a start... My 2 cents, pascal Link to comment Share on other sites More sharing options...
siddaramesh Posted February 2, 2015 Author Share Posted February 2, 2015 thanks for your replay's, yes i want the names of the supplier, attributes, names of the features and values..... any query is there for this.....? Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now