Need Shopify CSV modification and import

Job ID: 37390816

Budget: $15 – $25 AUD

We have 104 CSV files each file around 1000 products details with products that we need to update/import to our shopify store.

we need to do the below changes to all the files. We have formulas and list of words that need to be translated. in the CSV files before its imported. Here is a list of the things needed to be done.

Update price (we have a formula)
Replace words in certain columns with translation (size, type, color etc.) (we have list of translations)
Add standard text into description (processing time etc.) (text and samples ready)
Structure description (samples ready)
Make sure products already in shopify are only updated and not created again (by SKU)
Make sure discontinued products are set to draft (by SKU)
Make sure all imported products have inventory not tracked set on them.