KDP Update

1. Overview and Context

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

Download 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" from the leftside menu
• Select the appropriate month
• Click "Download Report." KDP delivers XLSX files.

3.2 Clean

• Open in LibreOffice
• Tab "Combined Sales"
• Delete table header
• Save as text CSV, comma-delimited

3.3 Upload

• Navigate to phpMyAdmin table "KDP"
• select Import tab;
• select file
• click "Go."
• archive files under Punctum Admin > Metrics > KDP

4. Additional Information

5. Document Control