Filling the site woocomerce. Lots of goods. How to automate?

Question

Automation

Hello.
I have an online store. On Wordpress - woocomerce.
Need to be filled with goods.
Now I fill manually.
But the task is very routine and consistent, so I think there is some possibility to automate this process.
All product images are on my computer.
Now the filling process looks like this: (Admin panel)
Add product > Enter product name > Variable product > Attributes > Add attributes (2 pcs) > Variations > Create all possible variations from attributes > 3 variations are created > in each I fill in all the items (photos, prices , sizes, etc.) > Select a category > publish.

It seems to me that you can write a script that will take all the necessary data (path to photos, names, prices) from a previously created file (table).
Can someone come across? I'll just turn gray until I fill everything by hand... And hiring someone, it's an average of $ 0.4 per item, with my number of items, it's expensive for me...
Thank you

Answer 1

and how will the script know what data you have where? one way or another, you need to program
and place the data over so that the script knows where what

Answer 2

Usually in the admins they use csv for this,
something like this
name, url, photoUrl, category1, category2, category3, price, discount

Answer 3

For the future. When you think of an online store with a complex and large range, start with the source. Usually it is 1C. Trade management.