How can I automate product import and status updates from different vendors?

Hello,

Wondering if a tool exists or would you know how to import products from different vendors, but if some items in the CSV from the vendor are not included, mainly because they are out of stock, set them to draft within my shop during import if they already exist.

For instance:

Vendor = AW (only applies to products with this vendor name)

100 products processed

10 Products Missing - Discontinued or Out of Stock (Products Set to Draft)
20 Products Updated (Price or description change etc)
20 New Products Created
50 Products Unchanged

I have several vendors, all send me a complete CSV of products. It would much easier to process the whole CSV and automatically update the products and products status.

On some products it would be very useful to add a field to the product page, such as “Dimensions”. Some vendors include the dimensions in the description, some in a separate field. The functionality to add these new fields during import would be very useful. I know there are some tools out there (Meta-fields) but they don’t seem to do what I want.

I look forward to hearing from you

Chris