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

  1. sixfootjames
    Posted 3 years 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?


  2. Michael Visser
    Posted 3 years ago #

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



Topic Closed

This topic has been closed to new replies.

About this Plugin

  • WP eCommerce
  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic