Currency normalization - Githubissues

Zircoz / AmazonSummarizer

GNU General Public License v3.0

7 stars 8 forks source link

Currency normalization #7

Open Zircoz opened 2 years ago

Zircoz commented 2 years ago

orderHistory has multiple currencies if same account is used across different amazon sites (Amazon India, UK and so on). This shall be normalized by taking an input/config of which currency to report in and all currencies should be converted to it.

[ ] taking reporting currency input
[ ] converting all available currencies to target currency
[ ] using the timedate column to fetch the conversion rates of when purchase was made (might need multiple api calls; hence, optional)

Zircoz commented 2 years ago

Impact Summary:

Affected files: functions/parsing.py Affected df(s): RetailOrderHistDF Affected column(s): Currency, Unit Price, Unit Price Tax, Shipping Charge, Total Discounts, Total Owed, Shipment Item Subtotal, Shipment Item Subtotal Tax

Zircoz commented 2 years ago

@haspdecrypted Do you plan on doing this ?