Title: Export Orders
Last modified: October 23, 2018

---

# Export Orders

 *  Resolved [vickypinnacle](https://wordpress.org/support/users/vickypinnacle/)
 * (@vickypinnacle)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/export-orders-2/)
 * Hi, We have added plugin: [https://wordpress.org/plugins/woo-order-export-lite/](https://wordpress.org/plugins/woo-order-export-lite/)
   to our wordpress site which is running the free version of WCVendors however 
   we need to be able to export orders to an excel or .csv file which needs to include
   the vendor information. You can add custom code into that particular plugin but
   we don’t know what we would need to add. Please can you kindly advise?
 * Many thanks
 * Vicky

Viewing 2 replies - 1 through 2 (of 2 total)

 *  [Jamie Madden](https://wordpress.org/support/users/digitalchild/)
 * (@digitalchild)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/export-orders-2/#post-10813478)
 * Hello,
 * Vendor orders are linked to the relevant commissions in the commission table.
   So you would need to check the commissions table and export based on this. Once
   you have the relevant order and vendor_id you would then need to filter the order_items
   to find which vendor owns which product. We do store the vendor_id with the order
   item as order item meta to make this easier.
 * Once you have the vendor_id you can retrieve whatever vendor information you’d
   like via get_usermeta
 * cheers,
 * Jamie.
 *  Thread Starter [vickypinnacle](https://wordpress.org/support/users/vickypinnacle/)
 * (@vickypinnacle)
 * [7 years, 7 months ago](https://wordpress.org/support/topic/export-orders-2/#post-10833955)
 * Thank you for the info. I managed to find within the order export plugin all 
   the fields required in the end, including the vendor id – for anyone else reading
   this it is in the “set up fields to export” section & then within the “Products”
   section it has “Item Seller”. I also included “product Variation” to add the 
   attributes selected by the customer & “Short Description” as that is where we
   have all of our product data.
 * Thanks for your help though.

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Export Orders’ is closed to new replies.

 * ![](https://ps.w.org/wc-vendors/assets/icon.svg?rev=1645455)
 * [WC Vendors - WooCommerce Multivendor, WooCommerce Marketplace, Product Vendors](https://wordpress.org/plugins/wc-vendors/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/wc-vendors/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/wc-vendors/)
 * [Active Topics](https://wordpress.org/support/plugin/wc-vendors/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/wc-vendors/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/wc-vendors/reviews/)

## Tags

 * [export](https://wordpress.org/support/topic-tag/export/)

 * 2 replies
 * 2 participants
 * Last reply from: [vickypinnacle](https://wordpress.org/support/users/vickypinnacle/)
 * Last activity: [7 years, 7 months ago](https://wordpress.org/support/topic/export-orders-2/#post-10833955)
 * Status: resolved