The Guide to Cleaning WooCommerce Product Data for Migration

Migrating to a new store is the perfect time for spring cleaning. Over years of running a WooCommerce store, your data gets messy:

• Old shortcodes ([vc_row]...) from deleted page builders.
• Inconsistent naming ("T-Shirt" vs "Tee" vs "Tshirt").
• broken image links.

If you import this mess into a fresh Shopify or BigCommerce store, you start your new life with technical debt.

Step 1: Export Your Raw Data

Use WooScraperPro to get a complete dump of your current live products. We recommend exporting to CSV.

Step 2: The Spreadsheet Cleanse

Open your CSV in Excel or Google Sheets.

Fix Titles (SEO Standardization)

Use the PROPER() function in Excel to capitalize titles consistently.

• Before: "mens running shoe blue"
• After: "Mens Running Shoe Blue"

Remove Shortcodes

Search and Replace (Ctrl+H) is your friend.

• Find: [*] (Wildcard search often works nicely with regex tools)
• Replace with: (Empty)
• Goal: Remove anything that looks like [gallery ids="1,2"] code that won't work on your new site.

Standardize Vendors/Brands

Sort by the "Vendor" column. Identify duplicates like "Nike", "Nike Inc.", and "NIKE". Bulk rename them to a single standard: "Nike". This ensures your collection filters work perfectly on the new site.

Step 3: Re-Import

Now that your CSV is squeaky clean, upload it to your store. Your new site will look polished, professional, and trustworthy from Day 1.

Don't migrate mess. Clean it first. Start Your Clean Export →