Woocommerce Analytics CSV export decimal separator | ww.wp.xz.cn

Resolved dashastone
(@dashastone)

3 years, 8 months ago

Hi, for German financial system, we need the CSV export prices generated in Woocommerce Analytics (revenue and others) with decimal separator being a comma instead of a point, i.e. 10,00 instead of 10.00 – how can this be achieved? Also, if we have comma-separated decimals, we would need a semicolon-separated CSV instead of comma-separated?

I found this snipped, but I doubt it only affects CSV export:

function my_change_separator( $price ) {
return str_replace( ‘.’, ‘,’, $price );
}

Viewing 1 replies (of 1 total)

xue28 (woo-hc)
(@xue28)

3 years, 8 months ago

Hi @dashastone

Thanks for reaching out!

I understand that you want to use the comma as a decimal separator when exporting reports in WooCommerce Analytics.

These forums are meant for general support with the core functionality of WooCommerce itself. What you want to achieve is a bit complex and would require customization to do it. Since custom coding is outside our scope of support, I am leaving this thread open for a bit to see if anyone can chime in to help you out.

Meanwhile, I found that the WP All Export plugin can use the code you provided based on this forum thread.

For questions related to development and custom coding, your best bet is to ask on any of these channels for support. We’re lucky to have a great community of open-source developers for WooCommerce, and many of our developers hang out there, too.

– WooCommerce Developer Resources Portal
– WooCommerce Advanced Facebook group
– WooCommerce Community Forum
– WooCommerce Developer Slack Channel.
– Hire a WooCommerce Expert

Viewing 1 replies (of 1 total)

The topic ‘Woocommerce Analytics CSV export decimal separator’ is closed to new replies.

1 reply
2 participants
Last reply from: xue28 (woo-hc)
Last activity: 3 years, 8 months ago
Status: resolved