verify_migration_chunk
Database record verification with price format detection
Overview
After importing data into your new database, this tool verifies that records match the source. It catches price format issues, missing records, and field mismatches — the subtle data bugs that slip through manual QA.
How It Works
- Takes a sample of source records from your WordPress export.
- Queries your new database to find matching records.
- Compares field values, detecting type mismatches and formatting issues.
- Special handling for WooCommerce price fields (currency symbols, decimal precision).
- Reports missing records and field-level differences.
Input Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
source_sample |
array |
required | Array of source records to verify against the database |
table_name |
string |
optional | Database table to check against (default: products) |
db_connection_string |
string |
optional | Database connection string (uses DATABASE_URL if not provided) |
What You Get Back
- Match status for each record (matched, missing, mismatched)
- Field-level comparison details
- Price format issue detection
- Overall verification score
Example Use Case
After importing 2,000 WooCommerce products into PostgreSQL, verify a sample of 50 records. The tool catches that 3 products have prices stored as strings instead of numbers, and 1 product's description was truncated.
Tips
Verify in chunks rather than all at once — it's faster and easier to debug issues.
Pay attention to price format warnings — WooCommerce stores prices as strings which can cause calculation bugs.
Use with the generate_schema_proposal output to ensure your schema handles all field types correctly.