Why there’s no vendor table in database?

Hello @nijatmursali ,

Dokan vendors are like any other WordPress user. So you will not find them in a different table. They just have different capabilities. Let me know if you are looking for specific data about the vendor. I can guide you on that.

Thank you ??

Thanks for reply.

I need to get the address, zip, city type of information from vendors and insert it to another table. So, i need to choose the columns from user table and it should work right?

But there are not address fields in users table..

• This reply was modified 3 years, 12 months ago by nijatmursali.

Where all address type of things are stored in the database for users/vendors?

Hello @nijatmursali ,

Dokan saves the vendor information under the wp_usermeta table > dokan_profile_settings meta key. You have to extract the information from there if you want to use it elsewhere.

Thank you ??

Thanks for the information. The type of json is weird in meta_value which is

a: 20: {s: 10: "store_name";s: 10: "Test Store";s: 6: "social";a: 7: {s: 2: "fb";s: 0: "";s: 5: "gplus";s: 0: "";s: 7: "youtube";s: 0: "";s: 7: "twitter";s: 0: "";s: 8: "linkedin";s: 0: "";s: 9: "pinterest";s: 0: "";s: 9: "instagram";s: 0: "";
    }s: 7: "payment";a: 2: {s: 4: "bank";a: 7: {s: 7: "ac_name";s: 0: "";s: 9: "ac_number";s: 0: "";s: 9: "bank_name";s: 0: "";s: 9: "bank_addr";s: 0: "";s: 14: "routing_number";s: 0: "";s: 4: "iban";s: 0: "";s: 5: "swift";s: 0: "";
        }s: 6: "paypal";a: 1: {s: 5: "email";s: 0: "";
        }
    }s: 5: "phone";s: 0: "";s: 10: "show_email";s: 2: "no";s: 7: "address";a: 6: {s: 8: "street_1";s: 15: "Via Ariosto, 25";s: 8: "street_2";s: 0: "";s: 4: "city";s: 4: "Rome";s: 3: "zip";s: 5: "00185";s: 5: "state";s: 2: "RM";s: 7: "country";s: 2: "IT";
    }s: 8: "location";s: 0: "";s: 6: "banner";s: 4: "1622";s: 4: "icon";s: 0: "";s: 8: "gravatar";s: 4: "1623";s: 14: "show_more_ptab";s: 3: "yes";s: 9: "store_ppp";s: 2: "10";s: 10: "enable_tnc";s: 3: "off";s: 9: "store_tnc";s: 0: "";s: 23: "show_min_order_discount";s: 2: "no";s: 9: "store_seo";a: 0: {}s: 24: "dokan_store_time_enabled";s: 3: "yes";s: 23: "dokan_store_open_notice";s: 0: "";s: 24: "dokan_store_close_notice";s: 0: "";s: 16: "dokan_store_time";a: 0: {}
}

How can I get the address, zip out of this one with mysql command? Thanks.

• This reply was modified 3 years, 11 months ago by nijatmursali.

Hello @nijatmursali

I see you want get vendor information, here have simple way to get the information’s.

simply pass vendor ID to this function dokan_get_store_info()
Example:

$seller_id  = 99;
$store_info = dokan_get_store_info( $seller_id );

now here will return all kinds of seller information’s with this array $store_info

if you want to show street address then print : $store_info['address']['street_1']

if you want to show zip then print : $store_info['address']['zip']

If you have still confusion let me know, i will be here.

Thanks!

• This reply was modified 3 years, 11 months ago by alamgircsebd.

It’s time consuming version. What I wanna do is, use all the sellers(so all sellers with different IDs in a loop) and get the address, street, zip kind of information for all sellers into different array or something like that to use all these information in different plugin for map.