Title: Lotus theme SQL data export assistance required
Last modified: August 22, 2016

---

# Lotus theme SQL data export assistance required

 *  [CreativeNorthWest](https://wordpress.org/support/users/creativenorthwest/)
 * (@creativenorthwest)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/lotus-theme-sql-data-export-assistance-required/)
 * We have inherited site A ( standard WordPress build) with all product items we
   need to export built in a “product tab” in a theme called “Lotus we think was
   bought from Theme forest”, the client has now outgrown this theme.
 * We need to take the data of each product – Name, description, price, media file,
   url, etc and get that into a csv to import into site B with a different theme
   that we intend to run Woo commerce as a catalogue to manage the products.
 * We have found the Woo commerce csv importer plugin for site B so that looks fine.
 * We have webmin access to server to get to the SQL files and folders and also 
   RDP access so can get to any files anywhere.
 * Do we need to export the SQL to access the build the relationships of the tables
   or is there a plugin anyone has seen that will do it?
 * The question is how do we extract the data from the original site A into csv 
   format?, any ideas would be really helpful and very gratefully received.

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Matt Knowles](https://wordpress.org/support/users/aestheticdesign/)
 * (@aestheticdesign)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/lotus-theme-sql-data-export-assistance-required/#post-5652326)
 * Do you have access to phpMyAdmin? It makes it very easy to select the entries
   in a table and export it to CSV.
 *  Thread Starter [CreativeNorthWest](https://wordpress.org/support/users/creativenorthwest/)
 * (@creativenorthwest)
 * [11 years, 4 months ago](https://wordpress.org/support/topic/lotus-theme-sql-data-export-assistance-required/#post-5652408)
 * Matt, thanks for your reply, we have access to everything on the server.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Lotus theme SQL data export assistance required’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 2 replies
 * 2 participants
 * Last reply from: [CreativeNorthWest](https://wordpress.org/support/users/creativenorthwest/)
 * Last activity: [11 years, 4 months ago](https://wordpress.org/support/topic/lotus-theme-sql-data-export-assistance-required/#post-5652408)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics