Magento - Db Query To Get Full Product URLs?May 11, 2011
I am looking to interact with the database outside of Magento. Upon reviewing tables in the database, catalog_product_flat_1 seems to store the majority of the information I am looking to retrieve so this gets me just all about everything but the final step. I am trying to understand the relations within the Magento DB and get all the full product URL's into my newly created table.
The purpose of this is for an SEO/PPC initiative where having a nice list of every product sku, name, brand, description and url directly to the product would make the work a breeze. I have everything working just fine aside from the full product URL. I have been doing a good amount of reading and it appears more people are using SQL injections within the normal Magento methods, but I am looking to do this with the database outside of the site.