• Resolved vickypinnacle

    (@vickypinnacle)


    Hi, We have added plugin: https://ww.wp.xz.cn/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)
  • 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

    (@vickypinnacle)

    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.