Update prices for items

Update prices for items

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

      • Sticky Posts

      • How to Add Users to your Organization in ZohoMail?

        A better clarity so you can create other users to start using Zoho Mail. You can directly Add Users from the Control Panel to your Organization. You can invite users with the existing email address. If the person (user) already uses ZohoCRM, then you can import users from Zoho CRM. You can also import them using a .csv file. (if you are planning to add them in Bulk)  In this topic, We will be discussing on how to Add and Invite users only.  The Import options are self explanatory. ____________________________________________________________________________________________________________