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
    Location
    Arizona
    Posts
    27,761
    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

  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
    Location
    Arizona
    Posts
    27,761
    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

  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,821
    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,,

  7. #7
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,761
    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

  8. #8
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    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.

 

 

Similar Threads

  1. Formating the export data from mysql in excel
    By ninobalducci2 in forum General Questions
    Replies: 0
    Last Post: 8 Feb 2012, 08:30 AM
  2. Replies: 1
    Last Post: 15 Sep 2009, 10:36 PM
  3. Export product to excel sheet
    By UrbanClothingExpress in forum General Questions
    Replies: 4
    Last Post: 23 Jun 2009, 04:58 AM
  4. Export data to Amazon Excel file?
    By PetesTown in forum All Other Contributions/Addons
    Replies: 2
    Last Post: 5 Jun 2008, 05:55 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
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR