MySQL + Stripe

Update rows in MySQL when subscriptions are updated in Stripe

When a subscription update occurs in Stripe, utilize this workflow to seamlessly make corresponding changes to a specific row in MySQL. This significantly simplifies maintaining up-to-date records and ensures consistent data between your payment processing and database management systems. Hence, you can effortlessly streamline your subscription management process and improve data accuracy.

When this happens...
Updated Subscription
Triggers when a customer subscription has changed.
TriggerInstant
automatically do this!
Update Row
Updates an existing row.
ActionWrite

Start free with email

Start free with Google

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

Supported triggers and actions

Canceled Subscription
Triggers when a subscription is canceled (by a subscriber or due to end of billing period).
Trigger
Instant
Try It
Failed Payment
Triggers when a payment attempt fails.
Trigger
Instant
Try It
- Ignore payments intentsRequired
Trigger
Instant
Try It
New Dispute
Triggers when a customer disputes a charge.
Trigger
Instant
Try It
- Event Types
Trigger
Polling
Try It

- Status
- Collection Method
- Customer ID
- Subscription ID
Trigger
Polling
Try It
- Products
Trigger
Polling
Try It

Updated Subscription
Triggers when a customer subscription has changed.
Trigger
Instant
Try It
- Subscription IDRequired
Action
Write
- ModeRequired
- Price ID
- Quantity
- Success URLRequired
- Cancel URL
- Customer ID
- Customer Email
- Payment Method Types
- Currency
- Billing Address Collection
- Shipping Countries
- Allow Promotion Codes
- Automatic Tax Enabled
- Coupon ID
- Promotion Code ID
- Client Reference ID
- Expires At
Action
Write
- Customer ID
- Description
- Quantity
- Unit Price
- Amount
- Include Tax In Price?
- Item Taxes
- Is Discountable?
- Item Coupons
- Supply Date - Start
- Supply Date - End
- Invoice Item Currency
- Price ID
- Invoice Item Subscription ID
- Tax Code
- Shipping Rate
- Invoice Coupons
- Default Tax Rates
- Payment Collection
- Due Date
- Days Until Due
- Turn On Automatic Collection?
- Default Payment Method
- Memo
- Footer
- Custom Fields
- Tax IDs
- PDF Page Size
- Shipping Details Instructions
- Shipping Details - Name
- Shipping Details - Phone
- Shipping Details - Address Line 1
- Shipping Details - Address Line 2
- Shipping Details - City
- Shipping Details - State
- Shipping Details - Postal Code
- Shipping Details - Country
- Subscription ID
- Automatic Tax Enabled?
- Invoice Currency
- Effective At
- Payment Method Types
- Rendering - Amount Tax Display
- Statement Descriptor
- Pending Invoice Items Behavior
- Invoice Metadata
- Help Text For Finalizing Sending Charging
- Finalize Invoice?
- Send Invoice for Manual Payment?
- Pay Invoice?
- Pay Invoice - Forgive
- Pay Invoice - Off-Session
- Pay Invoice - Paid Out of Band
Action
Write
- PriceRequired
- QuantityRequired
- Minimum adjustable quantity
- Maximum adjustable quantity
- Collect Tax Automatically?
- Allow Promotion Codes?
- Maximum number of times the link can be used
- Collect Customers' Addresses?
- Require customers to provide a phone number?
- Collect Tax ID?
- Create Invoice on Payment?
- Require customers to accept terms of service agreement?
- Confirmation Page
- Metadata
- Payment Method Types
Action
Write
- NameRequired
- Description
- Image
- Tax Code
- Metadata
Action
Write
- Payment LinkRequired
Action
Write
- Stop on errorRequired
- HTTP MethodRequired
- URLRequired
- Query string parameters
- Additional request headers
- Body
Action
Write
- Account IDRequired
Action
Search
- Find by
- QueryRequired
Action
Search
- Payment Intent IDRequired
Action
Search
- Table/ViewRequired
Trigger
Polling
Try It
- QueryRequired
Trigger
Polling
Try It
- Table/ViewRequired
- Primary KeyRequired
- Order ByRequired
- Trigger Column
- Trigger Column Configuration
Trigger
Polling
Try It
- TableRequired
- ID ColumnRequired
Action
Write
- QueryRequired
Action
Search

Checkout Session Completed
Triggers when a checkout session is completed.
Trigger
Instant
Try It
Invoice Payment Failed
Triggers when an invoice payment fails.
Trigger
Instant
Try It
New Customer
Triggers when a new customer is added.
Trigger
Instant
Try It
New Subscription
Triggers when a customer is signed up for a new plan.
Trigger
Instant
Try It
New Invoice Item
Triggers when a new invoice item is created.
Trigger
Polling
Try It
New Payment
Triggers when a new payment is completed.
Trigger
Instant
Try It
New Refund
Triggers when a charge is refunded, including partial refunds.
Trigger
Polling
Try It
Updated Dispute
Triggers when a dispute is updated (usually with evidence).
Trigger
Instant
Try It
- Warning
- Payment IDRequired
- Payment Method ID
- Receipt Email
- Error on Requires Action?
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
Action
Write
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
- Warning
- AmountRequired
- CurrencyRequired
- Customer ID
- Payment Method ID
- Confirm Payment Immediately?
- Error on Requires Action?
- Off Session?
- Payment Description
- Receipt Email
- Shipping - Name
- Shipping Address - Line 1
- Shipping Address - Line 2
- Shipping Address - Postal Code
- Shipping Address - City
- Shipping Address - State
- Shipping Address - Country
- Shipping - Carrier
- Shipping - Phone
- Shipping - Tracking Number
- Statement Descriptor
- Statement Descriptor Suffix
- Metadata
- Capture Method
Action
Write
- ProductRequired
- Price (in minor units, e.g. cents)Required
- CurrencyRequired
- Recurring or One time?
- Tax Behavior
Action
Write
- Customer IDRequired
- ItemsRequired
- Collection MethodRequired
- Coupon ID
- Cancel at period end?
- Metadata
Action
Write
- Customer IDRequired
- Name
- Email
- Description
- Billing - Address Line 1
- Billing - Address Line 2
- Billing - City
- Billing - State
- Billing - ZIP
- Billing - Country
- Billing - Phone
- Shipping - Name
- Shipping - Address Line 1
- Shipping - Address Line 2
- Shipping - City
- Shipping - State
- Shipping - ZIP
- Shipping - Country
- Shipping - Phone
- Language
- Invoice prefix
- Next Invoice Sequence
- Tax Status
- Credit Balance
- Metadata
Action
Write
Find Account Balance
Finds the account balance for your stripe account
Action
Search
- Stripe Charge IDRequired
Action
Search
- Invoice IDRequired
Action
Search
- Customer IDRequired
- Price ID
- Status
Action
Search
- Table/ViewRequired
- Order By
- Dedupe Key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- TableRequired
Action
Write
- TableRequired
- Lookup ColumnRequired
- Lookup ValueRequired
Action
Search

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Learn more

Related categories

Databases

Similar apps

About Stripe

Stripe is a developer-friendly way to accept payments online and in mobile apps. Stripe's suite of APIs powers commerce for thousands of companies of all sizes, processing billions of dollars for businesses each year.

Learn more

Related categories

Payment Processing

MySQL + Stripe

Update rows in MySQL when subscriptions are updated in Stripe

Canceled Subscription

Failed Payment

New Charge

New Dispute

New Event

New Invoice

New Payment Link

Updated Subscription

Cancel Subscription

Create Checkout Session

Create Invoice

Create Payment Link

Create Product

Deactivate Payment Link

API Request (Beta)

Find Account by ID

Find Customer

Find Payment

New Column

New Row (Custom Query)

New or Updated Row

Update Row

Find Row via Custom Query

Checkout Session Completed

Invoice Payment Failed

New Customer

New Subscription

New Invoice Item

New Payment

New Refund

Updated Dispute

Confirm Payment

Create Customer

Create Payment

Create Price

Create Subscription

Update Customer

Find Account Balance

Find Charge

Find Invoice

Find Subscription

New Row

New Table

New Row

Find Row

About MySQL

Related categories

Similar apps

SQL Server

Quickbase

Firebase / Firestore

About Stripe

Related categories

Related Zap Templates

Related Zap Templates