Migrate affiliates and payout data to new wordpress instance

[mmelton12]

We are rebuilding our site and are hoping to migrate our existing affiliates and their affiliate history to our new site- how can I go about doing this?

[Shadow Labs]

@mmelton12, You will need to import all the existing tables from the database.

All of our tables start with the “wpam” prefix. For example:

wp_wpam_actions
wp_wpam_affiliates
wp_wpam_affiliates_fields
wp_wpam_creatives
wp_wpam_events
wp_wpam_impressions
wp_wpam_messages
wp_wpam_paypal_logs
wp_wpam_tracking_tokens
wp_wpam_tracking_tokens_purchase_logs
wp_wpam_transactions

Each WordPress user associated with an affiliate account also needs to exist on the new site (with the same ID). It’s better to just import the whole site. That way the settings and other options will also be there.

[Author]

Posts