WordPress Groups to Guided Tours - Processing Guide

This guide walks you through the process of extracting WordPress group data from your database and formatting it for import as guided tours using WP All Import.

Overview

The workflow consists of three main steps:

1. Database Query - Extract group data from WordPress database

2. Data Export & Import - Export to CSV and import into Google Sheets

3. Data Formatting - Clean and format post IDs for WP All Import

Step 1: Database Query (phpMyAdmin)

What it does

Extracts all groups from your WordPress database along with their associated content (post IDs).

Instructions

1. Open phpMyAdmin and select your WordPress database

2. Go to the SQL tab

3. Paste and execute the following query:

Query Explanation

• Selects groups (custom post type 'group')

• Joins with postmeta table to get the 'content' field

• Cleans up serialized PHP data by removing common prefixes

• Replaces semicolons with pipes for easier processing

• Orders results by group ID

Step 2: Export and Import to Google Sheets

Export from phpMyAdmin

1. After running the query, click Export at the bottom of the results

2. Choose CSV format

3. Download the file to your computer

Import to Google Sheets

1. Open Google Sheets

2. Create a new spreadsheet or open existing one

3. Go to File > Import

4. Upload your CSV file

5. Configure import settings as needed

6. Import the data

Step 3: Data Formatting in Google Sheets

Identify the Data Column

Locate the column containing the post IDs data. This column will contain partially cleaned serialized data that needs further processing.

Apply Formatting Formulas

Formula 1: Extract 4-digit Post IDs

In an empty column (e.g., column E), apply this formula to extract 4-digit post IDs:

What it does:

• Uses regex to find 4-digit numbers in quotes

• Replaces matches with the number followed by a pipe (|)

• Removes extra spaces

Formula 2: Remove Trailing Characters

In the next column (e.g., column F), apply this formula to clean up the final format:

What it does:

• Removes the last 3 characters (typically "|||" or similar trailing artifacts)

• Gives you clean pipe-separated post IDs

Apply to All Rows

1. Select the cell with your first formula (E2)

2. Copy the formula down to all rows with data

3. Repeat for the second formula in column F

4. Copy the final results and paste as values to preserve the formatting

Step 4: Prepare for WP All Import

Final Data Format

After applying both formulas, you should have clean data in this format:

This pipe-separated format is ideal for WP All Import to process multiple post IDs for guided tours.

Using with WP All Import

1. Export your final Google Sheets data as CSV

2. In WP All Import, map the cleaned post IDs column to your guided tour tour contnet post IDs field

Troubleshooting

Common Issues

• Empty results: Check that your post type is actually 'group' and meta key is 'content'

• Malformed data: The original data might be serialized differently - adjust the REPLACE functions as needed

• Formula errors: Ensure you're referencing the correct column (D2, E2, etc.)

Data Validation

• Check that post IDs are 4 digits (or adjust regex pattern if different)

• Verify that pipe separation is working correctly

• Confirm all groups have been extracted

Notes

• This process assumes WordPress serialized data in a specific format

• Post IDs are assumed to be 4 digits - modify the regex \\d{4} if your IDs are different lengths

• Always backup your database before making changes

• Test the import process with a small batch first

Support

If you encounter issues with the data format or need to modify the queries for your specific setup, consider the structure of your serialized data and adjust the REPLACE functions accordingly.