Jump to content

how to get one product full details in mysql


siddaramesh

Recommended Posts

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

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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...