• Hello,

    I’m having difficulty by finding vendor table which should show in database. I just have dokan announcement, order, refunds, vendor balance and withdraw tables, but not the table to show vendors.

Viewing 7 replies - 1 through 7 (of 7 total)
  • 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 🙂

    Thread Starter nijatmursali

    (@nijatmursali)

    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 10 months, 2 weeks ago by nijatmursali.
    Thread Starter nijatmursali

    (@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 🙂

    Thread Starter nijatmursali

    (@nijatmursali)

    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 10 months, 2 weeks 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 10 months, 2 weeks ago by alamgircsebd.
    Thread Starter nijatmursali

    (@nijatmursali)

    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.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘Why there’s no vendor table in database?’ is closed to new replies.