Creating product variations by using CSV import suite or built-in importer
-
Hello,
I managed to import all products successfully by using the built-in importer and also did the same using the CSV import suite. Variables are not created automatically in either case, although parent products are created 100% correctly.
Just to clarify and expand on that:
– If I use the built-in importer, both attributes (size and colour) are imported, but not selected to be used for variations. I’m not sure how to make these attributes to be selected as a default for variables. So in this case I can understand why variables are not created.
– If I use the CSV import suite instead of the built-in importer, I can create all products with attributes (size and colour), and this time I can make them selected for creating variables by default (using 1|1|1).
However, in both cases, the parent products have no variables created, so I have to go and manually create all variations. For 1000+ products, this is a tedious and never-ending job. Creating all variations on a CSV (which would be around 45k) is also not practical. I imagine it would take less time to create them on the back end manually rather than creating 45k variations on CSV.
So the question is.. Once the parent product is successfully created, with all relevant attributes (size, colour etc.), and the ones that are used for variations are ticked.. How can I create all relevant variations? Or how can make import tool to create variations at the point of creating parent products?
Thanks in advance!
PS. I found a similar question here link but I wasn’t sure if it would be better to reply there or create a new post. Since it was marked “resolved”, I thought I’d create a new post, but if this is not the right approach please let me know for future ref.
-
Hello @yukikatayama! Thanks for the response, however, this is actually the main point.
I am importing products from another platform, and I have around 1400 products. Most products have 2 main attributes, size and colour. As a result, I have around 40000 variables.
As you can imagine, creating a CSV file with over 40k lines is not a practical job for manual entry. I don’t know if there is an automated way of generating the CSV – if so please let me know.
The other option is, of course, to generate variations from the variables tab. The trouble is, doing this 1400 times, is also no easy job.
I though WooCommerce would be able to handle this task, as part of the import job. My question is, how can I do that.. Not how to create a CSV for variables (unless there’s a way to generate such file).
I hope this makes sense, and there is a way to achieve that.
Thanks!
- The topic ‘Creating product variations by using CSV import suite or built-in importer’ is closed to new replies.
