How to Review WooCommerce SKUs, Prices, Stock and Product Images in CSV
After exporting WooCommerce products to CSV, review the spreadsheet before using it for migration, bulk editing or catalog analysis. Start with duplicate SKUs, blank product names, invalid prices, contradictory stock values, missing image URLs, inconsistent categories and incomplete variation rows.
A CSV file makes large catalogs easier to inspect, but a spreadsheet is only useful when the records are clean and understandable. This guide provides a practical WooCommerce product-data audit for Excel, Google Sheets and other spreadsheet editors.
Why review a WooCommerce CSV export?
WooCommerce catalog exports are used for migration, backup, bulk editing and analysis. Official WooCommerce documentation describes CSV import and export as a way to manage large volumes of product data, including attributes, categories and images. A review step helps you catch problems before they reach a production store.
WooCommerce CSV audit checklist
1. Check product names
Filter for blank names, duplicate names and truncated text. Duplicate names may be valid, but they should be reviewed when SKUs or product types differ.
2. Check product types
Review simple products, variable parents and variation rows. Confirm that the product type matches the intended catalog structure.
3. Find duplicate SKUs
SKUs are important identifiers for inventory, migration mapping and catalog maintenance. Use a duplicate check in your spreadsheet.
Example Google Sheets or Excel formula when the SKU is in column B:
=COUNTIF($B:$B,B2)>1Filter the formula column for TRUE to review duplicate SKUs.
4. Find blank SKUs
Not every store requires every row to have a SKU, but blank identifiers should be intentional. Pay special attention to variation rows when your migration workflow relies on unique child identifiers.
Example formula:
=TRIM(B2)=""5. Review regular prices
Look for blank values, text stored as numbers, unexpected zeros and currency symbols that may interfere with import mapping.
6. Review sale prices
Check whether a sale price is higher than the regular price. Confirm that blank sale prices remain blank rather than being converted into zeros.
Example formula when regular price is in column C and sale price is in column D:
=AND(D2<>"",C2<>"",VALUE(D2)>VALUE(C2))7. Compare stock status and quantity
Review rows where stock status and stock quantity conflict. A positive quantity with an out-of-stock status may require investigation. Some stores do not publicly expose quantities, so blank values may be expected.
8. Review variable-product parents
A variable parent should have related child rows when native variations are publicly exposed. Confirm that variation rows reference the expected product and use the correct attribute combinations.
9. Review variation attributes
Look for missing values, inconsistent spelling and unexpected combinations. For example, Blue, blue and BLUE may need normalization depending on the target import workflow.
10. Check image URLs
Filter for blank image URLs. Open a sample of URLs in the browser and confirm that they load. Review whether you have permission to reuse the assets in the target workflow.
11. Check categories
Look for inconsistent naming, accidental duplicates and unexpected uncategorized records. Use How to Export WooCommerce Categories and Collections to CSV to create a separate category-first spreadsheet.
12. Check descriptions
Review short descriptions and full descriptions for broken HTML, outdated promotions, unsupported scripts, source-store links and formatting problems.
13. Check tags and attributes
Confirm that tags describe products consistently and attributes represent product characteristics accurately. WooCommerce uses categories, tags and attributes for different catalog-management purposes.
14. Identify add-ons that are not variations
When a product page shows extra options that do not appear as child rows, review Native WooCommerce Variations vs Product Add-ons: Why Some Options Are Missing.
15. Save an original copy before cleaning
Keep the raw export unchanged. Create a separate working copy for cleanup, normalization and import preparation.
Recommended spreadsheet columns for an audit
| Audit area | Useful columns | What to look for |
|---|---|---|
| Identity | ID, Type, Name, SKU, Parent | Duplicates, blanks, incorrect relationships |
| Pricing | Regular price, Sale price | Blank values, invalid values, unexpected sale logic |
| Inventory | Stock status, Stock quantity | Contradictions and missing values |
| Variations | Parent reference, Attributes, Variation SKU | Missing children, invalid combinations, spelling differences |
| Images | Featured image URL, Gallery image URLs | Broken links, blanks and asset permissions |
| Taxonomy | Categories, Tags, Attributes | Inconsistent naming and incomplete mapping |
Additional spreadsheet formulas for WooCommerce CSV review
Use helper columns in a working copy of the spreadsheet. Adjust the column letters to match your file.
Flag leading or trailing spaces in SKUs
=B2<>TRIM(B2)Flag missing product names
=TRIM(A2)=""Flag image URLs that do not start with HTTP or HTTPS
=AND(E2<>"",LEFT(E2,4)<>"http")Flag out-of-stock rows with a positive quantity
=AND(F2="outofstock",VALUE(G2)>0)Formulas highlight rows for review. They do not automatically prove that the source data is wrong. A store may use custom inventory rules, blank public quantities or plugin-specific behavior.
Create a data dictionary before large catalog work
A data dictionary explains what each column means, whether it is required, whether blanks are allowed and how values should be normalized. This is especially useful when a CSV file is shared between catalog managers, developers and migration specialists.
| Column | Meaning | Review rule |
|---|---|---|
| SKU | Product or variation identifier | Review duplicates, blanks and spaces |
| Type | Simple, variable parent or variation | Confirm expected structure |
| Parent | Reference linking a variation to a parent | Check missing or incorrect links |
| Regular price | Base product price | Check blanks, text values and unexpected zeros |
| Sale price | Discounted price when used | Check invalid relationships |
| Images | Public product image URLs | Open a sample and review permissions |
Use a repeatable WooCommerce SKU audit process
A WooCommerce SKU audit should be repeatable. Save the formulas, filters and normalization rules in a template spreadsheet. When you export another catalog, duplicate the template and apply the same checks. Consistent review is more reliable than visually scanning thousands of rows.
Simple spreadsheet workflow
- Save the raw CSV file as an untouched backup.
- Create a working copy.
- Freeze the header row.
- Enable filters.
- Add audit columns for duplicate SKUs, blank SKUs and sale-price checks.
- Sort variable parents and child rows together.
- Review categories, image URLs and descriptions.
- Save a cleaned version with a new filename.
- Run a representative sample import in a staging store.
Common WooCommerce CSV review questions
Are blank stock quantities always a problem?
No. A selected store may not expose stock quantity publicly, or it may use stock-status logic without quantity tracking. Treat blanks as a review item rather than automatically replacing them.
Should variation rows consume additional free export credits?
In WooCommerce Product Scraper & CSV Exporter, a variable product counts as one top-level product under the free allowance. Related publicly exposed native variation rows are included without using extra free product credits.
Can I clean the CSV and import it immediately?
Keep the raw file, create a cleaned copy and test a small sample in a staging environment before importing a complete catalog.
Where should I start when the catalog has thousands of rows?
Start with identifiers, product types, parent-child relationships, prices, stock values and images. Then review taxonomy and descriptions.
Related guides
- How to Export WooCommerce Products to CSV with Product Variations
- How to Export WooCommerce Categories and Collections to CSV
- WooCommerce Catalog Migration Checklist for CSV Product Files
Official WooCommerce references
- WooCommerce Product CSV Importer and Exporter documentation
- WooCommerce product taxonomies documentation
- WooCommerce bulk product update guidance
Responsible use: Use catalog-export tools only for lawful workflows. Export data only when you have the right or permission to use it, and follow applicable website terms, privacy requirements, intellectual-property rules and data-use regulations.
