Using Laravel Dusk to download Paddle payout PDFs

Managing multiple Paddle accounts for various products can make monthly accounting a tedious chore. Previously, I manually logged into each account, downloaded US and RoW (rest-of-world) payout PDFs, and imported them into my accounting software. To streamline this, I automated the process using Laravel Dusk, and I'm sharing the solution here.

This blog post introduces a new GitHub repository showcasing a Laravel Dusk application designed to automate the login to Paddle's web interface, navigate to the payouts section, and download the relevant payout PDFs. If you're manually downloading Paddle payout data each month, this automation could significantly improve your workflow.

Read on for a detailed explanation and walkthrough, or jump straight to the repository: https://www.php.cn/link/d6055de68dad5a21a33d640118198c98

The Problem

Paddle's monthly payouts include essential PDF invoices for accounting. With multiple products and separate Paddle accounts, this process quickly becomes time-consuming. This project aims to simplify this for anyone using Paddle with multiple accounts or seeking a more efficient solution.

How it Works

The repository contains a Laravel Dusk test script that automates the entire process:

1. Account Retrieval: The script requires pre-configured PaddleAccount records in your database. You can modify or remove the PaddleAccount and PaddlePayout models as needed.
2. Login and Navigation: The script logs into the Paddle dashboard using specified credentials and navigates to the Payouts page.
3. PDF Download: It downloads available payout PDFs for both US and RoW invoices, saving them to storage/app/private/paddle_invoices/.
4. Total Extraction: Leveraging the PdfToText package, it extracts total payout amounts from the downloaded PDFs.
5. Database Update: Finally, it creates or updates PaddlePayout database records with the extracted data.

Getting Started

The GitHub repository provides a sample Laravel project, including PaddleDownloadPayoutPdfTest.php. You can adapt parts of this file or clone the entire project. After setting up a database and running migrations, create a PaddleAccount record and execute php artisan dusk to test the script.

Future Enhancements

This script significantly reduces manual effort, transforming hours of monthly work into a minutes-long automated task. While integration with my accounting software isn't included, the locally stored PDFs enable further processing as needed.

For the complete code or to contribute, visit the GitHub repository. Contributions and feedback are welcome.

The above is the detailed content of Using Laravel Dusk to download Paddle payout PDFs. For more information, please follow other related articles on the PHP Chinese website!