Skip to main content

Lightning Source Update

1. Overview and Context

This procedure updates the KDPLightning Source 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

3. Steps to Be Performed

3.1 Download

DownloadThe the sales data from KDP through its backend. After 90 days, data are no longer downloadable and data entry should be done manually, which is a pain.

    Click "Reports" in the main menu on top Select "Orders"books from the leftsideUitgeverij menuimprint Selectare hosted through Lightning Source. Reports can be downloaded from the appropriateReports>Print monthSales Clickmenu "Downloaditem. Report."

    Lightning KDPSource delivers XLSXXLS files.

      Screen_Shot_2022-06-27_at_07.00.16.png

      3.2 Clean

      • Open in LibreOfficeLibreOffice, switch off "space" as a possible delimiter
      • TabAppend "Combined1 Sales"column to the left, add date in YYYY-MM-01 format
      • Delete table header
      Save as text CSV, comma-delimited

      3.3 Upload

      • Upload into phpMyAdmin table "KDP"Lightning_source"

      4. Additional Information

      5. Document Control

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