Editing subscribers manually?
I migrated from a Ghost(Pro) instance to a self-hosted one through Cloudron, but I messed up when exporting and importing paying Stripe subscribers... I have contacted Stripe and Ghost support, but haven't been able to completely solve the issue.
Currently, I have imported the subscribers into Ghost, but only with their name and email (importing Stripe data didn't work). I also have the subscribers on Stripe, with their Stripe IDs, subscriptions and payment info from when they subscribed on the Ghost(Pro) instance, and the appropriate subscription products. The Stripe integration is now functional with the new Ghost instance.
As there are not too many subscribers, I was wondering if there is a way to edit subscribers manually from my Cloudron console, where I could add the Stripe IDs for each of them. Could that possibly solve my problem?
Any other suggestion about how to proceed would also be greatly appreciated.
As there are not too many subscribers, I was wondering if there is a way to edit subscribers manually from my Cloudron console, where I could add the Stripe IDs for each of them.
Yes, this should be possible. Are you asking for how to access the database?
@girish Yes please. I would need a bit of guidance to find the subscribers info.
@abargel We wouldn't know how or what to edit the database itself, we can only give access to the database.
Have you seen https://ghost.org/help/import-members/ and https://ghost.org/help/import-members/ ? If you handcraft the CSV, then you can import it into Ghost via the UI. I recommend following this approach instead of editing the database etc (tbh, it will be hard to get help for this other than the upstream project).
For MySQL access, you can open a Web terminal . Then in the top, you see a button called MySQL. Click on it and it will paste the CLI to access the database. Press enter and you get the MySQL prompt.
I fixed the link, I mean https://ghost.org/help/import-members/#prepare-your-csv-file
@girish Yes, I have tried importing a csv file, properly formatted. Every time I got an error message, saying that there was a csv file attached with the errors, but that csv file was always empty. When I deleted the colomuns regarding Stripe, I was able to import the csv.
Thanks for indicating the MySQL button. Unfortunately, I am not able to find my away around a database enough to proceed. I've asked Ghost support that specific question, waiting for an answer.
Thank you, once again.
@abargel Well, actually, from the MySQL access in Web terminal, and a little help from the MySQL manual, it wasn't that difficult to find the table with
SELECT * FROM members_stripe_customers_subscriptions;
and add records with information from Stripe (and from the table members_stripe_customers) with
INSERT ... VALUES (see MySQL manual for format)
Sure, it is a bit tedious... But for a limited number of members, it can be done