We need to automate the process when importing items from our partner's warehouse. We also need the ability to change items price before importing those into the system and to do that automatically with our formula. Etc.: to multiply all prices x2.

Conditions:

IF PRODUCT is PUBLISHED we need to update only product AVAILABILITY, AMOUNT and PRICE. Do not touch title, description and variation, because they are translated in another language, to avoid an override (this is very important).

If the product is NOT PUBLISHED, or an item is NEW, then the item must be uploaded with the status "PENDING". We will publish items manually after we'll do translations (this is very important).

Currently, there are a lot of products which are already translated. Is it possible to update those as well? Other company not finished this job and for now, we are not able to update items. It is very important to save items descriptions, titles. For current items, we only need update availability. If there is no such product then we need to make it "Not published state". Also, current items should work the same as described in the conditions above.

It would be good to automate the process, so it would update items 2 times per 24 hours also another option to update items manually.