alejandroprestashop123 Posted November 25, 2012 Share Posted November 25, 2012 Where can i find the product name and description in Prestashop database with Mysql select? Im creating my own product list and i need make this with mysql_query. I can find stock,product_id,reference,price,..... but i cant find the product name and product description. Anybody knows where can i find this values? At now my select is... $result = mysql_query("SELECT prod.id_product,prod.reference,prodstock.quantity FROM ps_product prod, ps_stock_available prodstock WHERE prod.id_product=prodstock.id_product"); Anybody can help me?? Link to comment Share on other sites More sharing options...
vekia Posted November 25, 2012 Share Posted November 25, 2012 here's the prestashop database schema: http://www.daveegert...-prestashop.png you can check how "products" are stored in database my tip: you can find it out in language tables 1 1 Link to comment Share on other sites More sharing options...
alejandroprestashop123 Posted November 25, 2012 Author Share Posted November 25, 2012 Thank you so much Vekia!! 1 Link to comment Share on other sites More sharing options...
vekia Posted November 25, 2012 Share Posted November 25, 2012 I mark this topic as solved, if you've got any other questions feel free to write or create new topic Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 hello, I just activate some languages. Any help for updating by mysql all the description_long and short in the default language to all other products in other languages ( us, de, it,...)? Link to comment Share on other sites More sharing options...
vekia Posted June 12, 2013 Share Posted June 12, 2013 But your site may be banned by Google for duplicated content, it isn't good for seo, believe me Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 well, that's mean that french customer can have a full description of a product and images but not customers from other countries... seems strange ? Link to comment Share on other sites More sharing options...
vekia Posted June 12, 2013 Share Posted June 12, 2013 but you can use the same content (in the same language) for other languages? Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 i do because of the title of the products and images are the same. check here : http://goo.gl/VSD6x Google explains that " you should follow the guidelines on rel-alternate-hreflang to make sure that the correct language or regional URL is served to searchers " http://support.google.com/webmasters/bin/answer.py?hl=en&answer=182192 Link to comment Share on other sites More sharing options...
vekia Posted June 12, 2013 Share Posted June 12, 2013 in my opinion is better to translate descriptions to the correct language. Pictures can be the same, but content not Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 if there a way to use rel="alternate" hreflang="x" with PS 1.5 to do as google want ? and by the way do you have a MYSQL request to solve my problem ? Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 the best way and simple is here : http://support.google.com/webmasters/bin/answer.py?hl=en&answer=2620865 just create a new sitemap and submit it ^^ Link to comment Share on other sites More sharing options...
shaka Posted June 12, 2013 Share Posted June 12, 2013 May be this with a LEFT OUTER JOIN ? SELECT ps_product_lang.name AS nom_produit, ps_product_lang.description_short AS description_courte_produit, ps_product_lang.description AS description_produit FROM ps_product_lang, ps_lang WHERE id_product = ".$id_produit." AND ps_product_lang.id_lang = ps_lang.id_lang AND iso_code = '".$_SESSION['langue']."' Link to comment Share on other sites More sharing options...
shaka Posted June 18, 2013 Share Posted June 18, 2013 nobody to help me ? Link to comment Share on other sites More sharing options...
vekia Posted June 18, 2013 Share Posted June 18, 2013 but your query that you pasted above works well... Link to comment Share on other sites More sharing options...
shaka Posted June 18, 2013 Share Posted June 18, 2013 in fact, i'm afraid to ruin my database... so i didn't try. But if the pro say that's work... it's cool Link to comment Share on other sites More sharing options...
vekia Posted June 18, 2013 Share Posted June 18, 2013 remember about variables: $_SESSION['langue'] $id_produit Link to comment Share on other sites More sharing options...
shaka Posted June 18, 2013 Share Posted June 18, 2013 what do you mean ? For example, if i want to make it only for EN products ( language n° 1 ) ? what would be the code ? Link to comment Share on other sites More sharing options...
Guest locen Posted December 29, 2015 Share Posted December 29, 2015 Hi, i would create query to shows PRODUC TNAME, COUNTRY, QUANTITY SALES and SALE DATE. Because in STATS->BEST-SELLING PRODUCTS i can't shows also country that products are sold Please help me Link to comment Share on other sites More sharing options...
maickonen Posted September 20, 2016 Share Posted September 20, 2016 Hi there!I end up here cause I am search wich is table with name of product... I had some problem with duplicated product, I NEED TO ERASE PRODUCT WITH SAME NAME AS SKU, but I don't figure out which the query could be... I messed up! Thanks guys for your help Link to comment Share on other sites More sharing options...
Recommended Posts