Hi Guy's.
Please bare with me, its been about eight years since I set my site up, so have forgotten most of the terminology and what add-ons I've installed.
I need to supply a spreadsheet of my products to a 3rd party with the following information
Product code
Product description
Image location URL
Product location URL
The product image URL was easy, I just added http://www.mysite.com/store/images/ before the image name. real easy in a spread sheet
However its not so straight forward with the product page URL as I have an add-on that creates a search engine friendly URL (sorry, can't remember what it was called), such as
http://www.mysite.com/store/blank-widget-panel-p-8513.html
The product code would be something like MLD-blank_widget
As a temporary URL I could use
http://www.mystore.com/store/advanced_search_result.php?keywords=
Then add the product code at the end, but I'd prefer a URL that goes direct to the product description page.
Can someone help me out please? Thanks in advance :)
PS. I have about 3K of products, so don't want to manually go through each product to get the URL