Support » Plugin: One User Avatar | User Profile Picture » Meta Field for Import?

  • one3rdnerd



    I am using WP All Import to import 200 or so users into memberpress. Is there a meta field all of these avatars are stored under so I can import them en masse?


Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Support Daniel Tara



    The avatars are stored in the usermeta table with the key ‘user_avatar’ prefixed with the current blog prefix.

    For a non-multisite installation with the default ‘wp_’ prefix the key would be ‘wp_user_avatar’. You can check to see which key your website uses by performing this query:

    SELECT * FROM `wp_usermeta` WHERE `meta_key` LIKE '%user_avatar'

    I hope this helps.

    Thread Starter one3rdnerd


    Thanks for that. My prefix is ryj_

    I gave it a try but it’s not working for me.

    I’m trying to use WPAllImport plugin but I am feeling it a column full of absolute URLs for images that aren’t in the media library yet.

    Maybe it would make a difference if I upload them all and then sanitize the column so only the image name and extension remain in each row rather than the full URL? Do you think that would be enough to attach the image to this meta field?

    Plugin Support Daniel Tara


    The meta field is supposed to store the image ID and not the URL. Avatars are just like any other attachment images, so try importing your attachments first. The plugin would expect them to have the same IDs so doing this on a fresh install would be ideal.

    Thread Starter one3rdnerd


    Hi Daniel,

    Ah! Okay thank you for explaining, I didn’t think of that.

    Okay so I think my only option would be to upload the 291 attachments, then write down all 291 ID’s and paste them one by one into the spreadsheet.

    Trying to see if there’s a way of doing that without me having to do it all manually one by one as that defeats the point of using the import spreadsheet to save time.

    At that point I may as well just work through all 291 users in the dashboard and add the images manually one by one.

    I will contact the WP All Import guys and see if they can find a way to streamline this process.

    I appreciate you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.