WHMCS import: invoices lose their date and are all marked unsent

Sheernox

Sheernox

New Member
Env: ClientExec 7.2.2 (ionCube), PHP 8.5.10, MariaDB 11.8.9. Source WHMCS 9.

Where: plugins/import/whmcs/whmcs2ce.php line 1040. The invoice query selects duedate and datepaid, not tblinvoices.date.

Bug:
  • Imported invoices have no datecreated, so the PDF shows 12/31/1969.
  • The importer also sets sent = 0 on every invoice, although WHMCS had sent them. Any "send unsent" path would email the whole history to clients.

Repro: Export and import any WHMCS 9 database, then open an imported invoice PDF.

Fix: Export i.date and map it to datecreated. Import with sent = 1, sentdate = date.
 
You must log in or register to reply here.
Back
Top