How do you export product URL's?

[jokkah]

Would generally agree, but may cause some confusion to a visitor... Almost done with a mod to EP4 to incorporate/add the uri to the full products export, and will duplicate something similar for categories. Looking at this being switchable from the EP4 configuration menu so that it is something that can be turned off (faster processing) if not desired to include. Doing this instead of creating a new export option as it seems somewhat more appropriate.

I seem to have something working....here is what I did:

1. Run the following MySQL Query:

SELECT master_categories_id, products.`products_id`, products_description.`products_name`
FROM products
INNER JOIN products_description
ON products.`products_id` = products_description.`products_id`

2. Save results to CSV

3. Open CSV in Excel, add 'http://store.yourstore.com/index.php?main_page=index&cPath=' to one column

4. Add '&products_id=' to another column

5. In final column, use the formula '=D3&A3&E3&B3' or something like that to add URL (step 3 URL), plus master_categories_id, plus second URL piece (step 4) plus products_id

The result of that column should be the complete URL

I hope there is a better, more automated way soon!! (and I hope this makes sense)