Title: WCFM SQL
Last modified: April 12, 2020

---

# WCFM SQL

 *  Resolved [ruseau](https://wordpress.org/support/users/ruseau/)
 * (@ruseau)
 * [5 years, 12 months ago](https://wordpress.org/support/topic/wcfm-sql/)
 * Hi,
 * I’m using your SQL data base syncronise with Excel for create report of selling
   and having the maximum of information about my clients.
 * I have 0 knowledge about SQL i just know what kind of information i need,
 * I saw few report empty and also i can’t find one from WCFM with the billing address
   and phone number associate with the client or the order id.
 * the most important report is this one for the moment :
    wpt5_wcfm_marketplace_orders
 * Empty one :
    wpt5_wcfm_marketplace_product_multivendor
 * i think this one could help me with product / ID / store / store ID / ?
 * Best Regards,
    -  This topic was modified 5 years, 12 months ago by [ruseau](https://wordpress.org/support/users/ruseau/).

Viewing 1 replies (of 1 total)

 *  Plugin Author [WC Lovers](https://wordpress.org/support/users/wclovers/)
 * (@wclovers)
 * [5 years, 11 months ago](https://wordpress.org/support/topic/wcfm-sql/#post-12673241)
 * Hi,
 * > Empty one :
   >  wpt5_wcfm_marketplace_product_multivendor
 * – This table use for “Single Product Multi-vendor” module – [https://wclovers.com/knowledgebase/wcfm-marketplace-single-product-multi-vendor/](https://wclovers.com/knowledgebase/wcfm-marketplace-single-product-multi-vendor/)
 * Possibly you do not have any such product so it’s empty.
 * > I saw few report empty and also i can’t find one from WCFM with the billing
   > address and phone number associate with the client or the order id.
 * – You have to process WooCommerce order object to get such data.
 * Thank You

Viewing 1 replies (of 1 total)

The topic ‘WCFM SQL’ is closed to new replies.

 * ![](https://ps.w.org/wc-frontend-manager/assets/icon-256x256.jpg?rev=1800818)
 * [WCFM - Frontend Manager for WooCommerce](https://wordpress.org/plugins/wc-frontend-manager/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wc-frontend-manager/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wc-frontend-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/wc-frontend-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wc-frontend-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wc-frontend-manager/reviews/)

 * 1 reply
 * 2 participants
 * Last reply from: [WC Lovers](https://wordpress.org/support/users/wclovers/)
 * Last activity: [5 years, 11 months ago](https://wordpress.org/support/topic/wcfm-sql/#post-12673241)
 * Status: resolved