Export Order Purchase Cost

  • siwhyatt

    (@siwhyatt)


    5 years, 7 months ago

    Hi Booster Team,

    I want to either run a report or export orders, that shows the “Purchase Cost” of an order.

    I can see the column under admin>orders but can’t work out how to get it to export.

    I presume I just have to add an “Additional Export Orders Field” and select “Order Meta” but don’t know what to put in the value for the order meta.

    Thanks,

    Simon

    The page I need help with: [log in to see the link]

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

    (@rokasjan)

    5 years, 7 months ago

    Hi Simon,

    If you export products with stock Woocommerce tool (that is directly form products page) with export meta option enabled, you will see a column “Meta: _wcj_purchase_price” with purchase prices. Therefore, you can try using your mentioned 3rd party plugin and retrieve _wcj_purchase_price meta field.

    Thread Starter siwhyatt

    (@siwhyatt)

    5 years, 7 months ago

    Hi RokasJ,

    Thanks for your reply.

    This kind of works, but it means I have to export the orders with all the items itemised and individually priced, then edit the document calculating the sum of all the individual items of each order.

    I want to export the total cost per order – this total is displayed in the orders admin section, so it must be stored somewhere?

    Any ideas?

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Export Order Purchase Cost’ is closed to new replies.