KDP Update

1. Overview and Context

This procedure updates the dateKDP table in the SQL Database.

2. Triggers

The execution of this procedure is usually triggered by

• Metrics

3. Steps to Be Performed

3.1 Download

TheDownload Datethe Tablesales indata phpMyAdminfrom needsKDP tothrough its backend. After 90 days, data are no longer downloadable and data entry should be updateddone everymanually, monthwhich withis thea last month.pain.

• GoClick to"Reports" DateTablein the main menu on top
• SQLSelect Tab"Orders" from the leftside menu

Select the appropriate month Click "Download Report." KDP delivers XLSX files.

To add:

INSERT

3.2 INTOClean

`DateTable`(`Date`)

VALUESOpen ("2021-01-01")in

ToLibreOffice

delete:

DELETE FROM `DateTable` WHERE `Date` =

Tab "2021-01-01"Combined Sales" Delete table header Save as text CSV, comma-delimited

3.3 Upload

Upload into phpMyAdmin table "KDP"

4. Additional Information

5. Document Control

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