I have the need to export order data which contains both the “cost of good(s)” plus final sell amounts. I enabled the Cost of Goods and the Export Orders tool then using the short code [wcj_order_items_cost] in a custom field to export that new field.
When viewing the order report from the web page the cost shows fine but when exporting that to CSV the data comes into excel as:
<span class=”woocommerce-Price-amount amount”><bdi><span class=”woocommerce-Price-currencySymbol”>$</span>5.00</bdi></span>
It’s obviously pulling it correctly to the web page but does anyone have any advice on whether this is a Booster bug or something I can fix in excel?
I’m like 98% finished with the test and would really like to get this to work.
.
