A WooCommerce CSV import will publish whatever you give it, including the mistakes. This is the pre-import and post-import checklist I actually use on catalog migrations, from column mapping to duplicate SKUs and missing images.
When a store owner hands me the keys, I don’t start fixing anything. I spend the first hour and a half just looking. Here’s exactly what I check and why.
If a buyer cannot tell which size, pack, or color they are ordering, they stop. I have watched that happen on wholesale catalogs more than once. Here is how I structure SKUs, variants, and attributes so the store matches how people actually buy.