Zen Cart Logo
Forums / General Questions / Exporting product URLs

Exporting product URLs

Views: 1,041

Results 1 to 5 of 5
26 Jun 2014, 10:15 PM
#1
meljen avatar

meljen

Zen Follower

Join Date:
Apr 2012
Posts:
127
Plugin Contributions:
0

Exporting product URLs

I need to get my product urls into a CSV file. I am using the standard ZC url setup with the category and product ID as part of the string. Due to this, I am having a hard time getting all of the product urls for my CSV file short of going through each category and C&P'ing each url in... there are a handful of variations of the url for each product due to the categories they're sorted into. I can't just go to 'all products' and mass copy and paste from there.

Is there a way to actually export product urls? I couldn't find them in the MyPHP. I'm not that experienced with MyPHP as it is. I cannot install something like Easy Populate as I am going to be closing my store in a couple weeks and I have bad luck with installing ZC mods and getting them to work correctly.

Any help would be appreciated. I have about 1000 products, and on average I'm handling 5000 unique urls because of the url structure and the categories. I feel like I'm doing this wrong.

And no, I'm not moving to another ZC shop, so any instructions for that probably wouldn't work, I'd imagine. :(

26 Jun 2014, 11:19 PM
#2
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Exporting product URLs

This is a fairly confusing request. What exactly is it that you are trying to do?

No, there is no data dump of the database from my phpadmin that already looks like the urls that you copy from the web browser. Those urls are generated from combinations of data tht is in the database. EP (or at least EP4) doesn't overwrite any other ZC files, and worst case for installation that I've seen is that the progrm just doesn't work.

Otherwise, if you export your entire database from phpmyadmin then you will have all of the data available so that you cn recrete whatever it is you want.

26 Jun 2014, 11:32 PM
#3
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,908
Plugin Contributions:
2

Re: Exporting product URLs

If however the goal really is to have a listing of the web addresses for all products, a small php file could be written to produce/provide each url for every product through the use of zen_href_link. This could be done to display to the screen and then could be copied and pasted, or could go a step further and generate the csv file that you are looking for.

27 Jun 2014, 6:27 AM
#4
balihr avatar

balihr

Totally Zenned

Join Date:
Oct 2008
Location:
Croatia
Posts:
1,795
Plugin Contributions:
22

Re: Exporting product URLs

EasyPopulate is an extremely simple install - basically drag'n'drop. There's literally nothing that you could break - as mc12345678 said, in worst case scenario, the module just won't work. And, there's an export option with that module called Froogle which, amongst other data, also provides a column with direct links to each product.

7 Jul 2014, 8:35 PM
#5
meljen avatar

meljen

Zen Follower

Join Date:
Apr 2012
Posts:
127
Plugin Contributions:
0

Re: Exporting product URLs

I already did it all manually, category by category. But thanks for your replies.

And yes, my request was just to have all of my possible products links put into a CSV file. The way ZC sets up links, it's based off of categories as well as the product ID. So I couldn't just search for the product and do one link for it. That goes off of its master category. I also have all of the other category possibilities which would have to be linked as well.

Basically I was setting up a CSV for 301 redirects from my old shop to a new one. But like I said, it's done, so nothing to worry about now. Thanks for the replies.