so-doanh-thu-revenue

Run import_from_gsheet with dry_run=True first to preview rows without writing. The import reads the SM Hanoi and HCM REV tabs and applies dual-fingerprint dedup before inserting into the so_doanh_thu table.

Run scripts/dedup_gsheet_ledger.py in dry-run mode first, then with --apply which creates a timestamped backup before deleting. Verify with a SQL query grouping by uid, day, and amount having count greater than one.

DingTalk uses periods as thousands separators, which Google Sheets misreads as decimals. The _gmv_from_vnd function auto-corrects ratios below 0.01 and logs warnings for the grey zone between 0.01 and 0.10.

get_rate_for_date queries the exchange_rates table for the latest rate effective on or before the target date, falling back to DEFAULT_TY_GIA of 3700. Insert new periods into exchange_rates with an effective_from date.

fetch_rows_capped in analytics_limits.py truncates results at 50000 rows, and current callers silently discard the truncated flag. Query the table directly to check whether the cap was hit for large date ranges.

Do not use it for CRM sync logic in crm_routes.py, mPOS or Payoo reconciliation, or Supabase migrations and secrets management. Those belong to separate dedicated skills.