Issue: getting subscription data out of Woocommerce to analyse in Google Data Studio. This needs to be done Zapier because Woocommerce doesn’t export this data into a google sheets.
Goals:
- create new subscription (DONE);
- update subscription when renewed (NEED HELP):
- how can one update only some of the rows when a subscription is renewed, and can the revenue which comes from the renewal be updated to add the revenue of the renewal to the first revenue generated through the customer buying the membership for the first time?
- Update total_revenue & next_payment_date etc.