InvoiceNinja Update

1. Overview and Context

This procedure updates the Lightning SourceInvoiceNinja table in the SQL Database.

Lightning Source reports have bee discontinued. Their new reports can no longer be exported.

2. Triggers

The execution of this procedure is usually triggered by

• Metrics

3. Steps to Be Performed

3.1 Download

TheSales booksdata fromper the Uitgeverij imprint are hosted through Lightning Source. Reportsproduct can be downloadedconveniently fromgenerated theunder Reports>Print"Reports," Salesorganized menuby item.Invoice Item. Product numbers in InvoiceNinja correspond to PBNs.

Lightning

Source

InvoiceNinja delivers XLSCSV files. They suck.

3.2 Clean

• Open in LibreOffice, switch off "space" as a possible delimiterLibreOffice
• AppendSort 1by invoice number
  

delete rows with non-book data convert Product column to thetext, left,append add0 dateto in YYYY-MM-01 formatPBNs Deletefix InvoiceDate to 20XX-XX-01 fix price by removing $ sign delete table header save as text CSV, comma-delimited

3.3 Upload

• Upload into phpMyAdmin table "Lightning_source"InvoiceNinja"
  

4. Additional Information

5. Document Control

Document ID	PRO-035036
Document Owner	Vincent
Version	1.0
Last Date of Change	March 26, 2026
Next Review Due Date
Version & Change Tracking