Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse

Cloudron Forum

Apps | Demo | Docs | Install

Editing subscribers manually?

Scheduled Pinned Locked Moved Ghost
7 Posts 2 Posters 208 Views
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • A Offline
    A Offline
    abargel
    wrote on last edited by
    #1

    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.

    Thank you.

    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to abargel on last edited by
    #2

    @abargel said in Editing subscribers manually?:

    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?

    A 1 Reply Last reply
    0
  • A Offline
    A Offline
    abargel
    replied to girish on last edited by
    #3

    @girish Yes please. I would need a bit of guidance to find the subscribers info.

    girishG 1 Reply Last reply
    0
  • girishG Offline
    girishG Offline
    girish Staff
    replied to abargel on last edited by girish
    #4

    @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.

    1 Reply Last reply
    1
  • girishG Offline
    girishG Offline
    girish Staff
    wrote on last edited by
    #5

    I fixed the link, I mean https://ghost.org/help/import-members/#prepare-your-csv-file

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    abargel
    replied to girish on last edited by
    #6

    @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.

    A 1 Reply Last reply
    1
  • A Offline
    A Offline
    abargel
    replied to abargel on last edited by
    #7

    @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
    SHOW TABLES;
    then
    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 😉

    1 Reply Last reply
    2

  • Login

  • Don't have an account? Register

  • Login or register to search.
  • First post
    Last post
0
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Login

  • Don't have an account? Register

  • Login or register to search.