WooCommerce: Import additional Variations using standard import tool

I’m using the standard WooCommerce importer (https://docs.woocommerce.com/document/product-csv-importer-exporter/).

Using a PHP script I’m composing a compatible CSV with data coming from another system. This file was successfully imported into WooCommerce. However, I face the following issue when trying to import additional variations.

My variable products have an attribute called size which is set to e.g. S,M,L after the first import. Let’s imagine the second import also introduces XS,XL. What WooCommerce does is it skips the variables products as another product with the same SKU already exists and just imports the new variations. Sometimes, already existing variations (e.g. M again) are also imported.

All variations imported with the second CSV are set to Some size instead of their corresponding size. I figured out that this is caused by the variable (parent) product’s attributes not being updated with the second import. After selecting the overwrite option in an import and just import SKU and the size attribute columns, it will delete all other attributes of the product and also every change that was done manually after the first import.

Is there any option to import additional variations for already existing variable products without having to manually add the new size attribute values for every variable product? In addition, is it possible to keep the manual changes, i.e. to not overwrite fields that weren’t changed?

Thanks in advance.

• This topic was modified 5 years, 3 months ago by handsomehauke. Reason: introducing code tags to improve readability
• This topic was modified 5 years, 3 months ago by handsomehauke. Reason: Question on wordpress.stackexchange.com deleted, disclaimer removed