User Meta Fields in a Multisite Install

Does anyone know which meta_key rows are multisite specific and which ones are not?

I am trying to export/import the users from a standalone install to a multisite install and the export/import utility in s2Member Pro does not work.

So my suspicion is that certain meta_key rows need to be coded as *_ID_* where ID is the multisite site id.

For example, should wp_s2member_paid_registration_times actually be wp_22_s2member_paid_registration_times in my multisite whose ID=22

Well I found 3 meta_key 's that need to be changed.

  • wp_s2member_subscr_cid needs to be changed to wp_22_s2member_subscr_cid
  • wp_s2member_subscr_baid needs to be changed to wp_22_s2member_subscr_baid
  • wp_s2member_subscr_id needs to be changed to wp_22_s2member_subscr_id

Does anyone have an exhaustive list? If not, I have my trial & error work cut out for me :frowning:

It says it’s not an exhaustive list, but it probably gives you most of what you need: https://s2member.com/kb-article/where-is-the-s2member-data-stored-in-the-wordpress-database/

All the metas are site-specific in WPMSN.

“All the metas are site-specific in WPMSN”

You mean all s2member metas @krumch ? Because not all WordPress meta_keys and meta_values in multisite are site-specific.

Well, not all s2M metas either, but I can not give you more detailed info…