[SOLVED] Change billing address in CB Paid Subscription

During registration or new user there is no issue as the address fields are the same for information tab and CBSubs.

Both on backend and frontend the autoaction does not update the CBSubs fields in cbsubs_payment_baskets for the user.

I have tried both as a moderator from frontend or backend and as a user on frontend

Not sure what to suggest. How are you confirming it's not working? Have tested it and can see that cb_subs_inv_first_name was updated fine in _comprofiler so seams to be working. Note this does not update the invoice name for existing invoices. This is strictly used for new invoices only. Existing invoices pull their information from the basket itself.

So we're back to the old conflict basket/invoice

We need to update the table cbsubs_payment_baskets with the correct data for name/addresses, not only the _comprofiler table. For all recurring payments the data (name/address...) seems to be taken from the basket while the customer may have changed its data a couple of times during the recurring time.

This means that what you call invoices (baskets) are wrong after a time for all recurring payments.

Is there a way to update the correct data apart from a direct change in the cbsubs_payment_baskets table ?

Is there a way to update the correct data apart from a direct change in the cbsubs_payment_baskets table ?

Use a Query action on onAfterUserUpdate, onAfterUpdateUser triggers and update the address information for their basket rows in _cbsubs_payment_baskets. There is no other way to do this.

Excellent idea, I forgot about query auto actions for this.

I think that this should be ok ?
But it will update all table rows. How could I simply update the last ones that exist at the time of the change ?
I think that changing the last existing invoice should be enough. Often customers complain that the last invoice arrived with the wrong address or person in charge in case of moves in the company.

I believe you also have the option of just modifying "Customer address format" in CBSubs > Settings > Display > Invoices. It passes through normal user substitutions so you could for example replace [ADDRESS_FIRST_NAME] with [firstname] if you wanted.

How could I simply update the last ones that exist at the time of the change ?

Order by the id column so the most recent is first (e.g. `id` DESC) then apply LIMIT 1 so you only are updating the most recent entry. This should work fine since you're not joining any other tables since order by and limit in update queries is only allowed in single table queries.