Results 1 to 8 of 8
  1. #1
    Join Date
    Aug 2008
    Posts
    3
    Plugin Contributions
    0

    Default 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.

  2. #2
    Join Date
    Aug 2005
    Posts
    26,010
    Plugin Contributions
    9

    Default 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
    Get Your Business Found

  3. #3
    Join Date
    Aug 2008
    Posts
    3
    Plugin Contributions
    0

    Default Re: Export Product data to Excel

    I have information submitted in custom fields when they place an order: Take a look at:

    http://ponderosaspirit.com/shop/inde...products_id=10

  4. #4
    Join Date
    Aug 2005
    Posts
    26,010
    Plugin Contributions
    9

    Default 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
    Get Your Business Found

  5. #5
    Join Date
    Aug 2008
    Posts
    3
    Plugin Contributions
    0

    Default 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?

  6. #6
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,860
    Plugin Contributions
    2

    Default 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

  7. #7
    Join Date
    Aug 2005
    Posts
    26,010
    Plugin Contributions
    9

    Default Re: Export Product data to Excel

    Quote Originally Posted by 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
    Get Your Business Found

  8. #8
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,860
    Plugin Contributions
    2

    Default 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

 

 

Similar Threads

  1. Export product to excel sheet
    By UrbanClothingExpress in forum General Questions
    Replies: 4
    Last Post: 23 Jun 2009, 04:58 AM
  2. export orders to excel
    By pgu64 in forum Managing Customers and Orders
    Replies: 8
    Last Post: 5 Oct 2008, 02:15 PM
  3. Export data to Amazon Excel file?
    By PetesTown in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 5 Jun 2008, 05:55 PM
  4. Formating using Data from Excel for Product Description (and maybe more)
    By Outlawlb in forum Setting Up Categories, Products, Attributes
    Replies: 0
    Last Post: 23 Feb 2007, 06:34 PM
  5. Export product to excel sheet
    By UrbanClothingExpress in forum General Questions
    Replies: 1
    Last Post: 19 Jul 2006, 04:32 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •