How Do I Download Product URL's in csv file?

[wprince]

I am new to all of this so I am looking for a little help.

I want to download the URL's for all the products that I have in my store in a csv file so that I can upload them to Amazon.

Right now there are over 1500 downloadable products listed in the store. These are all downloadable digital scapbooking kits and addons that have been made by my wife, Connie Prince aka Designs By Connie Prince, www.connieprince.net

I have 1.3.9h and as I understand it that is a very stable very safe version of Zen Cart. I don't want to upgrade to 1.5 if I don't have too. The site is running like a clock and I don't want to do anything that may cause problems.

Thanks in advance.

William

[kobra]

Product url's are not something stored in the database

[wprince]

OK, I figured out how to do this, just dumb luck. I am posting this here if anyone else has this problem maybe this will help.

I downloaded the froggle delimited file. I saved that to my desk top and opened it with Note Pad Plus and saved that as a text file and then I was able to open that file with excel and saved it in an excel format and then opened that file in open office and saved as a csv file.

I know that I could have saved it as a csv file in excel but I have had trouble in the past with excel crashing when I try and save something as a csv file.

This gave me all the info that I needed, product URL, product name, price, description, image url, category, SKU, in stock, shipping, brand, UPC, manufacture, product type, and currency

A little editing to put the right data in the right columns for amazon and then I uploaded the finished csv file and it worked like a charm.

The links work and I have all the critical data that I needed.

[remops]

OK, I figured out how to do this, just dumb luck. I am posting this here if anyone else has this problem maybe this will help.

I downloaded the froggle delimited file. I saved that to my desk top and opened it with Note Pad Plus and saved that as a text file and then I was able to open that file with excel and saved it in an excel format and then opened that file in open office and saved as a csv file.

I know that I could have saved it as a csv file in excel but I have had trouble in the past with excel crashing when I try and save something as a csv file.

This gave me all the info that I needed, product URL, product name, price, description, image url, category, SKU, in stock, shipping, brand, UPC, manufacture, product type, and currency

A little editing to put the right data in the right columns for amazon and then I uploaded the finished csv file and it worked like a charm.

The links work and I have all the critical data that I needed.

Wow!
Great help Thanks

[mc12345678]

Wow!
Great help Thanks

FWIW, EasyPopulate V4 does this also when exporting the product(s). It has the ability to provide the full product URL as would be seen on a site designed to use ZC core code to provide the URI (ie. URI rewriter results are provided).

It didn't quite have as many options available back in 2013, but it has for the last year or more...

There may be other tools that can do that and generate a csv up front, rather than the unfortunate need to transfer through all of the systems as identified.