laravel-shop/database/migrations
Fabian @ Blax Software 423da476f5 feat(ledger): mirror PayPal accounts into the money ledger
PayPal checkouts that run through Stripe settle into our PayPal account.
Stripe's ledger row books the gross and Stripe's fee, but PayPal takes its
own fee inside the PayPal account, so net revenue was overstated.

- Ledger rows carry `provider` (stripe, paypal) and `account`; existing
  rows default to stripe.
- shop:import-paypal-ledger reads every account in shop.paypal.accounts
  through the Transaction Search API (read-only) and upserts one row per
  PayPal transaction. Stripe-originated payments and refunds add a
  `paypal_fee` row (amount 0, net -fee); payments PayPal swept on to
  Stripe are booked as `paypal_fee_passthrough`, because Stripe's fee
  already holds PayPal's. Direct PayPal sales count in full; holds,
  sweeps and withdrawals are non-revenue.
- `paypal_fee` joins the default revenue types.
- Stripe rows keep their payment intent in meta so PayPal rows find the
  buyer.
- Shop::ledgerTotalsByAccount() splits the totals per account.

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>
2026-10-07 10:46:46 +02:00
..
2025_01_01_000001_create_blax_shop_tables.php fix: product_action_runs.action_id must be uuidMorphs (ProductAction is HasUuids) 2026-06-10 11:33:09 +02:00
2025_01_01_000002_create_product_price_tiers_table.php I loanable product type, tiered pricing, lifecycle events, host helpers 2026-05-15 10:27:59 +02:00
2025_01_01_000003_add_stripe_to_users_table.php I loanable product type, tiered pricing, lifecycle events, host helpers 2026-05-15 10:27:59 +02:00
2025_01_01_000004_create_blax_shop_subscriptions.php feat(subscriptions): Cashier-backed subscription lifecycle with product link + events 2026-06-02 11:40:15 +02:00
2026_01_01_000000_drop_stock_quantity_from_products.php BF edgecases, R structure, A tests 2026-05-18 13:05:38 +02:00
2026_01_01_000001_drop_in_stock_and_stock_status_from_products.php BF edgecases, R structure, A tests 2026-05-18 13:05:38 +02:00
2026_01_01_000002_add_max_per_cart_and_max_per_user_to_products.php IAM "max usage" feature 2026-05-19 14:01:52 +02:00
2026_01_01_000003_create_license_seats_table.php feat(seats): assignable license seats — buy N, assign/reassign/reclaim per user 2026-07-29 10:07:58 +02:00
2026_01_01_000004_add_cost_amount_to_product_prices.php feat(cost): per-price cost basis (COGS) + net-MRR margin 2026-08-28 15:12:42 +02:00
2026_01_01_000005_add_license_fee_to_product_prices.php feat(cost): royalty / minimum-licence-fee margin (Aircademy-style) 2026-08-28 16:03:04 +02:00
2026_09_03_000001_create_stripe_transactions_table.php feat(ledger): user-independent Stripe BalanceTransaction ledger + daily net stats 2026-09-03 10:01:07 +02:00
2026_10_07_000001_add_provider_and_account_to_stripe_transactions_table.php feat(ledger): mirror PayPal accounts into the money ledger 2026-10-07 10:46:46 +02:00