Importing Comments from WordPress

Moving from WordPress? You can import your existing comments into JamComments using a CSV export.

How It Works

1. Export your WordPress comments to a CSV file using the query below
2. Upload the CSV on the WordPress import page
3. JamComments imports your comments and shows you the results

Creating the CSV Export

Run this SQL query on your WordPress database to generate the export:

SELECT wp_comments.*, wp_posts.post_name
FROM wp_comments
JOIN wp_posts ON wp_posts.id = wp_comments.comment_post_id;

Note: This query assumes your table prefix is wp_. If you use a different prefix, adjust the table names accordingly.

Important: Check Your Post Paths

The post_name column becomes the path for your comments in JamComments. Make sure it matches your new site’s URL structure.

Example:

• In WordPress, a post might have post_name = “my-post”
• If your new site uses paths like /blog/my-post, you’ll need to update the CSV to include the /blog/ prefix
• Otherwise, comments won’t appear on the correct pages after importing

After Importing

You’ll see a summary showing:

• How many comments were successfully imported
• How many duplicates were skipped (if any)

Duplicates are detected based on matching content, author, and site.

Need Help?

Contact support. Importing is a relatively new feature and I’m happy to help work through any issues.