Results 1 to 6 of 6
  1. #1
    Join Date
    Sep 2011
    Posts
    3
    Plugin Contributions
    0

    Default Product CSV Export via PhpMyAdmin ?

    Hi I need some clear instructions on how to export the products from my store as a CSV using phpmyadmin.

    I can see the 'Products_Description' row listed (which I believe contains the product info?) but I am unsure how to export it on it's own (as apposed to a full DB backup using the 'Export' tab.

    Any help gratefully received

    Thanks

  2. #2
    Join Date
    Nov 2007
    Location
    Woodbine, Georgia, United States
    Posts
    3,580
    Plugin Contributions
    53

    Default Re: Product CSV Export via PhpMyAdmin ?

    In PHP MY admin export it as a CSV is all..... Then before importing make sure you backup your database.

    ~Melanie
    PRO-Webs, Inc. :: Recent Zen Cart Projects :: Zen Cart SEO 12 Steps to Success
    **I answer questions in the forum, private messages are NOT answered. You are welcome to contact us via our website for professional engagements.

  3. #3
    Join Date
    Sep 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Product CSV Export via PhpMyAdmin ?

    Hi

    That's the bit I cant figure out! - Looking at the list of tables i do not know how to select/open the products on their own and then export them.

    I am just not sure where to click / which icon to select /which checkbox to tick and what the following steps are.

    Thanks

  4. #4
    Join Date
    May 2011
    Posts
    4
    Plugin Contributions
    0

    Default Re: Product CSV Export via PhpMyAdmin ?

    Select export. select export method custom (older versions of phpmyadmin does not have this button)

    you should see a list of the tables, press down ctrl and click on "products", "products_description" and if you want categories also add "products_to_categories" and "categories_description"

    change format to csv

    check put column names in the first row and you should be good to go

  5. #5
    Join Date
    Sep 2011
    Posts
    3
    Plugin Contributions
    0

    Default Re: Product CSV Export via PhpMyAdmin ?

    Ok - so I needed to be on the Export page of course - i didnt see the list of table rows that you could select...

    Thanks!

    Which table row would export only the product names?

  6. #6
    Join Date
    May 2011
    Posts
    4
    Plugin Contributions
    0

    Default Re: Product CSV Export via PhpMyAdmin ?

    Quote Originally Posted by gp999 View Post
    Ok - so I needed to be on the Export page of course - i didnt see the list of table rows that you could select...

    Thanks!

    Which table row would export only the product names?
    If you only want the product names to be exported then the fastest way to do that is by sql query.

    Press the SQL button from top of the phpmyadmin

    type on the query field "SELECT products_name FROM products_description ORDER by products_name ASC"

    scroll to the bottom of the page and there should be a small export button where you should be able to export just the product names to a CVS.

 

 

Similar Threads

  1. Import Product Attributes Via phpMyAdmin?
    By Andor1211 in forum Setting Up Categories, Products, Attributes
    Replies: 3
    Last Post: 3 Apr 2012, 10:20 AM
  2. Need to create a live product feed via CSV
    By martin.etail in forum General Questions
    Replies: 1
    Last Post: 11 Sep 2009, 04:21 PM
  3. Uploading Products in a CSV Format to PhPMyAdmin?
    By byrd813 in forum General Questions
    Replies: 4
    Last Post: 26 Aug 2009, 02:48 AM
  4. Need to export product catalogue to CSV
    By robax in forum General Questions
    Replies: 5
    Last Post: 8 Apr 2008, 05:42 AM
  5. Importing Table Data via phpMyAdmin and Excel CSV
    By webomat in forum General Questions
    Replies: 6
    Last Post: 16 Mar 2007, 12:52 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