Home Forums WC Vendors Free Support Bulk edit vendor name in an existing website

NOTICE: We've Moved to a Ticket System for Support

As of August 31, 2017 (12am EST) our support forums will be retired (read-only), and we will be moving to a support ticket system.  This will allow us to better organize and answer support requests, and provide a more personalized experience as we assist our customers.

For the time being, we will leave our forums open for reading and learning while we work on creating a more robust Knowledge Base for everyone to use.

If you are a WC Vendors Pro customer please open a support ticket here. 

If you are a WC Vendors user please open a support ticket on the Wordpress.org forums.

The information on this forum is outdated and in most instances no longer relevant. Please be sure to check our documentation for the most up to date information.

https://docs.wcvendors.com/

Thank you to all of our customers!

 

Viewing 5 posts - 1 through 5 (of 5 total)
  • Author
    Posts
  • #46306
    Yazir Arafath
    Participant

    I have added 500+ products in my website before installing WC Vendor. Now, after installing WC Vendor all the products show my admin account as the vendor. Is it possible for me to transfer all to another user?

    #46323
    WC Vendors Support
    Participant

    Oops.

    Yea, it’s actually pretty easy. Go in phpmyadmin, and in wp_posts, change the post_author from your current admin’s id to the vendors user id. You can do them bulk in there in seconds.

    Vendors simply “own” the product by being the post_author. After all products are posts it’s just WordPress after all. 🙂

    #46342
    Yazir Arafath
    Participant

    I don’t have phpMyAdmin installed on the server.

    So, is it okay if I execute following?

    SELECT ID, display_name FROM wp_users;
    UPDATE wp_posts SET post_author=’4′ WHERE post_author=’1′;

    #48588
    WC Vendors Support
    Participant

    I’m rusty on my SQL commands. Those look good, though, but as always keep a backup eh? 🙂

    That should change the post author from 1 to 4, and assuming your vendors user id is 4, you’re good to go.

    #48606
    Yazir Arafath
    Participant

    I used following to change the post author.

    UPDATE wp_posts SET post_author = ‘4’ WHERE wp_posts.post_type = ‘product’;

    Thanks for the support ben. 🙂

Viewing 5 posts - 1 through 5 (of 5 total)
  • The forum ‘WC Vendors Free Support’ is closed to new topics and replies.