FluentCart / FluentCart Pro 2.0.0: multi-currency issues

Site: thehiddencause.com · WordPress 7.1.3 · PHP 8.4 · Base currency USD; GBP, EUR and CAD enabled

1. The exchange-rate provider can’t be changed from Manual in the admin UI
   Settings → Multi-currency: the “Exchange rates from” selector (Manual / European Central Bank) sits inside the “Exchange rates” section. That section only displays when rate_provider is set and isn’t manual. With the provider on Manual, the section and its selector are both hidden, so there’s no way to switch to ECB. We had to change the setting in code; after that the section appeared and works.
   Expected: the selector is visible in Manual mode.

2. Customer::recountStats() throws a database error
   QueryException: Unknown column 'total_order_count' in 'field list'. It runs UPDATE wp_fct_customers SET total_order_count = …, total_order_value = …, but neither column exists in wp_fct_customers on 2.0.0 (the columns are purchase_count, purchase_value, ltv, aov). Customer stats can’t be recounted.

3. Reports quietly show only the base currency
   When the date range includes orders in several currencies, reports default to the base currency. The only way to change it is a “Currency” option inside the filter menu, and there’s no sign that orders in other currencies are being left out. In our case the Products report showed 1 sale where there were 2 (one GBP, one USD).
   Suggestion: a visible currency chip or picker whenever more than one currency is in range, plus a note such as “1 GBP order not shown”.

4. Feature request: manual and API orders in a non-base currency
   OrderController::store() runs unset($data['currency']) (commented “Admin orders in another currency are not released yet”), so admin-created and REST-created orders are always in the base currency. We need to record historical and offline orders in the currency they were actually paid in, with an optional exchange rate and original order date. Supporting currency, rate and created_at on create would cover it.