artemhp Posted August 8, 2010 Share Posted August 8, 2010 Help me to find structure and description of DB prestashopI need to create query:Get model, brand, price and link of the productThx Link to comment Share on other sites More sharing options...
presta-dyr Posted August 9, 2010 Share Posted August 9, 2010 This schema is not up to date but I still think it gives a good overview: http://www.daveegerton.com/assets/images/database-schema-prestashop.png./Kjeld Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 9, 2010 Share Posted August 9, 2010 The problem with trying to create one of these diagrams is that PS has NO foreign keys. You have to manually do the diagram lines. Link to comment Share on other sites More sharing options...
artemhp Posted August 17, 2010 Author Share Posted August 17, 2010 Thx, and now, please, help me to understand how url is formating?I have id_product, can i find url in DB for it or it is genetate in program? then how?I need only by DB create URL Link to comment Share on other sites More sharing options...
artemhp Posted August 17, 2010 Author Share Posted August 17, 2010 link must be something likesite.com/605-gitary-accent-gitara-accent-a-02n.htmlsite.com/gitary-select-acoustic-gitara-kiev-buy-acoustic-gitary-kiev/638-gitary-tenson-gitara-tenson-tenson-d-1-f501304.html Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 17, 2010 Share Posted August 17, 2010 link_rewrite value is based on product short description. See function link_rewrite in classes/Tools.php Link to comment Share on other sites More sharing options...
artemhp Posted August 17, 2010 Author Share Posted August 17, 2010 product real url is: site.com/352-park-audio-cf900.htmlbut link_rewrite in table = "park-audio-cf900-buy-park-audio-cf900-buy-park-audio-cf900-kiev-"how does 352-park-audio-cf900.html generate? Link to comment Share on other sites More sharing options...
MrBaseball34 Posted August 17, 2010 Share Posted August 17, 2010 function getProductLink in classes/Link.php 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