Hi,
I have a product feed from a supplier that I need to perform a search and replace on to replace stock levels.
The supplier uses the following in their spreadsheet:
Low Stock
In Stock
Out Of Stock
I need to replace the above with numbers instead so I can import them into our order management system. So I need to do a periodic search and replace to swap out “Low Stock” for say “2”. “Out Of Stock” for “0”.
I’ve managed to get Zapier to save their feed as a CSV file on Google Drive but can’t seem to get Zapier to perform the search and replace.
I’ve tried using a combination of Files by Zapier and Formatter but I can’t seem to work out how to do it.
Is it indeed possible please?
Thanks
Justin