Skip to content

How to clean a WooCommerce product catalog, step by step

5 min read

WooCommerce catalogs get messy quickly: supplier imports, plugin migrations and years of manual edits leave behind duplicate SKUs, missing images and prices that make no sense. This is a reliable workflow to clean a WooCommerce catalog using the built-in CSV export and import.

Step 1: Export your products to CSV

In WordPress, go to Products, then All Products, and choose Export. Export all columns and all product types so that variations and their parents stay together. Keep an untouched copy of this file as a backup before you change anything.

Step 2: Know which columns matter

WooCommerce stores one product per row. The Type column tells you what each row is: simple, variable, variation, grouped or external. Variations point to their parent through the Parent column and inherit its name, description and images, so empty cells on a variation row are normal.

Prices live in Regular price and Sale price. The Images column can hold several URLs separated by commas, and the first one becomes the featured image.

Step 3: Fix the errors that affect sales

Work through the problems that customers actually notice:

  • Simple products and variations with an empty Regular price.
  • A Sale price that is equal to or higher than the Regular price.
  • Prices typed with currency symbols or commas.
  • Image URLs that are incomplete or do not start with http or https.
  • Products with no description, or one too short to be useful.
  • Products with no category, which makes them hard to find in your store.

Step 4: Resolve duplicate SKUs and names

WooCommerce expects every SKU to be unique. Duplicates usually appear after importing the same supplier file twice. Find every repeated SKU and repeated product name, decide which entry is correct, and remove or rename the other. This is a judgement call, so it should never be automated blindly.

Step 5: Import the cleaned file

Go back to Products, choose Import and upload the corrected CSV. Tick the option to update existing products, so WooCommerce matches rows by ID or SKU and updates them instead of creating copies. Keep the column names unchanged, and the mapping screen will fill itself in.

Clean a WooCommerce catalog faster

Catalio automates steps two to four. It recognises a WooCommerce export, understands variable products and variations, flags every pricing, image and duplicate problem with its row number, repairs badly formatted prices and titles, and returns a file with the same columns, ready for the importer.