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


Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Bookmarks
  • Search
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
Brand Logo

Cloudron Forum

Apps | Demo | Docs | Install
  1. Cloudron Forum
  2. Ghost
  3. Editing subscribers manually?

Editing subscribers manually?

Scheduled Pinned Locked Moved Ghost
7 Posts 2 Posters 1.2k Views 2 Watching
  • 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
      • A abargel

        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 Offline
        girishG Offline
        girish
        Staff
        wrote 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
        • girishG girish

          @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 Offline
          A Offline
          abargel
          wrote 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
          • A abargel

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

            girishG Offline
            girishG Offline
            girish
            Staff
            wrote 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
              • girishG girish

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

                A Offline
                A Offline
                abargel
                wrote 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 abargel

                  @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 Offline
                  A Offline
                  abargel
                  wrote 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
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                    • Login

                    • Don't have an account? Register

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