WooCommerce
How to clean a WooCommerce product CSV
WooCommerce exports often need the same kind of cleanup as Shopify files: header mapping, price normalization, and a good pass over titles, SKUs, and stock values.
What to do first
Start by comparing your source file to the browser editor, then use the platform preset to map common fields. Once your sample looks right, process the full file locally.
Map common WooCommerce fields first
Start with the fields you use most: name, description, regular price, sale price, SKU, stock, categories, and featured image. That gets most of the file into a usable shape quickly.
Check product names, stock, and pricing
WooCommerce feeds often include a mix of straightforward columns and platform-specific variations. Normalize price and stock values early so your import process is easier to validate.
- • Confirm the title field is mapped correctly.
- • Normalize regular price and sale price formats.
- • Check stock quantities for non-numeric values.
Clean up image and category data
Image URLs, categories, and tags are usually where a vendor export gets messy. Use the editor to spot and correct gaps before downloading the cleaned file.
Use the guide with a sample file first
A small sample lets you confirm whether your export format is matching the preset you expect before you work on the full catalog.
FAQ
Is this useful for WooCommerce migrations?
Yes. It is designed to help you clean and map WooCommerce product data before import or migration.
Does it handle variable products?
V1 is best as a cleanup and mapping foundation for common product exports rather than a full variable-product migration engine.
Can I keep the data local?
Yes. The browser-based workflow is intended to avoid uploading the raw CSV to a backend.