WordPress.org

Ready to get started?Download WordPress

Forums

WP eCommerce
[resolved] [Plugin: WP e-Commerce] Export all posts to import as product items (2 posts)

  1. sixfootjames
    Member
    Posted 1 year ago #

    Up until now, my client has been using WordPress posts as his way to display his products. I now need to export all these posts into a CSV format so that I can format the CSV file and import it back into WP e-Commerce.

    I've looked at number of options including plugins to export the posts, exporting directly from phpMyAdmin and using the XML export option within WP but none is coming out as clean as I would like it.

    I think I basically need an SQL query that I can run to export only the information from the POSTS table, excluding any other rubbish such as ID numbers, ping status, guid etc.

    All I need is:

    • Post Title
    • Post Content
    • Custom Fields
    • Categories

    Here's the start of my Query:

    SELECT *
     FROM  'wp_posts'
     WHERE  'post_status' =  'publish'

    Otherwise I am open to any better solutions to tackle this problem?

    http://wordpress.org/extend/plugins/wp-e-commerce/

  2. Visser Labs
    Member
    Plugin Author

    Posted 1 year ago #

    Hi sixfootjames, I think you already found our importer Plugin for importing/merging Products and free exporter Plugin. :)

    http://www.visser.com.au/wp-ecommerce/plugins/product-importer-deluxe/

    http://wordpress.org/extend/plugins/wp-e-commerce-exporter/

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic