Charitable migration and/or import donations

  • Resolved orlok7734

    (@orlok7734)


    3 years, 11 months ago

    Hello-
    I have a new client that has used Charitable on their old site.I don’t know if they have a paid subscription and they don’t know either 🙂 I suspect it’s a free version.
    I’ve set up the plugin on the new staging site, and imported what I thought was all the Charitable data, but all the past donations show as $0 no matter the status. Is there a better way to import the data than with WordPress import and export tools?
    Thank you in advance.

Viewing 3 replies - 1 through 3 (of 3 total)
  • Eric Daams

    (@ericdaams)

    3 years, 11 months ago

    Hi @orlok7734,

    It sounds like you may not have imported the wp_charitable_campaign_donations table. The donation amounts are stored in that table.

    The best way to migrate Charitable data from one site to another is to copy across the entire database.

    Donation and campaign data is recorded across a number of database tables:

    • wp_charitable* — All the ones starting with wp_charitable are created by Charitable.
    • wp_posts — Donations and campaigns are both stored in this table since they are custom post types in WordPress.
    • wp_postmeta — Metadata related to donations and campaigns is stored here.

    Also, if you have categorized or tagged campaigns, that is recorded in the WordPress tables:

    • wp_terms
    • wp_termmeta
    • wp_term_relationships
    • wp_term_taxonomy

    Finally, some donor related data for registered donors is stored in the wp_users and wp_usermeta tables.

    Eric Daams

    (@ericdaams)

    3 years, 11 months ago

    Hi @orlok7734,

    I haven’t heard back from you, so I’m going to mark this issue as resolved, but if you need a hand with anything else or have any follow-up questions, I’m more than happy to help.

    Cheers,
    Eric

    Thread Starter orlok7734

    (@orlok7734)

    3 years, 11 months ago

    Eric-

    Sorry, I thought I had posted my thanks here, but I did not. So thank you!

Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Charitable migration and/or import donations’ is closed to new replies.