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