The only way that I’ve seen it done that works is to do an export of the existing products, and copy-and-paste the new items into that CSV file, then import it back into WooCommerce. We’ve got a client that does that, and it’s worked for them. As a note, they’ve got about 200 base products, and about 30,000 variations set upder those products so I’ve seen it work on the same sort of products that you’ve got.
I have to admit that I tried this, but I have no idea how to read this file I mean it opens in MS Excel but it’s really chaotic. I don’t know which line belongs to which product. That makes me look at this like I’m blind. :/
The columns that you need to take the most notice of are the SKU and Parent ID. The product ID is relatively important if you’re updateing existing products, but it doesn’t help if you’re adding new products or variations.
The basic process behind it is that you’d export the existing products, filter out pretty much everything that you don’t need (which willb e most of them), copy the variations that are set for a current product, and paste them with a new parent ID to match the new products. It’s not easy, and will take some time to get your head around, but that is really the only way I know of to do it in any sort of automated fashion.
Well, thanks a lot, it really works. I’m just using Libre Office to edit csv file and everything works fine. Thanks!!
