Hello to all, let me explain my need. I have to change every day the prices of a lot of products (more than 10,000 and growing). This is because the prices are in USD and every day there isn exchange rate change. I cant give a tolerance margin, because the market prices are so agressive that if I do that, my sales will be affected. So the option is to change the items prices every day. I have a local database with the "new prices" every day at certain time. My question is, with "Data Prep" is it possible to create the new table ("item" id and "updated price") and with that, update the prices of these items in Zoho?
I know I can use CSV file in books, inventory, commerce, and also do it by API calls, I already explore these options and NONE of them worked for me because of multiple factors (automation, number of API calls, etc).
Please if it is possible give me a hint.
many thanks,
Javier