Support Migration from On-Premise to Matomo for WordPress

[tsteur]

This is currently not fully supported see https://matomo.org/faq/wordpress/how-do-i-migrate-all-my-data-from-matomo-on-premise-to-matomo-for-wordpress/

When Matomo for WordPress is installed, one site is created and a "link" to this site is created internally. All report data is shown for this linked idsite and all data is tracked into this linked site. When you click on "Matomo -> Reporting" in the WP admin dashboard, then this linked site will be opened.

When you migrate from Matomo On-Premise to Matomo for WordPress, the migration plugin will create a second site. You can only see the reports for this second site by following these steps: "Matomo Analytics -> Reporting -> Then selecting this different site in the site selector".

Matomo for WordPress does not allow you to edit or delete a site. This means this newly created second site cannot be edited or deleted. You can also not really track additional data into this migrated site unless you adjust the idSite in the tracking code manually.

To workaround this issue if you want to track data into this newly migrated site:

• Migrate the existing On-Premise site using this plugin
• Run this MySQL query in your database update wp_options set option_value = 2 where option_name = "matomo-site-id-1". You may need to adjust the wp_ database table prefix and the option_value=2 to the correct idSite in case you ran the migration command multiple times
• What will happen now is:
  • The tracking code will be automatically adjusted to use idSite=2 (unless the tracking code is configured manually)
  • The reports in the "Matomo => Summary" page will show stats from this second site and clicking on "Matomo => Reporting" will open directly the second site.

Notes:

• You cannot merge previously tracked data with data from Matomo On-Premise into one site. If you tracked data into the first site before the migration, you cannot view this data anymore.
• We do not recommended migrating from Matomo On-Premise to Matomo for WordPress unless you have little traffic and want to have less maintenance work. Using Matomo On-Premise will be significantly faster and need less resources overall. You can also see the difference between those Matomo On-Premise and Matomo for WordPress here