I had a similar issue when trying to manage products priced in USD while my base currency was different.

Hi,

You are using Odoo Online Enterprise with AED as your default currency, but many software products are purchased from vendors in USD. You want to add hundreds of such products without manually converting each price into AED, so that salespeople can quote customers directly in AED.

In Odoo, product sales prices are always stored in the company currency (AED), while vendor prices can be entered in their original currency (USD) under the Purchase tab. Since you cannot install custom modules on Odoo Online, the best approach is to use Sales Pricelists. By creating a pricelist in AED that is based on vendor cost, Odoo will automatically convert USD vendor prices into AED using exchange rates. You can also add markups or discounts in the pricelist rules.

This setup allows you to maintain vendor costs in USD while ensuring salespeople always see and use AED prices for quotations, without the need to manually update hundreds of product prices.

Hope it helps

Hi ,

I have tired to add the usd cost in the purchase tab. But how can i reflect the sales cost in the general information tab automatically as the number of products i need to add are so many.  Manually one by one is not an option. Also the cost price in general tab does not show the converted purchase cost from purchase tab.

Please check screenshots below.

https://drive.google.com/drive/folders/1BEh-c-7KKuYpfwS6JODX_RmHsl9_l5K2?usp=sharing

I am only referring to Sales aspect of the process at the moment. 

Thanks

Hi,

In Odoo you always define the Sales Price in your company’s currency (AED in your case). If the vendor gives you the cost in USD, you don’t need to convert manually for every product:

1. Go to Purchase tab of the product.
2. Under Vendors, add your supplier and enter the cost in USD — Odoo will automatically convert it into AED using the daily rate when you create POs.
3. For sales, just set your Sales Price once in AED (or use a pricelist if you want Odoo to calculate from cost).

If you have hundreds of items, prepare an import file with vendor, vendor currency = USD, and vendor price = cost. Odoo will keep the original cost in USD and handle conversion automatically.

That way your salespeople only see the AED selling prices, but you still maintain the vendor’s original USD costs.

Hope this helps!