Docs

WP Data Transformer lives in wp-admin under CSV Import Prep. It prepares files for your importer — it does not write products or posts to the database yet.

1. Choose an import target

Pick Generic CSV or WooCommerce products. The WooCommerce target guides readiness checks toward common product CSV headers (Name, Regular price, SKU, and more). It still exports a CSV.

2. Upload

Upload a .csv or .txt file. Review row/column counts, sample rows, and delimiter. Re-parse if your file uses semicolons or tabs.

3. Clean

Add steps in order. Useful starters:

• Trim whitespace on all columns
• Rename columns to match your importer
• Map values (e.g. In Stock → instock)
• Split combined fields
• Filter rows / remove duplicates

Watch the live before → after sample. Reorder steps with the arrows if needed.

4. Check readiness

Select columns that must be non-empty, then run the check. Missing WooCommerce headers show as errors or warnings. Nothing is auto-fixed — you go back to Clean if needed.

5. Download

Export the prepared CSV and import it with your usual tool. Cells that look like spreadsheet formulas are prefixed so Excel does not execute them.

Limits

Default caps are about 5 MB and 25,000 rows. Jobs and uploaded files expire after 48 hours.