Woocommerce product import and API connection

Hi, My name is Patrik, I own a woocommerce store and need some help with updating products from a certain supplier and also creating a Api connection to there site.

I have almost all of there products on my site already but they all need to be updated and also the supplier have alot of new products that needs to be uploaded to my site.

I have got a updated CSV file from the supplier were the products is sorted by brand name.
But the category is missing in the csv file and the supplier can not supply that.
The supplier have their own e-commerce webstore were all the products are with category and everything. I am wondering if it is better to scrape their site to a csv and then upload the csv to our site?

This is the suppliers site: www.baradesign.se
All the products and brands need to be scraped.
The csv file image column only have 1 image however on the suppliers site there is multiple images.

This is my site: www.svetrend.se

So in short this is what I need help with:

• Update all the products on my site that is in the csv
• Add the products that is in the csv file but not yet on our site
• Remove old products from this supplier that is not in the csv file (only remove old products from this supplier!)
• Scrape the suppliers site for category and also images?
• Create API connection for suppliers stock status

I have attached a example file of what columns that is needed in the csv file.

NOTE! I have a lot of products on my site and it is very important that this work ONLY affect products and brands from this supplier

I don't know what is the best to do? maybe its easier to just delete allt the products from this supplier and then scrape their complete site to upload on ours?

I have WP all import / Export pro installed on my Wordpress.

I am no pro on this so I hope we can discuss and come up with the best solution to help me :-)

Best Regards
Patrik Gustavsson