How do you export product URL's?

[jokkah]

Hmm, I am not sure if I grasp what you have suggested. Do you mean putting all this together from the database tables themselves?

I can easily just append the server name to a combination of data in other columns, but what about the URL's that use subcategories? An example would be servername:///index.php?main_page=product_info&cPath=312_322&products_id=611 (ones with underscore to separate category to subcategory)

I was thinking of just using an Excel formula to build all the product URL's, (servername + category + products_id) but ran into a snag when I realized a lot of the products are in subcategories such as the example above

[mc12345678]

Technically all that is needed for those is the last category. The product type is still important if you are using any product type other than the default product type 1 (product_info) but yes, could just use the data from myphpadmin to create the uri. Afterall that's all that really happens anyways, it's just done through functions and procedures to give a consistent method.

Try going to that product omitting the 312_ and open a browser next to it, with the uri above. What's the difference between the two other than the uri?

[jokkah]

Technically all that is needed for those is the last category. The product type is still important if you are using any product type other than the default product type 1 (product_info) but yes, could just use the data from myphpadmin to create the uri. Afterall that's all that really happens anyways, it's just done through functions and procedures to give a consistent method.

Try going to that product omitting the 312_ and open a browser next to it, with the uri above. What's the difference between the two other than the uri?

Ah. I see.

Well, removing the 312_ goes to the product, but the breadcrumb is omitted. Also, on the left side of the page where the categories are listed, it doesn't drill down in a 'tree' format to see the category all the way to sub or sub-sub category. I suppose this is ok for Google Merchant because you can still purchase the product from that page?

[mc12345678]

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.

[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)

[mc12345678]

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)

Generally makes sense though would have helped others to identify exactly which column was represented by each of the cell values. :) would have had EP4 up, but some of the ZC cross functions were kicking my ########. If I required the functions_categories.php file it conflicted with something else in the admin. Finally found the admin side function to generate the category path, but had to leave before I could test it. EP4 version 4.0.27 coming soon with the added functionality of providing the path to products as given by using zen_catalog_href_link functionality from the admin. Had a solution earlier this week, but the host on which it was tested started having problems, so had to delay completion of the change. An added benefit of this functionality is that if say CEON URI Mapping is installed and active, then the resulting rewritten paths will be provided. Not sure of the other uri rewriters and theirintegration with the admin's zen_catalog_href_link code. Ohh, and still will be a day or two considering a "holiday" that is coming. :)

[mc12345678]

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)

Version 4.0.27 to EP4 has been uploaded to https://github.com/mc12345678/EasyPopulate-4.0 which should eventually be mirrored to https://github.com/chaddro/EasyPopulate-4.0. A similar message will be posted on the EasyPopulate v4 thread (http://www.zen-cart.com/showthread.p...Support-Thread).