Where WooCommerce Guest Customers Are Saved in the Database?

  • I need to migrate the list of customers from a WooCommerce website. They have the option Allow customers to place orders without an account enabled, so no of their customers are a WP user, all are guests.

    How can I migrate them or where can I find them in the database?

Viewing 4 replies - 1 through 4 (of 4 total)
  • Stef

    (@serafinnyc)

    Depending on how many orders are there you’ll want to limit the database. Not sure.

    The query for this is (limiting to a 100)

    
SELECT * FROM wp_posts WHERE post_type = 'shop_order' LIMIT 100;

    To not add a limit

    
SELECT * FROM wp_posts WHERE post_type = 'shop_order';

    Hope this helps

    Thread Starter Stefano Monteiro

    (@stemon)

    @serafinnyc Thanks for replying, but I think I wasn’t clear enough. Your query will retrieve the order, I am looking for retrieving the Customers (guests), not users.

    Thanks

    Stef

    (@serafinnyc)

    I don’t think you’re understanding the queries then. These are not WP users. This query will catch all customers.

    Stef

    (@serafinnyc)

    Actually, sorry, I did mess up. However, you can simply go into Customers and export everyone there.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Where WooCommerce Guest Customers Are Saved in the Database?’ is closed to new replies.

Tags