Sync products from Shopify and WooCommerce

Hello.

We are running on multi-vendor platform, which is made in PHP, the system is not Laravel, Yii, or any other framework, it’s pure PHP, but using libraries as /vendor which is generated with composer.

We have already importing system for products for CSV but only able to upload them, but we want to change that so we can allow our vendors to sync their products from their own store directly into the system by using CURL and along with that Cronjob.

The vendor will go into for example Plugins -> Data import -> and then import their CSV url from their own store, that store will be for example https://examplewoocommercestore.com/ and that store uses for example Google product feed, Facebook product feed, etc.

The vendor at our marketplace, and store owner will take that url and import it into our system for example https://examplewoocommercestore.com/data/feed/custom-file.csv or xml and continue the journey to import products.

When the next step is taken, the system will ask the vendor to map the CSV for example SKU, name, picture, pictures, inventory, price, sale price etc, but it’s important to when mapping categories, there are many categories on their own pages, but when choosing categories the vendor will have to map the categories that he already have, and match them to the categories which we have so for example Woman clothes at the WooCommerce store is Clothes -> Woman’s at out side.

And offer Cronjob update on X time every hour, two hours, 6 hours, 12 hours, 24 hours, weekly, twice a week, and monthly, that action will only update edited products (inventory, price, desc, picture, sale price, sale price from date and to date, get new products if they do not exist, and delete/draft products that has been removed from the CSV.)

Alternative solution
Both Shopify and WooCommerce have an API communication, so do we, people having Shopify store, can go into Settings -> Apps and sales channels, and create private app, and give permission, we need to be able to do the same above with the CURL way, but with API if it’s easier to implement, same actions are available for WooCommerce as you already know.