Daniel Patilea Posted March 18, 2014 Share Posted March 18, 2014 Can anybody tell me where I can find in my prestashop database the permalink for a product? I need to get all products permalink using php, without using any prestasop functions. Is that possible? Link to comment Share on other sites More sharing options...
vekia Posted March 18, 2014 Share Posted March 18, 2014 permalink is not stored in the database, link to product is based on several factors for example friendly urls option, rewrite field value, associated category Link to comment Share on other sites More sharing options...
Daniel Patilea Posted March 18, 2014 Author Share Posted March 18, 2014 Thanks for your answer. I managed to do this. In ps_product_lang table, if I concatenate the site's url and some columns from this table i get the product's link. The structure is like this : shop's url + '/' + id_product + '/' + link_rewrite + '.html' Link to comment Share on other sites More sharing options...
musicmaster Posted March 18, 2014 Share Posted March 18, 2014 The structure is like this : shop's url + '/' + id_product + '/' + link_rewrite + '.html' That works for you? Better try something like: shop's url + '/' + name of product's category+ '/' + id_product + '-' + link_rewrite + '.html' Link to comment Share on other sites More sharing options...
vekia Posted March 18, 2014 Share Posted March 18, 2014 and whole plan will not work when you disable friendly urls Link to comment Share on other sites More sharing options...
NemoPS Posted March 19, 2014 Share Posted March 19, 2014 I second vekia. Furthermore, you can change the structure from the SEO and URLs tab in the back office, you have a couple of other fields available too Link to comment Share on other sites More sharing options...
Recommended Posts