Forums / General Questions / Export Product data to Excel

Export Product data to Excel

Locked

Started by riceman on 23 Feb 2009, 9:56 PM · Views: 3,401

Results 1 to 8 of 8
This thread is locked. New replies are disabled.
23 Feb 2009, 9:56 PM
#1
riceman avatar

riceman

New Zenner

Join Date:
Aug 2008
Posts:
3
Plugin Contributions:
0

Export Product data to Excel

I have a client with a product that has multiple custom fields....like names of Athletes, School, etc. Basically a registration form for a Camp. She wants to be able to have all the submitted info dump into an Excel spreadsheet. Is this possible? Is there a plugin that will do this?

Any help is appreciated, Thanks.

24 Feb 2009, 2:29 AM
#2
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Export Product data to Excel

Not sure were you are getting this information entered from???

If you have phpmyadmin one can select the table(s) where this information is stored and export as a csv

Zen-Venom Get Bitten

24 Feb 2009, 3:17 AM
#4
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Export Product data to Excel

I have information submitted in custom fields
Same answer and you know the table(s) this information is added to for downloading as a csv through phpmyadmin

Zen-Venom Get Bitten

24 Feb 2009, 6:46 AM
#5
riceman avatar

riceman

New Zenner

Join Date:
Aug 2008
Posts:
3
Plugin Contributions:
0

Re: Export Product data to Excel

I see now, thanks..do you know if there is a way to do this(export to csv) from the zencart admin? Or is my only option phpMyadmin?

24 Feb 2009, 7:43 AM
#6
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Export Product data to Excel

You could try Easy Populate though unsure if it will show
all those attributes....Paid version might,,

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others

24 Feb 2009, 8:21 AM
#7
kobra avatar

kobra

Black Belt

Join Date:
Aug 2005
Location:
Arizona
Posts:
31,500
Plugin Contributions:
4

Re: Export Product data to Excel

misty:

You could try Easy Populate though unsure if it will show
all those attributes
EP is geared to a specific set of ZenCart's tables only with little provision for anything else....great tool for product mass loading.

As stated phpmyadmin have a csv export function

Zen-Venom Get Bitten

24 Feb 2009, 8:38 AM
#8
misty avatar

misty

Inactive

Join Date:
Apr 2004
Location:
UK
Posts:
5,752
Plugin Contributions:
1

Re: Export Product data to Excel

Agreed but OP requested access via zencart admin...EP is only way me thinks, but as you/i have pointed out, limited
options only available,..phpmyadmin is cert to get desired info.

Dezina ZenCart Templates
Please do not PM for support queries..Post in forums..help others